#!/usr/bin/env python3
"""Migración v6 — agrega columna proveedor a picking_items."""
import sqlite3, sys

DB = sys.argv[1] if len(sys.argv) > 1 else "/home/embalado/bascunan.db"

MIGRATIONS = [
    "ALTER TABLE picking_items ADD COLUMN proveedor TEXT",
]

conn = sqlite3.connect(DB)
for sql in MIGRATIONS:
    try:
        conn.execute(sql)
        print(f"  + {sql}")
    except sqlite3.OperationalError as e:
        print(f"  ~ ya existe ({e})")
conn.commit()
conn.close()
print("Migración v6 completa.")