dazhuang
acd73431ae
Backend (FastAPI + SQLAlchemy + Claude API + RAG): - Config management with Pydantic v2 - Database engine with connection pooling and SQL injection prevention - AI engine with Claude API integration (support custom base URL) - RAG engine with ChromaDB and sentence-transformers - Requirement analysis service - Config generation service - Executor engine with SQL validation - REST API endpoints: /analyze, /generate, /execute Frontend (Vue 3 + Element Plus + Pinia): - Complete 3-step workflow: analyze → generate → execute - Step indicator with progress visualization - Analysis result display with field table - SQL preview with monospace font - Execute confirmation dialog with safety warning - Execution result display - State management with Pinia - API service integration Security: - SQL injection prevention with parameterized queries - Dangerous SQL operation blocking - Database password URL encoding - Transaction auto-rollback - Pydantic config validation Features: - Natural language requirement analysis - Automated SQL configuration generation - Safe execution with human review - LAN access support - Custom Claude API endpoint support Documentation: - README with quick start guide - Quick start guide - LAN access configuration - Dependency fixes guide - Claude API configuration - Git operation guide - Implementation report Dependencies fixed: - numpy<2.0.0 for chromadb compatibility - sentence-transformers==2.7.0 for huggingface_hub compatibility Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
26 lines
645 B
Python
26 lines
645 B
Python
import pytest
|
|
from app.core.db_engine import DatabaseEngine
|
|
|
|
|
|
def test_database_engine_init():
|
|
"""测试数据库引擎初始化"""
|
|
engine = DatabaseEngine()
|
|
assert engine.engine is not None
|
|
assert engine.Session is not None
|
|
|
|
|
|
def test_execute_sql_select():
|
|
"""测试执行 SELECT 查询"""
|
|
engine = DatabaseEngine()
|
|
result = engine.execute_sql("SELECT 1 AS test")
|
|
assert result is not None
|
|
assert len(result) > 0
|
|
|
|
|
|
def test_table_exists():
|
|
"""测试表存在性检查"""
|
|
engine = DatabaseEngine()
|
|
# 假设 SYS_FORM 表存在
|
|
exists = engine.table_exists("SYS_FORM")
|
|
assert exists is True
|