#!/bin/bash
export PATH=$PATH:/usr/pgsql-16/bin:/usr/bin
echo "=== superuser test (postgres.srmitihkajyjijvialqj) ==="
timeout 25 psql "host=aws-1-ap-southeast-1.pooler.supabase.com port=5432 dbname=postgres user=postgres.srmitihkajyjijvialqj password=UjianYuk@2026 sslmode=require" -tAc "select current_user, version()" 2>&1 | head -3
echo "=== list databases ==="
timeout 25 psql "host=aws-1-ap-southeast-1.pooler.supabase.com port=5432 dbname=postgres user=postgres.srmitihkajyjijvialqj password=UjianYuk@2026 sslmode=require" -tAc "select datname from pg_database" 2>&1 | head -10
echo "=== app db user test ==="
timeout 25 psql "host=aws-1-ap-southeast-1.pooler.supabase.com port=5432 dbname=cbtapps user=cbtappsc_admin password=xSql7PbdT%~3c-t^ sslmode=require" -tAc "select current_user, current_database(), (select count(*) from users)" 2>&1 | head -3