app/models/fallback_chain.py

from sqlalchemy import text,  Index, Integer, Text, func
from sqlalchemy.orm import Mapped, mapped_column

from app.models.base import Base


class FallbackChain(Base):
    __tablename__ = "fallback_chains"

    id: Mapped[int] = mapped_column(Integer, primary_key=True, autoincrement=True)
    name: Mapped[str] = mapped_column(Text, unique=True, nullable=False)
    description: Mapped[str] = mapped_column(Text, default="")
    trigger_models: Mapped[str] = mapped_column(Text, default="[]")
    chain: Mapped[str] = mapped_column(Text, default="[]")
    times_triggered: Mapped[int] = mapped_column(Integer, default=0)
    is_active: Mapped[int] = mapped_column(Integer, default=1)
    created_at: Mapped[str] = mapped_column(Text, server_default=text("CURRENT_TIMESTAMP"))

    __table_args__ = (Index("idx_fallback_active", "is_active"),)