| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556 |
- 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)
|