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"

    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)