#!/usr/bin/env python3
"""Verify illustrative helpdesk-file outputs for HS-FILE-20260823."""
import csv
import pathlib
import sys

EXPECTED = ["4410", "760", "9", "7", "login-reset", "none"]

def main() -> int:
    path = pathlib.Path(__file__).with_name("export-summary-HS-FILE-20260823.csv")
    with path.open(newline="", encoding="utf-8") as handle:
        rows = list(csv.DictReader(handle))
    values = [row["value"] for row in rows if row["status"] == "published"]
    held = [row for row in rows if row["status"].startswith("held_")]
    if values != EXPECTED or len(held) != 3 or any(row["value"] for row in held):
        print("FAIL: helpdesk-file outputs or held items are incorrect.", file=sys.stderr)
        return 1
    print("OK: six helpdesk-file outputs and three held items verified.")
    return 0

if __name__ == "__main__":
    raise SystemExit(main())