aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorFrederick Muriuki Muriithi2022-01-03 13:13:12 +0300
committerFrederick Muriuki Muriithi2022-01-10 08:15:19 +0300
commitd40fe8eabe0f7a21eaca1947a4b6bc0c1a1e1546 (patch)
tree3fad7b8e346d783ae60997053a8bfcc71891d4e1
parent3225e185c0df042e8515734806c3833174c89765 (diff)
downloadgenenetwork3-d40fe8eabe0f7a21eaca1947a4b6bc0c1a1e1546.tar.gz
Fix error in query: Replace '=' with 'IN'
-rw-r--r--gn3/db/partial_correlations.py4
1 files changed, 2 insertions, 2 deletions
diff --git a/gn3/db/partial_correlations.py b/gn3/db/partial_correlations.py
index 9a4d814..8c4ec65 100644
--- a/gn3/db/partial_correlations.py
+++ b/gn3/db/partial_correlations.py
@@ -733,8 +733,8 @@ def set_homologene_id(conn, traits):
"SELECT InbredSet.Name AS `group`, Homologene.GeneId AS geneid, "
"HomologeneId "
"FROM Homologene, Species, InbredSet "
- "WHERE Homologene.GeneId = ({geneids}) "
- "AND InbredSet.Name = ({groups}) "
+ "WHERE Homologene.GeneId IN ({geneids}) "
+ "AND InbredSet.Name IN ({groups}) "
"AND InbredSet.SpeciesId = Species.Id "
"AND Species.TaxonomyId = Homologene.TaxonomyId").format(
geneids=", ".join(["%s"] * len(geneids)),