| 12345678910111213141516171819202122232425262728293031323334 |
- import asyncio
- import os
- import sys
- # 保证根目录在 sys.path
- sys.path.insert(0, os.path.dirname(os.path.dirname(os.path.abspath(__file__))))
- from app.core.database import engine, Base
- import app.models # 确保所有模型注册至 Base.metadata
- from app.core.migration import run_settlement_migrations
- async def init_tables():
- print("⏳ 正在连接数据库并校验/创建财务结算相关数据表与字段...")
- try:
- async with engine.begin() as conn:
- # 1. 创建新增表 (vas_agency, vas_cost_record, vas_fault_compensation, vas_settlement_period, vas_settlement_detail)
- await conn.run_sync(Base.metadata.create_all)
- print("✅ 新增表结构检查/创建完成!")
- # 2. 检查并对原有表增量添加字段
- await run_settlement_migrations(conn)
- print("✅ 增量字段平滑迁移完成!")
- except Exception as e:
- print(f"❌ 初始化失败: {e}")
- import traceback
- traceback.print_exc()
- finally:
- await engine.dispose()
- if __name__ == "__main__":
- asyncio.run(init_tables())
|