From d6543befcdaf4786f42c10c1cdd0cb473a8d8453 Mon Sep 17 00:00:00 2001
From: Lei Yan
Date: Fri, 31 Jan 2014 16:12:36 -0600
Subject: On branch master

---
 .../maintenance/dataset/datastructure/__init__.py    |  0
 .../dataset/datastructure/datastructure.py           | 20 ++++++++++++++++++++
 2 files changed, 20 insertions(+)
 create mode 100644 wqflask/maintenance/dataset/datastructure/__init__.py
 create mode 100644 wqflask/maintenance/dataset/datastructure/datastructure.py

(limited to 'wqflask/maintenance/dataset/datastructure')

diff --git a/wqflask/maintenance/dataset/datastructure/__init__.py b/wqflask/maintenance/dataset/datastructure/__init__.py
new file mode 100644
index 00000000..e69de29b
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
-- 
cgit 1.4.1