From 9ea07e00fc8b92e9b75849859c1ecce77c7096d1 Mon Sep 17 00:00:00 2001 From: zhaoqingang <zhaoqg0118@163.com> Date: 星期四, 10 四月 2025 13:31:23 +0800 Subject: [PATCH] 优化 --- app/models/token_model.py | 49 +++++++++---------------------------------------- 1 files changed, 9 insertions(+), 40 deletions(-) diff --git a/app/models/token_model.py b/app/models/token_model.py index ccf6ee2..bfd088d 100644 --- a/app/models/token_model.py +++ b/app/models/token_model.py @@ -1,10 +1,6 @@ from datetime import datetime -from typing import Type - -from sqlalchemy import Column, Integer, DateTime, Text +from sqlalchemy import Column, Integer, DateTime, Text, String from sqlalchemy.orm import Session - -# from Log import logger from app.models.base_model import Base @@ -53,38 +49,11 @@ db.rollback() # 鍥炴粴浜嬪姟 -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 - # 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, - ) - # 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() # 鍥炴粴浜嬪姟 - - - +class ApiTokenModel(Base): + __tablename__ = "chat_api_tokens" + id = Column(String(36), primary_key=True) + app_id = Column(String(36), index=True) + type = Column(String(16)) + token = Column(String(255)) + created_at = Column(DateTime, default=datetime.now()) + last_used_at = Column(DateTime, default=datetime.now()) -- Gitblit v1.8.0