Medplum

// SPDX-FileCopyrightText: Copyright Orangebot, Inc. and Medplum contributors // SPDX-License-Identifier: Apache-2.0 import type { PoolClient } from 'pg'; import { prepareCustomMigrationJobData, runCustomMigration } from '../../workers/post-deploy-migration'; import * as fns from '../migrate-functions'; import type { MigrationActionResult } from '../types'; import type { CustomPostDeployMigration } from './types'; export const migration: CustomPostDeployMigration = { type: 'custom', prepareJobData: (asyncJob) => prepareCustomMigrationJobData(asyncJob), run: async (repo, job, jobData) => runCustomMigration(repo, job, jobData, callback), }; // prettier-ignore async function callback(client: PoolClient, results: MigrationActionResult[]): Promise<void> { await fns.idempotentCreateIndex(client, results, 'Coding_system_code_display_synonymOf_idx', `CREATE UNIQUE INDEX CONCURRENTLY IF NOT EXISTS "Coding_system_code_display_synonymOf_idx" ON "Coding" ("system", "code", "display", COALESCE("synonymOf", ('-1'::integer)::bigint))`); await fns.query(client, results, `DROP INDEX CONCURRENTLY IF EXISTS "Coding_system_code_display_idx"`); await fns.query(client, results, `DROP INDEX CONCURRENTLY IF EXISTS "Coding_system_code_idx"`); }