aboutsummaryrefslogtreecommitdiff
path: root/wqflask/utility/helper_functions.py
diff options
context:
space:
mode:
Diffstat (limited to 'wqflask/utility/helper_functions.py')
-rw-r--r--wqflask/utility/helper_functions.py69
1 files changed, 0 insertions, 69 deletions
diff --git a/wqflask/utility/helper_functions.py b/wqflask/utility/helper_functions.py
deleted file mode 100644
index 8b20bd74..00000000
--- a/wqflask/utility/helper_functions.py
+++ /dev/null
@@ -1,69 +0,0 @@
-from base import data_set
-from base.trait import create_trait
-from base.species import TheSpecies
-
-from utility import hmac
-from utility.tools import get_setting
-
-from wqflask.database import database_connection
-
-
-def get_species_dataset_trait(self, start_vars):
- if "temp_trait" in list(start_vars.keys()):
- if start_vars['temp_trait'] == "True":
- self.dataset = data_set.create_dataset(
- dataset_name="Temp",
- dataset_type="Temp",
- group_name=start_vars['group'])
- else:
- self.dataset = data_set.create_dataset(start_vars['dataset'])
- else:
- self.dataset = data_set.create_dataset(start_vars['dataset'])
- self.species = TheSpecies(dataset=self.dataset)
- self.this_trait = create_trait(dataset=self.dataset,
- name=start_vars['trait_id'],
- cellid=None,
- get_qtl_info=True)
-
-def get_trait_db_obs(self, trait_db_list):
- if isinstance(trait_db_list, str):
- trait_db_list = trait_db_list.split(",")
-
- self.trait_list = []
- for trait in trait_db_list:
- data, _separator, hmac_string = trait.rpartition(':')
- data = data.strip()
- assert hmac_string == hmac.hmac_creation(data), "Data tampering?"
- trait_name, dataset_name = data.split(":")[:2]
- if dataset_name == "Temp":
- dataset_ob = data_set.create_dataset(
- dataset_name=dataset_name, dataset_type="Temp",
- group_name=trait_name.split("_")[2])
- else:
- dataset_ob = data_set.create_dataset(dataset_name)
- trait_ob = create_trait(dataset=dataset_ob,
- name=trait_name,
- cellid=None)
- if trait_ob:
- self.trait_list.append((trait_ob, dataset_ob))
-
-
-def get_species_groups():
- """Group each species into a group"""
- _menu = {}
- species, group_name = None, None
- with database_connection(get_setting("SQL_URI")) as conn, conn.cursor() as cursor:
- cursor.execute(
- "SELECT s.MenuName, i.InbredSetName FROM InbredSet i "
- "INNER JOIN Species s ON s.SpeciesId = i.SpeciesId "
- "ORDER BY i.SpeciesId ASC, i.Name ASC"
- )
- for species, group_name in cursor.fetchall():
- if species in _menu:
- if _menu.get(species):
- _menu = _menu[species].append(group_name)
- else:
- _menu[species] = [group_name]
- return [{"species": key,
- "groups": value} for key, value in
- list(_menu.items())]