def getLog(initiator): sql = "select log_data, ajax_payload from t_log where initiator_url = '%s' order by id desc limit 10" % ( initiator) data = Db.fetch_all(sql) res = [] for item in data: res.append({ "log_data": json_decode(item['log_data']), "ajax_payload": json_decode(item['ajax_payload']) }) return res
def getStageList(initiatorUrl, ajaxUrl): ''' 返回该地址栏下 某个ajax请求相关的步骤列表 :param initiatorUrl: 地址栏 :param ajaxUrl: ajax请求的url :return: ''' req = getOne(initiatorUrl, ajaxUrl) if req: sql = " select ar.host, ar.url_format, ar.ajax_url, asr.cmd_format, asr.ajax_id, asr.stage_id, st.connect_str, st.stage_name, st.stage_type" \ " from t_ajax_request ar join t_ajax_stage_relation asr on ar.id = asr.ajax_id " \ " join t_stage st on asr.stage_id = st.id " \ " where ar.id = %d" %(req['id']) return Db.fetch_all(sql) return None
def getOne(initiatorUrl, ajaxUrl): ''' 通过地址栏和ajax请求的url,返回已有的请求信息 :param initiatorUrl: :param ajaxUrl: :return: ''' sql = "select id, url_format, ajax_url from t_ajax_request where ajax_url = '%s'" % ( ajaxUrl) urlFormatList = Db.fetch_all(sql) for item in urlFormatList: urlFormat = item['url_format'] reObj = re.compile(urlFormat) if initiatorUrl == urlFormat or (reObj.match(initiatorUrl) is not None): return item return None
def userList(): sql = "select * from t_user order by id desc" return Db.fetch_all(sql)
def stageList(): sql = "select * from t_stage order by id desc" return Db.fetch_all(sql)
def getList(keyword=""): sql = "select min(id) as id, url_format, min(ajax_url) as ajax_url ,min(host) as host, min(create_time) as create_time from t_ajax_request group by url_format" res = Db.fetch_all(sql) return res """