def test_SignInBags_001(self):
'''袋子签入：正常签入'''
r = self.obj.post(row=5)
isIn(self, r=r, row=5)
self.obj.db.update(
'update transfer_bag_mapping set check_in="N",check_in_time= NULL,check_in_by =null WHERE bag_id in(select bag_id from bag_infos where rf_id="313930353034303030303337");'
)
def test_BoxForecast_002(self):
'''箱子预报：同客户相同批次号'''
R = 9
self.obj.post_with_auth(row=R, account1="T0001", password1="asdfghjk")
r = self.obj.post_with_auth(row=R,
account1="T0001",
password1="asdfghjk")
isIn(self, r=r, row=R)
def test_PatchNumber_002(self):
'''批次预报：同客户相同批次号'''
R = 9
self.obj.post_with_auth(row=R, account1="T0001", password1="asdfghjk")
r = self.obj.post_with_auth(row=R,
account1="T0001",
password1="asdfghjk")
isIn(self, r=r, row=R)
def test_PatchNumber_001(self):
'''批次预报：正常预报'''
R = 8
r = self.obj.post_with_auth(row=R,
account1="T0001",
password1="asdfghjk")
isIn(self, r=r, row=R)
self.obj.db.update(
"delete from ots_inbound_order_info where batch_number='auto_test_number_001';"
)
def test_PatchNumber_003(self):
'''批次预报：不同客户相同批次号,可以预报成功'''
R = 10
self.obj.post_with_auth(row=R, account1="T0001", password1="asdfghjk")
r = self.obj.post_with_auth(row=R,
account1="T0002",
password1="123456")
isIn(self, r=r, row=R)
self.obj.db.update(
"delete from ots_inbound_order_info where batch_number='auto_test_number_001';"
)
def test_WarehouseQuery_002(self):
'''查询转运单信息：参数正确，查询ECDC仓成功'''
r = self.obj.post(row=2)
print(r.text)
isIn(self,r=r,row=2)
def test_AirlineForecast_005(self):
'''航班预报：客户不存在，预报失败'''
r = self.obj.post(row=85)
isIn(self,r=r,row=85)
def test_AirlineForecast_004(self):
'''航班预报：校验码不正确，预报失败'''
r = self.obj.post(row=84)
isIn(self,r=r,row=84)
def test_AirlineForecast_003(self):
'''航班预报：必填参数为空，预报失败'''
r = self.obj.post(row=83)
isIn(self,r=r,row=83)
def test_AirlineConfirmForecast_004(self):
'''航班确认预报：校验码不正确，预报失败'''
r = self.obj.post(row=89)
isIn(self, r=r, row=89)
def test_AirlineConfirmForecast_002(self):
'''航班确认预报：预报渠道未配置，预报失败'''
r = self.obj.post(row=87)
isIn(self, r=r, row=87)
def test_SignInBags_004(self):
'''袋子签入：袋号不存在'''
R = 11
r = self.obj.post(row=R)
isIn(self, r=r, row=R)
def test_SignInBags_003(self):
'''袋子签入：仓库代码不传'''
r = self.obj.post(row=7)
isIn(self, r=r, row=7)
def test_SignInBags_002(self):
'''袋子签入：袋号已签入'''
r = self.obj.post(row=6)
isIn(self, r=r, row=6)
def test_WarehouseQuery_004(self):
'''查询转运单信息：仓库代码不存在，查询到所有仓成功'''
r = self.obj.post(row=4)
print(r.text)
isIn(self,r=r,row=4)
def test_AirlineConfirmForecast_001(self):
'''航班确认预报：请求参数正确，预报成功'''
r = self.obj.post(row=86)
isIn(self, r=r, row=86)
def test_All(self, args):
print(args, type(args))
if self.obj.excel.getCaseID(args) != "":
print("第" + str(args + 1) + "行")
if self.obj.excel.getPre_CaseID(args) != "":
case = eval(self.obj.excel.getPre_CaseID(args))
for i in case:
run_predata(self, i)
if self.obj.excel.getHeaders(args) != "":
'''获取请求头，如果没有则用默认请求头'''
header = eval(self.obj.excel.getHeaders(args))
else:
header = self.obj.excel.getDefaultHeaders()
if self.obj.excel.getAuthorization(args) != "":
'''添加授权到headers'''
data = eval(self.obj.excel.getAuthorization(args))
header = self.obj.get_authorizaiton(header, data[0], data[1])
if self.obj.excel.getRequest_Type(args).lower() == "post":
'''如果excel里面是post请求，则使用post请求'''
print("header:", header)
url = self.obj.excel.getUrl(row=args)
#data = eval(json.dumps(self.obj.excel.get_request_data(row=args)))
data = eval(
json.dumps(
str(
eval(
self.obj.excel.get_request_data(row=args).replace(
"null", '""'))))) #将请求参数值为null变成空值
print("请求地址", url, "请求地址结束")
print("请求参数", data, "请求参数结束")
r = self.obj.post_new(url=url,
data=data.encode("utf-8"),
header=header)
description = self.obj.excel.getTitle(args)
expect = self.obj.excel.getExcept(args)
print("用例描述", description, "用例描述结束")
print("期望", expect, "期望结束")
print("返回报文", r.text, "返回报文结束")
if self.obj.excel.getsql(args) != "":
'''执行sql操作，可以是多条sql'''
sqls = eval(self.obj.excel.getsql(args))
for sql in sqls:
#print(sql)
result = self.obj.db.update(sql)
print("数据库返回：", result)
self.assertTrue(result)
if result:
print(sql + "执行成功")
else:
print(sql + "执行失败")
if self.obj.excel.getExcept(args) != "":
'''做断言'''
isIn(self, r, args)
if self.obj.excel.getRequest_Type(args).lower() == "webservice":
'''如果excel里面是webservice请求，则使用webservice请求'''
url = self.obj.excel.getUrl(row=args)
# data = eval(json.dumps(self.obj.excel.get_request_data(row=args)))
data = self.obj.excel.get_request_data(row=args) # 将请求参数值为null变成空值
print("请求地址", url, "请求地址结束")
print("请求参数", data, "请求参数结束")
description = self.obj.excel.getTitle(args)
expect = self.obj.excel.getExcept(args)
print("用例描述", description, "用例描述结束")
print("期望", expect, "期望结束")
r = self.obj.request_wcf(url=url, data=data)
print("返回报文", r, "返回报文结束")
if self.obj.excel.getsql(args) != "":
'''执行sql操作，可以是多条sql'''
sqls = eval(self.obj.excel.getsql(args))
for sql in sqls:
# print(sql)
result = self.obj.db.update(sql)
print("数据库返回：", result)
self.assertTrue(result)
if result:
print(sql + "执行成功")
else:
print(sql + "执行失败")
if self.obj.excel.getExcept(args) != "":
'''做断言'''
wcf_isIn(self, r, args)
elif self.obj.excel.getRequest_Type(args).lower() == "get":
'''如果excel里面是get请求，则使用get请求'''
url = self.obj.excel.getUrl(row=args)
print("请求地址", url, "请求地址结束")
r = self.obj.get_new(args, header=header)
description = self.obj.excel.getTitle(args)
expect = self.obj.excel.getExcept(args)
print("用例描述", description, "用例描述结束")
print("期望", expect, "期望结束")
print("返回报文", r.text, "返回报文结束")
if self.obj.excel.getExcept(args) != "":
'''做断言'''
isIn(self, r, args)
if self.obj.excel.getsql(args) != "":
'''执行sql操作，可以是多条sql'''
sqls = eval(self.obj.excel.getsql(args))
for sql in sqls:
self.obj.db.update(sql)
def test_AirlineConfirmForecast_003(self):
'''航班确认预报：必填参数为空，预报失败'''
r = self.obj.post(row=88)
isIn(self, r=r, row=88)
def test_AirlineForecast_001(self):
'''航班预报：单个包裹预报,请求参数正确，预报成功'''
r = self.obj.post(row=81)
isIn(self,r=r,row=81)
def test_AirlineConfirmForecast_005(self):
'''航班确认预报：客户不存在，预报失败'''
r = self.obj.post(row=90)
isIn(self, r=r, row=90)
def test_AirlineForecast_002(self):
'''航班预报：预报渠道未配置，预报失败'''
r = self.obj.post(row=82)
isIn(self,r=r,row=82)
