prisma-next migration apply — run pending migrations

import { defineConfig } from '@prisma-next/cli/config-types';
import { typescriptContract } from '@prisma-next/sql-contract-ts/config-types';
import postgresAdapter from '@prisma-next/adapter-postgres/control';
import postgresDriver from '@prisma-next/driver-postgres/control';
import postgres from '@prisma-next/target-postgres/control';
import sql from '@prisma-next/family-sql/control';
import { contract } from './prisma/contract';

export default defineConfig({
  family: sql,
  target: postgres,
  adapter: postgresAdapter,
  driver: postgresDriver,
  extensionPacks: [],
  contract: typescriptContract(contract, 'src/prisma/contract.json'),
  db: {
    connection: process.env.DATABASE_URL,
  },
  migrations: {
    dir: 'migrations', // optional, defaults to 'migrations/'
  },
});

✖ MIGRATION.HASH_MISMATCH
  Migration at migrations/20240115120000-migration/ has been modified since it was emitted.
  Restore the original file from version control or re-run:
  node migrations/20240115120000-migration/migration.ts

# Apply migrations up to the point tracked by the 'staging' ref
prisma-next migration apply --ref staging --db $STAGING_DATABASE_URL

# Apply migrations up to the point tracked by the 'production' ref
prisma-next migration apply --ref production --db $PRODUCTION_DATABASE_URL

prisma-next migration apply ➜ Apply pending migrations to the database
  config:     prisma-next.config.ts
  migrations: migrations/
  db:         postgresql://localhost/mydb

Applying 2 pending migration(s)...
  → [1/2] 20240115120000-add-user-roles  sha256:def456...
  → [2/2] 20240116090000-backfill-roles  sha256:789abc...
✔ Applied 2 migration(s)
  Database is now at: sha256:789abc...

✔ No pending migrations — database is up to date
  Current marker: sha256:789abc...

{
  "ok": true,
  "migrationsApplied": 2,
  "destination": "sha256:789abc...",
  "migrations": [
    {
      "dir": "migrations/20240115120000-add-user-roles",
      "migrationHash": "sha256:def456...",
      "status": "applied"
    },
    {
      "dir": "migrations/20240116090000-backfill-roles",
      "migrationHash": "sha256:789abc...",
      "status": "applied"
    }
  ],
  "timings": { "total": 312 }
}