Any suggestion on how I'd commit/rollback using a connection pool? about momoko HOT 3 CLOSED

Could I still avoid executting a commit after exiting the managed context?

Nothing in momoko lib calls COMMIT for you. I'm not sure why you believe it happens (may be Postgres does it behind the scenes in some way - I'm not much familiar with this DB). BTW, there is Connection.transaction method, that executes a list of statements and commits/rolls back. Does it help you?

Rolling back - I see indeed no rollback method on the connection

Again, there are no helper methods like Connection.commit and Connection.rollback - you can call execute with appropriate statements or extend connection class to add this methods (currently it will requires monkey-patching the imported package, but I can extend Pool to accept ConnectionClass in constructor).

After retrieving a cursor from yield pool.execute('select something') I'll get back a cursor...

Are named cursors what you are after?

from momoko.

Closing this discussion due to inactivity. Feel free to reopen.

from momoko.

Yeah, I'm still thinking about it. If I have anything interesting I'll let you know. Thanks for the support! :)

from momoko.