#!/usr/bin/env zsh
# db-reset.sh — drop + recreate the vsr_dev schema and re-run all migrations
# Usage: ./docker/scripts/db-reset.sh
# Requires: docker compose running (docker compose up -d)
set -euo pipefail

CONTAINER="vsr-postgres"
DB="${POSTGRES_DB:-vsr_dev}"
USER="${POSTGRES_USER:-vsr_app}"

echo "==> Resetting database: $DB"

docker exec -i "$CONTAINER" psql -U "$USER" -c "DROP SCHEMA public CASCADE; CREATE SCHEMA public;" "$DB"

echo "==> Running migrations from infra/sql/"

for f in $(ls infra/sql/*.sql | sort); do
  echo "  → $f"
  docker exec -i "$CONTAINER" psql -U "$USER" -d "$DB" < "$f"
done

echo "==> Done. Tables:"
docker exec -i "$CONTAINER" psql -U "$USER" -d "$DB" -c "\dt"