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

print(f"Total travelers: {len(db.get('travelers', []))}")
print(f"Total talentGroups: {len(db.get('talentGroups', []))}")
print(f"Total hotelRecords: {len(db.get('hotelRecords', []))}")

for s in db.get("shows", []):
    sid = s.get("id", "")
    name = s.get("name", "?")
    trav = [t for t in db.get("travelers", []) if t.get("showId") == sid]
    groups = [g for g in db.get("talentGroups", []) if g.get("showId") == sid]
    cancelled = [t for t in trav if t.get("status") == "cancelled"]
    print(f"\n{name} ({sid}):")
    print(f"  Travelers: {len(trav)} ({len(cancelled)} cancelled)")
    print(f"  Talent Groups: {len(groups)}")