From b316d0a842ca83049aeb8e374db70831bcb4a928 Mon Sep 17 00:00:00 2001
From: Zachary Sloan
Date: Tue, 12 Mar 2013 18:35:47 -0500
Subject: Added the script generating probesetfreeze data matrix files

The script was created to regenerate a bad file for Evan
---
 wqflask/base/generate_probesetfreeze_file.py | 31 ++++++++++++++++++++++++++++
 1 file changed, 31 insertions(+)
 create mode 100644 wqflask/base/generate_probesetfreeze_file.py

(limited to 'wqflask/base')

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
-- 
cgit v1.2.3