| 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 |