From 9ac9e6a305e5e96d24a67a7469e3f2ea66fc0c72 Mon Sep 17 00:00:00 2001
From: zsloan
Date: Tue, 1 Feb 2022 20:48:33 +0000
Subject: Remove PublishFreeze from retrieve_publish_trait_info query

The PublishFreeze table isn't necessary in phenotype queries, since
PublishFreeze.Id = InbredSet.Id (for the purposes of identifying traits,
at least)
---
 gn3/db/traits.py | 5 ++---
 1 file changed, 2 insertions(+), 3 deletions(-)

(limited to 'gn3')

diff --git a/gn3/db/traits.py b/gn3/db/traits.py
index fdbba21..062b68c 100644
--- a/gn3/db/traits.py
+++ b/gn3/db/traits.py
@@ -309,13 +309,12 @@ def retrieve_publish_trait_info(trait_data_source: Dict[str, Any], conn: Any):
         "SELECT "
         "{columns} "
         "FROM "
-        "PublishXRef, Publication, Phenotype, PublishFreeze "
+        "PublishXRef, Publication, Phenotype "
         "WHERE "
         "PublishXRef.Id = %(trait_name)s AND "
         "Phenotype.Id = PublishXRef.PhenotypeId AND "
         "Publication.Id = PublishXRef.PublicationId AND "
-        "PublishXRef.InbredSetId = PublishFreeze.InbredSetId AND "
-        "PublishFreeze.Id =%(trait_dataset_id)s").format(columns=columns)
+        "PublishXRef.InbredSetId = %(trait_dataset_id)s").format(columns=columns)
     with conn.cursor() as cursor:
         cursor.execute(
             query,
-- 
cgit v1.2.3