For tester, there are various test results summary tools, this time I will introduce how to update test results in HPQC use a auto script.
# -*- coding: UTF-8 -*-
'''
function: This script is used for updating test result in HPQC
author : Tong
version: ver1
date: 2018/01/29
'''
import os
import requests
import logging
import copy
from xml.etree import ElementTree
logging.basicConfig(filename='HPQC.log', filemode='a',
format='%(asctime)s,%(msecs)d %(name)s %(levelname)s %(message)s', level=logging.DEBUG)
logging.debug("---------------------- update HPQC ----------------------\n")
logging.info('The current path' + os.path.abspath('.'))
class HpUpdate(object):
def __init__(self, QC_owner, QC_domain, QC_project):
self.QC_owner = QC_owner
self.QC_domain = QC_domain
self.QC_project = QC_project
@staticmethod
def get_instance(get_instance_url, get_headers):
get_instance = requests.get(url=get_instance_url, headers=get_headers, verify=False)
instance_tree = ElementTree.fromstring(get_instance.content)
for elem in instance_tree.findall('Entity/Fields/Field'): # get instance ID
if (elem.attrib['Name'] == 'id'):
test_instance = elem[0].text
test_instances.append(test_instance)
elif (elem.attrib['Name'] == 'status'):
test_status = elem[0].text
test_statuses.append(test_status)
elif (elem.attrib['Name'] == 'test-id'):
test_id = elem[0].text
test_ids.append(test_id)
else:
pass
return test_instances, test_statuses, test_ids
@staticmethod
def get_status(get_filed_url, get_headers):
get_field = requests.get(url=get_filed_url, headers=get_headers, verify=False)
field_tree = ElementTree.fromstring(get_field.content)
for elem in field_tree.findall('List'):
name = elem.find('Name')
if name.text == 'Status':
items = elem.findall('Items/Item')
for item in items:
value = item.get('value')
all_status.append(value)
break
return all_status
def post_method(self, test_instances, post_headers, status, build):
for test_instance in test_instances:
data = 'tester={}&testInstanceID={}&status={}&build={}'.format(self.QC_owner, test_instance,
status, build)
post_instance_url = 'https://quality-api.eng.vmware.com:8443/QCIntgrt/rest/' + self.QC_domain + '/' + self.QC_project + '/run'
post = requests.post(url=post_instance_url, headers=post_headers, data=data, verify=False)
logging.info('Case instance id {} has been update with staus {}'.format(test_instance, status))
if post.status_code != 200:
logging.ERROR("Post Error for instance {}".format(test_instance))
class BasicFuncs(object):
@staticmethod
def default(default_value, given_value):
if given_value == '':
return default_value
else:
return given_value
# basic info
default_owner = 'Tong'
QC_domain = 'Domain'
QC_project = 'Project'
given_owner = input("Please enter the owner:\n****** Select default value 'tester', just press 'Enter' ***\n")
QC_owner = BasicFuncs.default(default_owner, given_owner)
testset_id = input("Please enter test set ID:\n")
host = 'http://HOST/'
basic_url = host + 'QCIntgr2/rest/rest.php'
suffix_url = '/domains/' + QC_domain + '/projects/' + QC_project
get_instance_url = '/test-instances?filter={cycle-id[' + str(testset_id) + ']}'
get_instance_url = basic_url + suffix_url + get_instance_url
get_filed_url = '/lists/run'
get_filed_url = basic_url + suffix_url + get_filed_url
get_headers = {
'Accept': 'application/xml',
'APIKey': 'Tvkw5LAMNdENQexWKpM5IA8ARZyMCquw',
}
post_headers = copy.deepcopy(get_headers)
post_headers.update({'Content-Type': 'application/x-www-form-urlencoded'})
test = HpUpdate(QC_owner, QC_domain, QC_project)
all_status = test.get_field(get_filed_url, get_headers)
i = 1
for instance_stauts in all_status:
print("[{}] {}".format(i, instance_stauts))
i += 1
status_id = input("Please choose the test status:\n")
status = all_status[int(status_id) - 1]
build = input("Please enter the build:\n")
# get instance info
test_instances, test_statuses, test_ids = test.get_instance(get_instance_url, get_headers)
# post instance info
test.post_method(test_instances, post_headers, status, build)
Also u can refer the HPQC REST API.
