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()
|