#!/bin/bash
# L6 CGIS user-data volume on 14.225.11.8 - read-only COUNTs on auth/PII tables
set -u
OUT="/root/ir-assessment/redteam/gitlab_vdss_com_vn/L6_cgis_usercounts_8.txt"
BASE="host=14.225.11.8 port=5432 user=postgres connect_timeout=10"
export PGPASSWORD='Ctech2022!@#'

{
  echo "===L6 CGIS USER COUNTS 14.225.11.8 $(date -u) ==="
  # AspNetUsers counts on major DBs
  for db in hanoiip2026 dongnaiip2026 hoabinh2025 phutho2025 viettri2025 vsip2024 sonlagis_live_v2 hanoi2023v2 sisp score ifamily_2024 cems2025; do
    cnt=$(psql "${BASE} dbname=${db}" -Atc "SELECT count(*) FROM authentication.\"AspNetUsers\";" 2>/dev/null || echo "ERR")
    echo "${db}.AspNetUsers = ${cnt}"
  done
  echo "--- miwiz PII ---"
  for db in miwiz miwiz2024; do
    u=$(psql "${BASE} dbname=${db}" -Atc "SELECT count(*) FROM public.users;" 2>/dev/null || echo "ERR")
    b=$(psql "${BASE} dbname=${db}" -Atc "SELECT count(*) FROM public.bank_accounts;" 2>/dev/null || echo "ERR")
    m=$(psql "${BASE} dbname=${db}" -Atc "SELECT count(*) FROM public.memberships;" 2>/dev/null || echo "ERR")
    echo "${db}: users=${u} bank_accounts=${b} memberships=${m}"
  done
  echo "===END==="
} > "$OUT" 2>&1

echo "--- output file: $OUT ---"
cat "$OUT"