def run_testproject(self, http):
logger.info('正在获取测试项目[id：%s, name：%s]对应对应的测试计划名称列表' %
(self.project_id, self.name))
testplans_name_list = []
testplans = mytestlink.getProjectTestPlans(self.project_id)
for testplan in testplans:
testplans_name_list.append(testplan['name'])
logger.info('成功获取项目测试计划名称列表[list=%s]' % testplans_name_list)
for testplan in testplans_name_list:
testplan_info = mytestlink.getTestPlanByName(self.name, testplan)
testplan_name = testplan_info[0]['name']
testplan_id = int(testplan_info[0]['id'])
active_status = int(testplan_info[0]['active'])
notes = other_tools.conver_date_from_testlink(
testplan_info[0]['notes'])
testplan_obj = TestPlan(testplan_name, testplan_id, active_status,
notes, self.name)
logger.info('正在执行项目测试计划[project：%s，testplan：%s]' %
(self.name, testplan))
testplan_obj.run_testplan(http)
def run_testcase(self, http, testplan):
if 0 == self.active_status:
logger.warning('用例[name=%s]处于禁用状态[active=0]，不执行' %
self.testcase_name)
return ('Block', '用例处于禁用状态，不执行')
protocol_all = http.get_protocol()
host_all = http.get_host()
port_all = http.get_port()
for step in self.steps:
# 构造测试步骤对象
step_id = int(step['id'])
step_number = int(step['step_number'])
step_action = other_tools.conver_date_from_testlink(
step['actions'])
logger.info('转换来自test_link 的step_action值为：%s' % step_action)
expected_results = other_tools.conver_date_from_testlink(
step['expected_results'])
logger.info('转换来自test_link 的expected_results值为：%s' %
expected_results)
logger.debug('step_action： %s' % step_action)
sql_insert = 'INSERT INTO '+ case_step_report_tb +'(executed_history_id, testcase_id, testcase_name, testplan, project, step_id, step_num, protocol_method, protocol, host, port, ' \
'step_action, expected_results, runresult, reason, runtime)' \
' VALUES(%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)'
if step_action.find('步骤类型') != -1 and step_action.find(
'执行用例') != -1: # 待执行步骤为用例
data = (executed_history_id, self.testcase_id,
self.testcase_name, testplan, self.testproject,
step_id, step_number, '无', '无', '无', '无', step_action,
expected_results, 'Block', '', '0000-00-00 00:00:00')
logger.info('记录测试步骤到测试步骤报告表')
testdb.execute_insert(sql_insert, data)
elif step_action.find('步骤类型') != -1 and (
step_action.find('执行sql') != -1
or step_action.find('执行SQL') != -1): #: # 待执行步骤为sql
data = (executed_history_id, self.testcase_id,
self.testcase_name, testplan, self.testproject,
step_id, step_number, '', '', testdb.get_host(),
testdb.get_port(), step_action, expected_results,
'Block', '', '0000-00-00 00:00:00')
logger.info('记录测试步骤到测试步骤报告表')
testdb.execute_insert(sql_insert, data)
elif step_action.find('步骤类型') == -1: # 待执行步骤为普通用例步骤
data = (executed_history_id, self.testcase_id,
self.testcase_name, testplan, self.testproject,
step_id, step_number, '', protocol_all, host_all,
port_all, step_action, expected_results, 'Block', '',
'0000-00-00 00:00:00')
logger.info('记录测试步骤到测试步骤报告表')
testdb.execute_insert(sql_insert, data)
run_time = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime()) # 记录运行时间
try:
step_action = json.loads(step_action,
object_pairs_hook=OrderedDict)
if '步骤类型' not in step_action:
protocol_method = step_action['方法']
else:
protocol_method = '无'
if expected_results != '':
expected_results = json.loads(expected_results)
step_obj = CaseStep(step_id, step_number, expected_results,
step_action, self.testcase_id)
except Exception as e:
logger.error(
'步骤[%s]信息填写错误: %s,停止执行用例[id=%s, name=%s]' %
(step_number, e, self.testcase_id, self.testcase_name))
sql_update = 'UPDATE '+ case_step_report_tb +' SET runresult=\"%s\",reason=\"%s\", protocol_method=\"%s\", runtime=\"%s\"' \
' WHERE executed_history_id = %s AND testcase_id = %s AND step_id = %s' \
' AND project=\'%s\' AND testplan=\'%s\''
data = ('Block', '%s' % e, protocol_method, run_time,
str(executed_history_id), self.testcase_id, step_id,
self.testproject, testplan)
logger.info('正在更新步骤执行结果')
testdb.execute_update(sql_update, data)
return ('Error', [
('TestCase', '步骤[%s]信息填写错误: %s,停止执行用例[id=%s, name=%s]' %
(step_number, e, self.testcase_id, self.testcase_name))
])
logger.info('开始执行步骤操作[第%s步]' % step_number)
run_time = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime()) # 记录运行时间
if '步骤类型' in step_action:
if step_action['步骤类型'] == '执行用例':
step_run_result = globalpkg.global_function.run_testcase_by_id(
step_action['用例id'], testplan)
else:
step_run_result = step_obj.run_step() # 运行sql,或者是普通用例步骤
else:
step_run_result = step_obj.run_step(http) # 运行普通用例步骤
try: # 转换 “ 为 ‘ ，防止数据库存储出错
action_of_step = step_obj.get_action()
if type(action_of_step) == type(b''):
action_of_step = action_of_step.decode('utf-8')
elif type(action_of_step) == type({}):
action_of_step = str(action_of_step)
action_of_step = json.dumps(action_of_step)
action_of_step = action_of_step.replace('"', "'")
result_of_step = step_obj.get_expected_result()
if type(result_of_step) == type(b''):
result_of_step = result_of_step.decode('utf-8')
elif type(result_of_step) == type({}):
result_of_step = str(result_of_step)
result_of_step = result_of_step.replace('"', "'")
# except Exception as e:
# logger.error('获取step action、expected_result出错 %s' % e)
# action_of_step = ''
# result_of_step = ''
finally:
if step_run_result[0] == 'Error':
fail_or_error_reason = step_run_result[1][0][1]
fail_or_error_reason = fail_or_error_reason.replace(
'\n', '')
fail_or_error_reason = fail_or_error_reason.replace(
'\"', '')
fail_or_error_reason = fail_or_error_reason.replace(
'\'', '')
logger.error(
'步骤[%s]执行出错,停止执行用例[id=%s, name=%s]' %
(step_number, self.testcase_id, self.testcase_name))
sql_update = 'UPDATE '+ case_step_report_tb +' SET runresult=\"%s\",reason=\"%s\", protocol_method=\"%s\", runtime=\"%s\",' \
'step_action=\"%s\", expected_results=\"%s\"' \
' WHERE executed_history_id = %s AND testcase_id = %s AND step_id = %s' \
' AND project=\'%s\' AND testplan=\'%s\''
data = (step_run_result[0], fail_or_error_reason,
protocol_method, run_time,
action_of_step, result_of_step,
str(executed_history_id), self.testcase_id,
step_id, self.testproject, testplan)
logger.info('正在更新步骤执行结果')
testdb.execute_update(sql_update, data)
return step_run_result
elif step_run_result[0] == 'Fail':
fail_or_error_reason = step_run_result[1][0][1]
fail_or_error_reason = fail_or_error_reason.replace(
'\n', '')
fail_or_error_reason = fail_or_error_reason.replace(
'\"', '')
fail_or_error_reason = fail_or_error_reason.replace(
'\'', '')
logger.info(
'步骤[%s]执行失败,停止执行用例[id=%s, name=%s]' %
(step_number, self.testcase_id, self.testcase_name))
sql_update = 'UPDATE '+ case_step_report_tb +' SET runresult=\"%s\",reason=\"%s\", protocol_method=\"%s\", runtime=\"%s\",' \
'step_action=\"%s\", expected_results=\"%s\"' \
' WHERE executed_history_id = %s AND testcase_id = %s AND step_id = %s' \
' AND project=\'%s\' AND testplan=\'%s\''
data = (step_run_result[0], fail_or_error_reason,
protocol_method, run_time,
action_of_step, result_of_step,
str(executed_history_id), self.testcase_id,
step_id, self.testproject, testplan)
logger.info('正在更新步骤执行结果')
testdb.execute_update(sql_update, data)
return step_run_result
elif step_run_result[0] == 'Block':
fail_or_error_reason = step_run_result[1]
logger.info(
'步骤[%s]执行失败,停止执行用例[id=%s, name=%s]' %
(step_number, self.testcase_id, self.testcase_name))
sql_update = 'UPDATE '+ case_step_report_tb +' SET runresult=\"%s\",reason=\"%s\", protocol_method=\"%s\", runtime=\"%s\"' \
' WHERE executed_history_id = %s AND testcase_id = %s AND step_id = %s' \
' AND project=\'%s\' AND testplan=\'%s\''
data = (step_run_result[0],
fail_or_error_reason, '无', run_time,
str(executed_history_id), self.testcase_id,
step_id, self.testproject, testplan)
logger.info('正在更新步骤执行结果')
testdb.execute_update(sql_update, data)
return step_run_result
else:
fail_or_error_reason = ''
sql_update = 'UPDATE '+ case_step_report_tb +' SET runresult=\"%s\",reason=\"%s\", protocol_method=\"%s\", runtime=\"%s\",' \
'step_action=\"%s\", expected_results=\"%s\"'\
' WHERE executed_history_id = %s AND testcase_id = %s AND step_id = %s'\
' AND project=\'%s\' AND testplan=\'%s\''
data = (step_run_result[0], fail_or_error_reason,
protocol_method, run_time,
action_of_step, result_of_step,
str(executed_history_id), self.testcase_id,
step_id, self.testproject, testplan)
logger.info('正在更新步骤执行结果')
testdb.execute_update(sql_update, data)
logger.info('测试用例[id=%s, name=%s]执行成功' %
(self.testcase_id, self.testcase_name))
return ('Pass', '')
def run_testcase(self, http, testplan, case_executed_history_id):
if 0 == self.active_status:
logger.warning('用例[name=%s]处于禁用状态[active=0]，不执行' %
self.testcase_name)
return ('Block', '用例处于禁用状态，不执行')
if self.preconditions.find('使用上级配置') != -1:
logger.info('用例[name=%s]使用上级套件的ip配置' % self.testcase_name)
logger.info('正在读取用例[name=%s]所在套件的协议，host，端口配置...' %
self.testcase_name)
testsuite_info = mytestlink.getTestSuiteByID(
self.testsuite_id) # 获取套件基本信息
testsuite_conf = other_tools.conver_date_from_testlink(
testsuite_info['details'])
testsuite_name = testsuite_info['name']
testsuite_id = testsuite_info['id']
testsuite_id_name = str(testsuite_id) + testsuite_name
if testsuite_id_name in TestCase.testsuite_config.keys(): # 已存在配置
logger.info('检测到系统已保存用例[name=%s]所在套件[name=%s]配置，使用现有配置' %
(testsuite_name, self.testcase_name))
http = TestCase.testsuite_config[testsuite_id_name]
protocol = http.get_protocol()
host = http.get_host()
port = http.get_port()
else:
try:
details = json.loads(testsuite_conf)
protocol = details['protocol']
host = details['host']
port = details['port']
# 构造http对象
http = MyHttp(protocol, host, port)
TestCase.testsuite_config[testsuite_id_name] = http
except Exception as e:
logger.error(
'用例[name=%s]所在套件[name=%s]的协议，host，端口配置错误,未执行：%s' %
(testsuite_name, self.testcase_name, e))
return ('Block', [
('TestCase',
'用例[name=%s]所在套件[name=%s]的协议，host，端口配置错误,未执行：%s' %
(testsuite_name, self.testcase_name, e))
])
else: # 使用统一的项目配置
protocol = http.get_protocol()
host = http.get_host()
port = http.get_port()
for step in self.steps:
# 构造测试步骤对象
step_id = int(step['id'])
step_number = int(step['step_number'])
step_action = other_tools.conver_date_from_testlink(
step['actions'])
logger.info('转换来自test_link 的step_action值为：%s' % step_action)
expected_results = other_tools.conver_date_from_testlink(
step['expected_results'])
logger.info('转换来自test_link 的expected_results值为：%s' %
expected_results)
logger.debug('step_action： %s' % step_action)
sql_insert = 'INSERT INTO '+ case_step_report_tb +'(executed_history_id, testcase_id, testcase_name, testplan, project, step_id, step_num, protocol_method, protocol, host, port, ' \
'step_action, expected_results, runresult, reason, runtime)' \
' VALUES(%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)'
if step_action.find('步骤类型') != -1 and step_action.find(
'执行用例') != -1: # 待执行步骤为用例
data = (case_executed_history_id, self.testcase_id,
self.testcase_name, testplan, self.testproject,
step_id, step_number, '无', '无', '无', '无', step_action,
expected_results, 'Block', '', '0000-00-00 00:00:00')
logger.info('记录测试步骤到测试步骤报告表')
testdb.execute_insert(sql_insert, data)
elif step_action.find('步骤类型') != -1 and (
step_action.find('执行sql') != -1
or step_action.find('执行SQL') != -1): #: # 待执行步骤为sql
data = (case_executed_history_id, self.testcase_id,
self.testcase_name, testplan, self.testproject,
step_id, step_number, '', '', testdb.get_host(),
testdb.get_port(), step_action, expected_results,
'Block', '', '0000-00-00 00:00:00')
logger.info('记录测试步骤到测试步骤报告表')
testdb.execute_insert(sql_insert, data)
elif step_action.find('步骤类型') == -1: # 待执行步骤为普通用例步骤
data = (case_executed_history_id, self.testcase_id,
self.testcase_name, testplan, self.testproject,
step_id, step_number, '', protocol, host, port,
step_action, expected_results, 'Block', '',
'0000-00-00 00:00:00')
logger.info('记录测试步骤到测试步骤报告表')
testdb.execute_insert(sql_insert, data)
run_time = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime()) # 记录运行时间
try:
ifgot_protocol_method = 0
step_action = json.loads(step_action,
object_pairs_hook=OrderedDict)
if '步骤类型' not in step_action:
protocol_method = step_action['方法']
else:
protocol_method = '无'
ifgot_protocol_method = 1
if expected_results != '':
expected_results = json.loads(expected_results)
step_obj = CaseStep(step_id, step_number, expected_results,
step_action, self.testcase_id)
except Exception as e:
logger.error(
'步骤[%s]信息填写错误: %s,停止执行用例[id=%s, name=%s]' %
(step_number, e, self.testcase_id, self.testcase_name))
sql_update = 'UPDATE '+ case_step_report_tb +' SET runresult=\"%s\",reason=\"%s\", protocol_method=\"%s\", runtime=\"%s\"' \
' WHERE executed_history_id = %s AND testcase_id = %s AND step_id = %s' \
' AND project=\'%s\' AND testplan=\'%s\''
if ifgot_protocol_method == 0:
protocol_method = '未获取到'
data = ('Block', '%s' % e, protocol_method, run_time,
str(case_executed_history_id), self.testcase_id,
step_id, self.testproject, testplan)
logger.info('正在更新步骤执行结果')
testdb.execute_update(sql_update, data)
return ('Error', [
('TestCase', '步骤[%s]信息填写错误: %s,停止执行用例[id=%s, name=%s]' %
(step_number, e, self.testcase_id, self.testcase_name))
])
logger.info('开始执行步骤操作[第%s步]' % step_number)
run_time = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime()) # 记录运行时间
if '步骤类型' in step_action:
if step_action['步骤类型'] == '执行用例':
step_run_result = globalpkg.global_function.run_testcase_by_id(
step_action['用例id'], None, testplan)
else:
step_run_result = step_obj.run_step() # 运行sql,或者是普通用例步骤
else:
step_run_result = step_obj.run_step(http) # 运行普通用例步骤
try: # 转换 “ 为 ‘ ，防止数据库存储出错
action_of_step = step_obj.get_action()
if type(action_of_step) == type(b''):
action_of_step = action_of_step.decode('utf-8')
elif type(action_of_step) == type({}):
action_of_step = str(action_of_step)
action_of_step = json.dumps(action_of_step, ensure_ascii=False)
action_of_step = action_of_step.replace('"', "'")
result_of_step = step_obj.get_expected_result()
if type(result_of_step) == type(b''):
result_of_step = result_of_step.decode('utf-8')
elif type(result_of_step) == type({}):
result_of_step = str(result_of_step)
result_of_step = result_of_step.replace('"', "'")
# except Exception as e:
# logger.error('获取step action、expected_result出错 %s' % e)
# action_of_step = ''
# result_of_step = ''
finally:
if step_run_result[0] == 'Error':
fail_or_error_reason = step_run_result[1][0][1]
fail_or_error_reason = fail_or_error_reason.replace(
'\n', '')
fail_or_error_reason = fail_or_error_reason.replace(
'\"', '')
fail_or_error_reason = fail_or_error_reason.replace(
'\'', '')
logger.error(
'步骤[%s]执行出错,停止执行用例[id=%s, name=%s]' %
(step_number, self.testcase_id, self.testcase_name))
sql_update = 'UPDATE '+ case_step_report_tb +' SET runresult=\"%s\",reason=\"%s\", protocol_method=\"%s\", runtime=\"%s\",' \
'step_action=\"%s\", expected_results=\"%s\"' \
' WHERE executed_history_id = %s AND testcase_id = %s AND step_id = %s' \
' AND project=\'%s\' AND testplan=\'%s\' AND runtime=\'%s\' '
data = (step_run_result[0], fail_or_error_reason,
protocol_method, run_time, action_of_step,
result_of_step, str(case_executed_history_id),
self.testcase_id, step_id, self.testproject,
testplan, '0000-00-00 00:00:00')
logger.info('正在更新步骤执行结果')
testdb.execute_update(sql_update, data)
return step_run_result
elif step_run_result[0] == 'Fail':
fail_or_error_reason = step_run_result[1][0][1]
fail_or_error_reason = fail_or_error_reason.replace(
'\n', '')
fail_or_error_reason = fail_or_error_reason.replace(
'\"', '')
fail_or_error_reason = fail_or_error_reason.replace(
'\'', '')
logger.info(
'步骤[%s]执行失败,停止执行用例[id=%s, name=%s]' %
(step_number, self.testcase_id, self.testcase_name))
sql_update = 'UPDATE '+ case_step_report_tb +' SET runresult=\"%s\",reason=\"%s\", protocol_method=\"%s\", runtime=\"%s\",' \
'step_action=\"%s\", expected_results=\"%s\"' \
' WHERE executed_history_id = %s AND testcase_id = %s AND step_id = %s' \
' AND project=\'%s\' AND testplan=\'%s\' AND runtime=\'%s\''
data = (step_run_result[0], fail_or_error_reason,
protocol_method, run_time, action_of_step,
result_of_step, str(case_executed_history_id),
self.testcase_id, step_id, self.testproject,
testplan, '0000-00-00 00:00:00')
logger.info('正在更新步骤执行结果')
testdb.execute_update(sql_update, data)
return step_run_result
elif step_run_result[0] == 'Block':
fail_or_error_reason = step_run_result[1]
logger.info(
'步骤[%s]执行失败,停止执行用例[id=%s, name=%s]' %
(step_number, self.testcase_id, self.testcase_name))
sql_update = 'UPDATE '+ case_step_report_tb +' SET runresult=\"%s\",reason=\"%s\", protocol_method=\"%s\", runtime=\"%s\"' \
' WHERE executed_history_id = %s AND testcase_id = %s AND step_id = %s' \
' AND project=\'%s\' AND testplan=\'%s\' AND runtime=\'%s\''
data = (step_run_result[0], fail_or_error_reason, '无',
run_time, str(case_executed_history_id),
self.testcase_id, step_id, self.testproject,
testplan, '0000-00-00 00:00:00')
logger.info('正在更新步骤执行结果')
testdb.execute_update(sql_update, data)
return step_run_result
else:
fail_or_error_reason = ''
sql_update = 'UPDATE '+ case_step_report_tb +' SET runresult=\"%s\",reason=\"%s\", protocol_method=\"%s\", runtime=\"%s\",' \
'step_action=\"%s\", expected_results=\"%s\"'\
' WHERE executed_history_id = %s AND testcase_id = %s AND step_id = %s'\
' AND project=\'%s\' AND testplan=\'%s\' AND runtime=\'%s\''
data = (step_run_result[0], fail_or_error_reason,
protocol_method, run_time, action_of_step,
result_of_step, str(case_executed_history_id),
self.testcase_id, step_id, self.testproject,
testplan, '0000-00-00 00:00:00')
logger.info('正在更新步骤执行结果')
testdb.execute_update(sql_update, data)
logger.info('测试用例[id=%s, name=%s]执行成功' %
(self.testcase_id, self.testcase_name))
return ('Pass', '')
def run_testcase(self, http, testplan):
if 0 == self.active_status:
logger.warning('用例[name=%s]处于禁用状态[active=0]，不执行' % self.testcase_name)
return 'Block'
protocol_all = http.get_protocol()
host_all = http.get_host()
port_all = http.get_port()
for step in self.steps:
# 构造测试步骤对象
step_id = int(step['id'])
step_number = int(step['step_number'])
step_action = other_tools.conver_date_from_testlink(step['actions'])
expected_results = other_tools.conver_date_from_testlink(step['expected_results'])
logger.debug('step_action： %s' % step_action)
sql_insert = 'INSERT INTO '+ case_step_report_tb +'(executed_history_id, testcase_id, testcase_name, testplan, project, step_id, step_num, protocol_method, protocol, host, port, ' \
'step_action, expected_results, runresult, reason, runtime)' \
' VALUES(%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)'
if step_action.find('style') != -1:
data = (executed_history_id, self.testcase_id, self.testcase_name, testplan, self.testproject, step_id, step_number, '无', '无', '无', '无',
step_action, expected_results, 'Block', '', '')
else:
data = (executed_history_id, self.testcase_id, self.testcase_name, testplan, self.testproject, step_id, step_number, '', protocol_all, host_all, port_all,
step_action, expected_results, 'Block', '', '')
logger.info('记录测试步骤到测试步骤报告表')
testdb.execute_insert(sql_insert, data)
try:
step_action = json.loads(step_action)
if 'style' not in step_action:
protocol_method = step_action['method']
else:
protocol_method = '无'
if expected_results != '':
expected_results = json.loads(expected_results)
step_obj = CaseStep(step_id, step_number, expected_results, step_action, self.testcase_id)
except Exception as e:
logger.error('步骤[%s]信息填写错误: %s,停止执行用例[id=%s, name=%s]' % (step_number, e, self.testcase_id, self.testcase_name))
return 'Error'
logger.info('开始执行步骤操作[第%s步]'% step_number)
run_time = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime()) # 记录运行时间
if 'style' in step_action:
step_run_result = globalpkg.global_function.run_testcase_by_id(step_action['testcase_id'], testplan)
else:
step_run_result = step_obj.run_step(http)
try:# 转换 “ 为 ‘ ，防止数据库存储出错
action_of_step = step_obj.get_action()
if type(action_of_step) == type(b''):
action_of_step = action_of_step.decode('utf-8')
elif type(action_of_step) == type({}):
action_of_step = str(action_of_step)
action_of_step = action_of_step.replace('"', "'")
result_of_step = step_obj.get_expected_result()
if type(result_of_step) == type(b''):
result_of_step = result_of_step.decode('utf-8')
elif type(result_of_step) == type({}):
result_of_step = str(result_of_step)
result_of_step = result_of_step.replace('"', "'")
# except Exception as e:
# logger.error('获取step action、expected_result出错 %s' % e)
# action_of_step = ''
# result_of_step = ''
finally:
if step_run_result[0] == 'Error':
fail_or_error_reason = step_run_result[1][0][1]
fail_or_error_reason = fail_or_error_reason.replace('\n', '')
fail_or_error_reason = fail_or_error_reason.replace('\"', '')
fail_or_error_reason = fail_or_error_reason.replace('\'', '')
logger.error('步骤[%s]执行出错,停止执行用例[id=%s, name=%s]' % (step_number, self.testcase_id, self.testcase_name))
sql_update = 'UPDATE '+ case_step_report_tb +' SET runresult=\"%s\",reason=\"%s\", protocol_method=\"%s\", runtime=\"%s\",' \
'step_action=\"%s\", expected_results=\"%s\"' \
' WHERE executed_history_id = %s AND testcase_id = %s AND step_id = %s' \
' AND project=\'%s\' AND testplan=\'%s\'' % \
(step_run_result[0], fail_or_error_reason, protocol_method, run_time, action_of_step, result_of_step, str(executed_history_id),self.testcase_id, step_id,
self.testproject, testplan)
logger.info('正在更新步骤执行结果')
testdb.execute_update(sql_update)
return 'Error'
elif step_run_result[0] == 'Fail':
fail_or_error_reason = step_run_result[1][0][1]
fail_or_error_reason = fail_or_error_reason.replace('\n', '')
fail_or_error_reason = fail_or_error_reason.replace('\"', '')
fail_or_error_reason = fail_or_error_reason.replace('\'', '')
logger.info('步骤[%s]执行失败,停止执行用例[id=%s, name=%s]' % (step_number, self.testcase_id, self.testcase_name))
sql_update = 'UPDATE '+ case_step_report_tb +' SET runresult=\"%s\",reason=\"%s\", protocol_method=\"%s\", runtime=\"%s\",' \
'step_action=\"%s\", expected_results=\"%s\"' \
' WHERE executed_history_id = %s AND testcase_id = %s AND step_id = %s' \
' AND project=\'%s\' AND testplan=\'%s\'' % \
(step_run_result[0], fail_or_error_reason, protocol_method, run_time, action_of_step, result_of_step, str(executed_history_id),self.testcase_id, step_id,
self.testproject, testplan)
logger.info('正在更新步骤执行结果')
testdb.execute_update(sql_update)
return 'Fail'
elif step_run_result[0] == 'Block':
fail_or_error_reason = step_run_result[1]
logger.info('步骤[%s]执行失败,停止执行用例[id=%s, name=%s]' % (step_number, self.testcase_id, self.testcase_name))
sql_update = 'UPDATE '+ case_step_report_tb +' SET runresult=\"%s\",reason=\"%s\", protocol_method=\"%s\", runtime=\"%s\"' \
' WHERE executed_history_id = %s AND testcase_id = %s AND step_id = %s' \
' AND project=\'%s\' AND testplan=\'%s\'' % \
(step_run_result[0], fail_or_error_reason, '无', run_time, str(executed_history_id), self.testcase_id, step_id,
self.testproject, testplan)
logger.info('正在更新步骤执行结果')
testdb.execute_update(sql_update)
return 'Fail'
else:
fail_or_error_reason = ''
# sql_update = 'UPDATE '+ case_step_report_tb +' SET runresult=\"%s\",reason=\"%s\", protocol_method=\"%s\", runtime=\"%s\"' \
# ' WHERE executed_history_id = %s AND testcase_id = %s AND step_id = %s'\
# ' AND project=\'%s\' AND testplan=\'%s\'' % \
# (step_run_result[0], fail_or_error_reason, protocol_method, run_time, str(executed_history_id), self.testcase_id, step_id,
# self.testproject, testplan)
sql_update = 'UPDATE '+ case_step_report_tb +' SET runresult=\"%s\",reason=\"%s\", protocol_method=\"%s\", runtime=\"%s\",' \
'step_action=\"%s\", expected_results=\"%s\"'\
' WHERE executed_history_id = %s AND testcase_id = %s AND step_id = %s'\
' AND project=\'%s\' AND testplan=\'%s\'' % \
(step_run_result[0], fail_or_error_reason, protocol_method, run_time, action_of_step, result_of_step, str(executed_history_id),self.testcase_id, step_id,
self.testproject, testplan)
logger.info('正在更新步骤执行结果')
testdb.execute_update(sql_update)
logger.info('测试用例[id=%s, name=%s]执行成功' % (self.testcase_id, self.testcase_name))
return 'Pass'
def run_testcase_by_id(testcase_id, testplan='无计划'):
try:
testcase_info = mytestlink.getTestCase(testcase_id) # 获取测试用例基本信息
logger.info('获取测试用例信息 %s' % testcase_info)
except Exception as e:
logger.error('获取用例信息失败 %s,,暂停执行该用例' % e)
return ('Fail', ('获取用例信息失败 %s' % e))
# 获取用例所在套件和项目名称
response = mytestlink.getFullPath([int(testcase_id)])
response = response[str(testcase_id)]
testsuite_name = ''
for suit in response[1:]:
testsuite_name = testsuite_name + '-' + suit
testsuite_name = testsuite_name.lstrip('-')
project_name = response[0]
# 构造测试用例对象
testcase_name = testcase_info[0]['name']
testcase_steps = testcase_info[0]['steps']
testcase_isactive = int(testcase_info[0]['active'])
testcase_obj = TestCase(testcase_id, testcase_name, testcase_steps,
testcase_isactive, project_name)
testsuite_id = int(testcase_info[0]['testsuite_id'])
logger.info('正在读取套件[id=%s]的协议，host，端口配置...' % (testsuite_id))
testsuite_info = mytestlink.getTestSuiteByID(testsuite_id)
testsuite_name = testsuite_info['name']
testsuite_details = other_tools.conver_date_from_testlink(
testsuite_info['details'])
project = mytestlink.getFullPath(testsuite_id)
project = project[str(testsuite_id)][0]
testsuite_obj = TestSuite(testsuite_id, testsuite_name, testsuite_details,
project)
testsuite_conf = testsuite_obj.get_testsuite_conf() # 获取套件基本信息
if '' == testsuite_conf:
logger.error('测试套件[id=%s ,name=%s]未配置协议，host，端口信息，暂时无法执行' %
(testsuite_id, testsuite_name))
return ('Fail', ('测试套件[id=%s ,name=%s]未配置协议，host，端口信息，暂时无法执行' %
(testsuite_id, testsuite_name)))
try:
details = json.loads(testsuite_conf)
protocol = details['protocol']
host = details['host']
port = details['port']
except Exception as e:
logger.error('测试套件[id=%s ,name=%s]协议，host，端口信息配置错误,未执行：%s' %
(testsuite_id, testsuite_name, e))
return ('Fail', '测试套件[id=%s ,name=%s]协议，host，端口信息配置错误,未执行：%s' %
(testsuite_id, testsuite_name, e))
# 构造http对象
myhttp = MyHttp(protocol, host, port)
try:
sql_insert = 'INSERT INTO '+testcase_report_tb +'(executed_history_id, testcase_id, testcase_name, testsuit, testplan, project, runresult, runtime)' \
' VALUES(%s, %s, %s, %s, %s, %s, %s, %s)'
data = (executed_history_id, testcase_id, testcase_name,
testsuite_name, testplan, project_name, 'Block', '')
logger.info('记录测试用例到测试用例报表')
testdb.execute_insert(sql_insert, data)
logger.info('开始执行测试用例[id=%s，name=%s]' % (testcase_id, testcase_name))
run_time = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime()) # 记录运行时间
testcase_run_result = testcase_obj.run_testcase(myhttp, testplan)
logger.info('正在更新用例执行结果')
sql_update = 'UPDATE '+testcase_report_tb +' SET runresult=\"%s\", runtime=\"%s\"' \
' WHERE executed_history_id = %s and testcase_id = %s' \
' AND project=\'%s\' AND testplan=\'%s\'' % \
(testcase_run_result, run_time, executed_history_id, testcase_id, project_name, testplan)
testdb.execute_update(sql_update)
logger.info('指定用例[%s]已执行完' % testcase_id)
if testcase_run_result == 'Block':
return (testcase_run_result, '用例被阻塞,未执行')
else:
return (testcase_run_result, '')
except Exception as e:
logger.error('运行用例出错 %s' % e)
return ('Fail', ('执行用例出错 %s' % testcase_id))
for id in global_case_id_list:
res = run_testcase_by_id(id)
logger.info('用例[%s]运行结果：%s' % (id, res))
if 1 == run_mode:
logger.info('按项目运行测试')
project_mode = run_mode_conf.get_project_mode()
testplans_name_list = []
if 1 == project_mode:
logger.info('运行所有项目')
projects = mytestlink.getProjects()
for project in projects:
# 构造项目对象
active_status = project['active']
project_name = project['name']
project_notes = other_tools.conver_date_from_testlink(
project['notes'])
project_id = int(project['id'])
project_obj = TestProject(active_status, project_name,
project_notes, project_id)
logger.info('正在读取测项目[id：%s, project：%s]的协议，host，端口配置...' %
(project_id, project_name))
testproject_conf = project_notes
logger.info('成功读取配置信息：%s' % testproject_conf)
if '' == testproject_conf:
logger.error(
'测试项目[id：%s, project：%s]未配置协议，host，端口信息，暂时无法执行' %
(project_id, project_name))
continue