import csv rows=list(csv.DictReader(open('output/action-plan.csv',newline=''))) cols=['action_id','action','owner','due','status','dependencies','source'] assert list(rows[0].keys())==cols for r in rows: assert None not in r and all(r[c] for c in cols), r ids={r['action_id'] for r in rows} assert len(ids)==len(rows) for r in rows: for d in r['dependencies'].replace(',',' ').split(): if d.startswith('A') and d[1:].isdigit(): assert d in ids, d srcfiles=['01-original-brief.md','02-meeting-notes.md','03-email-thread.txt','04-approved-change.md','05-open-questions.txt'] for r in rows: assert any(f in r['source'] for f in srcfiles) or 'CR-07' in r['source'], r['action_id'] t=open('output/update-email.txt').read() n=len(t.split()) print(len(rows),'rows; columns ok; deps ok; email words incl. headers =',n) assert n<=220 for bad in ['Oct 29','10:00 PT','120','StreamHall']: pass print('OK')