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

QuoteStatus1587565597402   A

Complexity

Total Complexity 2

Size/Duplication

Total Lines 18
Duplicated Lines 0 %

Importance

Changes 0
Metric Value
wmc 2
eloc 17
dl 0
loc 18
c 0
b 0
f 0
rs 10

2 Functions

Rating   Name   Duplication   Size   Complexity  
A up 0 7 1
A down 0 7 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