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.

1 files changed, 0 insertions, 6 deletions

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