about summary refs log tree commit diff
diff options
context:
space:
mode:
-rw-r--r--gn3/db_utils.py3
1 files changed, 3 insertions, 0 deletions
diff --git a/gn3/db_utils.py b/gn3/db_utils.py
index 2f65a33..5fd250d 100644
--- a/gn3/db_utils.py
+++ b/gn3/db_utils.py
@@ -35,7 +35,10 @@ def database_connection(sql_uri) -> Iterator[Connection]:
                              port=port or 3306)
     try:
         yield connection
+    except mdb.Error as _mbde:
+        connection.rollback()
     finally:
+        connection.commit()
         connection.close()