python/requirements.txt

# ── Core Framework ──
fastapi>=0.110.0
uvicorn[standard]>=0.27.0
python-dotenv>=1.0.0

# ── Database (PostgreSQL) ──
sqlalchemy[asyncio]>=2.0.0
asyncpg>=0.29.0
alembic>=1.13.0

# ── Validation & Serialization ──
pydantic>=2.0.0
pydantic-settings>=2.0.0
pydantic[email]                  # Required by user_model.py (EmailStr)

# ── HTTP & Multipart ──
python-multipart>=0.0.6

# ── PDF Generation ──
reportlab>=4.0.0
pillow>=10.0.0

# ── DOCX Import (ETL Pipeline) ──
# (Removed - Data sets are now managed via Excel/CSV or DB directly)

# ── Auth (JWT + Password Hashing) — Functional Stub ──
# These are lazy-imported in auth_controller.py.
# Install to activate authentication:
pyjwt[crypto]>=2.8.0
passlib[bcrypt]>=1.7.4

# ── Cloud Storage (Presigned URL) — Lazy-loaded ──
# Install to activate direct photo upload:
# boto3>=1.34.0                   # For S3 / MinIO
# google-cloud-storage>=2.14.0   # For GCS

# ── Push Notifications — Lazy-loaded ──
# Install to activate FCM push:
# firebase-admin>=6.2.0

# ── Testing ──
pytest>=8.0.0
pytest-asyncio>=0.23.0
httpx>=0.27.0
aiosqlite>=0.19.0                # async SQLite driver for in-memory test DB