import { MigrationInterface, QueryRunner } from "typeorm"

export class AddPlaceIdInCustomerTripsAndHospital1771244275044 implements MigrationInterface {
  name = "AddPlaceIdInCustomerTripsAndHospital1771244275044"

  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `ALTER TABLE "trips" ADD "pickup_place_id" character varying`,
    )
    await queryRunner.query(
      `ALTER TABLE "trips" ADD "dropoff_place_id" character varying`,
    )
    await queryRunner.query(
      `ALTER TABLE "trip_intermediate_stops" ADD "place_id" character varying`,
    )
    await queryRunner.query(
      `ALTER TABLE "customers" ADD "place_id" character varying`,
    )
    await queryRunner.query(
      `ALTER TABLE "hospitals" ADD "place_id" character varying`,
    )
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(
      `ALTER TABLE "trips" DROP COLUMN "dropoff_place_id"`,
    )
    await queryRunner.query(`ALTER TABLE "trips" DROP COLUMN "pickup_place_id"`)
    await queryRunner.query(
      `ALTER TABLE "trip_intermediate_stops" DROP COLUMN "place_id"`,
    )
    await queryRunner.query(`ALTER TABLE "hospitals" DROP COLUMN "place_id"`)
    await queryRunner.query(`ALTER TABLE "customers" DROP COLUMN "place_id"`)
  }
}