import json
db = json.load(open("/home/rmlac2fmr/public_html/jn.com/ops/data/db.json"))

person_ids = set(p["id"] for p in db["persons"])
orphans = [a for a in db["assignments"] if a["personId"] not in person_ids]

print(f"Total assignments: {len(db['assignments'])}")
print(f"Orphaned assignments: {len(orphans)}\n")

for a in orphans:
    show = next((s for s in db["shows"] if s["id"] == a["showId"]), None)
    show_name = show["code"] if show else a["showId"]
    # Check if there's a travel request with this personId
    reqs = [r for r in db["travelRequests"] if r["personId"] == a["personId"]]
    req_info = f" — has {len(reqs)} travel request(s): {', '.join(r.get('submittedName','?') for r in reqs)}" if reqs else " — no travel requests"
    print(f"  Assignment {a['id']}: personId={a['personId']} show={show_name}{req_info}")