config.get_config('./lib/conf.properties')
mysql = Mysql()
mysql.init_mysql('./lib/userinfo.sql')
#开始读取用例
reader = Reader()
# http = HTTP()
# reader.open_excel('./lib/HTTP接口用例.xls')
reader.open_excel('./lib/' + casename)
sheetname = reader.get_sheets()
logger.info(sheetname)
writer = Writer()
# writer.copy_open('./lib/HTTP接口用例.xls', './lib/result-HTTP接口用例.xls')
writer.copy_open('./lib/' + casename, './lib/result-' + casename)
# sheetname = writer.get_sheets()
#获取开始时间
t = str(time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time())))
#设置shet页
writer.set_sheet(sheetname[0])
# 写入结果文件
writer.write(1, 3, t)
#识别接口类型
reader.readline()
line = reader.readline()
if line[1] == 'HTTP':
http = HTTP(writer)
casename = 'HTTP.xls'
# 运行用例之前，初始化配置，初始化数据库
config.get_config('./lib/conf.properties')
mysql = Mysql()
mysql.init_mysql('./lib/userinfo.sql')
# 开的读取用例
reader = Reader()
reader.open_excel('./lib/' + casename)
sheetname = reader.get_sheets()
logger.info(sheetname)
writer = Writer()
writer.copy_open('./lib/' + casename, './lib/结果-' + casename)
t = str(time.strftime('%Y-%m-%d %H:%M:%S',time.localtime(time.time())))
writer.set_sheet(sheetname[0])
writer.write(1,3,t)
reader.readline()
line = reader.readline()
if line[1] == 'HTTP':
http = HTTP(writer)
elif line[1] == 'WEB':
http = Web(writer)
elif line[1] == "APP":
http = APP(writer)
else:
http = SOAP(writer)
elif len(params) == 1:
func(line[4])
elif len(params) == 2:
func(line[4],line[5])
elif len(params) == 3:
func(line[4],line[5],line[6])
else:
print('暂不支持超过3个参数的关键字')
#逐行读取excel内容
reader = Reader()
casename = 'HTTP接口用例_gmd'
#打开Excel
reader.open_excel('./lib/%s.xls' % casename)
#调用write函数，给出复制路径
writer = Writer()
writer.copy_open('./lib/%s.xls' % casename, './lib/result-%s.xls' % casename)
#获取Excel的sheet内容
sheetname = reader.get_sheets()
writer.set_sheet(sheetname[0])
starttime = time.strftime('%Y-%m-%d %H:%M:%S',time.localtime(time.time()))
writer.write(1,3,starttime)
#读取excel坐标（1，1）的数据，查看执行用例对象
reader.readline()
casetype = reader.readline()[1]
# 执行用例的关键字库对象
obj = None
if casetype == 'HTTP':
#执行http接口自动化
obj = HTTP(writer)
func(line[4])
return
if len(args) == 2:
func(line[4], line[5])
return
if len(args) == 3:
func(line[4], line[5], line[6])
return
print("warning: 目前仅支持三个以内的参数")
casename = "SOAP"
reader = Reader()
reader.open_excel("./lib/cases/" + casename + ".xls")
writer = Writer()
writer.copy_open('./lib/cases/' + casename + '.xls',
'./lib/results/' + casename + '-result.xls')
sheetnames = writer.get_sheets()
reader.readline()
caseType = reader.readline()[1]
http = None
if caseType == 'HTTP':
http = HTTP(writer)
elif caseType == 'SOAP':
http = SOAP(writer)
#开始执行时间
writer.set_sheet(sheetnames[0])
writer.write(1, 3, str(datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S')))
for sheet in sheetnames: