Jeason
e514a11e62
User 模型新增 is_admin 字段
新增 InviteCode 模型（邀请码表）
注册接口必须提供有效邀请码，使用后自动标记
管理员接口：查看所有用户、启用/禁用用户、生成/删除邀请码
前端新增管理面板页面 /admin，导航栏对管理员显示入口
注册页面新增邀请码输入框
选择性超话签到：
新增 GET /api/v1/accounts/{id}/topics 接口获取超话列表
POST /signin 接口支持 {"topic_indices": [0,1,3]} 选择性签到
新增超话选择页面 /accounts/{id}/topics，支持全选/手动勾选
账号详情页新增"选择超话签到"按钮
42 lines
1.5 KiB
Python
42 lines
1.5 KiB
Python
"""User ORM model."""
|
|
|
|
import uuid
|
|
|
|
from sqlalchemy import Boolean, Column, DateTime, String
|
|
from sqlalchemy.orm import relationship
|
|
from sqlalchemy.sql import func
|
|
|
|
from .base import Base
|
|
|
|
|
|
class User(Base):
|
|
__tablename__ = "users"
|
|
|
|
id = Column(String(36), primary_key=True, default=lambda: str(uuid.uuid4()))
|
|
username = Column(String(50), unique=True, nullable=False, index=True)
|
|
email = Column(String(255), unique=True, nullable=True, index=True)
|
|
hashed_password = Column(String(255), nullable=True)
|
|
wx_openid = Column(String(64), unique=True, nullable=True, index=True)
|
|
wx_nickname = Column(String(100), nullable=True)
|
|
wx_avatar = Column(String(500), nullable=True)
|
|
is_admin = Column(Boolean, default=False)
|
|
created_at = Column(DateTime, server_default=func.now())
|
|
is_active = Column(Boolean, default=True)
|
|
|
|
accounts = relationship("Account", back_populates="user", cascade="all, delete-orphan")
|
|
|
|
def __repr__(self):
|
|
return f"<User(id={self.id}, username='{self.username}')>"
|
|
|
|
|
|
class InviteCode(Base):
|
|
__tablename__ = "invite_codes"
|
|
|
|
id = Column(String(36), primary_key=True, default=lambda: str(uuid.uuid4()))
|
|
code = Column(String(32), unique=True, nullable=False, index=True)
|
|
created_by = Column(String(36), nullable=False)
|
|
used_by = Column(String(36), nullable=True)
|
|
is_used = Column(Boolean, default=False)
|
|
created_at = Column(DateTime, server_default=func.now())
|
|
used_at = Column(DateTime, nullable=True)
|