#!/bin/sh
set -e

# 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

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