From e2f222b08f0162fb067260bbbf1f58056b1badd7 Mon Sep 17 00:00:00 2001 From: Alex Browne Date: Tue, 23 Oct 2018 16:03:52 -0700 Subject: Implement support for getting and parsing blocks and transactions --- packages/pipeline/src/entities/Block.ts | 9 ++++ packages/pipeline/src/entities/Transaction.ts | 11 +++++ packages/pipeline/src/entities/block.ts | 10 ++-- packages/pipeline/src/entities/transaction.ts | 20 +++----- packages/pipeline/src/index.ts | 68 +++++++++++++++++++++++++++ 5 files changed, 97 insertions(+), 21 deletions(-) create mode 100644 packages/pipeline/src/entities/Block.ts create mode 100644 packages/pipeline/src/entities/Transaction.ts create mode 100644 packages/pipeline/src/index.ts 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 { + 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 { + 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 { + 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.'); +} -- cgit v1.2.3