aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorFrederick Muriuki Muriithi2022-09-12 07:12:08 +0300
committerFrederick Muriuki Muriithi2022-09-12 07:12:08 +0300
commitd5c8a84636b7fdb5934a67853287632253454416 (patch)
tree3d523294ac6a4616dd5db917d727119ec6a5306c
parentdf7ae4856b2191c449d96eac42ce23d3f830073d (diff)
downloadgenenetwork2-d5c8a84636b7fdb5934a67853287632253454416.tar.gz
Fix query: Remove extraneous bracket
-rw-r--r--wqflask/wqflask/correlation/rust_correlation.py8
1 files changed, 4 insertions, 4 deletions
diff --git a/wqflask/wqflask/correlation/rust_correlation.py b/wqflask/wqflask/correlation/rust_correlation.py
index debc4930..8e8cd463 100644
--- a/wqflask/wqflask/correlation/rust_correlation.py
+++ b/wqflask/wqflask/correlation/rust_correlation.py
@@ -139,15 +139,15 @@ def compute_top_n_sample(start_vars, dataset, trait_list):
# fetching strain data in bulk
query = (
"SELECT * from ProbeSetData "
- f"WHERE StrainID IN ({', '.join(['%s'] * len(sample_ids))})"
- "AND id IN ("
+ f"WHERE StrainID IN ({', '.join(['%s'] * len(sample_ids))}) "
+ "AND Id IN ("
" SELECT ProbeSetXRef.DataId "
" FROM (ProbeSet, ProbeSetXRef, ProbeSetFreeze) "
" WHERE ProbeSetXRef.ProbeSetFreezeId = ProbeSetFreeze.Id "
" AND ProbeSetFreeze.Name = %s "
" AND ProbeSet.Name "
- f" IN ({', '.join(['%s'] * len(trait_list))})"
- " ProbeSet.Id = ProbeSetXRef.ProbeSetId)"
+ f" IN ({', '.join(['%s'] * len(trait_list))}) "
+ " AND ProbeSet.Id = ProbeSetXRef.ProbeSetId"
")")
curr.execute(
query,