workflow_template

WorkflowTemplate

Bases: SQLModel

Model for the workflowtemplate database table.

ATTRIBUTE	DESCRIPTION
id	TYPE: int | None
user_id	TYPE: int
name	TYPE: str
version	TYPE: int
fractal_server_version	TYPE: str
timestamp_created	TYPE: datetime
timestamp_last_used	TYPE: datetime
user_group_id	TYPE: int | None
description	TYPE: str | None
data	TYPE: dict[str, Any]

Source code in fractal_server/app/models/v2/workflow_template.py

class WorkflowTemplate(SQLModel, table=True):
    """
    Model for the `workflowtemplate` database table.

    Attributes:
        id:
        user_id:
        name:
        version:
        fractal_server_version:
        timestamp_created:
        timestamp_last_used:
        user_group_id:
        description:
        data:
    """

    id: int | None = Field(default=None, primary_key=True)

    user_id: int = Field(foreign_key="user_oauth.id", nullable=False)
    name: str
    version: int

    fractal_server_version: str
    timestamp_created: datetime = Field(
        default_factory=get_timestamp,
        sa_column=Column(DateTime(timezone=True), nullable=False),
    )
    timestamp_last_used: datetime = Field(
        default_factory=get_timestamp,
        sa_column=Column(DateTime(timezone=True), nullable=False),
    )

    user_group_id: int | None = Field(
        foreign_key="usergroup.id", default=None, ondelete="SET NULL"
    )

    description: str | None = None
    data: dict[str, Any] = Field(sa_column=Column(JSON, nullable=False))

    __table_args__ = (
        Index(
            "ix_workflowtemplate_user_name_version_unique_constraint",
            "user_id",
            "name",
            "version",
            unique=True,
        ),
    )