search

blockchain-etl / ethereum-etl

Python scripts for ETL (extract, transform and load) jobs for Ethereum blocks, transactions, ERC20 / ERC721 tokens, transfers, receipts, logs, contracts, internal transactions. Data is available in Google BigQuery https://goo.gl/oY5BCQ
https://t.me/BlockchainETL
MIT License
2.87k stars 812 forks source link

SQLalchemy never commits #445

Open guyalterya opened 1 year ago

guyalterya commented 1 year ago

Hi, I tried to execute ethererum-etl to keep my postgress db (in gcp) updated, even though the script worked and the insert commands were executed successfully the data was never committed and the DB remained empty (even after waiting). the solution was to add a connection.commit() in the end of the export_items function.

ideal93 commented 1 year ago

Maybe this problem won't occur with pg8000

consensyx commented 11 months ago

@guyalterya you can just add below command after this line connection.commit()