#!/usr/bin/env bash
set -e
DBPASS=$(grep ^DB_PASSWORD /var/www/html/mathapi/.env | cut -d= -f2-)

echo "=== Current schools ==="
mysql -uroot -p"$DBPASS" vocab -e "SELECT id, slug, name, subdomain, custom_domain FROM schools;" 2>/dev/null

echo ""
echo "=== Setting custom_domain on all-gifted ==="
mysql -uroot -p"$DBPASS" vocab -e "UPDATE schools SET custom_domain='vocabapi.allgifted.com' WHERE slug='all-gifted';" 2>/dev/null

echo ""
echo "=== After ==="
mysql -uroot -p"$DBPASS" vocab -e "SELECT id, slug, name, subdomain, custom_domain FROM schools;" 2>/dev/null

echo ""
echo "=== Clearing config + Apache reload ==="
cd /var/www/html/vocabapi
php artisan config:cache 2>&1 | tail -1
systemctl reload apache2

echo ""
echo "=== Reproduce: POST /api/auth/request-otp ==="
curl -s -i -X POST \
  -H "Content-Type: application/json" \
  -d '{"contact":"learner@vocabile.test"}' \
  https://vocabapi.allgifted.com/api/auth/request-otp | head -20