feat(sqlalchemy): organized provisioning for tests #24

	# This workflow will install Python dependencies, run tests and lint with a variety of Python versions
	# For more information see: https://docs.github.com/en/actions/automating-builds-and-tests/building-and-testing-python

	name: Test

	on:
	push:
	workflow_dispatch:

	jobs:
	tests:
	runs-on: ubuntu-20.04
	strategy:
	fail-fast: false
	matrix:
	# last supported for sqlitecloud, last security maintained, last release
	python-version: ["3.6", "3.8", "3.12"]

	steps:
	- 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 -r requirements.txt
	python -m pip install -r requirements-dev.txt
	- name: Lint
	run: \|
	flake8 . --count --exit-zero --show-source --statistics
	isort --diff --check-only src
	- name: Tests
	env:
	SQLITE_CONNECTION_STRING: ${{ vars.SQLITE_CONNECTION_STRING }}
	SQLITE_USER: ${{ secrets.SQLITE_USER }}
	SQLITE_PASSWORD: ${{ secrets.SQLITE_PASSWORD }}
	SQLITE_API_KEY: ${{ secrets.SQLITE_API_KEY }}
	SQLITE_HOST: ${{ vars.SQLITE_HOST }}
	SQLITE_DB: ${{ vars.SQLITE_DB }}
	SQLITE_PORT: ${{ vars.SQLITE_PORT }}
	run: \|
	pytest --cov -v src/tests
	- name: Upload coverage reports to Codecov
	uses: codecov/codecov-action@v4.0.1
	with:
	token: ${{ secrets.CODECOV_TOKEN }}

Provide feedback