1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
|
import { MigrationInterface, QueryRunner } from 'typeorm';
export class ConvertBigNumberToNumeric1542234704666 implements MigrationInterface {
public async up(queryRunner: QueryRunner): Promise<any> {
await queryRunner.query(
`ALTER TABLE raw.exchange_fill_events
ALTER COLUMN maker_asset_filled_amount TYPE numeric USING maker_asset_filled_amount::numeric,
ALTER COLUMN taker_asset_filled_amount TYPE numeric USING taker_asset_filled_amount::numeric,
ALTER COLUMN maker_fee_paid TYPE numeric USING maker_fee_paid::numeric,
ALTER COLUMN taker_fee_paid TYPE numeric USING taker_fee_paid::numeric;`,
);
await queryRunner.query(
`ALTER TABLE raw.exchange_cancel_up_to_events
ALTER COLUMN order_epoch TYPE numeric USING order_epoch::numeric;`,
);
await queryRunner.query(
`ALTER TABLE raw.sra_orders
ALTER COLUMN maker_asset_amount TYPE numeric USING maker_asset_amount::numeric,
ALTER COLUMN taker_asset_amount TYPE numeric USING taker_asset_amount::numeric,
ALTER COLUMN maker_fee TYPE numeric USING maker_fee::numeric,
ALTER COLUMN taker_fee TYPE numeric USING taker_fee::numeric,
ALTER COLUMN expiration_time_seconds TYPE numeric USING expiration_time_seconds::numeric,
ALTER COLUMN salt TYPE numeric USING salt::numeric;`,
);
}
public async down(queryRunner: QueryRunner): Promise<any> {
await queryRunner.query(
`ALTER TABLE raw.sra_orders
ALTER COLUMN maker_asset_amount TYPE varchar USING maker_asset_amount::varchar,
ALTER COLUMN taker_asset_amount TYPE varchar USING taker_asset_amount::varchar,
ALTER COLUMN maker_fee TYPE varchar USING maker_fee::varchar,
ALTER COLUMN taker_fee TYPE varchar USING taker_fee::varchar,
ALTER COLUMN expiration_time_seconds TYPE varchar USING expiration_time_seconds::varchar,
ALTER COLUMN salt TYPE varchar USING salt::varchar;`,
);
await queryRunner.query(
`ALTER TABLE raw.exchange_cancel_up_to_events
ALTER COLUMN order_epoch TYPE varchar USING order_epoch::varchar;`,
);
await queryRunner.query(
`ALTER TABLE raw.exchange_fill_events
ALTER COLUMN maker_asset_filled_amount TYPE varchar USING maker_asset_filled_amount::varchar,
ALTER COLUMN taker_asset_filled_amount TYPE varchar USING taker_asset_filled_amount::varchar,
ALTER COLUMN maker_fee_paid TYPE varchar USING maker_fee_paid::varchar,
ALTER COLUMN taker_fee_paid TYPE varchar USING taker_fee_paid::varchar;`,
);
}
}
|
