Class Storage

app/models.py:631–699

class Storage(Base):
    __tablename__: str = "storage"

    id: Mapped[str] = mapped_column(
        String(32), primary_key=True, default=lambda: token_hex(16)
    )
    name: Mapped[str] = mapped_column(String(100), index=True)
    type: Mapped[str] = mapped_column(
        SQLAEnum("database", "volume", "kv", "queue", name="storage_type"),
        nullable=False,
    )
    status: Mapped[str] = mapped_column(
        SQLAEnum("pending", "active", "resetting", "deleted", name="storage_status"),
        nullable=False,
        default="pending",
    )
    config: Mapped[dict[str, object]] = mapped_column(
        JSONB, nullable=False, default=dict
    )
    error: Mapped[dict[str, object] | None] = mapped_column(JSONB, nullable=True)
    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
    )
    team_id: Mapped[str] = mapped_column(ForeignKey("team.id"), index=True)

    # Relationships
    team: Mapped["Team"] = relationship(back_populates="storages")
    created_by_user: Mapped[User | None] = relationship(
        foreign_keys=[created_by_user_id]
    )
    project_links: Mapped[list["StorageProject"]] = relationship(
        back_populates="storage"
    )

    __table_args__ = (
        UniqueConstraint("team_id", "name", name="uq_storage_team_name"),
        Index(
            "ix_storage_team_name_lower",
            "team_id",
            func.lower(name),
            unique=True,
        ),
    )

    @override
    def __repr__(self):
        return f"<Storage {self.name} ({self.type})>"

    @property
    def projects(self) -> list["Project"]:
        return [link.project for link in self.project_links if link.project]