slot_refresh_status.py 1.6 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647
  1. from sqlalchemy import Column, Integer, String, DateTime, Enum, Text
  2. from datetime import datetime
  3. from app.core.database import Base
  4. class VasSlotRefreshStatus(Base):
  5. __tablename__ = "vas_slot_refresh_status"
  6. __ddl__ = """
  7. CREATE TABLE IF NOT EXISTS `vas_slot_refresh_status` (
  8. `id` INT NOT NULL AUTO_INCREMENT,
  9. `routing_key` VARCHAR(255) NOT NULL,
  10. `snapshot_source` ENUM('worker','manual','sync') NOT NULL,
  11. `country` VARCHAR(100) NOT NULL,
  12. `city` VARCHAR(100) NOT NULL,
  13. `visa_type` VARCHAR(100) NOT NULL,
  14. `last_refresh_at` DATETIME NOT NULL,
  15. `last_success_at` DATETIME NULL,
  16. `last_error` TEXT NULL,
  17. `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  18. PRIMARY KEY (`id`),
  19. UNIQUE KEY `uq_vas_slot_refresh_routing` (`routing_key`)
  20. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='签证考位刷新监控汇总表';
  21. """
  22. id = Column(Integer, primary_key=True, autoincrement=True)
  23. routing_key = Column(String(255), nullable=False, unique=True)
  24. snapshot_source = Column(
  25. Enum('worker', 'manual', 'sync'),
  26. nullable=False
  27. )
  28. country = Column(String(100), nullable=False)
  29. city = Column(String(100), nullable=False)
  30. visa_type = Column(String(100), nullable=False)
  31. last_refresh_at = Column(DateTime, nullable=False)
  32. last_success_at = Column(DateTime)
  33. last_error = Column(Text)
  34. updated_at = Column(
  35. DateTime,
  36. nullable=False,
  37. default=datetime.utcnow,
  38. onupdate=datetime.utcnow
  39. )