task.py 1.2 KB

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