#!/usr/bin/env python3 """Отчет по метаданным изображений в CSV.""" from __future__ import annotations import argparse import csv import sys from datetime import datetime from pathlib import Path try: from PIL import Image except ImportError: sys.exit("Нужен Pillow: python3 -m pip install Pillow") EXTENSIONS = {".jpg", ".jpeg", ".png", ".webp", ".tif", ".tiff"} FIELDS = [ "file", "format", "width", "height", "bytes", "modified", "date_taken", "make", "model", "lens", "iso", "f_number", "exposure", "focal_length", "orientation", "gps_lat", "gps_lon", ] def collect(root: Path, recursive: bool) -> list[Path]: pattern = "**/*" if recursive else "*" return sorted( path for path in root.glob(pattern) if path.is_file() and path.suffix.lower() in EXTENSIONS ) def clean(value: object) -> str: if value is None: return "" if isinstance(value, bytes): return value.decode("utf-8", errors="ignore").strip("\x00").strip() if isinstance(value, tuple) and len(value) == 2 and all(isinstance(item, int) for item in value): if value[1]: return f"{value[0] / value[1]:g}" return str(value).strip("\x00").strip() def decimal_gps(values: object, reference: object) -> str: try: degrees, minutes, seconds = values def number(item: object) -> float: if isinstance(item, tuple) and len(item) == 2 and item[1]: return item[0] / item[1] return float(item) result = number(degrees) + number(minutes) / 60 + number(seconds) / 3600 reference_text = ( reference.decode("ascii", errors="ignore") if isinstance(reference, bytes) else str(reference) ) if reference_text.upper() in {"S", "W"}: result = -result return f"{result:.6f}" except Exception: return "" def row_for(path: Path) -> dict[str, str]: stat = path.stat() row = {field: "" for field in FIELDS} row.update( { "file": str(path), "bytes": str(stat.st_size), "modified": datetime.fromtimestamp(stat.st_mtime).strftime("%Y-%m-%d %H:%M:%S"), } ) try: with Image.open(path) as image: row["format"] = image.format or "" row["width"] = str(image.width) row["height"] = str(image.height) exif = image.getexif() detailed = {} gps = {} try: detailed = exif.get_ifd(0x8769) except Exception: pass try: gps = exif.get_ifd(0x8825) except Exception: pass row["date_taken"] = clean(detailed.get(36867) or exif.get(306)) row["make"] = clean(exif.get(271)) row["model"] = clean(exif.get(272)) row["lens"] = clean(detailed.get(42036)) row["iso"] = clean(detailed.get(34855)) row["f_number"] = clean(detailed.get(33437)) row["exposure"] = clean(detailed.get(33434)) row["focal_length"] = clean(detailed.get(37386)) row["orientation"] = clean(exif.get(274)) if gps: row["gps_lat"] = decimal_gps(gps.get(2), gps.get(1)) row["gps_lon"] = decimal_gps(gps.get(4), gps.get(3)) except Exception as error: row["format"] = f"error: {error}" return row def main() -> int: parser = argparse.ArgumentParser(description="Собрать отчет по метаданным фото") parser.add_argument("--dir", type=Path, required=True) parser.add_argument("--csv", type=Path, default=Path("metadata-report.csv")) parser.add_argument("--recursive", action="store_true") args = parser.parse_args() root = args.dir.expanduser().resolve() if not root.is_dir(): parser.error(f"Папка не найдена: {root}") files = collect(root, args.recursive) if not files: print("Изображения не найдены.") return 0 rows = [] for path in files: rows.append(row_for(path)) print(f"Обработано: {path.name}") target = args.csv.expanduser().resolve() target.parent.mkdir(parents=True, exist_ok=True) with target.open("w", encoding="utf-8-sig", newline="") as handle: writer = csv.DictWriter(handle, fieldnames=FIELDS) writer.writeheader() writer.writerows(rows) print(f"Отчет сохранен: {target} ({len(rows)} строк)") return 0 if __name__ == "__main__": raise SystemExit(main())