diff options
| -rw-r--r-- | wqflask/base/mrna_assay_tissue_data.py | 14 |
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 |