76 lines
2.4 KiB
Python
76 lines
2.4 KiB
Python
"""Create canonical documents table.
|
|
|
|
Revision ID: 20260901_0001
|
|
Revises: None
|
|
Create Date: 2026-09-01
|
|
"""
|
|
|
|
from collections.abc import Sequence
|
|
|
|
import sqlalchemy as sa
|
|
from alembic import op
|
|
|
|
revision: str = "20260901_0001"
|
|
down_revision: str | None = None
|
|
branch_labels: str | Sequence[str] | None = None
|
|
depends_on: str | Sequence[str] | None = None
|
|
|
|
|
|
def upgrade() -> None:
|
|
"""Create document metadata and processing-status index."""
|
|
op.create_table(
|
|
"documents",
|
|
sa.Column("id", sa.Uuid(), nullable=False),
|
|
sa.Column("filename", sa.String(length=255), nullable=False),
|
|
sa.Column("media_type", sa.String(length=127), nullable=False),
|
|
sa.Column("size_bytes", sa.BigInteger(), nullable=False),
|
|
sa.Column("storage_key", sa.String(length=512), nullable=False),
|
|
sa.Column(
|
|
"status",
|
|
sa.Enum(
|
|
"uploaded",
|
|
"processing",
|
|
"ready",
|
|
"failed",
|
|
name="document_status",
|
|
native_enum=False,
|
|
create_constraint=False,
|
|
),
|
|
nullable=False,
|
|
),
|
|
sa.Column("error_message", sa.Text(), nullable=True),
|
|
sa.Column(
|
|
"created_at",
|
|
sa.DateTime(timezone=True),
|
|
server_default=sa.text("CURRENT_TIMESTAMP"),
|
|
nullable=False,
|
|
),
|
|
sa.Column(
|
|
"updated_at",
|
|
sa.DateTime(timezone=True),
|
|
server_default=sa.text("CURRENT_TIMESTAMP"),
|
|
nullable=False,
|
|
),
|
|
sa.CheckConstraint("length(filename) > 0", name="filename_not_empty"),
|
|
sa.CheckConstraint(
|
|
"length(storage_key) > 0",
|
|
name="storage_key_not_empty",
|
|
),
|
|
sa.CheckConstraint(
|
|
"size_bytes >= 0",
|
|
name="size_bytes_non_negative",
|
|
),
|
|
sa.CheckConstraint(
|
|
"status IN ('uploaded', 'processing', 'ready', 'failed')",
|
|
name="status_valid",
|
|
),
|
|
sa.PrimaryKeyConstraint("id", name="pk_documents"),
|
|
sa.UniqueConstraint("storage_key", name="uq_documents_storage_key"),
|
|
)
|
|
op.create_index("ix_documents_status", "documents", ["status"], unique=False)
|
|
|
|
|
|
def downgrade() -> None:
|
|
"""Reject downgrade because project migrations are forward-only."""
|
|
raise NotImplementedError("Database migrations are forward-only")
|