From 8c45fcf1e9228108034fab96bc7e7eaa7740f06c Mon Sep 17 00:00:00 2001 From: Zachary Sloan Date: Fri, 18 Jul 2014 17:31:41 +0000 Subject: Added outlier highlighting Changed order of tabs in statistics panel on trait page Started working on heatmap --- wqflask/base/data_set.py | 13 ++++++++----- 1 file changed, 8 insertions(+), 5 deletions(-) (limited to 'wqflask/base/data_set.py') diff --git a/wqflask/base/data_set.py b/wqflask/base/data_set.py index 2a79dc9c..e6bd61c1 100755 --- a/wqflask/base/data_set.py +++ b/wqflask/base/data_set.py @@ -563,12 +563,15 @@ class DataSet(object): """.format(*mescape(self.type, item, item, self.type, item, item)) if self.type == "Publish": + #query += """ + # WHERE {}XRef.InbredSetId = '{}' + # """.format(*mescape(self.type, self.group.name)) + query += """ - WHERE {}XRef.PublicationId = {}Freeze.Id - and {}Freeze.Name = '{}' + WHERE {}XRef.InbredSetId = '{}' and {}.Id = {}XRef.{}Id order by {}.Id - """.format(*mescape(self.type, self.type, self.type, self.name, + """.format(*mescape(self.type, self.group.name, dataset_type, self.type, dataset_type, dataset_type)) else: query += """ @@ -579,10 +582,10 @@ class DataSet(object): """.format(*mescape(self.type, self.type, self.type, self.type, self.name, dataset_type, self.type, self.type, dataset_type)) - #print("trait data query: ", query) + print("trait data query: ", query) results = g.db.execute(query).fetchall() - #print("query results:", results) + print("query results:", results) trait_sample_data.append(results) trait_count = len(trait_sample_data[0]) -- cgit v1.2.3