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

diff --git a/gn3/db/__init__.py b/gn3/db/__init__.py
index 149a344..ea800c1 100644
--- a/gn3/db/__init__.py
+++ b/gn3/db/__init__.py
@@ -60,7 +60,6 @@ def update(conn: Any,
     with conn.cursor() as cursor:
         cursor.execute(sql,
                        tuple(data_.values()) + tuple(where_.values()))
-        conn.commit()
         return cursor.rowcount
 
 
@@ -123,7 +122,6 @@ def insert(conn: Any,
     sql += ")"
     with conn.cursor() as cursor:
         cursor.execute(sql, tuple(dict_.values()))
-        conn.commit()
         return cursor.rowcount