aboutsummaryrefslogtreecommitdiff
path: root/wqflask/maintenance/dataset
diff options
context:
space:
mode:
authorLei Yan2014-02-12 20:42:29 -0600
committerLei Yan2014-02-12 20:42:29 -0600
commit9a516ba5b345e15895626e5b2a62616aa6babbd8 (patch)
treee47dc11c81de206a703f66aa4751a87f84ddd7b4 /wqflask/maintenance/dataset
parentedf9d73e017c74fe5b42ba9ee4941ba0886d25e5 (diff)
downloadgenenetwork2-9a516ba5b345e15895626e5b2a62616aa6babbd8.tar.gz
On branch master
Diffstat (limited to 'wqflask/maintenance/dataset')
-rw-r--r--wqflask/maintenance/dataset/datastructure.py13
1 files changed, 12 insertions, 1 deletions
diff --git a/wqflask/maintenance/dataset/datastructure.py b/wqflask/maintenance/dataset/datastructure.py
index 763fddc1..400c7fda 100644
--- a/wqflask/maintenance/dataset/datastructure.py
+++ b/wqflask/maintenance/dataset/datastructure.py
@@ -32,4 +32,15 @@ def get_strains(inbredsetid):
"""
cursor.execute(sql, (inbredsetid))
return cursor.fetchall()
- \ No newline at end of file
+
+def get_inbredset(probesetfreezeid):
+ cursor = utilities.get_cursor()
+ sql = """
+ SELECT InbredSet.`Id`, InbredSet.`Name`, InbredSet.`FullName`
+ FROM InbredSet, ProbeFreeze, ProbeSetFreeze
+ WHERE InbredSet.`Id`=ProbeFreeze.`InbredSetId`
+ AND ProbeFreeze.`Id`=ProbeSetFreeze.`ProbeFreezeId`
+ AND ProbeSetFreeze.`Id`=%s
+ """
+ cursor.execute(sql, (probesetfreezeid))
+ return cursor.fetchone()