aboutsummaryrefslogtreecommitdiff
path: root/wqflask/base
diff options
context:
space:
mode:
authorroot2013-09-24 18:08:23 -0500
committerroot2013-09-24 18:08:23 -0500
commit081f4f222a261c0d84bfb266aa4a32d6d62cab85 (patch)
treec79ef21b8703e50bd70e9fd05eef92a87802c196 /wqflask/base
parent183f9a0ba19b6fcdf1475285af1bb1fcd45a9442 (diff)
downloadgenenetwork2-081f4f222a261c0d84bfb266aa4a32d6d62cab85.tar.gz
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).
Diffstat (limited to 'wqflask/base')
-rwxr-xr-xwqflask/base/data_set.py14
1 files changed, 13 insertions, 1 deletions
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'''