from sqlalchemy import Column, Integer, String, DateTime, JSON, Enum from datetime import datetime from app.core.database import Base class VasTask(Base): __tablename__ = "vas_task" __ddl__ = """ CREATE TABLE IF NOT EXISTS `vas_task` ( `id` INT NOT NULL AUTO_INCREMENT, `order_id` VARCHAR(128) NOT NULL, `routing_key` VARCHAR(255) NOT NULL, `priority` INT NOT NULL DEFAULT 0, `script_version` VARCHAR(50) NULL, `config` JSON NULL, `status` ENUM('pending','grabbed','running','pause','cancelled','completed') NOT NULL DEFAULT 'pending', `user_inputs` JSON NULL, `grabbed_history` JSON NULL, `meta` JSON NULL, `attempt_count` INT NOT NULL DEFAULT 0, `notify_count` INT NOT NULL DEFAULT 0, `expire_at` DATETIME NULL, `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_vas_task_order_id` (`order_id`), KEY `idx_vas_task_status` (`status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='预约自动化执行任务表'; """ id = Column(Integer, primary_key=True, autoincrement=True) order_id = Column(String(128), nullable=False) routing_key = Column(String(255), nullable=False) priority = Column(Integer, default=0) script_version = Column(String(50)) config = Column(JSON) status = Column( Enum('pending','grabbed','running','pause','cancelled','completed'), default='pending' ) user_inputs = Column(JSON) grabbed_history = Column(JSON) meta = Column(JSON) attempt_count = Column(Integer, default=0) notify_count = Column(Integer, default=0) expire_at = Column(DateTime) created_at = Column(DateTime, default=datetime.utcnow) updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)