migrations 1627630878749-AddModularSetRating.ts

0% Statements 0/38
0% Branches 0/1
0% Functions 0/1
0% Lines 0/38
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  
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
  import { MigrationInterface, QueryRunner } from "typeorm";

export class AddModularSetRating1627630878749 implements MigrationInterface {
    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`
            ALTER TABLE modular_sets ADD COLUMN rating INT(11) NULL DEFAULT 0;
        `);

        await queryRunner.query(`UPDATE modular_sets SET rating=-4 WHERE id=1`);
        await queryRunner.query(`UPDATE modular_sets SET rating=1 WHERE id=2`);
        await queryRunner.query(`UPDATE modular_sets SET rating=2 WHERE id=3`);
        await queryRunner.query(`UPDATE modular_sets SET rating=3 WHERE id=4`);
        await queryRunner.query(`UPDATE modular_sets SET rating=3 WHERE id=5`);
        await queryRunner.query(`UPDATE modular_sets SET rating=-6 WHERE id=6`);
        await queryRunner.query(`UPDATE modular_sets SET rating=0 WHERE id=7`);
        await queryRunner.query(`UPDATE modular_sets SET rating=-3 WHERE id=8`);
        await queryRunner.query(`UPDATE modular_sets SET rating=-1 WHERE id=9`);
        await queryRunner.query(`UPDATE modular_sets SET rating=-2 WHERE id=10`);
        await queryRunner.query(`UPDATE modular_sets SET rating=-1 WHERE id=11`);
        await queryRunner.query(`UPDATE modular_sets SET rating=0 WHERE id=12`);
        await queryRunner.query(`UPDATE modular_sets SET rating=-3 WHERE id=13`);
        await queryRunner.query(`UPDATE modular_sets SET rating=-3 WHERE id=14`);
        await queryRunner.query(`UPDATE modular_sets SET rating=4 WHERE id=15`);
        await queryRunner.query(`UPDATE modular_sets SET rating=0 WHERE id=16`);
        await queryRunner.query(`UPDATE modular_sets SET rating=-7 WHERE id=17`);
        await queryRunner.query(`UPDATE modular_sets SET rating=0 WHERE id=18`);
        await queryRunner.query(`UPDATE modular_sets SET rating=-3 WHERE id=19`);
        await queryRunner.query(`UPDATE modular_sets SET rating=+2 WHERE id=20`);
        await queryRunner.query(`UPDATE modular_sets SET rating=0 WHERE id=21`);
        await queryRunner.query(`UPDATE modular_sets SET rating=+8 WHERE id=22`);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`
            ALTER TABLE modular_sets DROP COLUMN rating
        `);
    }
}