Use global handler to rollback db

[samhotep]

Is your feature request related to a problem? Please describe.
Normally, we add a rollback where we want some transaction to be atomic

Describe the solution you'd like
Add a global rollback handler to the sqlalchemy instantiation so that we don't have to explicitly rollback db actions