32 lines
1.3 KiB
Python
32 lines
1.3 KiB
Python
"""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)
|
|
)
|