All files / projects-dev/apps/mc-api/src/migrations 1626135664299-ScenariosSeed.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
50
51
52
53
54
55
56
57
58
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
import { MigrationInterface, QueryRunner } from "typeorm";

export class ScenariosSeed1626135664299 implements MigrationInterface {
    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`
            INSERT INTO scenarios (id, name, pack) VALUES
            (1, 'Rhino - The Break In!', 'MC001'),
            (2, 'Klaw - Underground Distribution', 'MC001'),
            (3, 'Ultron - The Crimson Cowl', 'MC001'),
            (4, 'Green Goblin - Risky Business', 'MC002'),
            (5, 'Green Goblin - Mutagen Formula', 'MC002'),
            (6, 'Wrecking Crew - Breakout', 'MC003'),
            (7, 'Crossbones - Attack on Mount Athena', 'MC010'),
            (8, 'Absorbing Man - None Shall Pass', 'MC010'),
            (9, 'Taskmaster - Hunting Down Heroes', 'MC010'),
            (10, 'Zola - The Island of Dr. Zola', 'MC010'),
            (11, 'Red Skull - The Rise of Red Skull', 'MC010'),
            (12, 'Kang - Kang''s Arrival', 'MC011'),
            (13, 'Brotherhood of Badoon', 'MC016'),
            (14, 'Collector 1 – Infiltrate the Museum', 'MC016'),
            (15, 'Collector 2 – Escape the Museum', 'MC016'),
            (16, 'Nebula', 'MC016'),
            (17, 'Ronan', 'PnP01');
        `);
        await queryRunner.query(`
            INSERT INTO scenarios_modular_sets (scenario, modular_set) VALUES
            (1, 1),
            (2, 2),
            (3, 3),
            (4, 8),
            (5, 6),
            (7, 4),
            (7, 11),
            (7, 12),
            (8, 12),
            (9, 11),
            (10, 3),
            (11, 10),
            (11, 12),
            (12, 14),
            (13, 17),
            (14, 20),
            (15, 20),
            (16, 21),
            (17, 19);
        `);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`
            TRUNCATE TABLE scenarios_modular_sets
        `);
        await queryRunner.query(`
            TRUNCATE TABLE scenarios
        `);
    }
}