36c53e0e7c
Major additions across backend, frontend, and infrastructure: Backend: - IoT collector framework (Modbus TCP, MQTT, HTTP) with manager - Realistic Beijing solar/weather simulator with cloud transients - Alarm auto-checker with demo anomaly injection (3-4 events/hour) - Report generation (PDF/Excel) with sync fallback and E2E testing - Energy data CSV/XLSX export endpoint - WebSocket real-time broadcast at /ws/realtime - Alembic initial migration for all 14 tables - 77 pytest tests across 9 API routers Frontend: - Live notification badge with alarm count (was hardcoded 0) - Sankey energy flow diagram on dashboard - Device photos (SVG illustrations) on all device pages - Report download with status icons - Energy data export buttons (CSV/Excel) - WebSocket hook with auto-reconnect and polling fallback - BigScreen 2D responsive CSS (tablet/mobile) - Error handling improvements across pages Infrastructure: - PostgreSQL + TimescaleDB as primary database - Production docker-compose with nginx reverse proxy - Comprehensive Chinese README - .env.example with documentation - quick-start.sh deployment script - nginx config with gzip, caching, security headers Data: - 30-day realistic backfill (47K rows, weather-correlated) - 18 devices, 6 alarm rules, 15 historical alarm events - Beijing solar position model with seasonal variation Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>
38 lines
1.4 KiB
Plaintext
38 lines
1.4 KiB
Plaintext
# =============================================
|
|
# 天普零碳园区智慧能源管理平台 - 环境变量配置
|
|
# =============================================
|
|
# 复制此文件为 .env 并修改为实际配置值
|
|
# cp .env.example .env
|
|
|
|
# ----- 数据库 (必填) -----
|
|
POSTGRES_DB=tianpu_ems
|
|
POSTGRES_USER=tianpu
|
|
POSTGRES_PASSWORD=your-secure-password-here
|
|
|
|
# Docker 内部连接地址 (容器间通信)
|
|
DATABASE_URL=postgresql+asyncpg://tianpu:your-secure-password-here@postgres:5432/tianpu_ems
|
|
DATABASE_URL_SYNC=postgresql://tianpu:your-secure-password-here@postgres:5432/tianpu_ems
|
|
|
|
# 本地开发连接地址 (宿主机直连)
|
|
DATABASE_URL_LOCAL=postgresql+asyncpg://tianpu:your-secure-password-here@localhost:5432/tianpu_ems
|
|
DATABASE_URL_LOCAL_SYNC=postgresql://tianpu:your-secure-password-here@localhost:5432/tianpu_ems
|
|
|
|
# ----- Redis (必填) -----
|
|
# Docker 内部连接
|
|
REDIS_URL=redis://redis:6379/0
|
|
# 本地开发连接
|
|
REDIS_URL_LOCAL=redis://localhost:6379/0
|
|
|
|
# ----- JWT 认证 (必填) -----
|
|
# 生产环境请使用强随机密钥: python -c "import secrets; print(secrets.token_urlsafe(64))"
|
|
SECRET_KEY=change-this-to-a-random-secret-key
|
|
ALGORITHM=HS256
|
|
# 令牌过期时间 (分钟)，默认 480 分钟 (8 小时)
|
|
ACCESS_TOKEN_EXPIRE_MINUTES=480
|
|
|
|
# ----- 应用配置 (可选) -----
|
|
APP_NAME=TianpuEMS
|
|
# 生产环境设为 false
|
|
DEBUG=false
|
|
API_V1_PREFIX=/api/v1
|