from conexion.conexionBD import connectionBD

def sql_lista_todas_ieBD(search_nivel=None, search_nombre=None):
    try:
        with connectionBD() as conexion_MySQLdb:
            with conexion_MySQLdb.cursor(dictionary=True) as cursor:
                querySQL = """
                    SELECT
                        codmodular,
                        establecimiento,
                        nombreie,
                        nivel,
                        distrito
                    FROM iiee AS e
                    WHERE 1=1
                """
                params = []
                
                if search_nivel and search_nivel.strip():
                    querySQL += " AND e.nivel LIKE %s"
                    params.append(f"%{search_nivel.strip()}%")
                
                if search_nombre and search_nombre.strip():
                    querySQL += " AND e.nombreie LIKE %s"
                    params.append(f"%{search_nombre.strip()}%")
                
                querySQL += " ORDER BY e.establecimiento ASC"
                
                cursor.execute(querySQL, params)
                iieeBD = cursor.fetchall()
        return iieeBD
    except Exception as e:
        print(
            f"Errro en la función sql_lista_todas_ieBD: {e}")
        return None