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.9 KB
Raw Blame
import { QueryRunner } from 'typeorm'
import { Migration } from '../../migration'

export class AddChatRolloutFreeCreditGrant1802000000000 implements Migration {
    name = 'AddChatRolloutFreeCreditGrant1802000000000'
    breaking = false
    release = '0.85.5'

    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`
            ALTER TABLE "chat_rollout_user" ADD COLUMN "grantedFreeCreditAt" TIMESTAMP WITH TIME ZONE
        `)
        // Make the managed Activepieces provider the default chat provider so cloud free users
        // skip the "set up a provider" wall. Scoped to platforms that have not already picked a
        // chat provider, so existing BYO selections are preserved.
        await queryRunner.query(`
            UPDATE "ai_provider" SET "enabledForChat" = true
            WHERE "provider" = 'ACTIVEPIECES'
            AND "platformId" NOT IN (
                SELECT "platformId" FROM "ai_provider" WHERE "enabledForChat" = true
            )
        `)
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        // Revert the backfill: up() set enabledForChat only on ACTIVEPIECES providers for platforms
        // that had no chat provider, so those platforms now have ACTIVEPIECES as their sole chat
        // provider. Disable exactly those rows again, leaving any platform with a BYO chat provider
        // untouched.
        await queryRunner.query(`
            UPDATE "ai_provider" SET "enabledForChat" = false
            WHERE "provider" = 'ACTIVEPIECES'
            AND "enabledForChat" = true
            AND "platformId" NOT IN (
                SELECT "platformId" FROM "ai_provider"
                WHERE "enabledForChat" = true AND "provider" <> 'ACTIVEPIECES'
            )
        `)
        await queryRunner.query(`
            ALTER TABLE "chat_rollout_user" DROP COLUMN "grantedFreeCreditAt"
        `)
    }
}