about summary refs log tree commit diff
path: root/wqflask/maintenance/dataset/datastructure.py
diff options
context:
space:
mode:
authorLei Yan2014-02-04 12:14:14 -0600
committerLei Yan2014-02-04 12:14:14 -0600
commit839115abbdf1b7e90da1d4db7758a2f7f8f83037 (patch)
tree345cf6dc1f1e6545421e9111305826b3c5925a15 /wqflask/maintenance/dataset/datastructure.py
parentad07fc167c4f35490fd59e687aac1f4291defcc2 (diff)
downloadgenenetwork2-839115abbdf1b7e90da1d4db7758a2f7f8f83037.tar.gz
On branch master
Diffstat (limited to 'wqflask/maintenance/dataset/datastructure.py')
-rw-r--r--wqflask/maintenance/dataset/datastructure.py18
1 files changed, 12 insertions, 6 deletions
diff --git a/wqflask/maintenance/dataset/datastructure.py b/wqflask/maintenance/dataset/datastructure.py
index 73e1c0d8..f94009f5 100644
--- a/wqflask/maintenance/dataset/datastructure.py
+++ b/wqflask/maintenance/dataset/datastructure.py
@@ -1,11 +1,7 @@
-import sys
-sys.path.append('.')
-sys.path.append('..')
-
-from utilities import db
+import utilities
 
 def get_probesetfreeze(inbredsetid):
-    cursor = db.get_cursor()
+    cursor = utilities.get_cursor()
     sql = """
         SELECT ProbeSetFreeze.`Id`, ProbeSetFreeze.`Name`, ProbeSetFreeze.`FullName`
         FROM ProbeSetFreeze, ProbeFreeze
@@ -14,4 +10,14 @@ def get_probesetfreeze(inbredsetid):
         """
     cursor.execute(sql, (inbredsetid))
     return cursor.fetchall()
+
+def get_probesetfreeze(probesetfreezeid):
+    cursor = utilities.get_cursor()
+    sql = """
+        SELECT ProbeSetFreeze.`Id`, ProbeSetFreeze.`Name`, ProbeSetFreeze.`FullName`
+        FROM ProbeSetFreeze
+        WHERE ProbeSetFreeze.`Id`=%s
+        """
+    cursor.execute(sql, (probesetfreezeid))
+    return cursor.fetchone()
     
\ No newline at end of file