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="更新时间")