import sqlite3
import os

db_path = "c:\\mfmm\\MelodixAPI\\musical_master.db"

if not os.path.exists(db_path):
    print(f"Error: {db_path} no existe")
    exit(1)

conn = sqlite3.connect(db_path)
cursor = conn.cursor()

try:
    print("Añadiendo columnas a 'calendarios'...")
    cursor.execute("ALTER TABLE calendarios ADD COLUMN icono TEXT DEFAULT 'calendar'")
    cursor.execute("ALTER TABLE calendarios ADD COLUMN color_fondo TEXT DEFAULT '#CE93D8'")
except sqlite3.OperationalError as e:
    print(f"Nota (calendarios): {e}")

try:
    print("Añadiendo columnas a 'servicios'...")
    cursor.execute("ALTER TABLE servicios ADD COLUMN hora TEXT")
    cursor.execute("ALTER TABLE servicios ADD COLUMN color_fondo TEXT")
except sqlite3.OperationalError as e:
    print(f"Nota (servicios): {e}")

conn.commit()
conn.close()
print("Migración completada.")