"""Invented relationship reconciliation exercise. Run with Python 3."""
import json
from collections import Counter
# type, source ID, target type, target ID, role, primary
expected = [
 ("contact","C1","company","A1","employee",True),
 ("contact","C1","company","A2","advisor",False),
 ("contact","C2","company","A2","employee",True),
 ("deal","D1","company","A1","customer",False),
 ("deal","D1","contact","C1","buyer",False),
 ("deal","D1","contact","C2","technical",False),
]
def replace(rows,i,**fields):
 r=list(rows); e=list(r[i]); names=["source_type","source_id","target_type","target_id","role","primary"]
 for k,v in fields.items(): e[names.index(k)]=v
 r[i]=tuple(e); return r
cases={"correct":expected,
 "wrong_company":replace(expected,1,target_id="A3"),
 "lost_role":replace(expected,5,role=""),
 "wrong_primary":replace(replace(expected,0,primary=False),1,primary=True),
 "duplicate_replaces_missing":expected[:5]+[expected[4]],
 "reversed_endpoints":replace(expected,4,source_type="contact",source_id="C1",target_type="deal",target_id="D1"),
 "missing_link":expected[:-1]}
results=[]
for name,rows in cases.items():
 want,got=Counter(expected),Counter(rows)
 results.append(dict(case=name,rows=len(rows),count_pass=len(rows)==len(expected),
 missing=sum((want-got).values()),unexpected=sum((got-want).values()),exact_pass=want==got))
assert sum(r["count_pass"] and not r["exact_pass"] for r in results)==5
assert sum(r["exact_pass"] for r in results)==1
print(json.dumps(results,indent=2))
