init_settlement_tables.py 1.1 KB

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