aboutsummaryrefslogtreecommitdiff
path: root/wqflask/base
diff options
context:
space:
mode:
authorZachary Sloan2013-03-13 21:02:56 +0000
committerZachary Sloan2013-03-13 21:02:56 +0000
commit64d164010ec1e1345920d7dbf8460e9f244693aa (patch)
treea70a77f8d6d05f568d98f52c210f82e495c3aea4 /wqflask/base
parentf1ae6713b88dff2758470b741637bbc5d717c38b (diff)
parentb316d0a842ca83049aeb8e374db70831bcb4a928 (diff)
downloadgenenetwork2-64d164010ec1e1345920d7dbf8460e9f244693aa.tar.gz
Merge branch 'flask' of http://github.com/zsloan/genenetwork into flask
Diffstat (limited to 'wqflask/base')
-rw-r--r--wqflask/base/generate_probesetfreeze_file.py31
1 files changed, 31 insertions, 0 deletions
diff --git a/wqflask/base/generate_probesetfreeze_file.py b/wqflask/base/generate_probesetfreeze_file.py
new file mode 100644
index 00000000..a0ff804b
--- /dev/null
+++ b/wqflask/base/generate_probesetfreeze_file.py
@@ -0,0 +1,31 @@
+from __future__ import absolute_import, print_function, division
+import os
+import math
+
+import json
+import itertools
+
+from flask import Flask, g
+
+from base import webqtlConfig
+from dbFunction import webqtlDatabaseFunction
+from utility import webqtlUtil
+
+from MySQLdb import escape_string as escape
+from pprint import pformat as pf
+
+
+query = """ select ProbeSet.Name
+ from ProbeSetXRef,
+ ProbeSetFreeze,
+ ProbeSet
+ where ProbeSetXRef.ProbeSetFreezeId = ProbeSetFreeze.Id and
+ ProbeSetFreeze.Name = "EPFLMouseMuscleCDRMA1211" and
+ ProbeSetXRef.ProbeSetId = ProbeSet.Id;
+ """
+
+markers = g.db.execute(query).fetchall()
+print("markers: ", pf(markers))
+
+if __name__ == '__main__':
+ main() \ No newline at end of file