| 123456789101112131415161718192021222324252627282930313233343536 |
- from datetime import datetime
- from sqlalchemy import Column, Integer, String, DateTime, JSON
- from app.core.database import Base
- class NotificationOutbox(Base):
- __tablename__ = "notification_outbox"
- __ddl__ = """
- CREATE TABLE IF NOT EXISTS `notification_outbox` (
- `id` INT NOT NULL AUTO_INCREMENT,
- `msg_id` VARCHAR(64) NOT NULL,
- `channel` VARCHAR(32) NOT NULL,
- `payload` JSON NOT NULL,
- `priority` INT NOT NULL DEFAULT 10,
- `status` VARCHAR(16) NOT NULL DEFAULT 'pending',
- `attempts` INT NOT NULL DEFAULT 0,
- `next_retry_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`),
- UNIQUE KEY `uq_notif_outbox_msg_id` (`msg_id`),
- KEY `idx_notif_outbox_status_next_retry` (`status`,`next_retry_at`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='通知发件箱/重试队列';
- """
- id = Column(Integer, primary_key=True, autoincrement=True)
- msg_id = Column(String(64), nullable=False, unique=True)
- channel = Column(String(32), nullable=False)
- payload = Column(JSON, nullable=False)
- priority = Column(Integer, default=10)
- status = Column(String(16), default="pending")
- attempts = Column(Integer, default=0)
- next_retry_at = Column(DateTime, nullable=True)
- created_at = Column(DateTime, default=datetime.utcnow)
- updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
|