import pymysql

conn = pymysql.connect(host='85.215.144.168', port=3306, user='asesoft', password='Pantera1', database='pastelerias', cursorclass=pymysql.cursors.DictCursor)
with conn.cursor() as cur:
    cur.execute("SELECT * FROM ge_albaranes WHERE serie='26' AND numero IN ('436', '437', '438')")
    albaranes = cur.fetchall()
    print("=== ALBARANES ===")
    for a in albaranes:
        print({k: a[k] for k in ['id', 'serie', 'numero', 'cliente_id', 'bultos', 'numero_pedido', 'edi_referencia_pedido_cliente', 'observaciones1'] if k in a})
        cur.execute("SELECT * FROM ge_albaranes_bultos WHERE albaran_id = %s", (a['id'],))
        bultos = cur.fetchall()
        print(f"  Bultos ({len(bultos)}):", bultos)
        cur.execute("SELECT id, articulo_id, descripcion, cantidad, bultos, lotes FROM ge_albaranes_lineas WHERE albaran_id = %s", (a['id'],))
        lineas = cur.fetchall()
        print(f"  Lineas ({len(lineas)}):", lineas)