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

SQLalchemy never commits #445

Open
guyalterya opened this issue May 17, 2023 · 2 comments
Open

SQLalchemy never commits #445

guyalterya opened this issue May 17, 2023 · 2 comments

Comments

@guyalterya
Copy link

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
Copy link

ideal93 commented Jun 22, 2023

Maybe this problem won't occur with pg8000

@consensyx
Copy link

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

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

3 participants