fix: resolve walkthrough layering and tighten provider integration ch… #27

	name: Backend Tests (Postgres)

	on:
	pull_request:
	branches:
	- main
	- master
	push:
	branches:
	- main
	- master

	jobs:
	postgres-test:
	runs-on: ubuntu-latest
	timeout-minutes: 30

	services:
	postgres:
	image: postgres:16
	env:
	POSTGRES_USER: postgres
	POSTGRES_PASSWORD: postgres
	POSTGRES_DB: efficientai_test
	ports:
	- 5432:5432
	options: >-
	--health-cmd "pg_isready -U postgres -d efficientai_test"
	--health-interval 10s
	--health-timeout 5s
	--health-retries 10

	env:
	DATABASE_URL: postgresql://postgres:postgres@localhost:5432/efficientai_test
	TEST_DATABASE_URL: postgresql://postgres:postgres@localhost:5432/efficientai_test
	POSTGRES_USER: postgres
	POSTGRES_PASSWORD: postgres
	POSTGRES_DB: efficientai_test
	POSTGRES_HOST: localhost
	POSTGRES_PORT: 5432
	REDIS_URL: redis://localhost:6379/0
	CELERY_BROKER_URL: redis://localhost:6379/0
	CELERY_RESULT_BACKEND: redis://localhost:6379/0

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

	- name: Set up Python
	uses: actions/setup-python@v5
	with:
	python-version: "3.12"
	cache: "pip"

	- name: Install dependencies
	run: \|
	python -m pip install --upgrade pip
	python -m pip install -e ".[dev]"

	- name: Run backend test suite on Postgres
	run: make test

Provide feedback