import csv, io, pathlib, re root=pathlib.Path('output') text=(root/'action-plan.csv').read_text() rows=list(csv.DictReader(io.StringIO(text))) expected=['action_id','action','owner','due','status','dependencies','source'] assert list(rows[0])==expected assert len(rows)==17 assert all(None not in r and all(r.values()) for r in rows) ids=[r['action_id'] for r in rows] assert len(ids)==len(set(ids)) for r in rows: refs=re.findall(r'\bA\d{2}\b',r['dependencies']) assert all(x in ids for x in refs), (r['action_id'],refs) assert r['action_id'] not in refs paths=re.findall(r'inputs/[\w.-]+',r['source']) assert paths and all(pathlib.Path(p).exists() for p in paths) email=(root/'update-email.txt').read_text() words=len(email.split()) assert words<=220, words assert email.startswith('To: Field Notes project team') assert 'Draft only; not sent.' in email assert (root/'decision-log.md').read_text().strip() print(f'PASS: CSV exact seven-column schema; {len(rows)} complete rows; unique IDs; valid dependency references; cited CSV input paths exist.') print(f'PASS: Email {words} whitespace-delimited words including headers and sources (limit 220); team addressee and draft-only marker present.') print('PASS: Decision log present and nonempty. Checks do not verify project execution, permissions or platform readiness.')