diff options
author | zsloan | 2021-04-30 18:40:13 +0000 |
---|---|---|
committer | zsloan | 2021-04-30 18:40:13 +0000 |
commit | 21b2e2a552b8b6bedb789263543a4d6d039ac8a9 (patch) | |
tree | fe55511b99a522198c1b840909d7b91c9b45ab22 /wqflask/db/webqtlDatabaseFunction.py | |
parent | 699b952c7bda5426f3f3e947454f656a4ec7538b (diff) | |
parent | 799b25481fffc97e2adb07004adf502096bf371c (diff) | |
download | genenetwork2-21b2e2a552b8b6bedb789263543a4d6d039ac8a9.tar.gz |
Merge branch 'testing' of github.com:genenetwork/genenetwork2 into testing
Diffstat (limited to 'wqflask/db/webqtlDatabaseFunction.py')
-rw-r--r-- | wqflask/db/webqtlDatabaseFunction.py | 13 |
1 files changed, 8 insertions, 5 deletions
diff --git a/wqflask/db/webqtlDatabaseFunction.py b/wqflask/db/webqtlDatabaseFunction.py index 2805febd..29112949 100644 --- a/wqflask/db/webqtlDatabaseFunction.py +++ b/wqflask/db/webqtlDatabaseFunction.py @@ -24,24 +24,27 @@ from db.call import fetch1 from utility.tools import USE_GN_SERVER from utility.logger import getLogger -logger = getLogger(__name__ ) +logger = getLogger(__name__) ########################################################################### -#output: cursor instance -#function: connect to database and return cursor instance +# output: cursor instance +# function: connect to database and return cursor instance ########################################################################### + def retrieve_species(group): """Get the species of a group (e.g. returns string "mouse" on "BXD" """ - result = fetch1("select Species.Name from Species, InbredSet where InbredSet.Name = '%s' and InbredSet.SpeciesId = Species.Id" % (group), "/cross/"+group+".json", lambda r: (r["species"],))[0] + result = fetch1("select Species.Name from Species, InbredSet where InbredSet.Name = '%s' and InbredSet.SpeciesId = Species.Id" % ( + group), "/cross/" + group + ".json", lambda r: (r["species"],))[0] logger.debug("retrieve_species result:", result) return result def retrieve_species_id(group): - result = fetch1("select SpeciesId from InbredSet where Name = '%s'" % (group), "/cross/"+group+".json", lambda r: (r["species_id"],))[0] + result = fetch1("select SpeciesId from InbredSet where Name = '%s'" % ( + group), "/cross/" + group + ".json", lambda r: (r["species_id"],))[0] logger.debug("retrieve_species_id result:", result) return result |