fix(ci): implement ORM-level cascading deletes to resolve foreign key… #8

	name: CI

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

	jobs:
	validate:
	runs-on: ubuntu-latest
	services:
	postgres:
	image: postgres:16
	env:
	POSTGRES_USER: postgres
	POSTGRES_PASSWORD: password
	POSTGRES_DB: test_db
	ports:
	- 5432:5432
	options: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5

	steps:
	- uses: actions/checkout@v4

	- name: Install uv
	uses: astral-sh/setup-uv@v4
	with:
	enable-cache: true

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

	- name: Install dependencies
	run: uv sync

	- name: Lint with Ruff
	run: uv run ruff check .

	- name: Check formatting with Ruff
	run: uv run ruff format --check .

	- name: Type check with Mypy
	run: uv run mypy .

	- name: Run tests with Pytest
	env:
	DATABASE_URL: postgresql+asyncpg://postgres:password@localhost:5432/test_db
	run: uv run pytest tests/

Navigation Menu