Class Project

app/models.py:312–599

class Project(Base):
    __tablename__: str = "project"

    id: Mapped[str] = mapped_column(
        String(32), primary_key=True, default=lambda: token_hex(16)
    )
    name: Mapped[str] = mapped_column(String(100), index=True)
    has_avatar: Mapped[bool] = mapped_column(Boolean, nullable=False, default=False)
    repo_id: Mapped[int] = mapped_column(BigInteger, nullable=False, index=True)
    repo_full_name: Mapped[str] = mapped_column(String(255), nullable=False, index=True)
    repo_status: Mapped[str] = mapped_column(
        SQLAEnum(
            "active", "deleted", "removed", "transferred", name="project_github_status"
        ),
        nullable=False,
        default="active",
    )
    github_installation_id: Mapped[int] = mapped_column(
        ForeignKey("github_installation.installation_id"), nullable=False, index=True
    )
    environments: Mapped[list[dict[str, str]]] = mapped_column(
        JSON, nullable=False, default=list
    )
    _env_vars: Mapped[str] = mapped_column("env_vars", Text, nullable=False, default="")
    slug: Mapped[str] = mapped_column(String(40), nullable=True, unique=True)
    config: Mapped[dict[str, object]] = mapped_column(
        JSON, nullable=False, default=dict
    )
    created_by_user_id: Mapped[int | None] = mapped_column(
        ForeignKey("user.id", use_alter=True, ondelete="SET NULL"), nullable=True
    )
    created_at: Mapped[datetime] = mapped_column(
        index=True, nullable=False, default=utc_now
    )
    updated_at: Mapped[datetime] = mapped_column(
        index=True, nullable=False, default=utc_now, onupdate=utc_now
    )
    status: Mapped[str] = mapped_column(
        SQLAEnum("active", "paused", "deleted", name="project_status"),
        nullable=False,
        default="active",
    )
    team_id: Mapped[str] = mapped_column(ForeignKey("team.id"), index=True)

    # Relationships
    github_installation: Mapped[GithubInstallation] = relationship(
        back_populates="projects"
    )
    deployments: Mapped[list["Deployment"]] = relationship(back_populates="project")
    team: Mapped[Team] = relationship(back_populates="projects")
    created_by_user: Mapped[User | None] = relationship(
        foreign_keys=[created_by_user_id]
    )
    domains: Mapped[list["Domain"]] = relationship(back_populates="project")
    storage_links: Mapped[list["StorageProject"]] = relationship(
        back_populates="project"
    )