aboutsummaryrefslogtreecommitdiff
path: root/gn3/db
diff options
context:
space:
mode:
authorzsloan2023-08-17 18:21:59 +0000
committerzsloan2023-08-17 14:54:42 -0500
commit346895669845b2778dbbae2638f44d1f8e5dd4c0 (patch)
tree1ac90bb876c1881e42ef2f5fbcabff99673eae61 /gn3/db
parent1bd2c99ee973f92a324379ea1afc79d355917345 (diff)
downloadgenenetwork3-346895669845b2778dbbae2638f44d1f8e5dd4c0.tar.gz
Fix fetch_trait query for phenotypes
Diffstat (limited to 'gn3/db')
-rw-r--r--gn3/db/phenotypes.py2
1 files changed, 1 insertions, 1 deletions
diff --git a/gn3/db/phenotypes.py b/gn3/db/phenotypes.py
index 2b16b17..6c6e61b 100644
--- a/gn3/db/phenotypes.py
+++ b/gn3/db/phenotypes.py
@@ -116,7 +116,7 @@ def fetch_trait(conn: DBConnection, dataset_id: int, trait_name: str) -> dict:
"FROM PublishFreeze AS pf INNER JOIN InbredSet AS iset "
"ON pf.InbredSetId=iset.Id "
"INNER JOIN PublishXRef AS pxr ON iset.Id=pxr.InbredSetId "
- "WHERE pf.Id=%(dataset_id)s AND pxr.Id=%(trait_name)s")
+ "WHERE iset.Id=%(dataset_id)s AND pxr.Id=%(trait_name)s")
with conn.cursor(cursorclass=DictCursor) as cursor:
cursor.execute(
query, {"dataset_id": dataset_id, "trait_name": trait_name})