import { MigrationInterface, QueryRunner } from 'typeorm';

export class RenameProductsToPagesInProductLists1650589363179
  implements MigrationInterface
{
  name = 'RenameProductsToPagesInProductLists1650589363179';

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `CREATE TABLE "product_lists_pages_pages" ("productListsId" uuid NOT NULL, "pagesId" uuid NOT NULL, CONSTRAINT "PK_b72a01fde8dd88c66a0f49371d9" PRIMARY KEY ("productListsId", "pagesId"))`
    );
    await queryRunner.query(
      `CREATE INDEX "IDX_cbfb697b822e9593732082d50b" ON "product_lists_pages_pages" ("productListsId") `
    );
    await queryRunner.query(
      `CREATE INDEX "IDX_0ce1ee4f8f02a75eb531bf88ec" ON "product_lists_pages_pages" ("pagesId") `
    );
    await queryRunner.query(
      `ALTER TABLE "product_lists_pages_pages" ADD CONSTRAINT "FK_cbfb697b822e9593732082d50b3" FOREIGN KEY ("productListsId") REFERENCES "product_lists"("id") ON DELETE CASCADE ON UPDATE CASCADE`
    );
    await queryRunner.query(
      `ALTER TABLE "product_lists_pages_pages" ADD CONSTRAINT "FK_0ce1ee4f8f02a75eb531bf88ec7" FOREIGN KEY ("pagesId") REFERENCES "pages"("id") ON DELETE CASCADE ON UPDATE CASCADE`
    );
    await queryRunner.query(
      `ALTER TABLE "product_lists_products_products" DROP CONSTRAINT "FK_ba731e91801bb2e09d06eb1c93c"`
    );
    await queryRunner.query(
      `ALTER TABLE "product_lists_products_products" DROP CONSTRAINT "FK_49086a8d2287fc05e0727e9920e"`
    );
    await queryRunner.query(`DROP TABLE "product_lists_products_products"`);
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `CREATE TABLE "product_lists_products_products" ("productListsId" uuid NOT NULL, "productsId" uuid NOT NULL, CONSTRAINT "PK_19b495c777c04d04ab565fbfe2b" PRIMARY KEY ("productListsId", "productsId"))`
    );
    await queryRunner.query(
      `CREATE INDEX "IDX_49086a8d2287fc05e0727e9920" ON "product_lists_products_products" ("productListsId") `
    );
    await queryRunner.query(
      `CREATE INDEX "IDX_ba731e91801bb2e09d06eb1c93" ON "product_lists_products_products" ("productsId") `
    );
    await queryRunner.query(
      `ALTER TABLE "product_lists_products_products" ADD CONSTRAINT "FK_ba731e91801bb2e09d06eb1c93c" FOREIGN KEY ("productsId") REFERENCES "products"("id") ON DELETE CASCADE ON UPDATE CASCADE`
    );
    await queryRunner.query(
      `ALTER TABLE "product_lists_products_products" ADD CONSTRAINT "FK_49086a8d2287fc05e0727e9920e" FOREIGN KEY ("productListsId") REFERENCES "product_lists"("id") ON DELETE CASCADE ON UPDATE CASCADE`
    );
    await queryRunner.query(
      `ALTER TABLE "product_lists_pages_pages" DROP CONSTRAINT "FK_0ce1ee4f8f02a75eb531bf88ec7"`
    );
    await queryRunner.query(
      `ALTER TABLE "product_lists_pages_pages" DROP CONSTRAINT "FK_cbfb697b822e9593732082d50b3"`
    );
    await queryRunner.query(
      `DROP INDEX "public"."IDX_0ce1ee4f8f02a75eb531bf88ec"`
    );
    await queryRunner.query(
      `DROP INDEX "public"."IDX_cbfb697b822e9593732082d50b"`
    );
    await queryRunner.query(`DROP TABLE "product_lists_pages_pages"`);
  }
}