packages/pipeline/migrations/1543980079179-ConvertTokenMetadataDecimalsToBigNumber.ts


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

import { MigrationInterface, QueryRunner } from 'typeorm';

export class ConvertTokenMetadataDecimalsToBigNumber1543980079179 implements MigrationInterface {
    public async up(queryRunner: QueryRunner): Promise<any> {
        await queryRunner.query(
            `ALTER TABLE raw.token_metadata
                ALTER COLUMN decimals TYPE numeric USING decimals::numeric;`,
        );
    }

    public async down(queryRunner: QueryRunner): Promise<any> {
        await queryRunner.query(
            `ALTER TABLE raw.token_metadata
                ALTER COLUMN decimals TYPE numeric USING decimals::integer;`,
        );
    }
}