#!/usr/bin/env bash
set -euo pipefail
ssh -o BatchMode=yes eventhub-ift bash -s <<'REMOTE'
set -euo pipefail
cd /opt/ai-router-stack
set -a; source .env; set +a
PG=$(docker ps -q -f name=ai-router_postgres | head -1)
USER="${POSTGRES_USER:-litellm}"
DB="${POSTGRES_DB:-litellm}"

echo "== SpendLogs columns =="
docker exec -e PGPASSWORD="$POSTGRES_PASSWORD" "$PG" \
  psql -U "$USER" -d "$DB" -c "\d+ \"LiteLLM_SpendLogs\"" | head -80

echo "== Recent failures =="
docker exec -e PGPASSWORD="$POSTGRES_PASSWORD" "$PG" \
  psql -U "$USER" -d "$DB" -c "
SELECT \"startTime\", status, model,
       left(coalesce(messages::text,''), 80) AS messages,
       left(coalesce(metadata::text,''), 200) AS metadata,
       left(coalesce(\"proxyServerRequest\"::text,''), 120) AS req,
       left(coalesce(response::text,''), 200) AS response
FROM \"LiteLLM_SpendLogs\"
ORDER BY \"startTime\" DESC
LIMIT 15;
"
REMOTE