diff options
author | Alex Browne <stephenalexbrowne@gmail.com> | 2018-12-05 12:20:49 +0800 |
---|---|---|
committer | Alex Browne <stephenalexbrowne@gmail.com> | 2018-12-05 12:20:49 +0800 |
commit | e0348f9c044b4909260e4864398b4f50232da620 (patch) | |
tree | 2250eb061a4b2c27d3dc1727a26e1380cb8d9226 /packages/pipeline/migrations | |
parent | 2e704ac01a077b0c73288aaa53c9cf66c73e27f1 (diff) | |
download | dexon-0x-contracts-e0348f9c044b4909260e4864398b4f50232da620.tar dexon-0x-contracts-e0348f9c044b4909260e4864398b4f50232da620.tar.gz dexon-0x-contracts-e0348f9c044b4909260e4864398b4f50232da620.tar.bz2 dexon-0x-contracts-e0348f9c044b4909260e4864398b4f50232da620.tar.lz dexon-0x-contracts-e0348f9c044b4909260e4864398b4f50232da620.tar.xz dexon-0x-contracts-e0348f9c044b4909260e4864398b4f50232da620.tar.zst dexon-0x-contracts-e0348f9c044b4909260e4864398b4f50232da620.zip |
Change type of transactions.gas_used and gas_price to BigNumber/numeric
Diffstat (limited to 'packages/pipeline/migrations')
-rw-r--r-- | packages/pipeline/migrations/1543983324954-ConvertTransactionGasPriceToBigNumber.ts | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/packages/pipeline/migrations/1543983324954-ConvertTransactionGasPriceToBigNumber.ts b/packages/pipeline/migrations/1543983324954-ConvertTransactionGasPriceToBigNumber.ts new file mode 100644 index 000000000..dcb0fd727 --- /dev/null +++ b/packages/pipeline/migrations/1543983324954-ConvertTransactionGasPriceToBigNumber.ts @@ -0,0 +1,19 @@ +import { MigrationInterface, QueryRunner } from 'typeorm'; + +export class ConvertTransactionGasPriceToBigNumber1543983324954 implements MigrationInterface { + public async up(queryRunner: QueryRunner): Promise<any> { + await queryRunner.query( + `ALTER TABLE raw.transactions + ALTER COLUMN gas_price TYPE numeric USING gas_price::numeric, + ALTER COLUMN gas_used TYPE numeric USING gas_used::numeric;`, + ); + } + + public async down(queryRunner: QueryRunner): Promise<any> { + await queryRunner.query( + `ALTER TABLE raw.transactions + ALTER COLUMN gas_price TYPE numeric USING gas_price::bigint, + ALTER COLUMN gas_used TYPE numeric USING gas_used::bigint;`, + ); + } +} |