From f48d60c1f4ddb222629e19fd42c840a961666334 Mon Sep 17 00:00:00 2001
From: Munyoki Kilyungi
Date: Wed, 7 Sep 2022 11:58:57 +0300
Subject: Use "%s" in sql query

* wqflask/base/mrna_assay_tissue_data.py: Delete db_tools.
(MrnaAssayTissueData.get_symbol_values_pairs): Re-format query.
* wqflask/tests/unit/base/test_mrna_assay_tissue_data.py:
(test_get_trait_symbol_and_tissue_values): Add test for above.
---
 wqflask/base/mrna_assay_tissue_data.py | 14 ++++++++------
 1 file changed, 8 insertions(+), 6 deletions(-)

(limited to 'wqflask/base')

diff --git a/wqflask/base/mrna_assay_tissue_data.py b/wqflask/base/mrna_assay_tissue_data.py
index a229151d..9a86134e 100644
--- a/wqflask/base/mrna_assay_tissue_data.py
+++ b/wqflask/base/mrna_assay_tissue_data.py
@@ -1,6 +1,5 @@
 import collections
 
-from utility import db_tools
 from utility import Bunch
 
 
@@ -82,13 +81,16 @@ class MrnaAssayTissueData:
         symbol_values_dict = {}
 
         if len(id_list) > 0:
-            query = """SELECT TissueProbeSetXRef.Symbol, TissueProbeSetData.value
-                       FROM TissueProbeSetXRef, TissueProbeSetData
-                       WHERE TissueProbeSetData.Id IN {} and
-                             TissueProbeSetXRef.DataId = TissueProbeSetData.Id""".format(db_tools.create_in_clause(id_list))
             results = []
             with self.conn.cursor() as cursor:
-                cursor.execute(query)
+                cursor.execute(
+                    "SELECT TissueProbeSetXRef.Symbol, "
+                    "TissueProbeSetData.value FROM "
+                    "TissueProbeSetXRef, TissueProbeSetData "
+                    "WHERE TissueProbeSetData.Id IN ("
+                    f"{', '.join(['%s' * len(id_list)])}) "
+                    "AND TissueProbeSetXRef.DataId = TissueProbeSetData.Id",
+                    tuple(id_list))
                 results = cursor.fetchall()
                 for result in results:
                     (symbol, value) = result
-- 
cgit v1.2.3