Skip to content

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

1.6 KB
Raw Blame
import { QueryRunner } from 'typeorm'
import { system } from '../../../helper/system/system'
import { Migration } from '../../migration'
import { migrationHelpers } from '../../migration-helpers'
import { BackfillPieceTranslation1874000000000 } from './background/1874000000000-BackfillPieceTranslation'

export class AddPieceTranslationTable1873000000000 implements Migration {
    name = 'AddPieceTranslationTable1873000000000'
    breaking = false
    release = '0.93.0'
    transaction = true

    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`
            CREATE TABLE IF NOT EXISTS "piece_translation" (
                "pieceMetadataId" character varying(21) NOT NULL,
                "locale" character varying NOT NULL,
                "translations" jsonb NOT NULL,
                CONSTRAINT "pk_piece_translation" PRIMARY KEY ("pieceMetadataId", "locale"),
                CONSTRAINT "fk_piece_translation_piece_metadata_id" FOREIGN KEY ("pieceMetadataId") REFERENCES "piece_metadata"("id") ON DELETE CASCADE ON UPDATE NO ACTION
            )
        `)
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await migrationHelpers.withBackgroundMigrationLock({
            log: system.globalLogger(),
            migration: BackfillPieceTranslation1874000000000,
            fn: async () => {
                await queryRunner.query('DELETE FROM "background_migrations" WHERE "name" = $1', [new BackfillPieceTranslation1874000000000().name])
                await queryRunner.query('DROP TABLE IF EXISTS "piece_translation"')
            },
        })
    }
}