| 123456789101112131415161718192021222324252627 |
- 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)
|