migrations 1626335070842-Teams.ts

0% Statements 0/35

0% Branches 0/1

0% Functions 0/1

0% Lines 0/35

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

export class Teams1626335070842 implements MigrationInterface {
    public async up(queryRunner: QueryRunner): Promise<void> {
        // eslint-disable-next-line no-secrets/no-secrets
        await queryRunner.query(`
            CREATE TABLE teams (
                hero1 int(11) NOT NULL,
                hero2 int(11) NOT NULL,
                PRIMARY KEY(hero1, hero2)
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
        `);

        await queryRunner.query(`
            ALTER TABLE teams ADD CONSTRAINT fk_team_heroes1 FOREIGN KEY (hero1) REFERENCES heroes(id) ON DELETE NO ACTION ON UPDATE NO ACTION
        `);
        await queryRunner.query(`
            ALTER TABLE teams ADD CONSTRAINT fk_team_heroes2 FOREIGN KEY (hero2) REFERENCES heroes(id) ON DELETE NO ACTION ON UPDATE NO ACTION
        `);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`
            ALTER TABLE teams DROP FOREIGN KEY fk_team_heroes1
        `);

        await queryRunner.query(`
            ALTER TABLE teams DROP FOREIGN KEY fk_team_heroes2
        `);

        await queryRunner.query(`
            DROP TABLE teams
        `);
    }
}