def insert_ifNameFromTestResult(self): """ 如果api_pass_rate表中没有该条if_name则将if_name插入该表中 :param data: :param table: :return: """ sql = "INSERT INTO api_pass_rate_wph (if_name) SELECT DISTINCT `if_name` FROM test_result WHERE if_name NOT IN(SELECT if_name FROM api_pass_rate_wph);" sql1 = "INSERT INTO api_pass_rate (if_name) SELECT DISTINCT `if_name` FROM test_result WHERE if_name NOT IN(SELECT if_name FROM api_pass_rate);" return Base.query(self, sql), Base.query(self, sql1)
def get_performanceOrderByIfname(self, type, orderby='if_name', method='esc'): """ 查询表 最近300条最终按照if_name 排序输出 :return: """ sql = "select * from (select * from api_performance order by id desc limit 300) a where type = '" + type + "' order by " + orderby + " " + method + ";" test_result = Base.query(self, sql) return test_result
def update_fail_num(self, if_name): """ 更新Fail_num字段 :param if_name: :return: """ type = Base.getApiType(self, if_name) sql = "UPDATE api_pass_rate_wph SET url_target='" + url_target + "',`type`='" + type + "',fail_num=fail_num+1 WHERE if_name = '" + if_name + "';" return Base.query(self, sql)
def update_pass_num(self, if_name): type = Base.getApiType(self, if_name) sql = "UPDATE api_pass_rate_wph SET url_target='" + url_target + "',`type`='" + type + "',pass_num=pass_num+1 WHERE if_name = '" + if_name + "';" return Base.query(self, sql)