Interface Automation Architecture – 2

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')

WordPress database error: [Table 'yf99682.wp_s6mz6tyggq_comments' doesn't exist]
SELECT SQL_CALC_FOUND_ROWS wp_s6mz6tyggq_comments.comment_ID FROM wp_s6mz6tyggq_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 2254 ORDER BY wp_s6mz6tyggq_comments.comment_date_gmt ASC, wp_s6mz6tyggq_comments.comment_ID ASC

Leave a Comment

Your email address will not be published.