migrations 1626396999193-NewHeroes.ts

0% Statements 0/25

0% Branches 0/1

0% Functions 0/1

0% Lines 0/25

Press n or j to go to the next uncovered block, b, p or k for the previous block.


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  
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
  import { MigrationInterface, QueryRunner } from "typeorm";

export class NewHeroes1626396999193 implements MigrationInterface {
    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`
            INSERT INTO packs VALUES
            ('MC023', 'War Machine - Hero Pack')
        `);
        await queryRunner.query(`
            INSERT INTO heroes VALUES
            (25, 'Adam Warlock', 'Adam Warlock', 'Aggression,Justice,Protection,Leadership', 'MC021'),
            (26, 'Spectrum', 'Monica Rambeau', 'Leadership', 'MC021'),
            (27, 'War Machine', 'James Rhodes', 'Leadership', 'MC023')
        `);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`
            DELETE FROM heroes WHERE id IN (25, 26, 27)
        `);
        await queryRunner.query(`
            DELETE FROM packs WHERE code IN ('MC023')
        `);
    }
}