aboutsummaryrefslogtreecommitdiff
path: root/wqflask/maintenance/dataset/probesets
diff options
context:
space:
mode:
Diffstat (limited to 'wqflask/maintenance/dataset/probesets')
-rw-r--r--wqflask/maintenance/dataset/probesets/__init__.py0
-rw-r--r--wqflask/maintenance/dataset/probesets/probesets.py45
2 files changed, 0 insertions, 45 deletions
diff --git a/wqflask/maintenance/dataset/probesets/__init__.py b/wqflask/maintenance/dataset/probesets/__init__.py
deleted file mode 100644
index e69de29b..00000000
--- a/wqflask/maintenance/dataset/probesets/__init__.py
+++ /dev/null
diff --git a/wqflask/maintenance/dataset/probesets/probesets.py b/wqflask/maintenance/dataset/probesets/probesets.py
deleted file mode 100644
index 7fa65786..00000000
--- a/wqflask/maintenance/dataset/probesets/probesets.py
+++ /dev/null
@@ -1,45 +0,0 @@
-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