Completed
Push — master ( df0fb2...2108a7 )
by Mathieu
14s queued 12s
created

IllimitedLeaveType1651234850677.up   A

Complexity

Conditions 1

Size

Total Lines 6
Code Lines 6

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
eloc 6
dl 0
loc 6
rs 10
c 0
b 0
f 0
cc 1
1
import {MigrationInterface, QueryRunner} from "typeorm";
2
3
export class IllimitedLeaveType1651234850677 implements MigrationInterface {
4
    name = 'IllimitedLeaveType1651234850677'
5
6
    public async up(queryRunner: QueryRunner): Promise<void> {
7
        await queryRunner.query(`ALTER TYPE "leave_request_type_enum" RENAME TO "leave_request_type_enum_old"`);
8
        await queryRunner.query(`CREATE TYPE "leave_request_type_enum" AS ENUM('paid', 'unpaid', 'special', 'medical', 'illimited')`);
9
        await queryRunner.query(`ALTER TABLE "leave_request" ALTER COLUMN "type" TYPE "leave_request_type_enum" USING "type"::"text"::"leave_request_type_enum"`);
10
        await queryRunner.query(`DROP TYPE "leave_request_type_enum_old"`);
11
    }
12
13
    public async down(queryRunner: QueryRunner): Promise<void> {
14
        await queryRunner.query(`CREATE TYPE "leave_request_type_enum_old" AS ENUM('paid', 'unpaid', 'special', 'medical')`);
15
        await queryRunner.query(`ALTER TABLE "leave_request" ALTER COLUMN "type" TYPE "leave_request_type_enum_old" USING "type"::"text"::"leave_request_type_enum_old"`);
16
        await queryRunner.query(`DROP TYPE "leave_request_type_enum"`);
17
        await queryRunner.query(`ALTER TYPE "leave_request_type_enum_old" RENAME TO "leave_request_type_enum"`);
18
    }
19
}
20