# FastAPI Framework
fastapi==0.109.0
uvicorn[standard]==0.27.0
python-multipart==0.0.7
jinja2>=3.1.0  # Template engine for serving Flask HTML

# Authentication & Security
python-jose[cryptography]==3.3.0
passlib[bcrypt]==1.7.4
PyJWT[crypto]>=2.8.0  # JWT validation for Azure AD id_tokens
msal>=1.20.0  # Microsoft Authentication Library for SSO (legacy, will be removed)

# Database & ORM
sqlalchemy==2.0.25
aiosqlite==0.19.0
alembic==1.13.1

# Redis & Caching
redis==5.0.1
aioredis==2.0.1

# Rate Limiting & Middleware
slowapi==0.1.9

# Pydantic & Settings
pydantic==2.5.0
pydantic-settings==2.1.0

# Async File Operations
aiofiles==23.2.1

# Core Libraries
python-magic>=0.4.27
python-dotenv>=1.0.1
tqdm>=4.66.0

# Excel Processing
pandas>=2.0.0
openpyxl>=3.1.0

# PDF Processing
pypdf>=4.0.0
pdfplumber>=0.11.0
PyPDF2>=3.0.0

# Image Processing
Pillow>=10.2.0
pytesseract>=0.3.0
pdf2image>=1.16.0
piexif>=1.1.0
iptcinfo3>=2.1.0

# Office Documents
python-docx>=1.0.0
python-pptx>=0.6.0

# Video Processing
mutagen>=1.45.0
ffmpeg-python>=0.2.0
pymediainfo>=7.0.0

# AI & Metadata Generation
openai>=1.0.0
tiktoken>=0.5.0
tenacity>=8.2.0

# ExifTool Integration (optional but recommended)
PyExifTool>=0.5.6

# Testing
pytest==7.4.3
pytest-asyncio==0.21.1
httpx==0.26.0
