From 91491d2f9918603f8270026b2b7a14d53d5f9037 Mon Sep 17 00:00:00 2001
From: Lei Yan
Date: Tue, 4 Feb 2014 10:39:01 -0600
Subject: On branch master

---
 wqflask/maintenance/dataset/probesets.py | 49 +++++++++++++++++++++-----------
 1 file changed, 32 insertions(+), 17 deletions(-)

diff --git a/wqflask/maintenance/dataset/probesets.py b/wqflask/maintenance/dataset/probesets.py
index 7fa65786..fbe54108 100644
--- a/wqflask/maintenance/dataset/probesets.py
+++ b/wqflask/maintenance/dataset/probesets.py
@@ -1,11 +1,9 @@
 import sys
-sys.path.append('.')
-sys.path.append('..')
 
-from utilities import db
+import utilities
 
-def fetch_probesetxref(probesetfreezeid):
-    cursor = db.get_cursor()
+def get_probesetxref(probesetfreezeid):
+    cursor = utilities.get_cursor()
     sql = """
         SELECT ProbeSetXRef.`ProbeSetId`, ProbeSetXRef.`DataId`
         FROM ProbeSetXRef
@@ -14,8 +12,8 @@ def fetch_probesetxref(probesetfreezeid):
     cursor.execute(sql, (probesetfreezeid))
     return cursor.fetchall()
     
-def fetch_probeset(probesetid):
-    cursor = db.get_cursor()
+def get_probeset(probesetid):
+    cursor = utilities.get_cursor()
     sql = """
         SELECT *
         FROM ProbeSet
@@ -24,8 +22,8 @@ def fetch_probeset(probesetid):
     cursor.execute(sql, (probesetid))
     return cursor.fetchone()
     
-def fetch_probesetdata(probesetdataid):
-    cursor = db.get_cursor()
+def get_probesetdata(probesetdataid):
+    cursor = utilities.get_cursor()
     sql = """
         SELECT Strain.`Id`, Strain.`Name`, ProbeSetData.`value`
         FROM ProbeSetData, Strain
@@ -35,11 +33,28 @@ def fetch_probesetdata(probesetdataid):
     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
+def get_probesetxref_probesetfreezeid(locus, probesetfreezeid):
+    cursor = utilities.get_cursor()
+    sql = """
+        SELECT ProbeSetXRef.`ProbeSetId`
+        FROM ProbeSetXRef
+        WHERE ProbeSetXRef.`ProbeSetFreezeId`=%s
+        AND ProbeSetXRef.`Locus` LIKE %s
+        """
+    cursor.execute(sql, (probesetfreezeid, locus))
+    return cursor.fetchall()
+    
+def get_probesetxref_inbredsetid(locus, inbredsetid):
+    cursor = utilities.get_cursor()
+    sql = """
+        SELECT ProbeSetXRef.`ProbeSetId`
+        FROM (ProbeSetXRef, ProbeSetFreeze, ProbeFreeze)
+        WHERE ProbeSetXRef.`ProbeSetFreezeId`=ProbeSetFreeze.`Id`
+        AND ProbeSetFreeze.`ProbeFreezeId`=ProbeFreeze.`Id`
+        AND ProbeFreeze.`InbredSetId`=%s
+        AND ProbeSetXRef.`Locus` LIKE %s
+        """
+    cursor.execute(sql, (inbredsetid, locus))
+    return cursor.fetchall()
+
+print get_probesetxref_inbredsetid(locus="rs3663871", inbredsetid=1)
\ No newline at end of file
-- 
cgit v1.2.3