diff options
Diffstat (limited to 'wqflask/maintenance/dataset/datastructure/datastructure.py')
-rw-r--r-- | wqflask/maintenance/dataset/datastructure/datastructure.py | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/wqflask/maintenance/dataset/datastructure/datastructure.py b/wqflask/maintenance/dataset/datastructure/datastructure.py new file mode 100644 index 00000000..ed429cb4 --- /dev/null +++ b/wqflask/maintenance/dataset/datastructure/datastructure.py @@ -0,0 +1,20 @@ +import sys +sys.path.append('.') +sys.path.append('..') + +from utilities import db + +def get_type(inbredsetid): + cursor=db.get_cursor() + sql = """ + SELECT ProbeSetFreeze.`Id`, ProbeSetFreeze.`Name`, ProbeSetFreeze.`FullName` + FROM ProbeSetFreeze, ProbeFreeze + WHERE ProbeSetFreeze.`ProbeFreezeId`=ProbeFreeze.`Id` + AND ProbeFreeze.`InbredSetId`=%s + """ + cursor.execute(sql, (inbredsetid)) + return cursor.fetchall() + + +print get_type() +
\ No newline at end of file |