Move sql for CRUD operations on case-attrs from gn2 to gn3

1 files changed, 3 insertions, 3 deletions

diff --git a/gn3/db/case_attributes.py b/gn3/db/case_attributes.py
index 8eb2bf6..98fc58d 100644
--- a/gn3/db/case_attributes.py
+++ b/gn3/db/case_attributes.py
@@ -33,13 +33,13 @@ def insert_case_attribute_audit(
                 "INSERT INTO caseattributes_audit "
                 "(status, editor, json_diff_data) "
                 "VALUES (%s, %s, %s)",
-                (status, author, data),
+                (status, author, data,),
             )
             rowcount = cursor.rowcount
-            conn.commit()
     except Exception as _e:
         conn.rollback()
         raise MySQLdb.Error(_e) from _e
+    conn.commit()
     return rowcount
 
 
@@ -55,7 +55,7 @@ def reject_case_attribute(conn: Any, case_attr_audit_id: int) -> int:
                 (case_attr_audit_id,),
             )
             rowcount = cursor.rowcount
-            conn.commit()
+        conn.commit()
     except Exception as _e:
         conn.rollback()
         raise MySQLdb.Error(_e) from _e