aboutsummaryrefslogtreecommitdiffstats
path: root/packages/pipeline/src/scripts/pull_erc20_events.ts
blob: bd520c6106fff5b5003591585a638f0dc7eb454d (plain) (blame)
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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
import { getContractAddressesForNetworkOrThrow } from '@0x/contract-addresses';
import { web3Factory } from '@0x/dev-utils';
import { Web3ProviderEngine } from '@0x/subproviders';
import { logUtils } from '@0x/utils';
import { Web3Wrapper } from '@0x/web3-wrapper';
import 'reflect-metadata';
import { Connection, ConnectionOptions, createConnection } from 'typeorm';

import { ERC20EventsSource } from '../data_sources/contract-wrappers/erc20_events';
import { ERC20ApprovalEvent } from '../entities';
import * as ormConfig from '../ormconfig';
import { parseERC20ApprovalEvents } from '../parsers/events';
import { handleError, INFURA_ROOT_URL } from '../utils';

const NETWORK_ID = 1;
const START_BLOCK_OFFSET = 100; // Number of blocks before the last known block to consider when updating fill events.
const BATCH_SAVE_SIZE = 1000; // Number of events to save at once.
const BLOCK_FINALITY_THRESHOLD = 10; // When to consider blocks as final. Used to compute default endBlock.

let connection: Connection;

interface Token {
    // name is used for logging only.
    name: string;
    address: string;
    defaultStartBlock: number;
}

const tokensToGetApprovalEvents: Token[] = [
    {
        name: 'WETH',
        address: getContractAddressesForNetworkOrThrow(NETWORK_ID).etherToken,
        defaultStartBlock: 4719568, // Block when the WETH contract was deployed.
    },
    {
        name: 'ZRX',
        address: getContractAddressesForNetworkOrThrow(NETWORK_ID).zrxToken,
        defaultStartBlock: 4145415, // Block when the ZRX contract was deployed.
    },
    {
        name: 'DAI',
        address: '0x89d24a6b4ccb1b6faa2625fe562bdd9a23260359',
        defaultStartBlock: 4752008, // Block when the DAI contract was deployed.
    },
];

(async () => {
    connection = await createConnection(ormConfig as ConnectionOptions);
    const provider = web3Factory.getRpcProvider({
        rpcUrl: INFURA_ROOT_URL,
    });
    const endBlock = await calculateEndBlockAsync(provider);
    for (const token of tokensToGetApprovalEvents) {
        await getAndSaveApprovalEventsAsync(provider, token, endBlock);
    }
    process.exit(0);
})().catch(handleError);

async function getAndSaveApprovalEventsAsync(
    provider: Web3ProviderEngine,
    token: Token,
    endBlock: number,
): Promise<void> {
    logUtils.log(`Getting approval events for ${token.name}...`);
    logUtils.log('Checking existing approval events...');
    const repository = connection.getRepository(ERC20ApprovalEvent);
    const startBlock = (await getStartBlockAsync(token)) || token.defaultStartBlock;

    logUtils.log(`Getting approval events starting at ${startBlock}...`);
    const eventsSource = new ERC20EventsSource(provider, NETWORK_ID, token.address);
    const eventLogs = await eventsSource.getApprovalEventsAsync(startBlock, endBlock);

    logUtils.log(`Parsing ${eventLogs.length} approval events...`);
    const events = parseERC20ApprovalEvents(eventLogs);
    logUtils.log(`Retrieved and parsed ${events.length} total approval events.`);
    await repository.save(events, { chunk: Math.ceil(events.length / BATCH_SAVE_SIZE) });
}

async function calculateEndBlockAsync(provider: Web3ProviderEngine): Promise<number> {
    const web3Wrapper = new Web3Wrapper(provider);
    const currentBlock = await web3Wrapper.getBlockNumberAsync();
    return currentBlock - BLOCK_FINALITY_THRESHOLD;
}

async function getStartBlockAsync(token: Token): Promise<number | null> {
    const queryResult = await connection.query(
        `SELECT block_number FROM raw.erc20_approval_events WHERE token_address = $1 ORDER BY block_number DESC LIMIT 1`,
        [token.address],
    );
    if (queryResult.length === 0) {
        logUtils.log(`No existing approval events found for ${token.name}.`);
        return null;
    }
    const lastKnownBlock = queryResult[0].block_number;
    return lastKnownBlock - START_BLOCK_OFFSET;
}