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, 5 deletions

diff --git a/gn3/db/sample_data.py b/gn3/db/sample_data.py
index d29f6c8..b67fe1c 100644
--- a/gn3/db/sample_data.py
+++ b/gn3/db/sample_data.py
@@ -255,9 +255,7 @@ def update_sample_data(
             if _rowcount:
                 count += 1
     except Exception as _e:
-        conn.rollback()
         raise MySQLdb.Error(_e) from _e
-    conn.commit()
     return count
 
 
@@ -325,9 +323,7 @@ def delete_sample_data(
                     inbredset_id=inbredset_id,
                 )
     except Exception as _e:
-        conn.rollback()
         raise MySQLdb.Error(_e) from _e
-    conn.commit()
     return count
 
 
@@ -420,5 +416,4 @@ def insert_sample_data(
                 )
         return count
     except Exception as _e:
-        conn.rollback()
         raise MySQLdb.Error(_e) from _e