vas_task.py 1.9 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556
  1. from sqlalchemy import Column, Integer, String, DateTime, JSON, Enum
  2. from datetime import datetime
  3. from app.core.database import Base
  4. class VasTask(Base):
  5. __tablename__ = "vas_task"
  6. __ddl__ = """
  7. CREATE TABLE IF NOT EXISTS `vas_task` (
  8. `id` INT NOT NULL AUTO_INCREMENT,
  9. `order_id` VARCHAR(128) NOT NULL,
  10. `routing_key` VARCHAR(255) NOT NULL,
  11. `priority` INT NOT NULL DEFAULT 0,
  12. `script_version` VARCHAR(50) NULL,
  13. `config` JSON NULL,
  14. `status` ENUM('pending','grabbed','running','pause','cancelled','completed') NOT NULL DEFAULT 'pending',
  15. `user_inputs` JSON NULL,
  16. `grabbed_history` JSON NULL,
  17. `meta` JSON NULL,
  18. `attempt_count` INT NOT NULL DEFAULT 0,
  19. `notify_count` INT NOT NULL DEFAULT 0,
  20. `expire_at` DATETIME NULL,
  21. `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  22. `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  23. PRIMARY KEY (`id`),
  24. KEY `idx_vas_task_order_id` (`order_id`),
  25. KEY `idx_vas_task_status` (`status`)
  26. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='预约自动化执行任务表';
  27. """
  28. id = Column(Integer, primary_key=True, autoincrement=True)
  29. order_id = Column(String(128), nullable=False)
  30. routing_key = Column(String(255), nullable=False)
  31. priority = Column(Integer, default=0)
  32. script_version = Column(String(50))
  33. config = Column(JSON)
  34. status = Column(
  35. Enum('pending','grabbed','running','pause','cancelled','completed'),
  36. default='pending'
  37. )
  38. user_inputs = Column(JSON)
  39. grabbed_history = Column(JSON)
  40. meta = Column(JSON)
  41. attempt_count = Column(Integer, default=0)
  42. notify_count = Column(Integer, default=0)
  43. expire_at = Column(DateTime)
  44. created_at = Column(DateTime, default=datetime.utcnow)
  45. updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)