From 421a7cec8e125e54a01a0cd71e0bef64ee8c3462 Mon Sep 17 00:00:00 2001
From: zsloan
Date: Mon, 1 May 2023 19:51:25 +0000
Subject: Fix get_trait_sample_data function

---
 gn3/db/sample_data.py | 24 ++++++++++++------------
 1 file changed, 12 insertions(+), 12 deletions(-)

(limited to 'gn3/db')

diff --git a/gn3/db/sample_data.py b/gn3/db/sample_data.py
index d8232cb..29a35d6 100644
--- a/gn3/db/sample_data.py
+++ b/gn3/db/sample_data.py
@@ -68,20 +68,20 @@ FROM PublishFreeze pf JOIN PublishXRef px ON px.InbredSetId = pf.InbredSetId
      JOIN PublishData pd ON pd.Id = px.DataId JOIN Strain st ON pd.StrainId = st.Id
      LEFT JOIN PublishSE ps ON ps.DataId = pd.Id AND ps.StrainId = pd.StrainId
      LEFT JOIN NStrain ns ON ns.DataId = pd.Id AND ns.StrainId = pd.StrainId
-     AND px.Id = %s AND px.PhenotypeId = %s
+WHERE px.Id = %s AND px.PhenotypeId = %s
 ORDER BY st.Name""", (trait_name, phenotype_id))
 
-    sample_data = {}
-    for data in cursor.fetchall():
-        this_data = {}
-        sample, value, error, n_cases = data
-        sample_data[sample] = {
-            'value': value,
-            'error': error,
-            'n_cases:': n_cases
-        }
-
-    return sample_data
+        sample_data = {}
+        for data in cursor.fetchall():
+            this_data = {}
+            sample, value, error, n_cases = data
+            sample_data[sample] = {
+                'value': value,
+                'error': error,
+                'n_cases:': n_cases
+            }
+
+        return sample_data
 
 def get_trait_csv_sample_data(
     conn: Any, trait_name: int, phenotype_id: int
-- 
cgit v1.2.3