from datetime import datetime from sqlalchemy import Column, Integer, String, Text, DateTime, JSON, func, SmallInteger from app.core.database import Base class Task(Base): __tablename__ = "task" __ddl__ = """ CREATE TABLE IF NOT EXISTS `task` ( `id` INT NOT NULL AUTO_INCREMENT, `command` VARCHAR(255) NOT NULL, `args` JSON NOT NULL, `result` JSON NULL, `status` SMALLINT NOT NULL DEFAULT 0 COMMENT '任务状态:0待执行 1执行中 2完成 3失败', `create_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='通用异步指令任务表'; """ id = Column(Integer, primary_key=True, autoincrement=True) command = Column(String(255), nullable=False) args = Column(JSON, nullable=False) result = Column(JSON, nullable=True) status = Column(SmallInteger, default=0, comment="任务状态:0待执行 1执行中 2完成 3失败") create_at = Column(DateTime, default=datetime.utcnow) update_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)