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)