update db syntax to sqlalchemy 2.x #1

	# workflow for testing
	name: CI
	on:
	push:
	branches: [ main ]
	pull_request:
	branches: [ main ]
	workflow_dispatch:

	jobs:
	test-webserver:
	runs-on: ${{ matrix.os }}
	strategy:
	fail-fast: false
	matrix:
	python-version: [3.11]
	os: [ubuntu-latest]
	# os: [ubuntu-latest, macos-latest]
	steps:
	- name: Checkout repository
	uses: actions/checkout@v4
	- name: Set up Python ${{ matrix.python-version }}
	uses: actions/setup-python@v4
	with:
	python-version: ${{ matrix.python-version }}
	- name: Install dependencies
	run: \|
	python -m pip install --upgrade pip
	python -m pip install -r requirements.txt
	- name: run base tests
	run: \|
	cd src
	python -m pytest -svv --cov=. --cov-report=xml
	- name: Upload coverage reports to Codecov
	uses: codecov/codecov-action@v4
	env:
	CODECOV_TOKEN: ${{ secrets.CODECOV_TOKEN }}

Provide feedback