Python DB API 2¶
However imperfect may it be, it’s here to stay.
So enjoy!
- class satella.db.transaction(connection_or_getter, close_the_connection_after=False, log_exception=True)¶
A context manager for wrapping a transaction and getting a cursor from the Python DB API 2.
Use it as a context manager. commit and rollback will be automatically called for you.
Use like:
>>> with transaction(conn) as cur: >>> cur.execute('DROP DATABASE')
Leaving the context manager will automatically close the cursor for you.
- Parameters:
connection_or_getter – the connection object to use, or a callable, that called with zero arguments will provide us with a connection
close_the_connection_after (bool) – whether the connection should be closed after use
log_exception (bool) – whether to log an exception if it happens