aboutsummaryrefslogtreecommitdiff
path: root/gn3/db/__init__.py
diff options
context:
space:
mode:
authorzsloan2023-04-17 21:28:00 +0000
committerzsloan2023-05-22 17:23:08 +0000
commit428c953cc50057848368482ee646e29fd89e4210 (patch)
tree7831ef6a36df99d156f589c09c3e172deeb0a061 /gn3/db/__init__.py
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
Diffstat (limited to 'gn3/db/__init__.py')
-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