blob: 6b15abb3f7fc6007fc751ef0f94784945fb77579 (
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
32
33
34
35
36
37
38
|
# Module for calling the backend
from flask import g
# import MySQLdb
import string
import urllib2
import json
# from base import webqtlConfig
from utility.tools import USE_GN_SERVER, LOG_SQL
from utility.benchmark import Bench
from utility.logger import getLogger
logger = getLogger(__name__ )
from inspect import stack
def fetchone(query):
"""Return tuple containing one row by calling SQL directly
"""
with Bench("SQL",LOG_SQL):
def helper(query):
res = g.db.execute(query)
return res.fetchone()
callername = stack()[1][3]
return logger.sql(callername, query, helper)
def gn_server(path):
"""Return JSON record by calling GN_SERVER
"""
with Bench("GN_SERVER",LOG_SQL):
res = urllib2.urlopen("http://localhost:8880/"+path)
rest = res.read()
res2 = json.loads(rest)
logger.info(res2)
return res2
|
