From 2035e96b06654f3395cf01823a4f02c10f401667 Mon Sep 17 00:00:00 2001
From: Munyoki Kilyungi
Date: Tue, 23 Aug 2022 13:26:58 +0300
Subject: Remove conn.commit() and conn.rollback()

* gn3/db/__init__.py (update): Delete conn.commit() and conn.rollback()
(insert): Ditto.
* gn3/db/case_attributes.py (insert_case_attribute_audit): Ditto.
(reject_case_attribute): Ditto.
(approve_case_attribute): Ditto.
* gn3/db/sample_data.py (update_sample_data): Ditto.
(delete_sample_data): Ditto.
(insert_sample_data): Ditto.
---
 gn3/db/case_attributes.py | 6 ------
 1 file changed, 6 deletions(-)

(limited to 'gn3/db/case_attributes.py')

diff --git a/gn3/db/case_attributes.py b/gn3/db/case_attributes.py
index 98fc58d..1d82f00 100644
--- a/gn3/db/case_attributes.py
+++ b/gn3/db/case_attributes.py
@@ -37,9 +37,7 @@ def insert_case_attribute_audit(
             )
             rowcount = cursor.rowcount
     except Exception as _e:
-        conn.rollback()
         raise MySQLdb.Error(_e) from _e
-    conn.commit()
     return rowcount
 
 
@@ -55,9 +53,7 @@ def reject_case_attribute(conn: Any, case_attr_audit_id: int) -> int:
                 (case_attr_audit_id,),
             )
             rowcount = cursor.rowcount
-        conn.commit()
     except Exception as _e:
-        conn.rollback()
         raise MySQLdb.Error(_e) from _e
     return rowcount
 
@@ -125,8 +121,6 @@ def approve_case_attribute(conn: Any, case_attr_audit_id: int) -> int:
                         (case_attr_audit_id,),
                     )
             rowcount = cursor.rowcount
-            conn.commit()
     except Exception as _e:
-        conn.rollback()
         raise MySQLdb.Error(_e) from _e
     return rowcount
-- 
cgit v1.2.3