aboutsummaryrefslogtreecommitdiff
path: root/wqflask/base/generate_probesetfreeze_file.py
blob: a0ff804bf63ec8f460bffa85fb3c5ed4f487c5ac (about) (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
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()