#!/usr/bin/env python3 """Строит HTML-отчет из CSV.""" from __future__ import annotations import argparse import csv import html import os import sys import tempfile from datetime import datetime, timezone from pathlib import Path def numeric_summary(rows: list[dict], field: str) -> dict | None: values = [] for row in rows: try: values.append(float(row[field])) except (KeyError, TypeError, ValueError): continue if not values: return None return { "count": len(values), "min": min(values), "max": max(values), "avg": sum(values) / len(values), } def build_table(rows: list[dict], fields: list[str]) -> str: head = "".join(f"{html.escape(field)}" for field in fields) body = [] for row in rows: cells = "".join(f"{html.escape(str(row.get(field, '')))}" for field in fields) body.append(f"{cells}") return f"{head}{''.join(body)}
" def main() -> int: parser = argparse.ArgumentParser(description="HTML-отчет из CSV") parser.add_argument("--input", required=True, type=Path) parser.add_argument("--output", required=True, type=Path) parser.add_argument("--title", default="Monitoring report") parser.add_argument("--max-rows", type=int, default=500) args = parser.parse_args() try: handle = args.input.open("r", encoding="utf-8", newline="") except OSError as error: print(f"ОШИБКА: {error}", file=sys.stderr) return 2 with handle: reader = csv.DictReader(handle) fields = reader.fieldnames or [] rows = list(reader) if not fields: print("В CSV нет заголовка", file=sys.stderr) return 2 summaries = [] for field in fields: summary = numeric_summary(rows, field) if summary: summaries.append((field, summary)) summary_table = "" if summaries: head = "ПолеТочекМинимумМаксимумСреднее" body = "".join( f"{html.escape(field)}{value['count']}" f"{value['min']:.3f}{value['max']:.3f}{value['avg']:.3f}" for field, value in summaries ) summary_table = f"

Сводка

{head}{body}
" visible = rows[: max(args.max_rows, 0)] data_table = build_table(visible, fields) generated = datetime.now(timezone.utc).strftime("%Y-%m-%d %H:%M:%S UTC") title = html.escape(args.title) document = f""" {title}

{title}

Сформировано: {generated}. Строк: {len(rows)}.

{summary_table}

Данные

{data_table} """ target = args.output.expanduser() if not target.parent.is_dir(): print(f"Каталог не найден: {target.parent}", file=sys.stderr) return 2 descriptor, temporary = tempfile.mkstemp(dir=target.parent, prefix=".report-", suffix=".html") try: with os.fdopen(descriptor, "w", encoding="utf-8") as output: output.write(document) os.replace(temporary, target) except OSError as error: print(f"ОШИБКА: {error}", file=sys.stderr) return 2 print(f"Отчет записан: {target}") return 0 if __name__ == "__main__": raise SystemExit(main())