import { MigrationInterface, QueryRunner } from "typeorm";

export class Migrations1740221576363 implements MigrationInterface {
    name = 'Migrations1740221576363'

    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE "social_medias" ADD "page_access_token" text`);
        await queryRunner.query(`COMMENT ON COLUMN "social_medias"."page_access_token" IS 'FACEBOOK PAGE ACCESS TOKEN IF ITS LINK WITH INSTAGRAM ONLY'`);
        await queryRunner.query(`ALTER TABLE "social_medias" ADD "page_access_token_expire_at" character varying`);
        await queryRunner.query(`COMMENT ON COLUMN "social_medias"."page_access_token_expire_at" IS 'FACEBOOK PAGE ACCESS EXPIRE AT IF ITS LINK WITH INSTAGRAM ONLY'`);
        await queryRunner.query(`ALTER TABLE "social_medias" ADD "is_page_token_expire" boolean NOT NULL DEFAULT false`);
        await queryRunner.query(`COMMENT ON COLUMN "social_medias"."is_page_token_expire" IS 'FACEBOOK PAGE ACCESS TOKEN EXPIRE IF ITS LINK WITH INSTAGRAM ONLY'`);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`COMMENT ON COLUMN "social_medias"."is_page_token_expire" IS 'FACEBOOK PAGE ACCESS TOKEN EXPIRE IF ITS LINK WITH INSTAGRAM ONLY'`);
        await queryRunner.query(`ALTER TABLE "social_medias" DROP COLUMN "is_page_token_expire"`);
        await queryRunner.query(`COMMENT ON COLUMN "social_medias"."page_access_token_expire_at" IS 'FACEBOOK PAGE ACCESS EXPIRE AT IF ITS LINK WITH INSTAGRAM ONLY'`);
        await queryRunner.query(`ALTER TABLE "social_medias" DROP COLUMN "page_access_token_expire_at"`);
        await queryRunner.query(`COMMENT ON COLUMN "social_medias"."page_access_token" IS 'FACEBOOK PAGE ACCESS TOKEN IF ITS LINK WITH INSTAGRAM ONLY'`);
        await queryRunner.query(`ALTER TABLE "social_medias" DROP COLUMN "page_access_token"`);
    }

}