douyin/test/config.py

import os
import sys
sys.path.append(os.path.dirname(os.path.dirname(__file__)))
from sqlalchemy import UniqueConstraint
from loguru import logger
from sqlmodel import Field, SQLModel

# 定义数据库模型，不推荐使用 __tablename__ = '"UserInfo"' 来定义包含大写的表名字，
# 因为可能会导致与其他数据库系统不兼容，而且表查询的时候需要额外注意表格名的大小写
class UserOAuthToken(SQLModel):  
    access_token:str = Field(default=None, primary_key=True)
    refresh_expires_in:str = Field(default=None, )
    refresh_token:str = Field(default=1, )
    __table_args__ = (UniqueConstraint('open_id', 'name', name='uq_open_id_name'),)
    
user = UserOAuthToken()
HOST = '::'
con:UniqueConstraint = [col.name for col in UserOAuthToken.__table__.constraints['uq_open_id_name'].columns] 
logger.info(con)
# print(HOST)