All files / projects-dev/apps/mc-api/src/migrations 1687271908584-AddNewPacksSummer2023.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 AddNewPacksSummer20231687271908584 implements MigrationInterface {
    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`
            REPLACE INTO packs VALUES
            ('MC040', 'NeXt Evolution', 'Expansion', '2023-08-30', false),
            ('MC041', 'Psylocke', 'Hero', '2023-09-30', false),
            ('MC042', 'Angel', 'Hero', '2023-09-30', false),
            ('MC043', 'X-23', 'Hero', '2023-11-30', false);
        `);

        await queryRunner.query(`
            REPLACE INTO heroes VALUES
            (63, 'Cable', 'Nathan Summers', 'Leadership', 'MC040'),
            (64, 'Domino', 'Neena Thurman', 'Justice', 'MC040'),
            (65, 'Psylocke', 'Betsy Braddock', 'Justice', 'MC041'),
            (66, 'Angel', 'Warren Worthington III', 'Protection', 'MC042'),
            (67, 'X-23', 'Laura Kinney', 'Aggression', 'MC043');
        `);

        await queryRunner.query(`
            REPLACE INTO scenarios VALUES
            (44, 'Morlock Siege - Mutant Massacre', 'MC040'),
            (45, 'On The Run - Escaping with hope', 'MC040'),
            (46, 'Juggernaut - The Unstoppable Juggernaut', 'MC040'),
            (47, 'Mister Sinister', 'MC040'),
            (48, 'Stryfe', 'MC040');
        `);

        await queryRunner.query(`
            REPLACE INTO modular_sets VALUES
            (73, 'Marauders', 'MC040');
        `);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(
            `DELETE FROM scenarios_modular_sets WHERE scenario_code IN ('MC040', 'MC041', 'MC042', 'MC043')`,
        );

        await queryRunner.query(`DELETE FROM scenarios WHERE pack_code IN ('MC040', 'MC041', 'MC042', 'MC043')`);

        await queryRunner.query(`DELETE FROM heroes WHERE pack_code IN ('MC040', 'MC041', 'MC042', 'MC043')`);

        await queryRunner.query(`DELETE FROM packs WHERE code IN ('MC040', 'MC041', 'MC042', 'MC043')`);
    }
}