diff options
author | Alexander_Kabui | 2022-09-09 15:55:35 +0300 |
---|---|---|
committer | BonfaceKilz | 2022-09-09 18:04:33 +0300 |
commit | d1f1c5c88a2a5c986c7099ddd91ca7a0fbf5dffc (patch) | |
tree | cdf6d8b78d056ea433257ba6734ba83a5b989deb | |
parent | d153147cfbd891d886519da5f0b08f6441f63b3c (diff) | |
download | genenetwork2-d1f1c5c88a2a5c986c7099ddd91ca7a0fbf5dffc.tar.gz |
tissue:fetch for query formatting
-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 |