import { MigrationInterface, QueryRunner } from 'typeorm';

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

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(`
            ALTER TABLE "aggregate_product_variants" DROP CONSTRAINT "FK_dd00af2f77e1b5ff42070ec65b9"
        `);
    await queryRunner.query(`
            ALTER TABLE "aggregate_product_variants"
            ALTER COLUMN "productId"
            SET NOT NULL
        `);
    await queryRunner.query(`
            ALTER TABLE "retailer_products" DROP CONSTRAINT "FK_87839253e3642f882e0f2225f7a"
        `);
    await queryRunner.query(`
            ALTER TABLE "retailer_products"
            ALTER COLUMN "aggregateProductId"
            SET NOT NULL
        `);
    await queryRunner.query(`
            ALTER TABLE "retailer_product_variants" DROP CONSTRAINT "FK_e8ca3231fdafa4fc0c662d5b14a"
        `);
    await queryRunner.query(`
            ALTER TABLE "retailer_product_variants" DROP CONSTRAINT "FK_027101f801f9cea54242a3f83ef"
        `);
    await queryRunner.query(`
            ALTER TABLE "retailer_product_variants"
            ALTER COLUMN "productId"
            SET NOT NULL
        `);
    await queryRunner.query(`
            ALTER TABLE "retailer_product_variants"
            ALTER COLUMN "variantId"
            SET NOT NULL
        `);
    await queryRunner.query(`
            ALTER TABLE "aggregate_product_variants"
            ADD CONSTRAINT "FK_dd00af2f77e1b5ff42070ec65b9" FOREIGN KEY ("productId") REFERENCES "aggregate_products"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
        `);
    await queryRunner.query(`
            ALTER TABLE "retailer_products"
            ADD CONSTRAINT "FK_87839253e3642f882e0f2225f7a" FOREIGN KEY ("aggregateProductId") REFERENCES "aggregate_products"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
        `);
    await queryRunner.query(`
            ALTER TABLE "retailer_product_variants"
            ADD CONSTRAINT "FK_e8ca3231fdafa4fc0c662d5b14a" FOREIGN KEY ("productId") REFERENCES "retailer_products"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
        `);
    await queryRunner.query(`
            ALTER TABLE "retailer_product_variants"
            ADD CONSTRAINT "FK_027101f801f9cea54242a3f83ef" FOREIGN KEY ("variantId") REFERENCES "aggregate_product_variants"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
        `);
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(`
            ALTER TABLE "retailer_product_variants" DROP CONSTRAINT "FK_027101f801f9cea54242a3f83ef"
        `);
    await queryRunner.query(`
            ALTER TABLE "retailer_product_variants" DROP CONSTRAINT "FK_e8ca3231fdafa4fc0c662d5b14a"
        `);
    await queryRunner.query(`
            ALTER TABLE "retailer_products" DROP CONSTRAINT "FK_87839253e3642f882e0f2225f7a"
        `);
    await queryRunner.query(`
            ALTER TABLE "aggregate_product_variants" DROP CONSTRAINT "FK_dd00af2f77e1b5ff42070ec65b9"
        `);
    await queryRunner.query(`
            ALTER TABLE "retailer_product_variants"
            ALTER COLUMN "variantId" DROP NOT NULL
        `);
    await queryRunner.query(`
            ALTER TABLE "retailer_product_variants"
            ALTER COLUMN "productId" DROP NOT NULL
        `);
    await queryRunner.query(`
            ALTER TABLE "retailer_product_variants"
            ADD CONSTRAINT "FK_027101f801f9cea54242a3f83ef" FOREIGN KEY ("variantId") REFERENCES "aggregate_product_variants"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
        `);
    await queryRunner.query(`
            ALTER TABLE "retailer_product_variants"
            ADD CONSTRAINT "FK_e8ca3231fdafa4fc0c662d5b14a" FOREIGN KEY ("productId") REFERENCES "retailer_products"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
        `);
    await queryRunner.query(`
            ALTER TABLE "retailer_products"
            ALTER COLUMN "aggregateProductId" DROP NOT NULL
        `);
    await queryRunner.query(`
            ALTER TABLE "retailer_products"
            ADD CONSTRAINT "FK_87839253e3642f882e0f2225f7a" FOREIGN KEY ("aggregateProductId") REFERENCES "aggregate_products"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
        `);
    await queryRunner.query(`
            ALTER TABLE "aggregate_product_variants"
            ALTER COLUMN "productId" DROP NOT NULL
        `);
    await queryRunner.query(`
            ALTER TABLE "aggregate_product_variants"
            ADD CONSTRAINT "FK_dd00af2f77e1b5ff42070ec65b9" FOREIGN KEY ("productId") REFERENCES "aggregate_products"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
        `);
  }
}