Files
lanhongguangandClaude Sonnet 4.6 6602c65441 docs: 后端核心模块添加必要注释
覆盖范围:main.py / core/security.py / models / api/ws.py / api/sim_requests.py
以及 services 下的 modem_manager / modem_poller / sms_scheduler

注释内容:
- model 导入顺序约束(SQLAlchemy metadata 注册)
- bcrypt 直接使用原因(passlib Python 3.13 不兼容)
- _perm() 多角色合并规则(并集/交集语义)
- get_user_modem_grants() 审批员自动授权逻辑
- mmcli 短信三步操作(create→send→delete)及逗号解析陷阱
- ZTE run_in_executor 必要性、_source 标记含义
- IMEI 保留策略(轮询为空时沿用旧值)
- SMS 去重键说明
- DateTrigger UTC 约定及 tzinfo 去除原因
- 单次任务状态转换规则
- WebSocket 鉴权必须在 accept() 前执行的原因

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-06-25 15:31:53 +08:00

58 lines
2.7 KiB
Python

import enum
from datetime import datetime
from sqlalchemy import Column, Integer, String, DateTime, ForeignKey, Enum as SAEnum, Text, UniqueConstraint
from sqlalchemy.orm import relationship
from app.core.database import Base
class RequestStatus(str, enum.Enum):
PENDING = "pending"
APPROVED = "approved"
REJECTED = "rejected"
class PermissionLevel(str, enum.Enum):
VIEW = "view" # can see card info only
USE = "use" # can send SMS / create tasks (implies view)
class SimAccessRequest(Base):
"""Records the approval workflow. Append-only once created; status is final."""
__tablename__ = "sim_access_requests"
id = Column(Integer, primary_key=True, index=True)
user_id = Column(Integer, ForeignKey("users.id", ondelete="CASCADE"), nullable=False, index=True)
modem_id = Column(Integer, ForeignKey("modems.id", ondelete="CASCADE"), nullable=False)
status = Column(SAEnum(RequestStatus), default=RequestStatus.PENDING, nullable=False)
requested_level = Column(SAEnum(PermissionLevel), default=PermissionLevel.USE, nullable=False)
reason = Column(Text, nullable=True)
admin_note = Column(Text, nullable=True)
created_at = Column(DateTime, default=datetime.utcnow)
updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
user = relationship("User", foreign_keys=[user_id])
modem = relationship("Modem")
class SimGrant(Base):
"""当前有效授权,每个 (user, modem) 对唯一一行,审批通过或直接授权时 UPSERT。
撤销时直接删除行;expires_at=None 表示永久有效。
request_id=None 表示由管理员直接授权(非经申请流程)。
"""
__tablename__ = "sim_grants"
__table_args__ = (UniqueConstraint("user_id", "modem_id", name="uq_sim_grants_user_modem"),)
id = Column(Integer, primary_key=True, index=True)
user_id = Column(Integer, ForeignKey("users.id", ondelete="CASCADE"), nullable=False)
modem_id = Column(Integer, ForeignKey("modems.id", ondelete="CASCADE"), nullable=False)
granted_level = Column(SAEnum(PermissionLevel), nullable=False)
expires_at = Column(DateTime, nullable=True) # None = 永久;到期后 get_user_modem_grants 忽略此行
granted_by_id = Column(Integer, ForeignKey("users.id"), nullable=True)
request_id = Column(Integer, ForeignKey("sim_access_requests.id"), nullable=True) # None = 直接授权
created_at = Column(DateTime, default=datetime.utcnow)
updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
user = relationship("User", foreign_keys=[user_id])
modem = relationship("Modem")
granted_by = relationship("User", foreign_keys=[granted_by_id])