vidreview/scripts/seed.sh

#!/bin/sh
# Seed VidReview mock data
#   - Checks if DB is empty first
#   - Only seeds if no users exist
#   - Safe to run on update deploys

DB_HOST="${DB_HOST:-vidreview-db}"
DB_NAME="${DB_NAME:-vidreview}"
DB_USER="${DB_USER:-vidreview}"

echo "Checking if DB needs seeding..."
COUNT=$(docker exec "$DB_HOST" psql -U "$DB_USER" -d "$DB_NAME" \
  -t -c "SELECT COUNT(*) FROM \"User\";" 2>/dev/null | tr -d '[:space:]')

if [ -z "$COUNT" ] || [ "$COUNT" -gt 0 ]; then
  echo "DB already has $COUNT user(s) -- skipping seed."
  exit 0
fi

echo "Seeding mock data..."
docker exec -i "$DB_HOST" psql -U "$DB_USER" -d "$DB_NAME" < /scripts/seed-mock-data.sql