"""ORM model for custom agents.""" from __future__ import annotations from datetime import UTC, datetime from sqlalchemy import BigInteger, Boolean, String, UniqueConstraint from sqlalchemy.orm import Mapped, mapped_column from deerflow.persistence.base import Base from deerflow.persistence.types import BeijingDateTime class AgentRow(Base): __tablename__ = "agents" # Stored as a plain string so the same id can be used as the filesystem # directory name under {base_dir}/agents/{id}/. id: Mapped[str] = mapped_column(String(64), primary_key=True) name: Mapped[str] = mapped_column(String(191), nullable=False, index=True) description: Mapped[str] = mapped_column(String(1024), nullable=False, default="") user_id: Mapped[str | None] = mapped_column(String(64), nullable=True, index=True) published: Mapped[bool] = mapped_column(Boolean, nullable=False, default=False, index=True) # When True, the agent is moved into the password-gated "private square" # (私密广场) and is hidden from the regular public square / built-in list. # The flag is independent of ``published``: a private agent is still # visible to its owner in the "我的" tab, and visible to anyone in the # private-square listing once the password has been verified. is_private: Mapped[bool] = mapped_column(Boolean, nullable=False, default=False, index=True) # NULL = not featured on the homepage selector. Non-NULL = admin-curated # featured rank (lower sorts first). Only ``published=True`` agents are # eligible; the router enforces that invariant on writes. BIGINT so the # frontend can seed initial ranks from ``Date.now()`` (ms-resolution # timestamps overflow a 4-byte INT on MySQL). featured_order: Mapped[int | None] = mapped_column(BigInteger, nullable=True, index=True) created_at: Mapped[datetime] = mapped_column(BeijingDateTime(), nullable=False, default=lambda: datetime.now(UTC)) updated_at: Mapped[datetime] = mapped_column(BeijingDateTime(), nullable=False, default=lambda: datetime.now(UTC), onupdate=lambda: datetime.now(UTC)) class AgentFavoriteRow(Base): """A user's bookmark of a (typically public-square) agent. Lets a user collect agents from the 广场 (square) into their "我的" tab without owning them. One row per (user, agent); the unique constraint makes favoriting idempotent. """ __tablename__ = "agent_favorites" __table_args__ = (UniqueConstraint("user_id", "agent_id", name="uq_agent_favorites_user_agent"),) id: Mapped[str] = mapped_column(String(64), primary_key=True) user_id: Mapped[str] = mapped_column(String(64), nullable=False, index=True) agent_id: Mapped[str] = mapped_column(String(64), nullable=False, index=True) created_at: Mapped[datetime] = mapped_column(BeijingDateTime(), nullable=False, default=lambda: datetime.now(UTC))