diff options
| author | Frederick Muriuki Muriithi | 2022-09-12 07:12:08 +0300 |
|---|---|---|
| committer | Frederick Muriuki Muriithi | 2022-09-12 07:12:08 +0300 |
| commit | d5c8a84636b7fdb5934a67853287632253454416 (patch) | |
| tree | 3d523294ac6a4616dd5db917d727119ec6a5306c | |
| parent | df7ae4856b2191c449d96eac42ce23d3f830073d (diff) | |
| download | genenetwork2-d5c8a84636b7fdb5934a67853287632253454416.tar.gz | |
Fix query: Remove extraneous bracket
| -rw-r--r-- | wqflask/wqflask/correlation/rust_correlation.py | 8 |
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, |