migrations 1628035363135-PacksAddMissingReleaseDates.ts

0% Statements 0/17

0% Branches 0/1

0% Functions 0/1

0% Lines 0/17

Press n or j to go to the next uncovered block, b, p or k for the previous block.


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18  
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
  import { MigrationInterface, QueryRunner } from "typeorm";

export class PacksAddMissingReleaseDates1628035363135 implements MigrationInterface {
    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`UPDATE packs SET releaseDate='2021-08-27', type='Expansion' WHERE code='MC021'`);
        await queryRunner.query(`UPDATE packs SET releaseDate='2021-09-01', type='Hero' WHERE code='MC022'`);
        await queryRunner.query(`UPDATE packs SET releaseDate='2021-10-01', type='Hero' WHERE code='MC023'`);
        await queryRunner.query(`INSERT INTO packs VALUES('MC024', 'The Hood', 'Scenario', '2021-11-01')`);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`UPDATE packs SET releaseDate=NULL, type=NULL WHERE code='MC021'`);
        await queryRunner.query(`UPDATE packs SET releaseDate=NULL, type=NULL WHERE code='MC022'`);
        await queryRunner.query(`UPDATE packs SET releaseDate=NULL, type=NULL WHERE code='MC023'`);
        await queryRunner.query(`DELETE FROM packs WHERE code='MC024'`);
    }
}