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

delete_pid = "P24483299od2"
keep_pid = "P97394751"

# Delete the duplicate person
before_p = len(db["persons"])
db["persons"] = [p for p in db["persons"] if p["id"] != delete_pid]
print(f"Deleted person {delete_pid} ({before_p} -> {len(db['persons'])})")

# Delete orphaned PD record
before_pd = len(db["perDiems"])
db["perDiems"] = [pd for pd in db["perDiems"] if pd.get("personId") != delete_pid]
print(f"Deleted orphaned PD records ({before_pd} -> {len(db['perDiems'])})")

# Delete duplicate assignment
before_a = len(db["assignments"])
db["assignments"] = [a for a in db["assignments"] if a.get("personId") != delete_pid]
print(f"Deleted duplicate assignments ({before_a} -> {len(db['assignments'])})")

# Delete any hotel bookings (should be 0)
before_h = len(db["hotelBookings"])
db["hotelBookings"] = [h for h in db["hotelBookings"] if h.get("personId") != delete_pid]
print(f"Deleted hotel bookings ({before_h} -> {len(db['hotelBookings'])})")

print(f"\nKept: Sean Marshall ({keep_pid}) with TR, hotel, PD, assignment")
json.dump(db, open("/home/rmlac2fmr/public_html/jn.com/ops/data/db.json", "w"), indent=2)
print("Done!")