#!/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""
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"Сводка
"
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())