All files / projects-dev/apps/mc-api/src/migrations 1632372547645-AddNewPacks20210923.ts

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
import { MigrationInterface, QueryRunner } from "typeorm";

export class AddNewPacks202109231632372547645 implements MigrationInterface {
    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`
            INSERT INTO packs VALUES
            ('MC025', 'Valkyrie', 'Hero', '2021-12-01'),
            ('MC026', 'Vision', 'Hero', '2022-01-01'),
            ('MC027', 'Sinister Motives', 'Expansion', '2022-02-01');
        `);
        await queryRunner.query(`
            INSERT INTO heroes VALUES
            (28, 'Valkyrie', 'Hero', 'Aggression', 'MC025'),
            (29, 'Vision', 'Hero', 'Protection', 'MC026')
        `);
        await queryRunner.query(`
            INSERT INTO modular_sets VALUES
            (30, 'Beasty Boys', 'MC027', 0),
            (31, 'Brothers Grimm', 'MC027', 0),
            (32, 'Mister Hyde', 'MC027', 0),
            (33, 'Wrecking Crew', 'MC027', 0),
            (34, 'Sinister Syndicate', 'MC027', 0),
            (35, 'Crossfire''s Crew', 'MC027', 0),
            (36, 'Ransacked Armory', 'MC027', 0),
            (37, 'State of Emergency', 'MC027', 0),
            (38, 'Streets of Mayhem', 'MC027', 0);
        `);
        await queryRunner.query(`
            INSERT INTO scenarios VALUES
            (23, 'The Hood - Making Connections', 'MC027', 0, 0, 0, 0);
        `);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`
            DELETE FROM scenarios WHERE pack IN ('MC025', 'MC026', 'MC027');
        `);
        await queryRunner.query(`
            DELETE FROM modular_sets WHERE pack IN ('MC025', 'MC026', 'MC027');
        `);
        await queryRunner.query(`
            DELETE FROM heroes WHERE pack IN ('MC025', 'MC026', 'MC027');
        `);
        await queryRunner.query(`
            DELETE FROM packs WHERE code IN ('MC025', 'MC026', 'MC027');
        `);
    }
}