#!/bin/sh
set -e

# ---------------------------------------------------------------------------
# 1. Resolve any previously failed migrations so deploy can proceed.
#    Prisma marks failed migrations in _prisma_migrations; we roll them back
#    so the current run can re-apply them cleanly.
# ---------------------------------------------------------------------------
echo "[migrate] Checking for failed migrations..."
FAILED=$(bunx prisma migrate status 2>&1 || true)

# Extract failed migration names and mark them as rolled back
echo "$FAILED" | grep -oE '[0-9]{14}_[a-z_]+' | while read -r MIGRATION; do
  # Only resolve if the status output says it failed
  if echo "$FAILED" | grep -q "failed"; then
    echo "[migrate] Resolving failed migration: $MIGRATION"
    bunx prisma migrate resolve --rolled-back "$MIGRATION" 2>/dev/null || true
  fi
done

# ---------------------------------------------------------------------------
# 2. Generate diff SQL between current migrations and the Prisma schema.
# ---------------------------------------------------------------------------
DIFF_SQL=$(bunx prisma migrate diff \
  --from-migrations prisma/migrations \
  --to-schema-datamodel prisma/schema.prisma \
  --script 2>/dev/null || true)

# If there's a meaningful diff (not just empty/comments), create a migration
if [ -n "$DIFF_SQL" ] && echo "$DIFF_SQL" | grep -qvE '^\s*$|^--'; then
  TIMESTAMP=$(date -u +"%Y%m%d%H%M%S")
  MIGRATION_DIR="prisma/migrations/${TIMESTAMP}_auto_generated"
  mkdir -p "$MIGRATION_DIR"
  echo "$DIFF_SQL" > "$MIGRATION_DIR/migration.sql"
  echo "[migrate] Created migration: $MIGRATION_DIR"
else
  echo "[migrate] Schema and migrations are in sync — no migration needed."
fi

# ---------------------------------------------------------------------------
# 3. Deploy all pending migrations.
# ---------------------------------------------------------------------------
echo "[migrate] Running prisma migrate deploy..."
bunx prisma migrate deploy