Total Complexity | 2 |
Total Lines | 28 |
Duplicated Lines | 0 % |
Changes | 0 |
1 | import { MigrationInterface, QueryRunner } from 'typeorm'; |
||
2 | |||
3 | export class AddRelocationLeave1719581515131 |
||
4 | implements MigrationInterface { |
||
5 | name = 'AddRelocationLeave1719581515131'; |
||
6 | |||
7 | public async up(queryRunner: QueryRunner): Promise<void> { |
||
8 | await queryRunner.query( |
||
9 | `ALTER TYPE "public"."leave_request_type_enum" RENAME TO "leave_request_type_enum_old"` |
||
10 | ); |
||
11 | await queryRunner.query( |
||
12 | `CREATE TYPE "public"."leave_request_type_enum" AS ENUM('paid', 'unpaid', 'special', 'medical', 'illimited', 'postponedWorkedFreeDay', 'relocation')` |
||
13 | ); |
||
14 | await queryRunner.query( |
||
15 | `ALTER TABLE "leave_request" ALTER COLUMN "type" TYPE "public"."leave_request_type_enum" USING "type"::"text"::"public"."leave_request_type_enum"` |
||
16 | ); |
||
17 | await queryRunner.query(`DROP TYPE "public"."leave_request_type_enum_old"`); |
||
18 | } |
||
19 | |||
20 | public async down(queryRunner: QueryRunner): Promise<void> { |
||
21 | await queryRunner.query( |
||
22 | `CREATE TYPE "public"."leave_request_type_enum_old" AS ENUM('paid', 'unpaid', 'special', 'medical', 'illimited', 'postponedWorkedFreeDay')` |
||
23 | ); |
||
24 | await queryRunner.query( |
||
25 | `ALTER TABLE "leave_request" ALTER COLUMN "type" TYPE "public"."leave_request_type_enum_old" USING "type"::"text"::"public"."leave_request_type_enum_old"` |
||
26 | ); |
||
27 | await queryRunner.query(`DROP TYPE "public"."leave_request_type_enum"`); |
||
28 | await queryRunner.query( |
||
29 | `ALTER TYPE "public"."leave_request_type_enum_old" RENAME TO "leave_request_type_enum"` |
||
30 | ); |
||
33 |