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())