#!/usr/bin/env python3
import csv
import html
from pathlib import Path
base = Path("/mnt/pool/Spatial/MSDatabase")
csv_dir = base / "csv"
html_dir = base / "html"
html_dir.mkdir(parents=True, exist_ok=True)
for csv_file in csv_dir.glob("*.csv"):
with csv_file.open(newline="", encoding="utf-8") as f:
rows = list(csv.DictReader(f))
if not rows:
continue
number_string = rows[0].get("Number_string", csv_file.stem)
columns = list(rows[0].keys())
th = "".join(f"| {html.escape(col)} | " for col in columns)
body_rows = []
for row in rows:
tds = "".join(f"{html.escape(str(row.get(col, '')))} | " for col in columns)
body_rows.append(f"{tds}
")
tbody = "\n".join(body_rows)
page = f"""
{html.escape(number_string)}
Drive Record: {html.escape(number_string)}
"""
out_file = html_dir / f"{csv_file.stem}.html"
out_file.write_text(page, encoding="utf-8")
print("Rendered HTML files to", html_dir)