From 20bbed188fd7833d14801dc202fa3cdbb085ca2b Mon Sep 17 00:00:00 2001 From: xuyonghao <898441624@qq.com> Date: 星期五, 20 十二月 2024 11:51:34 +0800 Subject: [PATCH] 优化excel合并脚本 --- app/models/token_model.py | 42 ++++++++++++++++++++++++++++++++++++++++-- 1 files changed, 40 insertions(+), 2 deletions(-) diff --git a/app/models/token_model.py b/app/models/token_model.py index 066c73e..736720c 100644 --- a/app/models/token_model.py +++ b/app/models/token_model.py @@ -4,6 +4,8 @@ from sqlalchemy import Column, Integer, DateTime, Text from sqlalchemy.orm import Session +from app.config.const import RAGFLOW +# from Log import logger from app.models.base_model import Base @@ -52,5 +54,41 @@ db.rollback() # 鍥炴粴浜嬪姟 -def get_token(db: Session, user_id: int) -> Type[TokenModel] | None: - return db.query(TokenModel).filter_by(user_id=user_id).first() +async def update_token(db: Session, user_id: int, access_token: str, token: dict): + # 鍙傛暟楠岃瘉 + if not isinstance(user_id, int) or user_id <= 0: + return + db_token = None + # print(token) + try: + # 鏌ヨ鐜版湁璁板綍 + db_token = db.query(TokenModel).filter_by(user_id=user_id).first() + if db_token: + # 璁板綍瀛樺湪锛岃繘琛屾洿鏂� + db_token.token = access_token + db_token.ragflow_token = token.get(RAGFLOW, "") + # db_token.token = access_token + # for k, v in token.items(): + # setattr(db_token, k.replace("app", "token"), v) + else: + # 璁板綍涓嶅瓨鍦紝杩涜鎻掑叆 + db_token = TokenModel( + user_id=user_id, + token=access_token, + ragflow_token = token.get(RAGFLOW, "") + ) + # for k, v in token.items(): + # setattr(db_token, k.replace("app", "token"), v) + db.add(db_token) + + # 鎻愪氦浜嬪姟 + db.commit() + db.refresh(db_token) + + except Exception as e: + # logger.error(e) + # 寮傚父澶勭悊 + db.rollback() # 鍥炴粴浜嬪姟 + + + -- Gitblit v1.8.0