diff options
Diffstat (limited to 'wqflask/base/data_set.py')
| -rwxr-xr-x | wqflask/base/data_set.py | 13 |
1 files changed, 8 insertions, 5 deletions
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]) |