# Delphi Consulting Group Database System
# Python 3.12+ FastAPI Backend Requirements

# Core Web Framework
fastapi==0.115.6
uvicorn[standard]==0.32.1
gunicorn==23.0.0

# Database
sqlalchemy==2.0.36
alembic==1.14.0

# Authentication & Security
python-multipart==0.0.12
python-jose[cryptography]==3.3.0
passlib[bcrypt]==1.7.4
bcrypt==4.0.1

# Data Validation
pydantic==2.10.3
pydantic-settings==2.7.0
email-validator==2.2.0

# Templates & Static Files
jinja2==3.1.4
aiofiles==24.1.0
docxtpl==0.16.7
python-docx==1.1.2
python-dateutil==2.8.2

# Testing
pytest==8.3.4
pytest-asyncio==0.24.0
httpx==0.28.1

# Development
python-dotenv==1.0.1

# Logging
loguru==0.7.2

# Caching (optional)
redis==5.0.8

# Workflow Scheduling
croniter==1.4.1

# Metrics/Monitoring (optional)
prometheus-client==0.20.0

# User agent parsing (session security)
user-agents==2.2.0