"""Look up a disease in Open Targets 26.09's disease index, for readers coding disease_id (claim_codebook.md).

    python code/find_disease.py build <Open Targets disease dir> <index json>
    python code/find_disease.py <index json> "<disease as written>"
    python code/find_disease.py <index json> --many "<disease 1>" "<disease 2>" ...

`build` keeps each disease's ID, name, exact synonyms, parents, and number of descendants. A search
prints exact matches of the name or an exact synonym first, then the closest others by shared words,
each with its parents, so a reader can pick the most specific term the paper's disease names.
"""

import json
import re
import sys
from pathlib import Path


def words(s: str) -> list:
    s = s.lower().replace("’", "'").replace("'s ", " ").replace("-", " ")
    return re.findall(r"[a-z0-9]+", s)


def norm(s: str) -> str:
    return " ".join(words(s))


def build(src: Path, out: Path) -> None:
    import duckdb
    rows = duckdb.connect().execute(f"""
        SELECT id, name, coalesce(exactSynonyms, []) AS syn, coalesce(parents, []) AS parents,
               len(coalesce(descendants, [])) AS descendants
        FROM read_parquet('{src}/*.parquet')""").fetchall()
    index = [{"id": i, "name": n, "synonyms": list(s), "parents": list(p), "descendants": d} for i, n, s, p, d in rows]
    out.write_text(json.dumps(index, ensure_ascii=False))
    print(f"{len(index)} diseases")


def search(index_path: Path, query: str, top: int = 10) -> None:
    index = json.loads(index_path.read_text())
    names = {d["id"]: d["name"] for d in index}
    q, qw = norm(query), set(words(query))
    exact, scored = [], []
    for d in index:
        labels = [d["name"], *d["synonyms"]]
        hit = next((l for l in labels if norm(l) == q), None)
        if hit:
            exact.append((d, hit))
            continue
        best = max(labels, key=lambda l: len(qw & set(words(l))) / len(qw | set(words(l))) if qw else 0)
        bw = set(words(best))
        score = len(qw & bw) / len(qw | bw) if qw | bw else 0
        if score > 0:
            scored.append((score, d, best))
    scored.sort(key=lambda x: (-x[0], x[1]["descendants"]))
    show = lambda d, label, tag: print(f"{tag} {d['id']}\t{d['name']}" + (f"\t(as \"{label}\")" if label != d['name'] else "")  # noqa: E731
                                       + f"\t{d['descendants']} descendants\tparents: " + "; ".join(names.get(p, p) for p in d["parents"][:3]))
    for d, label in exact:
        show(d, label, "EXACT")
    for score, d, label in scored[:top]:
        show(d, label, f"{score:.2f} ")


if __name__ == "__main__":
    if sys.argv[1] == "build":
        build(Path(sys.argv[2]), Path(sys.argv[3]))
    elif len(sys.argv) > 2 and sys.argv[2] == "--many":
        for q in sys.argv[3:]:
            print(f"== {q}")
            search(Path(sys.argv[1]), q, top=6)
    else:
        search(Path(sys.argv[1]), " ".join(sys.argv[2:]))
