Files
celtic-life-science/alembic/versions/c2e7f5b1a9d4_add_csv_import_rows.py
Shubhankar45 8fdd20b29f Production
2026-09-22 06:23:46 +00:00

33 lines
877 B
Python

"""store non-MVP CSV source rows
Revision ID: c2e7f5b1a9d4
Revises: b71d4c22a917
Create Date: 2026-09-18
"""
from collections.abc import Sequence
import sqlalchemy as sa
from alembic import op
revision: str = "c2e7f5b1a9d4"
down_revision: str | None = "b71d4c22a917"
branch_labels: str | Sequence[str] | None = None
depends_on: str | Sequence[str] | None = None
def upgrade() -> None:
op.create_table(
"csv_import_row",
sa.Column("id", sa.UUID(), nullable=False),
sa.Column("source_file", sa.String(length=255), nullable=False),
sa.Column("row_number", sa.Integer(), nullable=False),
sa.Column("data", sa.JSON(), nullable=False),
sa.PrimaryKeyConstraint("id"),
sa.UniqueConstraint("source_file", "row_number", name="uq_csv_import_file_row"),
)
def downgrade() -> None:
op.drop_table("csv_import_row")