aboutsummaryrefslogtreecommitdiff
path: root/wqflask
diff options
context:
space:
mode:
Diffstat (limited to 'wqflask')
-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