| 1234567891011121314 |
- from sqlalchemy import Column, Integer, String, Text, TIMESTAMP, func, SmallInteger
- from app.core.database import Base
- class Task(Base):
- __tablename__ = "task"
- id = Column(Integer, primary_key=True, autoincrement=True)
- command = Column(String(255), nullable=False, comment="任务类型/命令")
- args = Column(Text, nullable=False, comment="任务参数(JSON字符串)")
- result = Column(Text, nullable=True, comment="任务执行结果(JSON字符串)")
- status = Column(SmallInteger, default=0, comment="任务状态：0待执行 1执行中 2完成 3失败")
- create_at = Column(TIMESTAMP, server_default=func.now(), comment="创建时间")
- update_at = Column(TIMESTAMP, server_default=func.now(), onupdate=func.now(), comment="更新时间")
|
