aboutsummaryrefslogtreecommitdiff
path: root/wqflask/utility
diff options
context:
space:
mode:
authorLei Yan2017-03-16 17:22:06 +0000
committerLei Yan2017-03-16 17:22:06 +0000
commit5855229d3f5d3be33aef758a4c13620baf5faa9c (patch)
tree34f416fa2806e0b629174c83fd30b489aa454df2 /wqflask/utility
parent6224a885f99ed4e26164e49260c222183bf4982a (diff)
parent2b14b0d04387a262f9895ddd87ce465c6835fa8c (diff)
downloadgenenetwork2-5855229d3f5d3be33aef758a4c13620baf5faa9c.tar.gz
Merge /home/zas1024/gene
Diffstat (limited to 'wqflask/utility')
-rw-r--r--wqflask/utility/helper_functions.py20
-rw-r--r--wqflask/utility/tools.py1
2 files changed, 21 insertions, 0 deletions
diff --git a/wqflask/utility/helper_functions.py b/wqflask/utility/helper_functions.py
index 377f6b26..cf16879f 100644
--- a/wqflask/utility/helper_functions.py
+++ b/wqflask/utility/helper_functions.py
@@ -5,6 +5,9 @@ from base import data_set
from base.species import TheSpecies
from wqflask import user_manager
+
+from flask import Flask, g
+
import logging
logger = logging.getLogger(__name__ )
@@ -41,3 +44,20 @@ def get_trait_db_obs(self, trait_db_list):
name=trait_name,
cellid=None)
self.trait_list.append((trait_ob, dataset_ob))
+
+def get_species_groups():
+
+ species_query = "SELECT SpeciesId, MenuName FROM Species"
+ species_ids_and_names = g.db.execute(species_query).fetchall()
+
+ species_and_groups = []
+ for species_id, species_name in species_ids_and_names:
+ this_species_groups = {}
+ this_species_groups['species'] = species_name
+ groups_query = "SELECT InbredSetName FROM InbredSet WHERE SpeciesId = %s" % (species_id)
+ groups = [group[0] for group in g.db.execute(groups_query).fetchall()]
+
+ this_species_groups['groups'] = groups
+ species_and_groups.append(this_species_groups)
+
+ return species_and_groups
diff --git a/wqflask/utility/tools.py b/wqflask/utility/tools.py
index 8db9ac6e..c28c617a 100644
--- a/wqflask/utility/tools.py
+++ b/wqflask/utility/tools.py
@@ -212,6 +212,7 @@ USE_REDIS = get_setting_bool('USE_REDIS')
USE_GN_SERVER = get_setting_bool('USE_GN_SERVER')
GENENETWORK_FILES = get_setting('GENENETWORK_FILES')
+TEMP_TRAITS = get_setting('TEMP_TRAITS')
PYLMM_COMMAND = pylmm_command()
GEMMA_COMMAND = gemma_command()