"""ORM model for notification templates.""" from __future__ import annotations from datetime import UTC, datetime from sqlalchemy import Boolean, Integer, String, Text from sqlalchemy.orm import Mapped, mapped_column from deerflow.persistence.base import Base from deerflow.persistence.types import BeijingDateTime, PortableJSON class NotificationTemplateRow(Base): __tablename__ = "notification_templates" id: Mapped[str] = mapped_column(String(128), primary_key=True) name: Mapped[str] = mapped_column(String(100), unique=True, index=True) title_template: Mapped[str] = mapped_column(String(240), default="") content_template: Mapped[str] = mapped_column(Text, default="") tags: Mapped[list] = mapped_column(PortableJSON(), default=list) enabled: Mapped[bool] = mapped_column(Boolean, default=True) version: Mapped[int] = mapped_column(Integer, default=1) created_by: Mapped[str | None] = mapped_column(String(64)) updated_by: Mapped[str | None] = mapped_column(String(64)) created_at: Mapped[datetime] = mapped_column( BeijingDateTime(), default=lambda: datetime.now(UTC) ) updated_at: Mapped[datetime] = mapped_column( BeijingDateTime(), default=lambda: datetime.now(UTC), onupdate=lambda: datetime.now(UTC) )