# FastAPI ecosystem - Latest CVE-safe versions (Dec 2025)
fastapi~=0.124.0        # Latest non-vulnerable (no known CVEs)
uvicorn[standard]~=0.38.0  # Latest non-vulnerable (CVE-2025-43859 fixed in h11 0.16.0)
pydantic~=2.12.5        # Latest (CVE-2024-3772 fixed in 2.4.0+)
pydantic-settings~=2.7.0  # Settings management

# Task scheduling
apscheduler~=3.11.1     # Stable release (avoid 4.x alpha)
sqlalchemy~=2.0.36      # Required by APScheduler jobstore

# Database
psycopg2-binary~=2.9.11 # Latest stable PostgreSQL adapter
redis~=5.2.0            # Redis client

# HTTP client
httpx~=0.28.1           # Latest stable async HTTP client

# Web scraping (for doc mirroring)
scrapy~=2.12.0          # Latest stable
beautifulsoup4~=4.12.3  # HTML parsing
lxml~=5.1.0             # XML/HTML parser

# Git operations
gitpython~=3.1.43       # Latest stable

# Security/Auth
python-jose[cryptography]~=3.3.0  # JWT handling

# Cloud storage
google-cloud-storage~=2.18.0  # GCS offsite backups

# Testing
pytest~=8.3.4              # Test framework
pytest-asyncio~=0.25.2     # Async test support
pytest-cov~=6.0.0          # Coverage reporting
httpx~=0.28.1              # Already included above, used for API testing
freezegun~=1.5.1           # Time mocking for scheduler tests
