import { MigrationInterface, QueryRunner } from 'typeorm';

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

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query('DROP INDEX IF EXISTS "public"."email_username"');
    await queryRunner.query(
      'ALTER TABLE "users" DROP COLUMN IF EXISTS "passwordData"'
    );
    await queryRunner.query(
      'ALTER TABLE "users" DROP CONSTRAINT IF EXISTS "UQ_97672ac88f789774dd47f7c8be3"'
    );
    await queryRunner.query(
      'ALTER TABLE "users" DROP COLUMN IF EXISTS "email"'
    );
    await queryRunner.query(
      'ALTER TABLE "users" ADD IF NOT EXISTS  "passwordAuthId" uuid'
    );
    await queryRunner.query(
      'ALTER TABLE "users" ADD CONSTRAINT "UQ_2af040c64cb1b128fb66013ecbc" UNIQUE ("passwordAuthId")'
    );
    await queryRunner.query(
      'ALTER TABLE "users" ADD IF NOT EXISTS "anonymousAuthId" uuid'
    );
    await queryRunner.query(
      'ALTER TABLE "users" ADD CONSTRAINT "UQ_8e6e2bc18c8f01680b4350d4a11" UNIQUE ("anonymousAuthId")'
    );
    await queryRunner.query(
      'ALTER TABLE "users" DROP CONSTRAINT IF EXISTS "UQ_fe0bb3f6520ee0469504521e710"'
    );
    await queryRunner.query(
      'ALTER TABLE "users" DROP CONSTRAINT IF EXISTS "FK_8e6e2bc18c8f01680b4350d4a11"'
    );
    await queryRunner.query(
      'ALTER TABLE "users" DROP CONSTRAINT IF EXISTS "FK_2af040c64cb1b128fb66013ecbc"'
    );
    await queryRunner.query(
      'ALTER TABLE "users" ADD CONSTRAINT "FK_2af040c64cb1b128fb66013ecbc" FOREIGN KEY ("passwordAuthId") REFERENCES "password_authentication_strategy"("id") ON DELETE NO ACTION ON UPDATE NO ACTION'
    );
    await queryRunner.query(
      'ALTER TABLE "users" ADD CONSTRAINT "FK_8e6e2bc18c8f01680b4350d4a11" FOREIGN KEY ("anonymousAuthId") REFERENCES "anonymous_authentication_strategy"("id") ON DELETE NO ACTION ON UPDATE NO ACTION'
    );
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      'ALTER TABLE "users" DROP CONSTRAINT IF EXISTS "FK_8e6e2bc18c8f01680b4350d4a11"'
    );
    await queryRunner.query(
      'ALTER TABLE "users" DROP CONSTRAINT IF EXISTS "FK_2af040c64cb1b128fb66013ecbc"'
    );
    await queryRunner.query(
      'ALTER TABLE "users" ADD CONSTRAINT "UQ_fe0bb3f6520ee0469504521e710" UNIQUE ("username")'
    );
    await queryRunner.query(
      'ALTER TABLE "users" DROP CONSTRAINT IF EXISTS "UQ_8e6e2bc18c8f01680b4350d4a11"'
    );
    await queryRunner.query(
      'ALTER TABLE "users" DROP COLUMN IF EXISTS "anonymousAuthId"'
    );
    await queryRunner.query(
      'ALTER TABLE "users" DROP CONSTRAINT IF EXISTS "UQ_2af040c64cb1b128fb66013ecbc"'
    );
    await queryRunner.query(
      'ALTER TABLE "users" DROP COLUMN IF EXISTS "passwordAuthId"'
    );
    await queryRunner.query(
      'ALTER TABLE "users" ADD IF NOT EXISTS "email" character varying NOT NULL'
    );
    await queryRunner.query(
      'ALTER TABLE "users" ADD CONSTRAINT "UQ_97672ac88f789774dd47f7c8be3" UNIQUE ("email")'
    );
    await queryRunner.query(
      'ALTER TABLE "users" ADD IF NOT EXISTS  "passwordData" jsonb NOT NULL'
    );
    await queryRunner.query(
      'CREATE INDEX "email_username" ON "users" ("username", "email") '
    );
  }
}