/
1700751925992-MakeStripeCustomerIdNullable.ts
39 lines (36 loc) · 1.44 KB
/
1700751925992-MakeStripeCustomerIdNullable.ts
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
import { MigrationInterface, QueryRunner } from 'typeorm'
import { isNotOneOfTheseEditions } from '../../database-common'
import { logger } from '@activepieces/server-shared'
import { ApEdition } from '@activepieces/shared'
export class MakeStripeCustomerIdNullable1700751925992
implements MigrationInterface {
name = 'MakeStripeCustomerIdNullable1700751925992'
public async up(queryRunner: QueryRunner): Promise<void> {
if (isNotOneOfTheseEditions([ApEdition.CLOUD, ApEdition.ENTERPRISE])) {
return
}
logger.info('MakeStripeCustomerIdNullable1700751925992 is up')
await queryRunner.query(`
ALTER TABLE "project_plan"
ALTER COLUMN "stripeCustomerId" DROP NOT NULL
`)
await queryRunner.query(`
DROP INDEX "public"."idx_plan_stripe_customer_id"
`)
logger.info('MakeStripeCustomerIdNullable1700751925992 finished')
}
public async down(queryRunner: QueryRunner): Promise<void> {
if (isNotOneOfTheseEditions([ApEdition.CLOUD, ApEdition.ENTERPRISE])) {
return
}
logger.info('MakeStripeCustomerIdNullable1700751925992 is down')
await queryRunner.query(`
ALTER TABLE "project_plan"
ALTER COLUMN "stripeCustomerId"
SET NOT NULL
`)
await queryRunner.query(`
CREATE UNIQUE INDEX "idx_plan_stripe_customer_id" ON "project_plan" ("stripeCustomerId")
`)
}
}