migrations 1635512500128-AddDefaultEncountersAspects.ts

0% Statements 0/43
0% Branches 0/1
0% Functions 0/1
0% Lines 0/43
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
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44  
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
  import { MigrationInterface, QueryRunner } from "typeorm";

export class AddDefaultEncountersAspects1635512500128 implements MigrationInterface {
    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`UPDATE encounters_heroes SET aspects = 'Justice' WHERE hero = 1`);
        await queryRunner.query(`UPDATE encounters_heroes SET aspects = 'Leadership' WHERE hero = 2`);
        await queryRunner.query(`UPDATE encounters_heroes SET aspects = 'Aggression' WHERE hero = 3`);
        await queryRunner.query(`UPDATE encounters_heroes SET aspects = 'Aggression' WHERE hero = 4`);
        await queryRunner.query(`UPDATE encounters_heroes SET aspects = 'Protection' WHERE hero = 5`);
        await queryRunner.query(`UPDATE encounters_heroes SET aspects = 'Leadership' WHERE hero = 6`);
        await queryRunner.query(`UPDATE encounters_heroes SET aspects = 'Protection' WHERE hero = 7`);
        await queryRunner.query(`UPDATE encounters_heroes SET aspects = 'Aggression' WHERE hero = 8`);
        await queryRunner.query(`UPDATE encounters_heroes SET aspects = 'Justice' WHERE hero = 9`);
        await queryRunner.query(`UPDATE encounters_heroes SET aspects = 'Protection' WHERE hero = 10`);
        await queryRunner.query(`UPDATE encounters_heroes SET aspects = 'Aggression' WHERE hero = 11`);
        await queryRunner.query(`UPDATE encounters_heroes SET aspects = 'Leadership' WHERE hero = 12`);
        await queryRunner.query(`UPDATE encounters_heroes SET aspects = 'Aggression,Justice' WHERE hero = 13`);
        await queryRunner.query(`UPDATE encounters_heroes SET aspects = 'Leadership' WHERE hero = 14`);
        await queryRunner.query(`UPDATE encounters_heroes SET aspects = 'Aggression' WHERE hero = 15`);
        await queryRunner.query(`UPDATE encounters_heroes SET aspects = 'Protection' WHERE hero = 16`);
        await queryRunner.query(`UPDATE encounters_heroes SET aspects = 'Justice' WHERE hero = 17`);
        await queryRunner.query(`UPDATE encounters_heroes SET aspects = 'Protection' WHERE hero = 18`);
        await queryRunner.query(`UPDATE encounters_heroes SET aspects = 'Aggression' WHERE hero = 19`);
        await queryRunner.query(`UPDATE encounters_heroes SET aspects = 'Leadership' WHERE hero = 20`);
        await queryRunner.query(
            `UPDATE encounters_heroes SET aspects = 'Aggression,Justice,Protection' WHERE hero = 21`,
        );
        await queryRunner.query(`UPDATE encounters_heroes SET aspects = 'Protection' WHERE hero = 22`);
        await queryRunner.query(`UPDATE encounters_heroes SET aspects = 'Justice' WHERE hero = 23`);
        await queryRunner.query(`UPDATE encounters_heroes SET aspects = 'Justice' WHERE hero = 24`);
        await queryRunner.query(
            `UPDATE encounters_heroes SET aspects = 'Aggression,Justice,Leadership,Protection' WHERE hero = 25`,
        );
        await queryRunner.query(`UPDATE encounters_heroes SET aspects = 'Leadership' WHERE hero = 26`);
        await queryRunner.query(`UPDATE encounters_heroes SET aspects = 'Leadership' WHERE hero = 27`);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`
            UPDATE encounters_heroes SET aspects = NULL
        `);
    }
}