import csv,json,collections,zipfile,hashlib,os
rows=list(csv.DictReader(open("FIT-COVERAGE/C02/C02_FIT_COVERAGE.csv",encoding="utf-8")))
print("cols:",list(rows[0])[:14]);print("rows:",len(rows))
sc=next((k for k in rows[0] if "status" in k.lower() or "class" in k.lower()),None);print("status col:",sc)
print(collections.Counter(r[sc] for r in rows))
lv=next((k for k in rows[0] if k.lower() in("level","lvl","floor")),None)
if lv: print(collections.Counter(r[lv] for r in rows))
for r in rows:
    if r[sc]!="FITS": print({k:r[k] for k in list(rows[0])[:10]})
# C01 baseline too
r1=list(csv.DictReader(open("FIT-COVERAGE/C01/C01_FIT_COVERAGE.csv",encoding="utf-8")));print("C01",collections.Counter(r[sc] for r in r1))
# zip vs folder
z=zipfile.ZipFile("SHELL-C02/Exterior_C02_Review.zip");d=0;n=0;miss=[]
for i in z.infolist():
    if i.is_dir(): continue
    n+=1;name=i.filename.split("/",1)[-1] if i.filename.split("/")[0] not in("MODEL","VIEWS") and not os.path.exists("SHELL-C02/"+i.filename) else i.filename
    fp="SHELL-C02/"+name
    if not os.path.exists(fp): miss.append(i.filename);continue
    if hashlib.sha256(z.read(i)).hexdigest()!=hashlib.sha256(open(fp,"rb").read()).hexdigest(): d+=1;print("DIFF",i.filename)
print("zip entries",n,"differ from repo",d,"not in repo",miss)
# part bounds (glTF Y up)
P=json.load(open("C:/q2/c02_parts.json"))
def show(sub):
    for k,(lo,hi) in P.items():
        if sub.lower() in k.lower(): print(f"{k:34s} min {lo} max {hi}")
for s in("Foundation","Deck","Roof","Crown"): show(s)
