8da149b84e
- Add asyncpg connection pool (db/pool.py) with JSONB codec registration - Add schema.sql with users, clients, dropdown_categories, export_templates, sheets tables - Add migrate_json.py one-time migration script for existing JSON data - Rewrite user_store, sheets/manager, api/clients, api/dropdowns, api/export as async DB-backed - Update all callers (auth, sheets, admin, ai_command, export) to await async functions - Add postgres:16-alpine service to docker-compose with named volume and health check - App container depends_on postgres; DATABASE_URL injected via env - Schema applied automatically on startup; global categories seeded if DB is empty Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
47 lines
711 B
Text
Executable file
47 lines
711 B
Text
Executable file
# AC Tool — unified brief extractor + activation calendar
|
|
|
|
# Web framework
|
|
quart>=0.19.0
|
|
quart-cors>=0.7.0
|
|
hypercorn>=0.16.0
|
|
|
|
# Auth
|
|
PyJWT>=2.8.0
|
|
msal>=1.26.0
|
|
|
|
# AI / LLM providers
|
|
google-genai[aiohttp]>=0.4.0
|
|
openai>=1.0.0
|
|
anthropic>=0.67.0
|
|
aiohttp>=3.9.0
|
|
json5>=0.9.0
|
|
|
|
# Document parsing
|
|
llama-cloud-services>=0.6.62
|
|
python-pptx>=0.6.21
|
|
PyMuPDF>=1.23.0
|
|
python-docx>=0.8.11
|
|
openpyxl>=3.1.0
|
|
xlrd>=2.0.1
|
|
|
|
# Database
|
|
asyncpg>=0.29.0
|
|
|
|
# Data
|
|
pandas>=2.0.0
|
|
numpy>=1.24.0
|
|
pydantic>=2.0.0
|
|
|
|
# Misc
|
|
Pillow>=10.0.0
|
|
beautifulsoup4>=4.12.0
|
|
lxml>=4.9.0
|
|
requests>=2.31.0
|
|
python-dotenv>=1.0.0
|
|
structlog>=23.0.0
|
|
python-dateutil>=2.8.2
|
|
typing-extensions>=4.7.0
|
|
psutil>=5.9.0
|
|
tqdm>=4.65.0
|
|
regex>=2023.0.0
|
|
cryptography>=41.0.0
|