import { MigrationInterface, QueryRunner } from "typeorm";

export class Migrations1773315065356 implements MigrationInterface {
    name = 'Migrations1773315065356'

    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE "users" ADD "offline_payment_allowed" character varying(255)`);
        await queryRunner.query(`
                                UPDATE "users"
                                SET "offline_payment_allowed" = 
                                CASE 
                                    WHEN is_offline_payment_allowed = true THEN 'yes'
                                    ELSE 'no'
                                END
                                `);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`ALTER TABLE "users" DROP COLUMN "offline_payment_allowed"`);
    }

}