Cursor rule

1---
2description: "Backend Python development rules for FastAPI, SQLAlchemy 2.x, async patterns, and Alembic migrations."
3globs: "core/**/*.py,edgekit/**/*.py"
4alwaysApply: false
5---
6 
7# Backend Python Rules
8 
9These rules apply when working on backend Python code in `core/` and `edgekit/`.
10 
11## Technology Stack
12 
13- **Framework**: FastAPI (Python 3.11+)
14- **ORM**: SQLAlchemy 2.x with async session patterns
15- **Migrations**: Alembic
16- **Database**: PostgreSQL 16
17- **Authentication**: JWT (custom implementation)
18 
19## Coding Standards
20 
21- Use `ruff` for linting and formatting (config in `pyproject.toml`)
22- Always run `ruff check .` before committing
23- Use `mypy` for type checking
24- Python 3.11+ features are allowed (StrEnum, etc.)
25- Use async/await patterns for all FastAPI endpoints
26 
27## Database Operations
28 
29**CRITICAL**: All database operations MUST use RLS context helpers.
30 
31```python
32# User operations
33async with with_user_context(session, user_id) as ctx:
34    result = await ctx.execute(select(Model).where(Model.user_id == user_id))
35 
36# Admin operations
37async with with_admin_context(session, user_id) as ctx:
38    result = await ctx.execute(select(Model))
39 
40# System/background operations
41async with with_system_context(session, "source_name") as ctx:
42    result = await ctx.execute(insert(Model).values(data))
43```
44 
45Never use direct session calls without RLS context wrappers.
46 
47## Migration Workflow
48 
49```bash
50alembic revision --autogenerate -m "description"  # Create migration
51alembic upgrade head                               # Apply locally
52# Review the generated migration file before committing
53git add alembic/versions/
54git commit -m "feat(db): add migration description [{{TICKET_PREFIX}}-XXX]"
55```
56 
57Rules:
58- Always create proper Alembic migrations (never skip)
59- Review auto-generated migrations for correctness
60- Add RLS policies for any new tables
61- Schema changes require System Architect approval
62 
63## FastAPI Patterns
64 
65- Use dependency injection for database sessions
66- Use Pydantic v2 models for request/response validation
67- Use proper HTTP status codes
68- Include OpenAPI documentation (FastAPI generates this)
69- Use structured logging
70 
71## Testing
72 
73- Use `pytest` with async support (`pytest-asyncio`)
74- Run `pytest tests/` before committing
75- Integration tests go in `tests/integration/`
76- E2E tests go in `tests/e2e/`
77 
78## Key References
79 
80- See `patterns_library/api/` for API route patterns
81- See `docs/database/DATA_DICTIONARY.md` for schema reference
82- See `docs/database/RLS_IMPLEMENTATION_GUIDE.md` for RLS patterns
83- See `CONTRIBUTING.md` for full workflow details
84