Postgress connection standardization #1696

	name: Unit Tests

	on:
	pull_request:
	branches: [ main ]
	push:
	branches: [ main ]

	permissions:
	contents: read

	jobs:
	test:
	runs-on: ubuntu-latest

	steps:
	- uses: actions/checkout@v4

	- name: Set up Python
	uses: actions/setup-python@v5
	with:
	python-version: '3.11'

	- name: Install dependencies
	run: \|
	python -m pip install --upgrade pip
	pip install -r test/requirements.txt

	- name: Run unit tests with coverage
	run: \|
	pytest test/unit/ -v --tb=short \
	--cov --cov-report=term-missing --cov-report=xml

	- name: Coverage summary
	if: always()
	run: \|
	python - <<'PY'
	import xml.etree.ElementTree as ET, os
	try:
	rate = float(ET.parse("coverage.xml").getroot().get("line-rate", 0)) * 100
	except Exception:
	rate = 0.0
	summary = os.environ.get("GITHUB_STEP_SUMMARY")
	line = f"## Unit test coverage: {rate:.1f}% of lines\n"
	if summary:
	open(summary, "a").write(line)
	print(line)
	PY

	- name: Upload coverage report
	if: always()
	uses: actions/upload-artifact@v4
	with:
	name: coverage-report
	path: coverage.xml
	retention-days: 7

Provide feedback