import mysql.connector

db_config = {
    "host": "localhost",
    "user": "root",
    "password": "vertrigo",
    "database": "educa25_docente"
}

try:
    conn = mysql.connector.connect(**db_config)
    cursor = conn.cursor()
    
    # 1. Obtener todas las tablas MyISAM
    cursor.execute("""
        SELECT TABLE_NAME 
        FROM information_schema.tables 
        WHERE table_schema = 'educa25_docente' 
        AND ENGINE = 'MyISAM'
    """)
    tables = [t[0] for t in cursor.fetchall()]
    
    print(f"Detectadas {len(tables)} tablas MyISAM en 'educa25_docente'. Iniciando conversión...")
    
    for table in tables:
        # Intentar conversión directa
        # Nota: Si tiene ROW_FORMAT=FIXED, InnoDB lanzará error, así que lo forzamos a DEFAULT
        try:
            print(f"  Convirtiendo {table}...", end="\r")
            cursor.execute(f"ALTER TABLE `{table}` ENGINE=InnoDB ROW_FORMAT=DEFAULT")
        except mysql.connector.Error as err:
            print(f"\n  Error en {table}: {err}")
            
    conn.commit()
    print(f"\nProceso completado.")
    
    cursor.close()
    conn.close()
except mysql.connector.Error as err:
    print(f"Error general: {err}")