import { toSchemasContainer } from '@prisma/internals' import { Migrate } from '@prisma/migrate' import type { System } from './system' function setOrRemoveEnvVariable(name: string, value: string | undefined) { if (value === undefined) { delete process.env[name] return } process.env[name] = value } export async function withMigrate( prismaSchemaPath: string, system: { config: { db: Pick } }, cb: (operations: { apply: () => Promise diagnostic: () => Promise push: (force: boolean) => Promise reset: () => Promise schema: (_: string, force: boolean) => Promise }) => Promise ) { const migrate = new Migrate(prismaSchemaPath) async function run(f: () => T) { // only required once - on child process start - but easiest to do this always const prevDBURLFromEnv = process.env.DATABASE_URL const prevShadowDBURLFromEnv = process.env.SHADOW_DATABASE_URL const prevHiddenUpdateMessage = process.env.PRISMA_HIDE_UPDATE_MESSAGE try { process.env.DATABASE_URL = system.config.db.url setOrRemoveEnvVariable('SHADOW_DATABASE_URL', system.config.db.shadowDatabaseUrl) process.env.PRISMA_HIDE_UPDATE_MESSAGE = '1' // temporarily silence return await f() } finally { setOrRemoveEnvVariable('DATABASE_URL', prevDBURLFromEnv) setOrRemoveEnvVariable('SHADOW_DATABASE_URL', prevShadowDBURLFromEnv) setOrRemoveEnvVariable('PRISMA_HIDE_UPDATE_MESSAGE', prevHiddenUpdateMessage) } } try { return await cb({ async apply() { return run(() => migrate.applyMigrations()) }, async diagnostic() { return run(() => migrate.devDiagnostic()) }, async push(force) { return run(() => migrate.push({ force })) }, async reset() { return run(() => migrate.reset()) }, async schema(schema, force) { const schemaContainer = toSchemasContainer([[prismaSchemaPath, schema]]) return run(() => migrate.engine.schemaPush({ force, schema: schemaContainer })) }, }) } finally { await (migrate.engine as any).initPromise const closePromise = new Promise(resolve => { ;(migrate.engine as any).child.once('exit', resolve) }) migrate.stop() await closePromise } }