aboutsummaryrefslogtreecommitdiff
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