#!/usr/bin/env python3 """Преобразование XML-записей в CSV.""" from __future__ import annotations import argparse import csv import json import xml.etree.ElementTree as ET from collections import Counter from pathlib import Path def local_name(tag: str) -> str: return tag.rsplit("}", 1)[-1] def element_record(element: ET.Element) -> dict: record: dict[str, object] = {} for key, value in element.attrib.items(): record[f"@{local_name(key)}"] = value text = (element.text or "").strip() if text: record["#text"] = text for child in element: name = local_name(child.tag) if len(child) == 0 and not child.attrib: value: object = (child.text or "").strip() else: value = element_record(child) if name in record: existing = record[name] if isinstance(existing, list): existing.append(value) else: record[name] = [existing, value] else: record[name] = value return record def main() -> int: parser = argparse.ArgumentParser(description="XML в CSV") parser.add_argument("--input", type=Path, required=True, help="Исходный XML") parser.add_argument("--output", type=Path, default=Path("data.csv"), help="Результат") parser.add_argument("--record", default="", help="Имя тега записи") parser.add_argument("--delimiter", default=",", help="Разделитель колонок") parser.add_argument("--force", action="store_true", help="Перезаписать выходной файл") args = parser.parse_args() source = args.input.expanduser().resolve() target = args.output.expanduser().resolve() if not source.is_file(): parser.error(f"Файл не найден: {source}") if source == target: parser.error("Выходной файл не должен совпадать с исходным") if target.exists() and not args.force: parser.error(f"Файл уже существует: {target}. Добавьте --force") if len(args.delimiter) != 1: parser.error("Разделитель должен состоять из одного символа") try: root = ET.parse(source).getroot() except (OSError, ET.ParseError) as error: parser.error(f"Не удалось прочитать XML: {error}") if args.record: records = [element for element in root.iter() if local_name(element.tag) == args.record] if not records: parser.error(f"Не найдены записи с тегом {args.record}") else: children = list(root) if not children: records = [root] else: counts = Counter(local_name(child.tag) for child in children) tag, count = counts.most_common(1)[0] if count > 1: records = [child for child in children if local_name(child.tag) == tag] else: records = children rows = [element_record(record) for record in records] columns: list[str] = [] for row in rows: for key in row: if key not in columns: columns.append(key) target.parent.mkdir(parents=True, exist_ok=True) with target.open("w", encoding="utf-8", newline="") as handle: writer = csv.DictWriter(handle, fieldnames=columns, delimiter=args.delimiter, lineterminator="\n") writer.writeheader() for row in rows: output = {} for column in columns: value = row.get(column, "") if isinstance(value, (dict, list)): value = json.dumps(value, ensure_ascii=False) output[column] = "" if value is None else value writer.writerow(output) print(f"Записей: {len(rows)}") print(f"Колонок: {len(columns)}") print(f"Результат: {target}") return 0 if __name__ == "__main__": raise SystemExit(main())