product_routing.py 1.4 KB

1234567891011121314151617181920212223242526272829303132333435
  1. from sqlalchemy import Column, Integer, String, DateTime, JSON
  2. from datetime import datetime
  3. from app.core.database import Base
  4. class VasProductRouting(Base):
  5. __tablename__ = "vas_product_routing"
  6. __ddl__ = """
  7. CREATE TABLE IF NOT EXISTS `vas_product_routing` (
  8. `id` INT NOT NULL AUTO_INCREMENT,
  9. `product_id` INT NOT NULL,
  10. `routing_key` VARCHAR(255) NOT NULL,
  11. `script_version` VARCHAR(50) NOT NULL,
  12. `is_active` INT NOT NULL DEFAULT 1,
  13. `priority` INT NOT NULL DEFAULT 10,
  14. `config` JSON NULL,
  15. `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  16. `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  17. PRIMARY KEY (`id`),
  18. KEY `idx_vas_routing_product_id` (`product_id`)
  19. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='产品路由分流配置表';
  20. """
  21. id = Column(Integer, primary_key=True, autoincrement=True)
  22. product_id = Column(Integer, nullable=False)
  23. routing_key = Column(String(255), nullable=False)
  24. script_version = Column(String(50), nullable=False)
  25. is_active = Column(Integer, default=1)
  26. priority = Column(Integer, default=10)
  27. config = Column(JSON)
  28. created_at = Column(DateTime, default=datetime.utcnow)
  29. updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)