feat(db): support multiple SQL backends with optional extras (cont. #80) #173

	name: Run Unit Tests

	on:
	pull_request:
	branches:
	- main

	permissions:
	contents: read

	jobs:
	test:
	name: Test with Python ${{ matrix.python-version }}

	runs-on: ubuntu-latest

	if: github.repository == 'google/a2a-python'
	services:
	postgres:
	image: postgres:15-alpine
	env:
	POSTGRES_USER: postgres
	POSTGRES_PASSWORD: postgres
	POSTGRES_DB: a2a_test
	ports:
	- 5432:5432

	strategy:
	matrix:
	python-version: ["3.10", "3.13"]

	steps:
	- name: Checkout code
	uses: actions/checkout@v4

	- name: Set up Python ${{ matrix.python-version }}
	uses: actions/setup-python@v5
	with:
	python-version: ${{ matrix.python-version }}
	- name: Set postgres for tests
	run: \|
	sudo apt-get update && sudo apt-get install -y postgresql-client
	PGPASSWORD=postgres psql -h localhost -p 5432 -U postgres -d a2a_test -f ${{ github.workspace }}/docker/postgres/init.sql
	export POSTGRES_TEST_DSN="postgresql://postgres:postgres@localhost:5432/a2a_test"

	- name: Install uv
	run: \|
	curl -LsSf https://astral.sh/uv/install.sh \| sh

	- name: Add uv to PATH
	run: \|
	echo "$HOME/.cargo/bin" >> $GITHUB_PATH

	- name: Install dependencies
	run: uv sync --dev

	- name: Run tests
	run: uv run pytest

	- name: Upload coverage report
	uses: actions/upload-artifact@v4
	with:
	name: coverage-report-${{ matrix.python-version }}
	path: coverage.xml
	if-no-files-found: ignore

Provide feedback