From b462fae9df948dbf35232a764d61fbf10c930e82 Mon Sep 17 00:00:00 2001
From: Lei Yan
Date: Mon, 3 Feb 2014 12:28:08 -0600
Subject: On branch master

---
 wqflask/maintenance/dataset/probesets.py | 45 ++++++++++++++++++++++++++++++++
 1 file changed, 45 insertions(+)
 create mode 100644 wqflask/maintenance/dataset/probesets.py

(limited to 'wqflask/maintenance/dataset/probesets.py')

diff --git a/wqflask/maintenance/dataset/probesets.py b/wqflask/maintenance/dataset/probesets.py
new file mode 100644
index 00000000..7fa65786
--- /dev/null
+++ b/wqflask/maintenance/dataset/probesets.py
@@ -0,0 +1,45 @@
+import sys
+sys.path.append('.')
+sys.path.append('..')
+
+from utilities import db
+
+def fetch_probesetxref(probesetfreezeid):
+    cursor = db.get_cursor()
+    sql = """
+        SELECT ProbeSetXRef.`ProbeSetId`, ProbeSetXRef.`DataId`
+        FROM ProbeSetXRef
+        WHERE ProbeSetXRef.`ProbeSetFreezeId`=%s
+        """
+    cursor.execute(sql, (probesetfreezeid))
+    return cursor.fetchall()
+    
+def fetch_probeset(probesetid):
+    cursor = db.get_cursor()
+    sql = """
+        SELECT *
+        FROM ProbeSet
+        WHERE ProbeSet.`Id`=%s
+        """
+    cursor.execute(sql, (probesetid))
+    return cursor.fetchone()
+    
+def fetch_probesetdata(probesetdataid):
+    cursor = db.get_cursor()
+    sql = """
+        SELECT Strain.`Id`, Strain.`Name`, ProbeSetData.`value`
+        FROM ProbeSetData, Strain
+        WHERE ProbeSetData.`Id`=%s
+        AND ProbeSetData.`StrainId`=Strain.`Id`;
+        """
+    cursor.execute(sql, (probesetdataid))
+    return cursor.fetchall()
+
+results = fetch_probesetxref(112)
+for row in results:
+    print row
+    probesetid = row[0]
+    probesetdataid = row[1]
+    print fetch_probeset(probesetid)
+    print fetch_probesetdata(probesetdataid)
+    break
\ No newline at end of file
-- 
cgit v1.2.3