import {
  MigrationInterface,
  QueryRunner,
  TableColumn,
  TableForeignKey,
} from 'typeorm';

export class AlterGroupsTable1729587716941 implements MigrationInterface {
  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.addColumn(
      'groups',
      new TableColumn({
        name: 'zipcode',
        type: 'varchar',
        isNullable: true,
      }),
    );
    await queryRunner.addColumn(
      'groups',
      new TableColumn({
        name: 'province_id',
        type: 'uuid',
        isNullable: true,
      }),
    );
    await queryRunner.addColumn(
      'groups',
      new TableColumn({
        name: 'owner_id',
        type: 'uuid',
        isNullable: true,
      }),
    );
    await queryRunner.addColumn(
      'groups',
      new TableColumn({
        name: 'is_shareable',
        type: 'boolean',
        default: false,
        isNullable: true,
      }),
    );
    await queryRunner.addColumn(
      'groups',
      new TableColumn({
        name: 'owner_role',
        type: 'varchar',
        isNullable: true,
      }),
    );

    await queryRunner.createForeignKey(
      'groups',
      new TableForeignKey({
        name: 'groups_app_users_steps_fk',
        columnNames: ['owner_id'],
        referencedColumnNames: ['id'],
        referencedTableName: 'app_users',
        onDelete: 'CASCADE',
      }),
    );

    await queryRunner.createForeignKey(
      'groups',
      new TableForeignKey({
        name: 'groups_province_fk',
        columnNames: ['province_id'],
        referencedColumnNames: ['id'],
        referencedTableName: 'provinces',
        onDelete: 'CASCADE',
      }),
    );
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.dropColumns('groups', [
      'zipcode',
      'province_id',
      'owner_id',
      'is_shareable',
      'owner_role',
    ]);
  }
}