aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--packages/pipeline/src/entities/Block.ts9
-rw-r--r--packages/pipeline/src/entities/Transaction.ts11
-rw-r--r--packages/pipeline/src/entities/block.ts10
-rw-r--r--packages/pipeline/src/entities/transaction.ts20
-rw-r--r--packages/pipeline/src/index.ts68
5 files changed, 97 insertions, 21 deletions
diff --git a/packages/pipeline/src/entities/Block.ts b/packages/pipeline/src/entities/Block.ts
new file mode 100644
index 000000000..49e0ef840
--- /dev/null
+++ b/packages/pipeline/src/entities/Block.ts
@@ -0,0 +1,9 @@
+import { Column, Entity, PrimaryColumn } from 'typeorm';
+
+@Entity()
+export class Block {
+ @PrimaryColumn() public hash!: string;
+ @PrimaryColumn() public number!: number;
+
+ @Column() public unixTimestampSeconds!: number;
+}
diff --git a/packages/pipeline/src/entities/Transaction.ts b/packages/pipeline/src/entities/Transaction.ts
new file mode 100644
index 000000000..d89d44746
--- /dev/null
+++ b/packages/pipeline/src/entities/Transaction.ts
@@ -0,0 +1,11 @@
+import { Column, Entity, PrimaryColumn } from 'typeorm';
+
+@Entity()
+export class Transaction {
+ @PrimaryColumn() public transactionHash!: string;
+ @PrimaryColumn() public blockHash!: string;
+ @PrimaryColumn() public blockNumber!: number;
+
+ @Column() public gasUsed!: number;
+ @Column() public gasPrice!: number;
+}
diff --git a/packages/pipeline/src/entities/block.ts b/packages/pipeline/src/entities/block.ts
index 398946622..49e0ef840 100644
--- a/packages/pipeline/src/entities/block.ts
+++ b/packages/pipeline/src/entities/block.ts
@@ -1,13 +1,9 @@
import { Column, Entity, PrimaryColumn } from 'typeorm';
-import { numberToBigIntTransformer } from '../utils';
-
-@Entity({ name: 'blocks', schema: 'raw' })
+@Entity()
export class Block {
@PrimaryColumn() public hash!: string;
- @PrimaryColumn({ transformer: numberToBigIntTransformer })
- public number!: number;
+ @PrimaryColumn() public number!: number;
- @Column({ name: 'timestamp', transformer: numberToBigIntTransformer })
- public timestamp!: number;
+ @Column() public unixTimestampSeconds!: number;
}
diff --git a/packages/pipeline/src/entities/transaction.ts b/packages/pipeline/src/entities/transaction.ts
index 742050177..d89d44746 100644
--- a/packages/pipeline/src/entities/transaction.ts
+++ b/packages/pipeline/src/entities/transaction.ts
@@ -1,19 +1,11 @@
-import { BigNumber } from '@0x/utils';
import { Column, Entity, PrimaryColumn } from 'typeorm';
-import { bigNumberTransformer, numberToBigIntTransformer } from '../utils';
-
-@Entity({ name: 'transactions', schema: 'raw' })
+@Entity()
export class Transaction {
- @PrimaryColumn({ name: 'transaction_hash' })
- public transactionHash!: string;
- @PrimaryColumn({ name: 'block_hash' })
- public blockHash!: string;
- @PrimaryColumn({ name: 'block_number', transformer: numberToBigIntTransformer })
- public blockNumber!: number;
+ @PrimaryColumn() public transactionHash!: string;
+ @PrimaryColumn() public blockHash!: string;
+ @PrimaryColumn() public blockNumber!: number;
- @Column({ type: 'numeric', name: 'gas_used', transformer: bigNumberTransformer })
- public gasUsed!: BigNumber;
- @Column({ type: 'numeric', name: 'gas_price', transformer: bigNumberTransformer })
- public gasPrice!: BigNumber;
+ @Column() public gasUsed!: number;
+ @Column() public gasPrice!: number;
}
diff --git a/packages/pipeline/src/index.ts b/packages/pipeline/src/index.ts
new file mode 100644
index 000000000..ad0e4c68f
--- /dev/null
+++ b/packages/pipeline/src/index.ts
@@ -0,0 +1,68 @@
+import { web3Factory } from '@0x/dev-utils';
+import { Web3ProviderEngine } from '@0x/subproviders';
+import 'reflect-metadata';
+import { Connection, createConnection } from 'typeorm';
+
+import { ExchangeEventsSource } from './data_sources/contract-wrappers/exchange_events';
+import { Web3Source } from './data_sources/web3';
+import { Block } from './entities/Block';
+import { ExchangeFillEvent } from './entities/ExchangeFillEvent';
+import { Transaction } from './entities/Transaction';
+import { testConfig } from './ormconfig';
+import { parseExchangeEvents } from './parsers/events';
+import { parseBlock, parseTransaction } from './parsers/web3';
+
+const EXCHANGE_START_BLOCK = 6271590; // Block number when the Exchange contract was deployed to mainnet.
+
+let connection: Connection;
+
+(async () => {
+ connection = await createConnection(testConfig);
+ const provider = web3Factory.getRpcProvider({
+ rpcUrl: 'https://mainnet.infura.io',
+ });
+ await getExchangeEventsAsync(provider);
+ await getBlockAsync(provider);
+ await getTransactionAsync(provider);
+ console.log('Exiting process');
+ process.exit(0);
+})();
+
+async function getExchangeEventsAsync(provider: Web3ProviderEngine): Promise<void> {
+ console.log('Getting event logs...');
+ const eventsRepository = connection.getRepository(ExchangeFillEvent);
+ const exchangeEvents = new ExchangeEventsSource(provider, 1);
+ const eventLogs = await exchangeEvents.getFillEventsAsync(EXCHANGE_START_BLOCK, EXCHANGE_START_BLOCK + 100000);
+ console.log('Parsing events...');
+ const events = parseExchangeEvents(eventLogs);
+ console.log(`Retrieved and parsed ${events.length} total events.`);
+ console.log('Saving events...');
+ for (const event of events) {
+ await eventsRepository.save(event);
+ }
+ console.log('Saved events.');
+}
+
+async function getBlockAsync(provider: Web3ProviderEngine): Promise<void> {
+ console.log('Getting block info...');
+ const blocksRepository = connection.getRepository(Block);
+ const web3Source = new Web3Source(provider);
+ const rawBlock = await web3Source.getBlockInfoAsync(EXCHANGE_START_BLOCK);
+ const block = parseBlock(rawBlock);
+ console.log('Saving block info...');
+ await blocksRepository.save(block);
+ console.log('Done saving block.');
+}
+
+async function getTransactionAsync(provider: Web3ProviderEngine): Promise<void> {
+ console.log('Getting tx info...');
+ const txsRepository = connection.getRepository(Transaction);
+ const web3Source = new Web3Source(provider);
+ const rawTx = await web3Source.getTransactionInfoAsync(
+ '0x6dd106d002873746072fc5e496dd0fb2541b68c77bcf9184ae19a42fd33657fe',
+ );
+ const tx = parseTransaction(rawTx);
+ console.log('Saving tx info...');
+ await txsRepository.save(tx);
+ console.log('Done saving tx.');
+}