knowledge-platform/migrations/versions/20260901_0001_create_documents.py
2026-09-01 13:43:15 +08:00

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")