diff options
| author | Lei Yan | 2014-02-12 20:42:29 -0600 |
|---|---|---|
| committer | Lei Yan | 2014-02-12 20:42:29 -0600 |
| commit | 9a516ba5b345e15895626e5b2a62616aa6babbd8 (patch) | |
| tree | e47dc11c81de206a703f66aa4751a87f84ddd7b4 | |
| parent | edf9d73e017c74fe5b42ba9ee4941ba0886d25e5 (diff) | |
| download | genenetwork2-9a516ba5b345e15895626e5b2a62616aa6babbd8.tar.gz | |
On branch master
| -rw-r--r-- | wqflask/maintenance/dataset/datastructure.py | 13 |
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() |