Setting up automated deploys for GitHub to Vercel to Neon

// migrate-dev.mjs
import { spawn } from "child_process"
import { config } from "dotenv"

// Load environment variables from .env.local
config({ path: ".env.local" })

// Generate a unique migration name based on the current timestamp
const migrationName = `migration-${new Date()
  .toISOString()
  .replace(/[:.]/g, "-")}`

// Run the Prisma migrate dev command interactively
const migrate = spawn(
  "npx",
  ["prisma", "migrate", "dev", "--name", migrationName],
  { stdio: "inherit" }
)

migrate.on("close", (code) => {
  if (code !== 0) {
    console.error(`Migration process exited with code ${code}`)
    process.exit(1)
  }
})