diff options
author | Lei Yan | 2014-02-22 21:57:13 -0600 |
---|---|---|
committer | Lei Yan | 2014-02-22 21:57:13 -0600 |
commit | 866305ffa728cb6e90f16015b0b881ba6cb0362e (patch) | |
tree | eebaee9ec56b70bca7d089cccc42cf35fb8e59b8 /wqflask/maintenance/dataset/datastructure.py | |
parent | 30889320c00673660d194fc03b912d1832e5a6ed (diff) | |
download | genenetwork2-866305ffa728cb6e90f16015b0b881ba6cb0362e.tar.gz |
On branch master
Diffstat (limited to 'wqflask/maintenance/dataset/datastructure.py')
-rw-r--r-- | wqflask/maintenance/dataset/datastructure.py | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/wqflask/maintenance/dataset/datastructure.py b/wqflask/maintenance/dataset/datastructure.py index fd9386b3..0ee4b4ab 100644 --- a/wqflask/maintenance/dataset/datastructure.py +++ b/wqflask/maintenance/dataset/datastructure.py @@ -55,6 +55,16 @@ def get_species(inbredsetid): """ cursor.execute(sql, (inbredsetid)) return cursor.fetchone() + +def get_genofreeze_byinbredsetid(inbredsetid): + cursor, con = utilities.get_cursor() + sql = """ + SELECT GenoFreeze.`Id`, GenoFreeze.`Name`, GenoFreeze.`FullName`, GenoFreeze.`InbredSetId` + FROM GenoFreeze + WHERE GenoFreeze.`InbredSetId`=%s + """ + cursor.execute(sql, (inbredsetid)) + return cursor.fetchone() def get_nextdataid_phenotype(): cursor, con = utilities.get_cursor() |