mirror of
https://github.com/hongguang1994/SimNexus.git
synced 2026-11-22 21:29:38 +08:00
覆盖范围: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>
58 lines
2.7 KiB
Python
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])
|