def get_detailinfo(key):
key = "../{}/".format(key)
table_name = "trackingtokens"
sql ="select minititle,title,macros_num,traffic_platform,token_name,token_description,conversion_tracking," \
"panel_body,webname from {} where routing='{}'".format(table_name, key)
ret = db_module.execute_getinfo(sql)
return ret
def get_resultlist():
table_name = 'anomaly_detection_result'
sql = "select * from {}".format(table_name)
data = execute_getinfo(sql)
if isinstance(data, list) and data:
data_dict = dict()
data_dict['resultObj'] = data
data_dict['msg'] = '查询成功'
data_dict['success'] = True
json.dumps(data_dict)
return data_dict
def get_configlist(source, status):
table_name = 'anomaly_detection_config'
if source == '' and status == '':
sql = "select * from {}".format(table_name)
else:
sql = "select * from {} where source='{}' and status='{}'".format(
table_name, source, status)
data = execute_getinfo(sql)
if isinstance(data, list) and data:
data_dict = dict()
data_dict['resultObj'] = data
data_dict['msg'] = ''
data_dict['success'] = True
json.dumps(data_dict)
return data_dict
def get_allwebinfo():
table_name = "trackingtokens"
sql = "select webname,webtype,routing from {}".format(table_name)
ret = db_module.execute_getinfo(sql)
return ret
def select_ip(ip_port, table_name):
sql = "select ip_port from {} where ip_port='{}'".format(
table_name, ip_port)
ret = db_module.execute_getinfo(sql)
return ret