import { MigrationInterface, QueryRunner } from "typeorm";

export class Migrations1780491912893 implements MigrationInterface {
    name = 'Migrations1780491912893'

    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE "categories" ADD "is_recommended" boolean NOT NULL DEFAULT false`);
        await queryRunner.query(`ALTER TABLE "categories" ADD "is_hidden" boolean NOT NULL DEFAULT false`);

        const hot = await queryRunner.query(`
            INSERT INTO categories (
                is_active,
                is_recommended,
                is_hidden
            )
            VALUES (true, true, true)
            RETURNING id
        `);

        await queryRunner.query(`
            INSERT INTO category_translations (
                category_id,
                language_code,
                title,
                slug
            )
            VALUES (
                '${hot[0].id}',
                'en',
                '🔥 Hot',
                'hot'
            )
        `);

        const international = await queryRunner.query(`
            INSERT INTO categories (
                is_active,
                is_recommended,
                is_hidden
            )
            VALUES (true, true, true)
            RETURNING id
        `);

        await queryRunner.query(`
            INSERT INTO category_translations (
                category_id,
                language_code,
                title,
                slug
            )
            VALUES (
                '${international[0].id}',
                'en',
                'International',
                'international'
            )
        `);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE "categories" DROP COLUMN "is_hidden"`);
        await queryRunner.query(`ALTER TABLE "categories" DROP COLUMN "is_recommended"`);
    }

}