def run_testsuite(self, http):
logger.info('正在获取套件[id=%s，name=%s]的测试用例...' %
(self.testsuite_id, self.testsuite_name))
testcases_id_list_for_testsuit = self.get_testcases_id_for_testsuite()
logger.info('获取到用例id列表：%s', testcases_id_list_for_testsuit)
for testcase_id in testcases_id_list_for_testsuit[:]:
testcase_info = mytestlink.getTestCase(testcase_id) # 获取测试用例基本信息
logger.info('获取测试用例信息 %s' % testcase_info)
# 构造测试用例对象
testcase_name = testcase_info[0]['name']
preconditions = testcase_info[0]['preconditions']
if preconditions.find('isglobal') != -1:
logger.info('用例[id=%s, name=%s]为全局初始化用例，已跳过执行' %
(testcase_id, testcase_name))
continue
testcase_steps = testcase_info[0]['steps']
testcase_isactive = int(testcase_info[0]['active'])
testcase_obj = TestCase(testcase_id, testcase_name, testcase_steps,
testcase_isactive, self.project_name)
# 获取测试套件名称
logger.info(testcase_id)
full_path = mytestlink.getFullPath(int(testcase_id))
full_path = full_path[testcase_id]
testsuite_name = ''
for suit in full_path[1:]:
testsuite_name = testsuite_name + '-' + suit
testsuite_name = testsuite_name.lstrip('-')
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)'
testplan = '无计划'
data = (executed_history_id, testcase_id, testcase_name,
testsuite_name, testplan, self.project_name, 'Block',
'0000-00-00 00:00:00')
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(http, 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\''
data = (testcase_run_result[0], run_time, executed_history_id,
testcase_id, self.project_name, testplan)
testdb.execute_update(sql_update, data)
logger.info('测试套件[id=%s ,name=%s]已执行完' %
(self.testsuite_id, self.testsuite_name))
def run_testplan(self, http):
logger.info('正在获取测试计划[project=%s，name=%s]的测试用例' %
(self.testproject, self.testplan_name))
testcases_for_testplan = mytestlink.getTestCasesForTestPlan(
self.testplan_id)
if [] == testcases_for_testplan:
logger.warning('未获取到测试用例')
return
testcases_id_for_testplan = testcases_for_testplan.keys()
logger.info(
'成功获取测试计划[project=%s，name=%s]的测试用例id：%s' %
(self.testproject, self.testplan_name, testcases_id_for_testplan))
if 0 == self.active_status:
logger.warning('测试计划[project=%s，name=%s]处于不活动状态[active=0]，不执行' %
(self.testproject, self.testplan_name))
return
for testcase_id_str in testcases_id_for_testplan:
testcase_id = int(testcase_id_str)
testcase_info = mytestlink.getTestCase(testcase_id) # 获取测试用例基本信息
logger.info('获取测试用例信息 %s' % testcase_info)
# 构造测试用例对象
testcase_steps = testcase_info[0]['steps']
testcase_name = testcase_info[0]['name']
preconditions = testcase_info[0]['preconditions']
if preconditions.find('isglobal') != -1:
logger.info('用例[id=%s, name=%s]为全局初始化用例，已跳过执行' %
(testcase_id, testcase_name))
continue
testcase_isactive = int(testcase_info[0]['active'])
# 获取测试套件名称
full_path = mytestlink.getFullPath([testcase_id])
full_path = full_path[str(testcase_id)]
testsuite_name = ''
for suit in full_path[1:]:
testsuite_name = testsuite_name + '-' + suit
testsuite_name = testsuite_name.lstrip('-')
testcase_obj = TestCase(testcase_id, testcase_name, testcase_steps,
testcase_isactive, self.testproject)
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, str(testcase_name),
testsuite_name, self.testplan_name, self.testproject,
'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(
http, self.testplan_name)
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, self.testproject, self.testplan_name)
testdb.execute_update(sql_update)
bulid_info = mytestlink.getLatestBuildForTestPlan(
self.testplan_id) # 固定取最新的版本
bulid_version = bulid_info['name']
logger.info(
'正在更新testlink上测试计划[testplan_id=%s, bulid_version=%s],对应用例[testcase_id=%s]的执行结果'
% (self.testplan_id, bulid_version, testcase_id))
notes = '用例[id：%s]在测试计划[testplan_id：%s，testplan_name：%s,bulidversion：%s]中的执行结果' \
% (testcase_id, self.testplan_id,self.testplan_name, bulid_version)
if 'Fail' == testcase_run_result or 'Error' == testcase_run_result:
self.__execute_case_in_testlink(testcase_id, bulid_version,
'f', notes) # f - 失败
elif 'Pass' == testcase_run_result:
self.__execute_case_in_testlink(testcase_id, bulid_version,
'p', notes) # f - 成功
else:
pass # 如果未执行，啥都不做
logger.info('测试计划[project=%s ,testplan=%s]已执行完' %
(self.testproject, self.testplan_name))
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))