#!/usr/bin/env python3
"""Add a period-based health event, e.g. Aphte/Schub/Infekt/Medikation.

Examples:
  python3 health_add_event_period.py --start 2026-05-01 --end 2026-05-04 --type Aphte --severity mittel --label "Aphte Unterlippe"
"""
from __future__ import annotations
import argparse
import sqlite3
from pathlib import Path

DB = Path.home() / ".hermes" / "assets" / "Gesundheit" / "health_data.db"


def main() -> None:
    ap = argparse.ArgumentParser()
    ap.add_argument("--start", required=True, help="YYYY-MM-DD")
    ap.add_argument("--end", default=None, help="YYYY-MM-DD oder leer/offen")
    ap.add_argument("--type", required=True, help="z.B. Aphte, Schub, Infekt, Medikation, Ernährung")
    ap.add_argument("--label", default="")
    ap.add_argument("--severity", default="")
    ap.add_argument("--location", default="")
    ap.add_argument("--source", default="manual")
    ap.add_argument("--notes", default="")
    args = ap.parse_args()
    con = sqlite3.connect(DB)
    con.execute(
        """
        INSERT INTO health_event_periods(start_date,end_date,event_type,label,severity,location,source,notes)
        VALUES (?,?,?,?,?,?,?,?)
        """,
        (args.start, args.end, args.type, args.label, args.severity, args.location, args.source, args.notes),
    )
    con.commit(); con.close()
    print("event period added")


if __name__ == "__main__":
    main()