import { MigrationInterface, QueryRunner } from 'typeorm';

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

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(`
            ALTER TABLE "aggregate_product_variants" DROP CONSTRAINT "FK_09903fd293ff73f7a69aa038adf"
        `);
    await queryRunner.query(`
            ALTER TABLE "aggregate_product_variants"
                RENAME COLUMN "productsId" TO "productId"
        `);
    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
        `);
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(`
            ALTER TABLE "aggregate_product_variants" DROP CONSTRAINT "FK_dd00af2f77e1b5ff42070ec65b9"
        `);
    await queryRunner.query(`
            ALTER TABLE "aggregate_product_variants"
                RENAME COLUMN "productId" TO "productsId"
        `);
    await queryRunner.query(`
            ALTER TABLE "aggregate_product_variants"
            ADD CONSTRAINT "FK_09903fd293ff73f7a69aa038adf" FOREIGN KEY ("productsId") REFERENCES "aggregate_products"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
        `);
  }
}