aboutsummaryrefslogtreecommitdiff
path: root/wqflask/maintenance
diff options
context:
space:
mode:
Diffstat (limited to 'wqflask/maintenance')
-rw-r--r--wqflask/maintenance/gen_select_dataset.py97
1 files changed, 57 insertions, 40 deletions
diff --git a/wqflask/maintenance/gen_select_dataset.py b/wqflask/maintenance/gen_select_dataset.py
index 33813051..9224b884 100644
--- a/wqflask/maintenance/gen_select_dataset.py
+++ b/wqflask/maintenance/gen_select_dataset.py
@@ -76,17 +76,22 @@ def get_types(groups):
types[species] = {}
for group_name, _group_full_name in group_dict:
# make group an alias to shorten the code
- group = types[species][group_name] = [("Phenotypes", "Phenotypes"),
- ("Genotypes", "Genotypes")]
- Cursor.execute("""select distinct Tissue.Name, concat(Tissue.Name, ' mRNA') from
- ProbeFreeze,
- ProbeSetFreeze, InbredSet, Tissue where ProbeFreeze.TissueId = Tissue.Id and
+ types[species][group_name] = [("Phenotypes", "Phenotypes"), ("Genotypes", "Genotypes")]
+ types[species][group_name] += build_types(species, group_name)
+ return types
+
+
+def build_types(species, group):
+ Cursor.execute("""select distinct Tissue.Name, concat(Tissue.Name, ' mRNA')
+ from ProbeFreeze, ProbeSetFreeze, InbredSet, Tissue, Species
+ where Species.Name = %s and Species.Id = InbredSet.SpeciesId and
+ InbredSet.Name = %s and
+ ProbeFreeze.TissueId = Tissue.Id and
ProbeFreeze.InbredSetId = InbredSet.Id and
- InbredSet.Name = %s and ProbeSetFreeze.ProbeFreezeId = ProbeFreeze.Id and
+ ProbeSetFreeze.ProbeFreezeId = ProbeFreeze.Id and
ProbeSetFreeze.public > %s
- order by Tissue.Name""", (group_name, webqtlConfig.PUBLICTHRESH))
- group += Cursor.fetchall()
- return types
+ order by Tissue.Name""", (species, group, webqtlConfig.PUBLICTHRESH))
+ return Cursor.fetchall()
def get_datasets(types):
@@ -97,39 +102,44 @@ def get_datasets(types):
for group, type_list in group_dict.iteritems():
datasets[species][group] = {}
for type_name, type_full_name in type_list:
- dataset_text = dataset_value = None
- if type_name == "Phenotypes":
- dataset_value = "%sPublish" % group
- if group == 'MDP':
- dataset_text = "Mouse Phenome Database"
- else:
- dataset_text = "%s Published Phenotypes" % group
-
- elif type_name == "Genotypes":
- dataset_value = "%sGeno" % group
- dataset_text = "%s Genotypes" % group
-
- if dataset_value:
- datasets[species][group][type_name] = [(dataset_value, dataset_text)]
- else:
- Cursor.execute("""select ProbeSetFreeze.Name, ProbeSetFreeze.FullName from
- ProbeSetFreeze, ProbeFreeze, InbredSet, Tissue where
- ProbeSetFreeze.ProbeFreezeId = ProbeFreeze.Id and Tissue.Name = %s
- and ProbeFreeze.TissueId = Tissue.Id and ProbeFreeze.InbredSetId =
- InbredSet.Id and ProbeSetFreeze.public > %s order by
- ProbeSetFreeze.CreateTime desc""", (type_name,
- webqtlConfig.PUBLICTHRESH))
- datasets[species][group][type_name] = Cursor.fetchall()
-
+ datasets[species][group][type_name] = build_datasets(species, group, type_name)
return datasets
+def build_datasets(species, group, type_name):
+ dataset_text = dataset_value = None
+ if type_name == "Phenotypes":
+ dataset_value = "%sPublish" % group
+ if group == 'MDP':
+ dataset_text = "Mouse Phenome Database"
+ else:
+ dataset_text = "%s Published Phenotypes" % group
+
+ elif type_name == "Genotypes":
+ dataset_value = "%sGeno" % group
+ dataset_text = "%s Genotypes" % group
+
+ if dataset_value:
+ return [(dataset_value, dataset_text)]
+ else:
+ Cursor.execute("""select ProbeSetFreeze.Name, ProbeSetFreeze.FullName from
+ ProbeSetFreeze, ProbeFreeze, InbredSet, Tissue, Species where
+ Species.Name = %s and Species.Id = InbredSet.SpeciesId and
+ InbredSet.Name = %s and
+ ProbeSetFreeze.ProbeFreezeId = ProbeFreeze.Id and Tissue.Name = %s
+ and ProbeFreeze.TissueId = Tissue.Id and ProbeFreeze.InbredSetId =
+ InbredSet.Id and ProbeSetFreeze.public > %s order by
+ ProbeSetFreeze.CreateTime desc""", (
+ species, group, type_name, webqtlConfig.PUBLICTHRESH))
+ return Cursor.fetchall()
+
+
def main():
species = get_species()
groups = get_groups(species)
types = get_types(groups)
datasets = get_datasets(types)
-
+
species.append(('All Species', 'All Species'))
groups['All Species'] = [('All Groups', 'All Groups')]
types['All Species'] = {}
@@ -137,18 +147,25 @@ def main():
datasets['All Species'] = {}
datasets['All Species']['All Groups'] = {}
datasets['All Species']['All Groups']['Phenotypes'] = [('All Phenotypes','All Phenotypes')]
-
+
data = dict(species=species,
groups=groups,
types=types,
datasets=datasets,
)
-
- output_file = """../wqflask/static/new/javascript/dataset_menu_structure.json"""
-
+
+ output_file = """../wqflask/static/new/javascript/dataset_menu_structure"""
+
with open(output_file, 'w') as fh:
json.dump(data, fh, indent=" ", sort_keys=True)
-
+
+ print("\nWrote file to:", output_file)
+
+def test_it():
+ types = build_types("Mouse", "BXD")
+ print("build_types:", pf(types))
+ datasets = build_datasets("Mouse", "BXD", "Hippocampus")
+ print("build_datasets:", pf(datasets))
if __name__ == '__main__':
- main() \ No newline at end of file
+ main()