From 9e51ec752c93d850db15cd61a7a3463d8fe94344 Mon Sep 17 00:00:00 2001 From: zhaoqingang <zhaoqg0118@163.com> Date: 星期五, 06 十二月 2024 10:10:09 +0800 Subject: [PATCH] 问题处理 --- app/models/base_model.py | 17 ++++++++++++++--- 1 files changed, 14 insertions(+), 3 deletions(-) diff --git a/app/models/base_model.py b/app/models/base_model.py index b8efcb8..470f473 100644 --- a/app/models/base_model.py +++ b/app/models/base_model.py @@ -1,10 +1,10 @@ import os -from sqlalchemy import create_engine +from sqlalchemy import create_engine, text from sqlalchemy.ext.declarative import declarative_base from sqlalchemy.orm import sessionmaker, Session - from app.config.config import settings +# from app.models.agent_model import AgentModel DATABASE_URL = os.getenv('DATABASE_URL') or settings.database_url @@ -16,6 +16,12 @@ # 鍒涘缓鎵�鏈夎〃锛堝鏋滄湁鏂扮殑妯″瀷绫伙紝浼氳嚜鍔ㄥ垱寤虹浉搴旂殑琛級 def init_db(): + try: + sql = text('DROP TABLE IF EXISTS agent;') + engine.execute(sql) + except Exception as e: + print(e) + Base.metadata.create_all(bind=engine) @@ -24,4 +30,9 @@ try: yield db finally: - db.close() \ No newline at end of file + db.close() + + +# def drop_table(): +# sql = text('DROP TABLE IF EXISTS agent;') +# engine.execute(sql) \ No newline at end of file -- Gitblit v1.8.0