"""UTE1 · 35 · exporta la base de lotes y los miembros para la 2.ª implementación (Python puro).""" import duckdb con = duckdb.connect('/w/tmp/ute1.duckdb', read_only=True); x = con.execute x("SET threads=4; SET memory_limit='6GB'; SET temp_directory='/w/tmp/duck'") x("""COPY (SELECT l.source, l.id_canonical, l.lote_k, l.lic, l.cpv2, l.prov, l.anio, l.imp, l.es_ute, l.empresa_clave, l.pf, EXISTS (SELECT 1 FROM dup_socio d WHERE d.id_socio = l.id_canonical AND d.lote_k = l.lote_k) dup FROM lot l) TO '/w/tmp/i2_lot.parquet' (FORMAT PARQUET)""") x("COPY (SELECT ute_clave, emp FROM ute_m) TO '/w/tmp/i2_ute.parquet' (FORMAT PARQUET)") x("COPY (SELECT cpv2, prov, anio, n, k, p, zd, hecho FROM celf) TO '/w/tmp/i1_celf.parquet' (FORMAT PARQUET)") x("COPY (SELECT a, b, cpv2, prov, t FROM dual) TO '/w/tmp/i1_dual.parquet' (FORMAT PARQUET)") print('ok')