From 1055679028cdd24f845aac80dd4cde22a17a1e25 Mon Sep 17 00:00:00 2001
From: Frederick Muriuki Muriithi
Date: Fri, 9 Sep 2022 06:08:53 +0300
Subject: Replace `g.db.execute` with `cursor.execute`

---
 wqflask/base/data_set.py | 46 ++++++++++++++++++++++++----------------------
 1 file changed, 24 insertions(+), 22 deletions(-)

diff --git a/wqflask/base/data_set.py b/wqflask/base/data_set.py
index cd626526..4d708e59 100644
--- a/wqflask/base/data_set.py
+++ b/wqflask/base/data_set.py
@@ -479,28 +479,30 @@ class DatasetGroup:
 def datasets(group_name, this_group=None):
     key = "group_dataset_menu:v2:" + group_name
     dataset_menu = []
-    the_results = g.db.execute('''
-        (SELECT '#PublishFreeze',PublishFreeze.FullName,PublishFreeze.Name
-        FROM PublishFreeze,InbredSet
-        WHERE PublishFreeze.InbredSetId = InbredSet.Id
-            and InbredSet.Name = '%s'
-        ORDER BY PublishFreeze.Id ASC)
-        UNION
-        (SELECT '#GenoFreeze',GenoFreeze.FullName,GenoFreeze.Name
-        FROM GenoFreeze, InbredSet
-        WHERE GenoFreeze.InbredSetId = InbredSet.Id
-            and InbredSet.Name = '%s')
-        UNION
-        (SELECT Tissue.Name, ProbeSetFreeze.FullName,ProbeSetFreeze.Name
-        FROM ProbeSetFreeze, ProbeFreeze, InbredSet, Tissue
-        WHERE ProbeSetFreeze.ProbeFreezeId = ProbeFreeze.Id
-            and ProbeFreeze.TissueId = Tissue.Id
-            and ProbeFreeze.InbredSetId = InbredSet.Id
-            and InbredSet.Name like %s
-        ORDER BY Tissue.Name, ProbeSetFreeze.OrderList DESC)
-        ''' % (group_name,
-            group_name,
-            "'" + group_name + "'")).fetchall()
+    with database_connection() as conn, conn.cursor() as cursor:
+        cursor.execute('''
+            (SELECT '#PublishFreeze',PublishFreeze.FullName,PublishFreeze.Name
+            FROM PublishFreeze,InbredSet
+            WHERE PublishFreeze.InbredSetId = InbredSet.Id
+                and InbredSet.Name = '%s'
+            ORDER BY PublishFreeze.Id ASC)
+            UNION
+            (SELECT '#GenoFreeze',GenoFreeze.FullName,GenoFreeze.Name
+            FROM GenoFreeze, InbredSet
+            WHERE GenoFreeze.InbredSetId = InbredSet.Id
+                and InbredSet.Name = '%s')
+            UNION
+            (SELECT Tissue.Name, ProbeSetFreeze.FullName,ProbeSetFreeze.Name
+            FROM ProbeSetFreeze, ProbeFreeze, InbredSet, Tissue
+            WHERE ProbeSetFreeze.ProbeFreezeId = ProbeFreeze.Id
+                and ProbeFreeze.TissueId = Tissue.Id
+                and ProbeFreeze.InbredSetId = InbredSet.Id
+                and InbredSet.Name like %s
+            ORDER BY Tissue.Name, ProbeSetFreeze.OrderList DESC)
+            ''' % (group_name,
+                group_name,
+                "'" + group_name + "'"))
+        the_results = cursor.fetchall()
 
     sorted_results = sorted(the_results, key=lambda kv: kv[0])
 
-- 
cgit v1.2.3