#!/bin/bash
# Health Data Query Tool - RAG Protokoll
# Lädt medizinische Historie und Profil aus health_data.db
#
# usage: query_health.sh [category|parameter|all] [search_term]

DB="$HOME/Gesundheit/health_data.db"

if [ ! -f "$DB" ]; then
    echo "ERROR: Database not found at $DB"
    exit 1
fi

MODE="${1:-all}"
SEARCH="${2:-}"

echo "=== Medizinisches Profil (Sticky Context) ==="
sqlite3 -header -column "$DB" \
    "SELECT parameter, value, notes FROM health_events WHERE category='PROFIL' ORDER BY date;"

echo ""
echo "=== Gesundheitsdaten Historie ==="

case "$MODE" in
    "labor")
        sqlite3 -header -column "$DB" \
            "SELECT date, parameter, value, unit, source, notes FROM health_events WHERE category='LABOR' ${SEARCH:+AND parameter LIKE '%$SEARCH%'} ORDER BY date DESC;"
        ;;
    "symptome")
        sqlite3 -header -column "$DB" \
            "SELECT date, parameter, value, notes FROM health_events WHERE category='SYMPTOME' ${SEARCH:+AND parameter LIKE '%$SEARCH%'} ORDER BY date DESC;"
        ;;
    "medikamente")
        sqlite3 -header -column "$DB" \
            "SELECT date, parameter, value, notes FROM health_events WHERE category='MEDIKAMENTE' ${SEARCH:+AND parameter LIKE '%$SEARCH%'} ORDER BY date DESC;"
        ;;
    "ernaehrung")
        sqlite3 -header -column "$DB" \
            "SELECT date, parameter, value, notes FROM health_events WHERE category='ERNÄHRUNG' ${SEARCH:+AND parameter LIKE '%$SEARCH%'} ORDER BY date DESC;"
        ;;
    "befunde")
        sqlite3 -header -column "$DB" \
            "SELECT date, parameter, value, unit, source, notes FROM health_events WHERE category='BEFUNDE' ${SEARCH:+AND parameter LIKE '%$SEARCH%'} ORDER BY date DESC;"
        ;;
    *)
        sqlite3 -header -column "$DB" \
            "SELECT date, category, parameter, value, unit, source, notes FROM health_events WHERE category!='PROFIL' ${SEARCH:+AND (parameter LIKE '%$SEARCH%' OR value LIKE '%$SEARCH%')} ORDER BY date DESC;"
        ;;
esac