Class SelfCheckRun

src/database/models.py:215–258

系统自检运行记录

class SelfCheckRun(Base):
    """系统自检运行记录"""
    __tablename__ = "selfcheck_runs"

    id = Column(Integer, primary_key=True, autoincrement=True)
    run_uuid = Column(String(64), unique=True, nullable=False, index=True)
    mode = Column(String(20), nullable=False, default="quick")  # quick / full
    source = Column(String(40), nullable=False, default="manual")  # manual / scheduler / api
    status = Column(String(20), nullable=False, default="pending")  # pending / running / completed / failed / cancelled
    score = Column(Integer, default=0)
    total_checks = Column(Integer, default=0)
    passed_checks = Column(Integer, default=0)
    warning_checks = Column(Integer, default=0)
    failed_checks = Column(Integer, default=0)
    duration_ms = Column(Integer, default=0)
    summary = Column(String(500))
    error_message = Column(Text)
    result_data = Column(JSONEncodedDict)  # 结构化明细（检查项/修复项/统计）
    created_at = Column(DateTime, default=utcnow_naive, index=True)
    started_at = Column(DateTime)
    finished_at = Column(DateTime)
    updated_at = Column(DateTime, default=utcnow_naive, onupdate=utcnow_naive)

    def to_dict(self) -> Dict[str, Any]:
        return {
            "id": self.id,
            "run_uuid": self.run_uuid,
            "mode": self.mode,
            "source": self.source,
            "status": self.status,
            "score": int(self.score or 0),
            "total_checks": int(self.total_checks or 0),
            "passed_checks": int(self.passed_checks or 0),
            "warning_checks": int(self.warning_checks or 0),
            "failed_checks": int(self.failed_checks or 0),
            "duration_ms": int(self.duration_ms or 0),
            "summary": self.summary,
            "error_message": self.error_message,
            "result_data": self.result_data or {},
            "created_at": self.created_at.isoformat() if self.created_at else None,
            "started_at": self.started_at.isoformat() if self.started_at else None,
            "finished_at": self.finished_at.isoformat() if self.finished_at else None,
            "updated_at": self.updated_at.isoformat() if self.updated_at else None,
        }


class Setting(Base):