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

83 lines
3.1 KiB
Python

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