aboutsummaryrefslogtreecommitdiff
path: root/wqflask/maintenance/dataset/datastructure
diff options
context:
space:
mode:
authorLei Yan2014-01-31 16:12:36 -0600
committerLei Yan2014-01-31 16:12:36 -0600
commitd6543befcdaf4786f42c10c1cdd0cb473a8d8453 (patch)
tree41170e9f8a2bc81734760493500474fb33e71156 /wqflask/maintenance/dataset/datastructure
parent4a3c48c4b91c0cce9d7d0e9896be893d6e80a883 (diff)
downloadgenenetwork2-d6543befcdaf4786f42c10c1cdd0cb473a8d8453.tar.gz
On branch master
Diffstat (limited to 'wqflask/maintenance/dataset/datastructure')
-rw-r--r--wqflask/maintenance/dataset/datastructure/__init__.py0
-rw-r--r--wqflask/maintenance/dataset/datastructure/datastructure.py20
2 files changed, 20 insertions, 0 deletions
diff --git a/wqflask/maintenance/dataset/datastructure/__init__.py b/wqflask/maintenance/dataset/datastructure/__init__.py
new file mode 100644
index 00000000..e69de29b
--- /dev/null
+++ b/wqflask/maintenance/dataset/datastructure/__init__.py
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