aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAlexander_Kabui2022-09-09 15:55:35 +0300
committerBonfaceKilz2022-09-09 18:04:33 +0300
commitd1f1c5c88a2a5c986c7099ddd91ca7a0fbf5dffc (patch)
treecdf6d8b78d056ea433257ba6734ba83a5b989deb
parentd153147cfbd891d886519da5f0b08f6441f63b3c (diff)
downloadgenenetwork2-d1f1c5c88a2a5c986c7099ddd91ca7a0fbf5dffc.tar.gz
tissue:fetch for query formatting
-rw-r--r--wqflask/base/mrna_assay_tissue_data.py14
1 files changed, 7 insertions, 7 deletions
diff --git a/wqflask/base/mrna_assay_tissue_data.py b/wqflask/base/mrna_assay_tissue_data.py
index 9a86134e..a78182e3 100644
--- a/wqflask/base/mrna_assay_tissue_data.py
+++ b/wqflask/base/mrna_assay_tissue_data.py
@@ -83,14 +83,14 @@ class MrnaAssayTissueData:
if len(id_list) > 0:
results = []
with self.conn.cursor() as cursor:
+
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))
+ "SELECT TissueProbeSetXRef.Symbol, TissueProbeSetData.value "
+ "FROM TissueProbeSetXRef, TissueProbeSetData"
+ f" WHERE TissueProbeSetData.Id IN ({', '.join(['%s'] * len(id_list))})"
+ " AND TissueProbeSetXRef.DataId = TissueProbeSetData.Id"
+ ,tuple(id_list))
+
results = cursor.fetchall()
for result in results:
(symbol, value) = result