"""Each UKB-PPP cis set's lead's allele frequency in gnomAD's Finns, for the well-powered rule (plan section 6).

    python code/lead_frequencies.py <raw dir>

Reads Open Targets 26.09's variant table, as the IBD study's extract_marginal.py read the leads' frequency in
non-Finnish Europeans from it, for every set in <raw dir>/proteins/pqtl_sets.parquet, and writes
<raw dir>/proteins/pqtl_lead_af.parquet: studyLocusId and lead_af_fin. Metadata alone, outside the container.
"""

import sys
from pathlib import Path

import duckdb


def main(raw: Path) -> None:
    db = duckdb.connect()
    out = raw / "proteins/pqtl_lead_af.parquet"
    db.execute(f"""COPY (
        SELECT p.studyLocusId,
               (SELECT f.alleleFrequency FROM (SELECT unnest(v.alleleFrequencies) AS f) WHERE f.populationName = 'fin_adj') AS lead_af_fin
        FROM read_parquet('{raw}/proteins/pqtl_sets.parquet') p
        LEFT JOIN read_parquet('{raw}/ot/variant/*.parquet') v ON v.variantId = p.lead
        ORDER BY p.studyLocusId
    ) TO '{out}' (FORMAT parquet, COMPRESSION zstd)""")
    print(db.execute(f"SELECT count(*), count(lead_af_fin) FROM '{out}'").fetchone())


if __name__ == "__main__":
    main(Path(sys.argv[1]))
