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

# Find all persons with empty dept who have a travel request with submittedDept
fixed = 0
for p in db["persons"]:
    if not p.get("dept"):
        r = next((r for r in db["travelRequests"] if r.get("personId") == p["id"] and r.get("submittedDept")), None)
        if r:
            print(f"  Fixing {p['firstName']} {p['lastName']}: '' -> '{r['submittedDept']}'")
            p["dept"] = r["submittedDept"]
            fixed += 1
        else:
            print(f"  No dept: {p['firstName']} {p['lastName']} (no travel request to pull from)")

print(f"\nFixed {fixed} profiles")
json.dump(db, open("/home/rmlac2fmr/public_html/jn.com/ops/data/db.json", "w"), indent=2)
print("Done!")