"""add the stock inventory table behind the Products page and load stock.csv The Products page (GET /products/stock-inventory) reads ``stock_inventory``, which no migration created — the endpoint returned 500 on any database built from migrations. The rows are the company's product / pack / quantity list (stock.csv). They are inlined here because the CSV files are not part of the Docker image. Revision ID: h8d4f0a6c3e5 Revises: g7c3e9f5b2d4 Create Date: 2026-09-20 """ from collections.abc import Sequence import sqlalchemy as sa from alembic import op revision: str = "h8d4f0a6c3e5" down_revision: str | None = "g7c3e9f5b2d4" branch_labels: str | Sequence[str] | None = None depends_on: str | Sequence[str] | None = None # (serial_no, product_name, pack, quantity, unit) — straight from stock.csv STOCK_ROWS = [ (1, 'INTEZOLE-PD', '10X10 CAP', '10+2', None), (2, 'INTEZOLE-RD', '10X10 CAP', '10+2', None), (3, 'INTEZOLE-EL', '10X10 CAP', '10+2', None), (4, 'INTEZOLE-ED', '10X10 CAP', '10+2', None), (5, 'INTEZOLE-P40', '10X10 TAB', '10+1', None), (6, 'FENMONAC-P', '10X10 TAB', '10+1', None), (7, 'FENMONAC-SP', '10X10 TAB', '10+1', None), (8, 'FENMONAC-MR', '10X10 TAB', '10+1', None), (9, 'PENORENZ-MR 4', '10X10 TAB', '10+1', None), (10, 'CELVADOX-CV', '10X1X10 TAB', 'NA', None), (11, 'AMOCLADOV-CV 625', '10X1X10 TAB', '10+1', None), (12, 'INFEZOX-O', '10X10 TAB', '9+1', None), (13, 'FEBRIVANCE-PLUS', '10X10 TAB', '10+2', None), (14, 'HIFERGLOBIN-XT', '10X10 TAB', '9+1', None), (15, 'VIVACELLIX-360', '10X10 TAB', 'NA', None), (16, 'HEALTHOVANCE-SUPER', '10X10 TAB', '9+1', None), (17, 'HEALTHOVANCE-Q10', '10X10 TAB', 'NA', None), (18, 'MEGAVANCE-FORTE', '10X1X10CAP', '10+2', None), (19, 'BONETRA-STRONG', '10X1X10CAP', '9+1', None), (20, 'BONETRA-MAX+', '10X1X10CAP', '9+1', None), (21, 'WEAKOVER', '200ML SYRUP', '11+1', None), (22, 'BELLYFULLY', '200ML SYRUP', '11+1', None), (23, 'TUMMY SURE', '200ML SYRUP', '14+1', None), (24, 'VISCOSYNTH', '200ML SYRUP', '11+1', None), (25, 'HIFERGLOBIN-RED+', '200ML SYRUP', '14+1', None), (26, 'LYPOPINK-ADV', '200ML SYRUP', 'NA', None), ] def upgrade() -> None: stock = op.create_table( "stock_inventory", sa.Column("id", sa.Integer(), sa.Identity(), primary_key=True), sa.Column("serial_no", sa.Integer(), nullable=False), sa.Column("product_name", sa.Text(), nullable=False), sa.Column("pack", sa.Text(), nullable=True), sa.Column("quantity", sa.Text(), nullable=True), sa.Column("unit", sa.Text(), nullable=True), sa.UniqueConstraint("serial_no", name="uq_stock_inventory_serial_no"), ) op.bulk_insert( stock, [ { "serial_no": serial_no, "product_name": product_name, "pack": pack, "quantity": quantity, "unit": unit, } for serial_no, product_name, pack, quantity, unit in STOCK_ROWS ], ) def downgrade() -> None: op.drop_table("stock_inventory")