about summary refs log tree commit diff
diff options
context:
space:
mode:
authorzsloan2023-04-17 21:28:00 +0000
committerzsloan2023-05-22 17:23:08 +0000
commit428c953cc50057848368482ee646e29fd89e4210 (patch)
tree7831ef6a36df99d156f589c09c3e172deeb0a061
parentd93146504048e341262223c09be64c3f0c416c8d (diff)
downloadgenenetwork3-428c953cc50057848368482ee646e29fd89e4210.tar.gz
Commit update/insert queries, since they don't seem to be executed otherwise after the recent changes to the DB
-rw-r--r--gn3/db/__init__.py2
1 files changed, 2 insertions, 0 deletions
diff --git a/gn3/db/__init__.py b/gn3/db/__init__.py
index ea800c1..149a344 100644
--- a/gn3/db/__init__.py
+++ b/gn3/db/__init__.py
@@ -60,6 +60,7 @@ def update(conn: Any,
     with conn.cursor() as cursor:
         cursor.execute(sql,
                        tuple(data_.values()) + tuple(where_.values()))
+        conn.commit()
         return cursor.rowcount
 
 
@@ -122,6 +123,7 @@ def insert(conn: Any,
     sql += ")"
     with conn.cursor() as cursor:
         cursor.execute(sql, tuple(dict_.values()))
+        conn.commit()
         return cursor.rowcount