Get test cases
import xlrd
from lib.log import atp_log
class OpCase(object):
def get_case(self,file_path):
case = []
if file_path.endswith('.xls') or file_path .endswith('.xlsx '):
try:
book = xlrd.open_workbook(file_path)
sheet = book.sheet_by_index(0)
for i in range(1, sheet.nrows ): # How many lines are there in excle
row_data = sheet.row_values(i) # Get the value of each row
case.append(row_data[4:8]) # slice (because only the Values from subscript 4 to subscript 7)
atp_log.info('Total read %s use cases' % (len(case)))
except Exception as e:
atp_log.error('%s use case acquisition failed, error message% s' % (file_path, e))
else:
atp_log.error('The use case file is illegal: %s span>' % file_path)
return case
#Test
#m = OpCase()
#m.get_case(r'E:\Users\admin\PycharmProjects\Interface test\ATP')
#m.get_case(‘xx.xls‘)
#m.get_case(r'E:\Users\admin\PycharmProjects\Interface test\ATP\cases\test case.xlsx')< /span>
Send request
def my_request(self,url,method,data):
method = method.upper()
if method=='POST':
requests.get(url,params=data)
else:
atp_log.warning('This request method is not currently supported')
import xlrd
from lib.log import atp_log
class OpCase(object):
def get_case(self,file_path):
case = []
if file_path.endswith('.xls') or file_path .endswith('.xlsx '):
try:
book = xlrd.open_workbook(file_path)
sheet = book.sheet_by_index(0)
for i in range(1, sheet.nrows ): # How many lines are there in excle
row_data = sheet.row_values(i) # Get the value of each row
case.append(row_data[4:8]) # slice (because only the Values from subscript 4 to subscript 7)
atp_log.info('Total read %s use cases' % (len(case)))
except Exception as e:
atp_log.error('%s use case acquisition failed, error message% s' % (file_path, e))
else:
atp_log.error('The use case file is illegal: %s span>' % file_path)
return case
#Test
#m = OpCase()
#m.get_case(r'E:\Users\admin\PycharmProjects\Interface test\ATP')
#m.get_case(‘xx.xls‘)
#m.get_case(r'E:\Users\admin\PycharmProjects\Interface test\ATP\cases\Test Case.xlsx')< /span>
def my_request(self, url,method,data):
method = method.upper()
if method=='POST':
requests.get(url,params=data)
else:
atp_log.warning('This request method is not currently supported')