"""Print a compact review table of every inventoried site with its classification evidence."""
import glob
import json
import os
import sys

sys.path.insert(0, os.path.dirname(os.path.abspath(__file__)))
from nlr_common import ROOT

rows = []
for d in sorted(glob.glob(os.path.join(ROOT, "sites", "*"))):
    try:
        m = json.load(open(os.path.join(d, "metadata", "site.json")))
        e = json.load(open(os.path.join(d, "metadata", "classification_evidence.json")))
    except FileNotFoundError:
        continue
    strong = ",".join(f"{k}:{v}" for k, v in sorted(e["strong_hits"].items(), key=lambda x: -x[1]))
    gen = ",".join(f"{k}:{v}" for k, v in sorted(e["generic_hits"].items(), key=lambda x: -x[1])[:6])
    rows.append((m["name"], m.get("custom_domain") or "", (e.get("title") or "")[:60], e.get("file_count"),
                 m["build_settings"].get("repo_url") or "", strong[:90], gen[:90]))
for r in sorted(rows):
    print(" | ".join("" if x is None else str(x) for x in r))
print(len(rows), "sites")