aboutsummaryrefslogtreecommitdiff
path: root/wqflask/db/webqtlDatabaseFunction.py
diff options
context:
space:
mode:
authorAlexander Kabui2021-05-10 08:46:44 +0300
committerGitHub2021-05-10 08:46:44 +0300
commitf7eeb913af479358583844164400dc8489a87d8f (patch)
tree5deb035007120eff4d691c270c2ec2937622b852 /wqflask/db/webqtlDatabaseFunction.py
parent0b723720f7b1b9802b2f5453b747c7e48b693817 (diff)
parent1afece5464520700901cbde19599ac45222ea58f (diff)
downloadgenenetwork2-f7eeb913af479358583844164400dc8489a87d8f.tar.gz
Merge branch 'testing' into feature/integrate-correlation-api
Diffstat (limited to 'wqflask/db/webqtlDatabaseFunction.py')
-rw-r--r--wqflask/db/webqtlDatabaseFunction.py13
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