"""add the sales projection CSV table Revision ID: e5a1c7d9f3b2 Revises: d4f8a6c2e1b0 Create Date: 2026-09-18 """ from collections.abc import Sequence import sqlalchemy as sa from alembic import op revision: str = "e5a1c7d9f3b2" down_revision: str | None = "d4f8a6c2e1b0" branch_labels: str | Sequence[str] | None = None depends_on: str | Sequence[str] | None = None def upgrade() -> None: # A pre-migration local table may exist with the old product-master schema. # The CSV is the canonical source, so recreate it using the shared CSV-table shape. op.execute("DROP TABLE IF EXISTS sales_projection") op.create_table( "sales_projection", sa.Column("id", sa.UUID(), nullable=False), sa.Column("source_row_number", sa.Integer(), nullable=False), sa.Column("serial_no", sa.Text(), nullable=True), sa.Column("product_name", sa.Text(), nullable=True), sa.Column("pts", sa.Text(), nullable=True), sa.Column("secondary_qty", sa.Text(), nullable=True), sa.Column("value", sa.Text(), nullable=True), sa.Column("closing", sa.Text(), nullable=True), sa.Column("secondary_value", sa.Text(), nullable=True), sa.Column("aug_sales", sa.Text(), nullable=True), sa.Column("value_2", sa.Text(), nullable=True), sa.PrimaryKeyConstraint("id"), sa.UniqueConstraint("source_row_number", name="uq_sales_projection_source_row"), ) def downgrade() -> None: op.drop_table("sales_projection")