From edf9d73e017c74fe5b42ba9ee4941ba0886d25e5 Mon Sep 17 00:00:00 2001
From: Lei Yan
Date: Wed, 12 Feb 2014 20:14:18 -0600
Subject: On branch master

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

(limited to 'wqflask/maintenance/dataset')

diff --git a/wqflask/maintenance/dataset/datastructure.py b/wqflask/maintenance/dataset/datastructure.py
index f27c1aab..763fddc1 100644
--- a/wqflask/maintenance/dataset/datastructure.py
+++ b/wqflask/maintenance/dataset/datastructure.py
@@ -20,4 +20,16 @@ def get_probesetfreeze(probesetfreezeid):
         """
     cursor.execute(sql, (probesetfreezeid))
     return cursor.fetchone()
+    
+def get_strains(inbredsetid):
+    cursor = utilities.get_cursor()
+    sql = """
+        SELECT Strain.`Id`, Strain.`Name`
+        FROM StrainXRef, Strain
+        WHERE StrainXRef.`InbredSetId`=%s
+        AND StrainXRef.`StrainId`=Strain.`Id`
+        ORDER BY StrainXRef.`OrderId`
+        """
+    cursor.execute(sql, (inbredsetid))
+    return cursor.fetchall()
     
\ No newline at end of file
-- 
cgit v1.2.3