about summary refs log tree commit diff
path: root/wqflask/maintenance/dataset/datastructure.py
diff options
context:
space:
mode:
authorLei Yan2014-02-22 21:57:13 -0600
committerLei Yan2014-02-22 21:57:13 -0600
commit866305ffa728cb6e90f16015b0b881ba6cb0362e (patch)
treeeebaee9ec56b70bca7d089cccc42cf35fb8e59b8 /wqflask/maintenance/dataset/datastructure.py
parent30889320c00673660d194fc03b912d1832e5a6ed (diff)
downloadgenenetwork2-866305ffa728cb6e90f16015b0b881ba6cb0362e.tar.gz
On branch master
Diffstat (limited to 'wqflask/maintenance/dataset/datastructure.py')
-rw-r--r--wqflask/maintenance/dataset/datastructure.py10
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()