"""Convert a reviewed, normalized report to a new UTF-8 CSV. Python 3.10+.""" import argparse import csv import io import json from pathlib import Path HEADERS = ("记录号", "发现", "证据编号", "负责人", "修复状态", "复测结果") STATES = {"待修复", "待复测", "已关闭"} RESULTS = {"未复测", "通过", "未通过"} def field(row, key): value = row.get(key) if not isinstance(value, str) or not value.strip(): raise ValueError(f"字段 {key} 应为非空字符串") return value.strip() def safe_cell(text): # Keep untrusted text inert when opened in spreadsheet applications. return "'" + text if text.lstrip().startswith(("=", "+", "-", "@")) else text def convert(report): if not isinstance(report, dict): raise ValueError("根节点必须为对象") findings = report.get("findings") if not isinstance(findings, list): raise ValueError("findings 必须为列表") run = field(report, "run_id") stream = io.StringIO(newline="") writer = csv.writer(stream) writer.writerow(HEADERS) seen = set() for row in findings: if not isinstance(row, dict): raise ValueError("发现必须为对象") ident = field(row, "id") if ident in seen: raise ValueError(f"重复编号 {ident}") seen.add(ident) evidence = row.get("evidence") if not isinstance(evidence, list) or not evidence or not all( isinstance(ref, str) and ref.strip() for ref in evidence ): raise ValueError(f"{ident} 缺少证据编号") state, retest = field(row, "state"), field(row, "retest") if state not in STATES or retest not in RESULTS: raise ValueError(f"{ident} 状态或复测结果不在约定范围") if state == "已关闭" and retest != "通过": raise ValueError(f"{ident} 关闭前需要通过复测") values = [f"{run}/{ident}", field(row, "title"), " | ".join(ref.strip() for ref in evidence), field(row, "owner"), state, retest] writer.writerow(map(safe_cell, values)) return stream.getvalue() def main(): cli = argparse.ArgumentParser(description=__doc__) cli.add_argument("input", type=Path) cli.add_argument("output", type=Path) args = cli.parse_args() try: report = json.loads(args.input.read_text(encoding="utf-8-sig")) result = convert(report) with args.output.open("x", encoding="utf-8-sig", newline="") as dest: dest.write(result) except (ValueError, OSError) as err: cli.exit(1, f"{err}\n") print(f"{len(report['findings'])} records") if __name__ == "__main__": main()