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/generate_probesetfreeze_file.py') 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