Passed
Pull Request — master (#79)
by Mathieu
01:25
created

QuoteStatus1587565597402.up   A

Complexity

Conditions 1

Size

Total Lines 7
Code Lines 7

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
eloc 7
dl 0
loc 7
c 0
b 0
f 0
rs 10
cc 1
1
import {MigrationInterface, QueryRunner} from "typeorm";
2
3
export class QuoteStatus1587565597402 implements MigrationInterface {
4
    name = 'QuoteStatus1587565597402'
5
6
    public async up(queryRunner: QueryRunner): Promise<any> {
7
        await queryRunner.query(`ALTER TABLE "quote" DROP COLUMN "status"`, undefined);
8
        await queryRunner.query(`CREATE TYPE "quote_status_enum" AS ENUM('draft', 'sent', 'refused', 'accepted', 'canceled')`, undefined);
9
        await queryRunner.query(`ALTER TABLE "quote" ADD "status" "quote_status_enum" NOT NULL`, undefined);
10
        await queryRunner.query(`ALTER TABLE "quote" DROP COLUMN "status"`, undefined);
11
        await queryRunner.query(`ALTER TABLE "quote" ADD "status" character varying NOT NULL`, undefined);
12
    }
13
14
    public async down(queryRunner: QueryRunner): Promise<any> {
15
        await queryRunner.query(`ALTER TABLE "quote" DROP COLUMN "status"`, undefined);
16
        await queryRunner.query(`ALTER TABLE "quote" ADD "status" "quote_status_enum" NOT NULL`, undefined);
17
        await queryRunner.query(`ALTER TABLE "quote" DROP COLUMN "status"`, undefined);
18
        await queryRunner.query(`DROP TYPE "quote_status_enum"`, undefined);
19
        await queryRunner.query(`ALTER TABLE "quote" ADD "status" character varying NOT NULL`, undefined);
20
    }
21
22
}
23