mikroOrmMigration.ts

import { Migration } from '@mikro-orm/migrations';

export class Migration20211022164646 extends Migration {
  async up(): Promise<void> {
    this.addSql('alter table "Brands" drop constraint "Brands_clientId_fkey"');
    this.addSql('alter table "Brands" add constraint "Brands_clientId_fkey" foreign key ("clientId") references "clients" ("id") on update cascade on delete cascade;');
    this.addSql('delete from "Brands" where "clientId" is null');

    this.addSql('alter table "DynamicContentItems" drop constraint "DynamicContentItems_clientId_fkey"');
    this.addSql('alter table "DynamicContentItems" add constraint "DynamicContentItems_clientId_fkey" foreign key ("clientId") references "clients" ("id") on update cascade on delete cascade;');
    this.addSql('delete from "DynamicContentItems" where "clientId" is null');

    this.addSql('alter table "Groups" drop constraint "Groups_clientId_fkey"');
    this.addSql('alter table "Groups" add constraint "Groups_clientId_fkey" foreign key ("clientId") references "clients" ("id") on update cascade on delete cascade;');
    this.addSql('delete from "Groups" where "clientId" is null');

    this.addSql('alter table "Users" drop constraint "Users_clientId_fkey"');
    this.addSql('alter table "Users" add constraint "Users_clientId_fkey" foreign key ("clientId") references "clients" ("id") on update cascade on delete cascade;');
    this.addSql('delete from "Users" where "clientId" is null');
  }

  async down(): Promise<void> {
    this.addSql('alter table "Brands" drop constraint "Brands_clientId_fkey"');
    this.addSql('alter table "Brands" add constraint "Brands_clientId_fkey" foreign key ("clientId") references "clients" ("id") on update cascade on delete set null;');

    this.addSql('alter table "DynamicContentItems" drop constraint "DynamicContentItems_clientId_fkey"');
    this.addSql('alter table "DynamicContentItems" add constraint "DynamicContentItems_clientId_fkey" foreign key ("clientId") references "clients" ("id") on update cascade on delete set null;');

    this.addSql('alter table "Groups" drop constraint "Groups_clientId_fkey"');
    this.addSql('alter table "Groups" add constraint "Groups_clientId_fkey" foreign key ("clientId") references "clients" ("id") on update cascade on delete set null;');

    this.addSql('alter table "Users" drop constraint "Users_clientId_fkey"');
    this.addSql('alter table "Users" add constraint "Users_clientId_fkey" foreign key ("clientId") references "clients" ("id") on update cascade on delete set null;');
  }
}