Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ethereum-etl 遇到的坑 #12

Open
zexianghuang opened this issue Sep 8, 2022 · 2 comments
Open

ethereum-etl 遇到的坑 #12

zexianghuang opened this issue Sep 8, 2022 · 2 comments

Comments

@zexianghuang
Copy link
Contributor

ethereum-etl

@zexianghuang
Copy link
Contributor Author

zexianghuang commented Sep 8, 2022

ethereum-etl 导出geth同步数据,

导出 token_transfer
ethereumetl export_token_transfers --start-block 15481752 --end-block 15493678 --provider-uri file:///mnt/ethdata_fast/geth.ipc --output token_transfers.csv

导出 block/transactions
ethereumetl export_blocks_and_transactions --start-block 15481752 --end-block 15493678 --blocks-output blocks.csv --transactions-output transactions.csv --provider-uri file:///mnt/ethdata_fast/geth.ipc

导出 receipts_and_logs
`
ethereumetl extract_csv_column --input transactions.csv --column hash --output transaction_hashes.txt

ethereumetl export_receipts_and_logs --transaction-hashes transaction_hashes.txt --provider-uri file:///mnt/ethdata_fast/geth.ipc --receipts-output receipts.csv --logs-output logs.csv
`

导出 contract
`
ethereumetl extract_csv_column --input receipts.csv --column contract_address --output contract_addresses.txt
ethereumetl export_contracts --contract-addresses contract_addresses.txt --provider-uri file:///mnt/ethdata_fast/geth.ipc --output contracts.json

`

导出tokens
`
ethereumetl filter_items -i contracts.json -p "item['is_erc20'] or item['is_erc721']" | ethereumetl extract_field -f address -o token_addresses.txt

ethereumetl export_tokens --token-addresses token_addresses.txt --provider-uri file:///mnt/ethdata_fast/geth.ipc --output tokens.csv

`
一切都很顺利
但是 划重点:当导出到:traces 不行了!不行了!不行了

image
必须要用:openethereum 重新同步数据,同步节点数据。
坑呀。又得等很长时间。

@zhangmaosen
Copy link
Contributor

那traces导出只能在自己的节点上做,是吧?:)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants