All files / projects-dev/apps/mc-api/src/migrations 1626078554370-PackSeed.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 PackSeed1626078554370 implements MigrationInterface {
    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`
            INSERT INTO packs VALUES
            ('MC001', 'Core Set'),
            ('MC002', 'The Green Goblin - Scenario Pack'),
            ('MC003', 'The Wrecking Crew - Scenario Pack'),
            ('MC004', 'Captain America - Hero Pack'),
            ('MC005', 'Ms. Marvel - Hero Pack'),
            ('MC006', 'Thor - Hero Pack'),
            ('MC007', 'Black Widow - Hero Pack'),
            ('MC008', 'Doctor Strange - Hero Pack'),
            ('MC009', 'Hulk - Hero Pack'),
            ('MC010', 'The Rise of Red Skull - Expansion'),
            ('MC011', 'The Once and Future Kang - Scenario Pack'),
            ('MC012', 'Ant-Man - Hero Pack'),
            ('MC013', 'Wasp - Hero Pack'),
            ('MC014', 'Quicksilver - Hero Pack'),
            ('MC015', 'Scarlet Witch - Hero Pack'),
            ('MC016', 'The Galaxy''s Most Wanted - Expansion'),
            ('MC017', 'Star-Lord - Hero Pack'),
            ('MC018', 'Gamora - Hero Pack'),
            ('MC019', 'Drax - Hero Pack'),
            ('MC020', 'Venom - Hero Pack'),
            ('PnP01', 'Ronan the Accuser - Print and Play modular set')
        `);
    }

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