From 081f4f222a261c0d84bfb266aa4a32d6d62cab85 Mon Sep 17 00:00:00 2001
From: root
Date: Tue, 24 Sep 2013 18:08:23 -0500
Subject: Did some work towards doing the tissue correlation for all traits in
 a dataset (in order to sort by tissue correlation instead of sample
 correlation).

---
 wqflask/base/data_set.py | 14 +++++++++++++-
 1 file changed, 13 insertions(+), 1 deletion(-)

(limited to 'wqflask/base')

diff --git a/wqflask/base/data_set.py b/wqflask/base/data_set.py
index 96e04df0..5d21c901 100755
--- a/wqflask/base/data_set.py
+++ b/wqflask/base/data_set.py
@@ -1055,7 +1055,6 @@ class MrnaAssayDataSet(DataSet):
                 """ % (escape(self.name), escape(self.dataset.name))
         results = g.db.execute(query).fetchone()
         return results[0]
-    
    
     def retrieve_sample_data(self, trait):
         query = """
@@ -1077,6 +1076,19 @@ class MrnaAssayDataSet(DataSet):
         results = g.db.execute(query).fetchall()
         return results
 
+    def retrieve_gene_symbols(self):
+        query = """
+                    select ProbeSet.Name, ProbeSet.Symbol
+                    from ProbeSet,ProbeSetXRef
+                    where ProbeSetXRef.ProbeSetFreezeId = %s and
+                    ProbeSetXRef.ProbeSetId=ProbeSet.Id;
+                """ % (self.id)
+        results = g.db.execute(query).fetchall()
+        symbol_dict = {}
+        for item in results:
+            symbol_dict[item[0]] = item[1]
+        return symbol_dict
+
 
 class TempDataSet(DataSet):
     '''Temporary user-generated data set'''
-- 
cgit v1.2.3