Files
bruno 724ac61cfd
CI - Continuous Integration / Security Scan (push) Failing after 0s
CI - Continuous Integration / Run Tests (push) Failing after 0s
CI - Continuous Integration / Build and Verify (push) Has been skipped
Complete CI/CD Pipeline / Code Quality & Security (push) Failing after 0s
Complete CI/CD Pipeline / Run Tests (push) Has been skipped
Complete CI/CD Pipeline / Build Docker Image (push) Has been skipped
Complete CI/CD Pipeline / Container Security Scan (push) Has been skipped
Complete CI/CD Pipeline / Deploy to Development (GitOps) (push) Has been skipped
Complete CI/CD Pipeline / Deploy to Production (GitOps) (push) Has been skipped
Complete CI/CD Pipeline / Post-deployment Verification (push) Failing after 0s
Documentation / Build Documentation (push) Failing after 3s
Complete CI/CD Pipeline / Notify Results (push) Successful in 0s
Documentation / Deploy to GitHub Pages (push) Has been skipped
Documentation / Deploy Versioned Documentation (push) Has been skipped
Documentation / Check Documentation (push) Has been skipped
OpenAPI Spec Validation / Detect Breaking Changes (push) Has been skipped
OpenAPI Spec Validation / Generate OpenAPI Spec (push) Failing after 2s
OpenAPI Spec Validation / Validate OpenAPI Spec (push) Has been skipped
OpenAPI Spec Validation / Generate API Documentation (push) Has been skipped
Security Scanning / SAST (Bandit + Semgrep) (push) Failing after 0s
OpenAPI Spec Validation / OpenAPI Validation Summary (push) Successful in 0s
Security Scanning / Dependency Scanning (Safety + Trivy) (push) Failing after 2s
Security Scanning / Container Scanning (push) Failing after 1s
Security Scanning / Secret Scanning (push) Failing after 0s
Test Matrix / Lint (push) Failing after 0s
Security Scanning / License Compliance (push) Failing after 3s
Test Matrix / Test (${{ matrix.python-version }}, ${{ matrix.test-type }}) (macos-latest, 3.11, unit) (push) Has been skipped
Test Matrix / Test (${{ matrix.python-version }}, ${{ matrix.test-type }}) (ubuntu-latest, 3.10, integration) (push) Has been skipped
Test Matrix / Test (${{ matrix.python-version }}, ${{ matrix.test-type }}) (ubuntu-latest, 3.10, unit) (push) Has been skipped
Test Matrix / Test (${{ matrix.python-version }}, ${{ matrix.test-type }}) (ubuntu-latest, 3.11, integration) (push) Has been skipped
Test Matrix / Test (${{ matrix.python-version }}, ${{ matrix.test-type }}) (ubuntu-latest, 3.11, unit) (push) Has been skipped
Test Matrix / Test (${{ matrix.python-version }}, ${{ matrix.test-type }}) (ubuntu-latest, 3.12, integration) (push) Has been skipped
Test Matrix / Test (${{ matrix.python-version }}, ${{ matrix.test-type }}) (ubuntu-latest, 3.12, unit) (push) Has been skipped
Test Matrix / E2E Tests (push) Has been skipped
Test Matrix / Coverage Summary (push) Has been skipped
Security Scanning / Security Summary (push) Failing after 1s
TODO to Issue / Create Issues from TODOs (push) Failing after 0s
Test Matrix / Security Scan (push) Failing after 3s
Test Matrix / Build Docker Image (push) Has been skipped
Test Matrix / All Tests Passed (push) Failing after 0s
fix(database): migrate from SQLite to PostgreSQL per user requirement
- Update default DATABASE_URL to PostgreSQL in backend/models/__init__.py
- Update test database to use PostgreSQL in test_api_risk_assessments.py
- Add .env.example with PostgreSQL configuration
- Add scripts/setup-postgres.sh for automated PostgreSQL setup (Docker/Homebrew/apt)

Resolves SQLite UUID incompatibility issue.
PostgreSQL provides:
- Native UUID type support
- Production-ready concurrent access
- JSON field support
- Better performance for complex queries

Related to Issue #37

🤖 Generated with Claude Code
Co-Authored-By: Claude Sonnet 4.5 <[email protected]>
2026-01-01 14:31:02 +08:00

43 lines
1.5 KiB
Bash

# =============================================================================
# 留守儿童心理风险检测平台 - 环境变量配置示例
# =============================================================================
# 应用配置
APP_ENV=development
LOG_LEVEL=INFO
SECRET_KEY=your-secret-key-change-in-production-use-openssl-rand-hex-32
# =============================================================================
# 数据库配置 (PostgreSQL)
# =============================================================================
# 开发环境数据库
DATABASE_URL=postgresql+asyncpg://postgres:postgres@localhost:5432/ljwx_children
# 测试数据库
TEST_DATABASE_URL=postgresql://postgres:postgres@localhost:5432/ljwx_children_test
# SQL 查询日志
SQL_ECHO=false
# =============================================================================
# Redis 配置
# =============================================================================
REDIS_URL=redis://localhost:6379/0
# =============================================================================
# Ollama 配置
# =============================================================================
OLLAMA_BASE_URL=http://localhost:11434
OLLAMA_MODEL=lingjingwanxiang:32b
# =============================================================================
# OpenTelemetry 配置
# =============================================================================
OTEL_ENABLED=true
OTEL_SERVICE_NAME=ljwx-children-platform
OTEL_EXPORTER_OTLP_ENDPOINT=otel-collector.tracing.svc.cluster.local:4317