import mysql.connector

conn = mysql.connector.connect(
    host="85.215.144.168",
    port=3306,
    database="pastelerias",
    user="asesoft",
    password="Pantera1"
)
cur = conn.cursor()

# Check if column already exists
cur.execute("SHOW COLUMNS FROM ge_stock_envasado LIKE 'estado_fabricacion'")
res = cur.fetchall()
if not res:
    print("Adding estado_fabricacion column...")
    cur.execute("""
        ALTER TABLE ge_stock_envasado 
        ADD COLUMN estado_fabricacion ENUM('PESADO','AMASANDO','HORNEANDO','ENVASADO') 
        NOT NULL DEFAULT 'ENVASADO' 
        AFTER id_formato_presentacion
    """)
    conn.commit()
    print("Column added successfully.")
else:
    print("Column estado_fabricacion already exists.")

print("\n--- Current structure of ge_stock_envasado ---")
cur.execute("DESCRIBE ge_stock_envasado")
for col in cur.fetchall():
    print(col)

cur.close()
conn.close()
