def findCaseById(self,case_id): """ 根据id找测试用例 """ print("findCaseById") my_db = MysqlDb() sql = "select * from `testcaseapp_case` where id = '{0}'".format(case_id) returns = my_db.query(sql, state="one") return returns
def loadConfigByAppAndKey(self,app_name,dict_key): """ 根据app和key加载配置 """ print("loadConfigByAppAndKey") my_db = MysqlDb() sql = "select * from `testcaseapp_config` where name='{0}' and dict_key='{1}'".format(app_name,dict_key) returns = my_db.query(sql, state="one") return returns
def loadAllClassByApp(self,app_name_id): """ 根据app加载全部用例 """ print("loadAllClassByApp") my_db = MysqlDb() sql = "select * from `testcaseapp_case` where app_name_id = '{0}'".format(app_name_id) results = my_db.query(sql) return results
def updateResultByCaseId(self,response,is_pass,msg,case_id): """ 根据测试用例id,更新响应内容和测试内容 """ print("updateResultByCaseId") my_db = MysqlDb() current_time = datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S') response = my_db.conn.escape_string(str(response)) msg = my_db.conn.escape_string(msg) if is_pass: sql = "update `testcaseapp_case` set response='{0}', pass_or_not='{1}', msg='{2}', update_time='{3}' where id={4}".format("",is_pass,msg,current_time,case_id) else: sql = "update `testcaseapp_case` set response=\"{0}\", pass_or_not='{1}', msg='{2}', update_time='{3}' where id={4}".format(response,is_pass,msg,current_time,case_id) rows = my_db.execute(sql) return rows