Files
wevia-brain/db-stats.sh
2026-04-12 23:01:36 +02:00

7 lines
944 B
Bash
Executable File

#!/bin/bash
echo "DATABASE STATUS:"
echo " S204 PG: $(pg_isready 2>/dev/null && echo UP || echo DOWN)"
echo " S95 PG: $(curl -sk -u weval:W3valAdmin2026 'https://10.1.0.3:8443/api/sentinel-brain.php?action=exec&cmd=pg_isready' --max-time 5 2>/dev/null | python3 -c 'import sys,json;d=json.loads(sys.stdin.read());print(d.get("output","?"))' 2>/dev/null)"
echo " Ethica HCPs: $(curl -sk -u weval:W3valAdmin2026 'https://10.1.0.3:8443/api/sentinel-brain.php?action=exec&cmd=PGPASSWORD%3Dadmin123+psql+-U+admin+-d+adx_system+-t+-c+%22SELECT+count(*)+FROM+ethica.medecins_validated%22' --max-time 5 2>/dev/null | python3 -c 'import sys,json;print(json.loads(sys.stdin.read()).get("output","?").strip())' 2>/dev/null)"
echo " Qdrant: $(curl -sf http://127.0.0.1:6333/collections --max-time 3 2>/dev/null | python3 -c 'import sys,json;d=json.loads(sys.stdin.read());print(len(d.get("result",{}).get("collections",[])))' 2>/dev/null) collections"