fairnesscoop / permacoop

import {MigrationInterface, QueryRunner} from "typeorm";

export class QuoteStatus1587565597402 implements MigrationInterface {

    name = 'QuoteStatus1587565597402'

    public async up(queryRunner: QueryRunner): Promise<any> {

        await queryRunner.query(`ALTER TABLE "quote" DROP COLUMN "status"`, undefined);

        await queryRunner.query(`CREATE TYPE "quote_status_enum" AS ENUM('draft', 'sent', 'refused', 'accepted', 'canceled')`, undefined);

        await queryRunner.query(`ALTER TABLE "quote" ADD "status" "quote_status_enum" NOT NULL`, undefined);

        await queryRunner.query(`ALTER TABLE "quote" DROP COLUMN "status"`, undefined);

        await queryRunner.query(`ALTER TABLE "quote" ADD "status" character varying NOT NULL`, undefined);

    }

    public async down(queryRunner: QueryRunner): Promise<any> {

        await queryRunner.query(`ALTER TABLE "quote" DROP COLUMN "status"`, undefined);

        await queryRunner.query(`ALTER TABLE "quote" ADD "status" "quote_status_enum" NOT NULL`, undefined);

        await queryRunner.query(`ALTER TABLE "quote" DROP COLUMN "status"`, undefined);

        await queryRunner.query(`DROP TYPE "quote_status_enum"`, undefined);

        await queryRunner.query(`ALTER TABLE "quote" ADD "status" character varying NOT NULL`, undefined);

    }

}