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
TypeScript ai-agentai-agent-toolsai-agentsai-agents-frameworkmcpmcp-servermcp-toolsmcpsn8n-alternativeno-code-automationworkflowworkflow-automationworkflows
import { ApEdition } from '@activepieces/shared'
import { MigrationInterface, QueryRunner } from 'typeorm'
import { system } from '../../../helper/system/system'
import { AppSystemProp } from '../../../helper/system/system-props'
const OPERATOR_ROLE_ID = '3Wl9IAw5aM0HLafHgMYkb'
const edition = system.get(AppSystemProp.EDITION)
export class RemoveOperatorRole1769613456917 implements MigrationInterface {
name = 'RemoveOperatorRole1769613456917'
public async up(queryRunner: QueryRunner): Promise<void> {
const usedRole = await queryRunner.query(`
SELECT pm."platformId"
FROM "project_member" pm
WHERE pm."projectRoleId" = $1
LIMIT 1
`, [OPERATOR_ROLE_ID])
if (usedRole.length > 0 && edition === ApEdition.ENTERPRISE) {
const platformId = usedRole[0].platformId
await queryRunner.query(`
UPDATE "project_role"
SET "type" = 'CUSTOM', "platformId" = $1
WHERE "id" = $2
`, [platformId, OPERATOR_ROLE_ID])
}
else {
await queryRunner.query(`
UPDATE "project_member"
SET "projectRoleId" = 'aJVBSSJ3YqZ7r1laFjM0a'
WHERE "projectRoleId" = $1
`, [OPERATOR_ROLE_ID])
await queryRunner.query(`
DELETE FROM "project_role"
WHERE "id" = $1
`, [OPERATOR_ROLE_ID])
}
}
public async down(_queryRunner: QueryRunner): Promise<void> {
// Do nothing
}
}