notification_outbox.py 1.5 KB

123456789101112131415161718192021222324252627282930313233343536
  1. from datetime import datetime
  2. from sqlalchemy import Column, Integer, String, DateTime, JSON
  3. from app.core.database import Base
  4. class NotificationOutbox(Base):
  5. __tablename__ = "notification_outbox"
  6. __ddl__ = """
  7. CREATE TABLE IF NOT EXISTS `notification_outbox` (
  8. `id` INT NOT NULL AUTO_INCREMENT,
  9. `msg_id` VARCHAR(64) NOT NULL,
  10. `channel` VARCHAR(32) NOT NULL,
  11. `payload` JSON NOT NULL,
  12. `priority` INT NOT NULL DEFAULT 10,
  13. `status` VARCHAR(16) NOT NULL DEFAULT 'pending',
  14. `attempts` INT NOT NULL DEFAULT 0,
  15. `next_retry_at` DATETIME NULL,
  16. `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  17. `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  18. PRIMARY KEY (`id`),
  19. UNIQUE KEY `uq_notif_outbox_msg_id` (`msg_id`),
  20. KEY `idx_notif_outbox_status_next_retry` (`status`,`next_retry_at`)
  21. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='通知发件箱/重试队列';
  22. """
  23. id = Column(Integer, primary_key=True, autoincrement=True)
  24. msg_id = Column(String(64), nullable=False, unique=True)
  25. channel = Column(String(32), nullable=False)
  26. payload = Column(JSON, nullable=False)
  27. priority = Column(Integer, default=10)
  28. status = Column(String(16), default="pending")
  29. attempts = Column(Integer, default=0)
  30. next_retry_at = Column(DateTime, nullable=True)
  31. created_at = Column(DateTime, default=datetime.utcnow)
  32. updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)