docs: add honest project assessment (ASSESSMENT.md) #4

	name: CI

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

	jobs:
	backend:
	name: Backend
	runs-on: ubuntu-latest

	services:
	postgres:
	image: postgres:16-alpine
	env:
	POSTGRES_USER: postgres
	POSTGRES_PASSWORD: postgres
	POSTGRES_DB: docuquery_test
	ports:
	- 5432:5432
	options: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5

	defaults:
	run:
	working-directory: backend

	env:
	DATABASE_URL: postgresql+asyncpg://postgres:postgres@localhost:5432/docuquery_test
	SECRET_KEY: ci-test-secret-key

	steps:
	- uses: actions/checkout@v4

	- name: Install uv
	uses: astral-sh/setup-uv@v4

	- name: Set up Python
	run: uv python install 3.12

	- name: Install dependencies
	run: uv sync --all-extras

	- name: Lint
	run: uv run ruff check .

	- name: Format check
	run: uv run ruff format --check .

	- name: Run migrations
	run: uv run alembic upgrade head

	- name: Test
	run: uv run pytest tests/ -v --tb=short

	frontend:
	name: Frontend
	runs-on: ubuntu-latest

	defaults:
	run:
	working-directory: frontend

	steps:
	- uses: actions/checkout@v4

	- name: Set up Node.js
	uses: actions/setup-node@v4
	with:
	node-version: 20
	cache: npm
	cache-dependency-path: frontend/package-lock.json

	- name: Install dependencies
	run: npm ci

	- name: Lint
	run: npm run lint

	- name: Build
	run: npm run build

Provide feedback