diff options
| author | Frederick Muriuki Muriithi | 2022-01-03 13:13:12 +0300 |
|---|---|---|
| committer | Frederick Muriuki Muriithi | 2022-01-10 08:15:19 +0300 |
| commit | d40fe8eabe0f7a21eaca1947a4b6bc0c1a1e1546 (patch) | |
| tree | 3fad7b8e346d783ae60997053a8bfcc71891d4e1 | |
| parent | 3225e185c0df042e8515734806c3833174c89765 (diff) | |
| download | genenetwork3-d40fe8eabe0f7a21eaca1947a4b6bc0c1a1e1546.tar.gz | |
Fix error in query: Replace '=' with 'IN'
| -rw-r--r-- | gn3/db/partial_correlations.py | 4 |
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)), |