aboutsummaryrefslogtreecommitdiff
path: root/wqflask/maintenance
diff options
context:
space:
mode:
authorLei Yan2014-02-12 20:14:18 -0600
committerLei Yan2014-02-12 20:14:18 -0600
commitedf9d73e017c74fe5b42ba9ee4941ba0886d25e5 (patch)
tree970be5d9d25fc9cfa2d18815873e5513bbf45f7c /wqflask/maintenance
parent37e4152e6bbf446c165faefa0220cc722c5e3c54 (diff)
downloadgenenetwork2-edf9d73e017c74fe5b42ba9ee4941ba0886d25e5.tar.gz
On branch master
Diffstat (limited to 'wqflask/maintenance')
-rw-r--r--wqflask/maintenance/dataset/datastructure.py12
1 files changed, 12 insertions, 0 deletions
diff --git a/wqflask/maintenance/dataset/datastructure.py b/wqflask/maintenance/dataset/datastructure.py
index f27c1aab..763fddc1 100644
--- a/wqflask/maintenance/dataset/datastructure.py
+++ b/wqflask/maintenance/dataset/datastructure.py
@@ -20,4 +20,16 @@ def get_probesetfreeze(probesetfreezeid):
"""
cursor.execute(sql, (probesetfreezeid))
return cursor.fetchone()
+
+def get_strains(inbredsetid):
+ cursor = utilities.get_cursor()
+ sql = """
+ SELECT Strain.`Id`, Strain.`Name`
+ FROM StrainXRef, Strain
+ WHERE StrainXRef.`InbredSetId`=%s
+ AND StrainXRef.`StrainId`=Strain.`Id`
+ ORDER BY StrainXRef.`OrderId`
+ """
+ cursor.execute(sql, (inbredsetid))
+ return cursor.fetchall()
\ No newline at end of file