scripts/sync-review-queue-cleanup.sh

#!/usr/bin/env bash
set -euo pipefail

REPO_ROOT="$(cd "$(dirname "${BASH_SOURCE[0]}")/.." && pwd)"
DUMP_PATH="${1:-$REPO_ROOT/backups/pots_shutdown_tracker_2026-04-07_review_queue_zero.dump}"

if [[ -z "${NEON_PG_DB_URL:-}" ]]; then
  echo "NEON_PG_DB_URL is not set."
  echo "Export the Neon owner URL in this shell first."
  exit 1
fi

cd "$REPO_ROOT"

echo "Restoring review-queue cleanup dump to Neon..."
bash scripts/restore-neon-from-dump.sh "$DUMP_PATH"

echo
echo "Refreshing Neon app role grants..."
bash scripts/grant-neon-app-role.sh

echo
echo "Checking Neon-side five-carrier counts..."
bash scripts/check-neon-five-carriers.sh

echo
echo "Checking hosted five-carrier visibility..."
bash scripts/check-five-carriers.sh

echo
echo "Checking hosted review queue..."
bash scripts/check-review-queue.sh

echo
echo "Checking cross-environment alignment..."
bash scripts/check-five-carriers-alignment.sh

echo
echo "Review-queue cleanup sync completed."