All files / projects-dev/apps/mc-api/src/migrations 1627631343751-AddScenarioRating.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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
import { MigrationInterface, QueryRunner } from "typeorm";

export class AddScenarioRating1627631343751 implements MigrationInterface {
    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE scenarios ADD COLUMN rating_standard_solo INT(11) NULL DEFAULT 0`);
        await queryRunner.query(`ALTER TABLE scenarios ADD COLUMN rating_standard_multi INT(11) NULL DEFAULT 0`);
        await queryRunner.query(`ALTER TABLE scenarios ADD COLUMN rating_expert_solo INT(11) NULL DEFAULT 0`);
        await queryRunner.query(`ALTER TABLE scenarios ADD COLUMN rating_expert_multi INT(11) NULL DEFAULT 0`);

        await queryRunner.query(
            `UPDATE scenarios SET rating_standard_solo=7, rating_standard_multi=0, rating_expert_solo=10, rating_expert_multi=4 WHERE id=1`,
        );
        await queryRunner.query(
            `UPDATE scenarios SET rating_standard_solo=10, rating_standard_multi=4, rating_expert_solo=15, rating_expert_multi=6 WHERE id=2`,
        );
        await queryRunner.query(
            `UPDATE scenarios SET rating_standard_solo=6, rating_standard_multi=8, rating_expert_solo=17, rating_expert_multi=18 WHERE id=3`,
        );
        await queryRunner.query(
            `UPDATE scenarios SET rating_standard_solo=3, rating_standard_multi=-2, rating_expert_solo=3, rating_expert_multi=3 WHERE id=4`,
        );
        await queryRunner.query(
            `UPDATE scenarios SET rating_standard_solo=9, rating_standard_multi=9, rating_expert_solo=15, rating_expert_multi=20 WHERE id=5`,
        );
        await queryRunner.query(
            `UPDATE scenarios SET rating_standard_solo=-1, rating_standard_multi=-2, rating_expert_solo=2, rating_expert_multi=7 WHERE id=6`,
        );
        await queryRunner.query(
            `UPDATE scenarios SET rating_standard_solo=2, rating_standard_multi=1, rating_expert_solo=11, rating_expert_multi=6 WHERE id=7`,
        );
        await queryRunner.query(
            `UPDATE scenarios SET rating_standard_solo=0, rating_standard_multi=-2, rating_expert_solo=9, rating_expert_multi=2 WHERE id=8`,
        );
        await queryRunner.query(
            `UPDATE scenarios SET rating_standard_solo=4, rating_standard_multi=0, rating_expert_solo=11, rating_expert_multi=7 WHERE id=9`,
        );
        await queryRunner.query(
            `UPDATE scenarios SET rating_standard_solo=13, rating_standard_multi=8, rating_expert_solo=18, rating_expert_multi=9 WHERE id=10`,
        );
        await queryRunner.query(
            `UPDATE scenarios SET rating_standard_solo=15, rating_standard_multi=14, rating_expert_solo=17, rating_expert_multi=19 WHERE id=11`,
        );
        await queryRunner.query(
            `UPDATE scenarios SET rating_standard_solo=14, rating_standard_multi=6, rating_expert_solo=11, rating_expert_multi=12 WHERE id=12`,
        );
        await queryRunner.query(
            `UPDATE scenarios SET rating_standard_solo=-2, rating_standard_multi=7, rating_expert_solo=7, rating_expert_multi=12 WHERE id=13`,
        );
        await queryRunner.query(
            `UPDATE scenarios SET rating_standard_solo=8, rating_standard_multi=6, rating_expert_solo=23, rating_expert_multi=19 WHERE id=14`,
        );
        await queryRunner.query(
            `UPDATE scenarios SET rating_standard_solo=4, rating_standard_multi=5, rating_expert_solo=16, rating_expert_multi=13 WHERE id=15`,
        );
        await queryRunner.query(
            `UPDATE scenarios SET rating_standard_solo=12, rating_standard_multi=11, rating_expert_solo=22, rating_expert_multi=23 WHERE id=16`,
        );
        await queryRunner.query(
            `UPDATE scenarios SET rating_standard_solo=20, rating_standard_multi=26, rating_expert_solo=32, rating_expert_multi=25 WHERE id=17`,
        );
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE scenarios DROP COLUMN rating_standard_solo`);
        await queryRunner.query(`ALTER TABLE scenarios DROP COLUMN rating_standard_multi`);
        await queryRunner.query(`ALTER TABLE scenarios DROP COLUMN rating_expert_solo`);
        await queryRunner.query(`ALTER TABLE scenarios DROP COLUMN rating_expert_multi`);
    }
}