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

6.0 KB
Raw Blame
import { MigrationInterface, QueryRunner } from 'typeorm'
import { encryptUtils } from '../../../helper/encryption'
import { system } from '../../../helper/system/system'

const log = system.globalLogger()

type OldAiProviderConfig = {
    defaultHeaders: Record<string, string>
}

type NewAiProviderConfig = {
    apiKey: string
}

export class AIProviderRedactorPostgres1748871900624 implements MigrationInterface {
    name = 'AIProviderRedactorPostgres1748871900624'

    public async up(queryRunner: QueryRunner): Promise<void> {
        log.info('AIProviderRedactorPostgres1748871900624 up: started')


        const aiProviders = await queryRunner.query(`
            SELECT id, config, provider FROM "ai_provider"
        `)

        for (const provider of aiProviders) {
            try {
                const decryptedConfig: OldAiProviderConfig = await encryptUtils.decryptObject(provider.config)

                let apiKey = ''
                const providerType = provider.provider.toLowerCase()
                
                if (providerType === 'anthropic') {
                    apiKey = decryptedConfig.defaultHeaders['x-api-key'] || ''
                }
                else if (providerType === 'openai' || providerType === 'replicate') {
                    const authHeader = decryptedConfig.defaultHeaders['Authorization'] || ''
                    apiKey = authHeader.replace(/^Bearer\s+/i, '')
                }

                if (apiKey === '') {
                    log.error({ providerId: provider.id }, '[AIProviderRedactorPostgres1748871900624#up] No API key found for AI provider')
                    continue
                }

                const newConfig: NewAiProviderConfig = {
                    apiKey,
                }

                const encryptedNewConfig = encryptUtils.encryptObject(newConfig)
                
                await queryRunner.query(`
                    UPDATE "ai_provider" SET config = $1 WHERE id = $2
                `, [encryptedNewConfig, provider.id])
            }
            catch (error) {
                log.error({ 
                    error,
                    providerId: provider.id,
                }, 'Failed to transform config for provider')
                throw error
            }
        }

        await queryRunner.query(`
            ALTER TABLE "ai_provider" DROP COLUMN "baseUrl"
        `)
        await queryRunner.query(`
            ALTER TABLE "ai_provider" DROP CONSTRAINT "fk_ai_provider_platform_id"
        `)
        await queryRunner.query(`
            DROP INDEX "idx_ai_provider_platform_id_provider"
        `)
        await queryRunner.query(`
            ALTER TABLE "ai_provider" ALTER COLUMN "platformId" TYPE character varying(21)
        `)
        await queryRunner.query(`
            CREATE UNIQUE INDEX "idx_ai_provider_platform_id_provider" ON "ai_provider" ("platformId", "provider")
        `)
        await queryRunner.query(`
            ALTER TABLE "ai_provider"
            ADD CONSTRAINT "fk_ai_provider_platform_id" FOREIGN KEY ("platformId") REFERENCES "platform"("id") ON DELETE CASCADE ON UPDATE NO ACTION
        `)

        log.info('AIProviderRedactorPostgres1748871900624 up: finished')
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        log.info('AIProviderRedactorPostgres1748871900624 down: started')


        const aiProviders = await queryRunner.query(`
            SELECT id, config, provider FROM "ai_provider"
        `)

        for (const provider of aiProviders) {
            try {
                const decryptedConfig: NewAiProviderConfig = await encryptUtils.decryptObject(provider.config)
                
                const defaultHeaders: Record<string, string> = {}
                const providerType = provider.provider.toLowerCase()
                
                if (providerType === 'anthropic') {
                    defaultHeaders['x-api-key'] = decryptedConfig.apiKey
                }
                else if (providerType === 'openai' || providerType === 'replicate') {
                    defaultHeaders['Authorization'] = `Bearer ${decryptedConfig.apiKey}`
                }
                else {
                    defaultHeaders['Authorization'] = decryptedConfig.apiKey
                }

                const oldConfig: OldAiProviderConfig = {
                    defaultHeaders,
                }

                const encryptedOldConfig = encryptUtils.encryptObject(oldConfig)
                
                await queryRunner.query(`
                    UPDATE "ai_provider" SET config = $1 WHERE id = $2
                `, [encryptedOldConfig, provider.id])
            }
            catch (error) {
                log.error({ 
                    error,
                    providerId: provider.id,
                }, 'Failed to reverse transform config for provider')
                const fallbackConfig = encryptUtils.encryptObject({ defaultHeaders: {} })
                await queryRunner.query(`
                    UPDATE "ai_provider" SET config = $1 WHERE id = $2
                `, [fallbackConfig, provider.id])
            }
        }

        await queryRunner.query(`
            ALTER TABLE "ai_provider" DROP CONSTRAINT "fk_ai_provider_platform_id"
        `)
        await queryRunner.query(`
            DROP INDEX "idx_ai_provider_platform_id_provider"
        `)
        await queryRunner.query(`
            ALTER TABLE "ai_provider" ALTER COLUMN "platformId" TYPE character varying
        `)
        await queryRunner.query(`
            CREATE UNIQUE INDEX "idx_ai_provider_platform_id_provider" ON "ai_provider" ("platformId", "provider")
        `)
        await queryRunner.query(`
            ALTER TABLE "ai_provider"
            ADD CONSTRAINT "fk_ai_provider_platform_id" FOREIGN KEY ("platformId") REFERENCES "platform"("id") ON DELETE CASCADE ON UPDATE NO ACTION
        `)
        await queryRunner.query(`
            ALTER TABLE "ai_provider"
            ADD "baseUrl" character varying NOT NULL
        `)

        log.info('AIProviderRedactorPostgres1748871900624 down: finished')
    }
}