You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
25 lines
1.3 KiB
25 lines
1.3 KiB
from sqlalchemy import DateTime, Integer, String, Text, func |
|
from sqlalchemy.orm import Mapped, mapped_column |
|
|
|
from app.database import Base |
|
|
|
|
|
class Archive(Base): |
|
__tablename__ = "archives" |
|
|
|
id: Mapped[int] = mapped_column(Integer, primary_key=True, index=True) |
|
name: Mapped[str] = mapped_column(String(255), nullable=False) |
|
bottle_name: Mapped[str | None] = mapped_column(String(255), nullable=True) |
|
description: Mapped[str | None] = mapped_column(Text, nullable=True) |
|
tags: Mapped[str | None] = mapped_column(Text, nullable=True) |
|
arch: Mapped[str | None] = mapped_column(String(32), nullable=True) |
|
runner: Mapped[str | None] = mapped_column(String(128), nullable=True) |
|
windows_version: Mapped[str | None] = mapped_column(String(32), nullable=True) |
|
file_name: Mapped[str] = mapped_column(String(255), nullable=False) |
|
stored_name: Mapped[str] = mapped_column(String(255), unique=True, nullable=False) |
|
content_type: Mapped[str | None] = mapped_column(String(255), nullable=True) |
|
size_bytes: Mapped[int] = mapped_column(Integer, nullable=False) |
|
sha256: Mapped[str] = mapped_column(String(64), nullable=False, index=True) |
|
created_at: Mapped[str] = mapped_column( |
|
DateTime(timezone=True), server_default=func.now(), nullable=False |
|
)
|
|
|