diff options
| author | Lei Yan | 2014-02-12 20:14:18 -0600 |
|---|---|---|
| committer | Lei Yan | 2014-02-12 20:14:18 -0600 |
| commit | edf9d73e017c74fe5b42ba9ee4941ba0886d25e5 (patch) | |
| tree | 970be5d9d25fc9cfa2d18815873e5513bbf45f7c /wqflask/maintenance | |
| parent | 37e4152e6bbf446c165faefa0220cc722c5e3c54 (diff) | |
| download | genenetwork2-edf9d73e017c74fe5b42ba9ee4941ba0886d25e5.tar.gz | |
On branch master
Diffstat (limited to 'wqflask/maintenance')
| -rw-r--r-- | wqflask/maintenance/dataset/datastructure.py | 12 |
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 |