All files / projects-dev/apps/mc-api/src/migrations 1626652588443-CleanupPacksNames.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
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
import { MigrationInterface, QueryRunner } from "typeorm";

export class CleanupPacksNames1626652588443 implements MigrationInterface {
    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`UPDATE packs SET name=REPLACE(name, " - Scenario Pack", "")`);
        await queryRunner.query(`UPDATE packs SET name=REPLACE(name, " - Hero Pack", "")`);
        await queryRunner.query(`UPDATE packs SET name=REPLACE(name, " - Expansion", "")`);
        await queryRunner.query(`UPDATE packs SET name=REPLACE(name, " - Print and Play modular set", "")`);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`UPDATE packs SET name='Core Set' WHERE code='MC001'`);
        await queryRunner.query(`UPDATE packs SET name='The Green Goblin - Scenario Pack' WHERE code='MC002'`);
        await queryRunner.query(`UPDATE packs SET name='The Wrecking Crew - Scenario Pack' WHERE code='MC003'`);
        await queryRunner.query(`UPDATE packs SET name='Captain America - Hero Pack' WHERE code='MC004'`);
        await queryRunner.query(`UPDATE packs SET name='Ms. Marvel - Hero Pack' WHERE code='MC005'`);
        await queryRunner.query(`UPDATE packs SET name='Thor - Hero Pack' WHERE code='MC006'`);
        await queryRunner.query(`UPDATE packs SET name='Black Widow - Hero Pack' WHERE code='MC007'`);
        await queryRunner.query(`UPDATE packs SET name='Doctor Strange - Hero Pack' WHERE code='MC008'`);
        await queryRunner.query(`UPDATE packs SET name='Hulk - Hero Pack' WHERE code='MC009'`);
        await queryRunner.query(`UPDATE packs SET name='The Rise of Red Skull - Expansion' WHERE code='MC010'`);
        await queryRunner.query(`UPDATE packs SET name='The Once and Future Kang - Scenario Pack' WHERE code='MC011'`);
        await queryRunner.query(`UPDATE packs SET name='Ant-Man - Hero Pack' WHERE code='MC012'`);
        await queryRunner.query(`UPDATE packs SET name='Wasp - Hero Pack' WHERE code='MC013'`);
        await queryRunner.query(`UPDATE packs SET name='Quicksilver - Hero Pack' WHERE code='MC014'`);
        await queryRunner.query(`UPDATE packs SET name='Scarlet Witch - Hero Pack' WHERE code='MC015'`);
        await queryRunner.query(`UPDATE packs SET name='The Galaxy''s Most Wanted - Expansion' WHERE code='MC016'`);
        await queryRunner.query(`UPDATE packs SET name='Star-Lord - Hero Pack' WHERE code='MC017'`);
        await queryRunner.query(`UPDATE packs SET name='Gamora - Hero Pack' WHERE code='MC018'`);
        await queryRunner.query(`UPDATE packs SET name='Drax - Hero Pack' WHERE code='MC019'`);
        await queryRunner.query(`UPDATE packs SET name='Venom - Hero Pack' WHERE code='MC020'`);
        await queryRunner.query(
            `UPDATE packs SET name='Ronan the Accuser - Print and Play modular set' WHERE code='PnP01'`,
        );
    }
}