#!/bin/bash
# view_events.sh - Affiche le contenu de NRGY_EVENTS

DB_HOST="${DB_HOST:-localhost}"
DB_PORT="${DB_PORT:-5432}"
DB_NAME="${DB_NAME:-pcNrgy5}"
DB_USER="${DB_USER:-postgres}"
DB_PASSWORD="fromspace"

# Définir le password si fourni                                               
  if [ -n "$DB_PASSWORD" ]; then                            
    export PGPASSWORD="$DB_PASSWORD"
  fi  

MODE="${1:-summary}"

case "$MODE" in
  summary)
    echo "=== Derniers 50 événements ==="
    psql -h "$DB_HOST" -p "$DB_PORT" -U "$DB_USER" -d "$DB_NAME" \
      -c "SELECT id, ts, phase, delta_w, matched_label, ROUND(confidence::numeric, 2), source FROM NRGY_EVENTS ORDER BY ts DESC LIMIT 50;"
    ;;

  detail)
    echo "=== Vue détaillée (20 derniers) ==="
    psql -h "$DB_HOST" -p "$DB_PORT" -U "$DB_USER" -d "$DB_NAME" -x \
      -c "SELECT * FROM NRGY_EVENTS ORDER BY ts DESC LIMIT 20;"
    ;;

  count)
    echo "=== Total et par label ==="
    psql -h "$DB_HOST" -p "$DB_PORT" -U "$DB_USER" -d "$DB_NAME" \
      -c "SELECT COUNT(*) as total FROM NRGY_EVENTS; SELECT matched_label, COUNT(*) as nb FROM NRGY_EVENTS WHERE matched_label IS NOT NULL GROUP BY matched_label ORDER BY nb DESC;"
    ;;

  by_label)
    echo "=== Statistiques par consommateur ==="
    psql -h "$DB_HOST" -p "$DB_PORT" -U "$DB_USER" -d "$DB_NAME" \
      -c "SELECT matched_label, phase, COUNT(*) as nb_events, ROUND(AVG(delta_w)::numeric, 0) as delta_moyen, MIN(delta_w), MAX(delta_w) FROM NRGY_EVENTS GROUP BY matched_label, phase ORDER BY matched_label, phase;"
    ;;

  *)
    echo "Usage: $0 [summary|detail|count|by_label]"
    echo ""
    echo "  summary    - Derniers 50 événements (défaut)"
    echo "  detail     - Vue détaillée (20 derniers)"
    echo "  count      - Nombre total et par label"
    echo "  by_label   - Statistiques par consommateur"
    exit 1
    ;;
esac

