From 9a516ba5b345e15895626e5b2a62616aa6babbd8 Mon Sep 17 00:00:00 2001
From: Lei Yan
Date: Wed, 12 Feb 2014 20:42:29 -0600
Subject: On branch master

---
 wqflask/maintenance/dataset/datastructure.py | 13 ++++++++++++-
 1 file changed, 12 insertions(+), 1 deletion(-)

(limited to 'wqflask/maintenance')

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()
-- 
cgit v1.2.3