task.py 647 B

123456789101112131415
  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. id = Column(Integer, primary_key=True, autoincrement=True)
  7. command = Column(String(255), nullable=False)
  8. args = Column(JSON, nullable=False)
  9. result = Column(JSON, nullable=True)
  10. status = Column(SmallInteger, default=0, comment="任务状态:0待执行 1执行中 2完成 3失败")
  11. create_at = Column(DateTime, default=datetime.utcnow)
  12. update_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)