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
