def getpayment(self):
u"""获取未开票交易的用户号"""
for i in range(2):
filepath = "D:\\pycharm-5.0.4\\Report_test\\Four_jiekou\\config\\mobiles.xlsx"
sheetName = "Sheet1"
data = ExcelUtil(filepath, sheetName)
cute_data = data.dict_data()
# payload={
# "userNo":cute_data[1],
# "ownership":'0140',
# }
# logger_message.loginfo(u'%s\t入参%s\t'%(send_time,payload))
get_paymentRecordList = requests.post(
"http://app.eslink.cc/invoice-zyzt/invoice/bzzy/getPaymentRecordList?userNo=0%s&ownership=0140"
% cute_data[i])
logger_message.loginfo(
u"%s\t方法名：%s\t请求地址：%s\t请求状态：%s\t返回内容：%s" %
(send_time, sys._getframe().f_code.co_name,
get_paymentRecordList.url, get_paymentRecordList.status_code,
get_paymentRecordList.text))
json_result = get_paymentRecordList.json()
# print(json_result["responseCode"])
if json_result["result"] != {} and json_result[
"responseCode"] == "100000":
print(cute_data[i])
def test_updateMenu_1(self):
u"""添加菜单"""
try:
#登陆Ecc获取登陆
logging_cookie = Login_ecc.Login_ecc()
cookies = requests.utils.dict_from_cookiejar(
logging_cookie.cookies)
#上传图片得到图片id
uploadMenuIcon = clientSet_uploadMenuIcon.uploadMenuIcon(self)
dict_result = json.loads(uploadMenuIcon)
case = dict_result["result"]
send_load = {
"posMenuName": "菜单名称",
"id": case["id"],
"posMenuRemark": "测试"
}
#发送请求
data = ExcelUtil(reportxlsx, Sheet_Name1).dict_data()
test_id = 0
s = requests.session()
res = send_requests(
s,
data[test_id],
send_load,
cookies,
)
self.assertTrue(res)
return res
except Exception as Error:
logger_message.logwarning('%s\t%s\t' % (send_time, Error))
raise
def operation_batchDeleteIndex_1(self):
u"""删除店铺首页公告列表记录接口"""
try:
operation_saveIndex_1(self) # 先新增店铺首页公告
queryAdIndexList = operation_queryAdIndexList_1(
self) # 执行查询店铺首页最后一条公告的id
get_queryAdIndexList = queryAdIndexList[-1]["id"]
queryAdIndex = {"ids": "%s" % get_queryAdIndexList}
data = ExcelUtil(report_xlsx, Sheet_Name).dict_data()
test_id = 0
s = requests.session()
res = send_requests(s,
data[test_id],
send_load=queryAdIndex,
cookie=self.token)
if str(res["responseCode"]) == '100000':
logger_message.loginfo("接口返回信息：%s" % res)
else:
logger_message.logwarning("接口返回信息：%s" % res)
except Exception as Error:
logger_message.logwarning(
u"%s\t方法名：%s\t异常原因：%s" %
(send_time, sys._getframe().f_code.co_name, Error))
raise
def operation_saveIndex_3(self):
u"""保存店铺首页轮播图片接口"""
try:
operation_file_upload = operation_file_upload_1(self)
save_index_load = {
# "image[0]": "%s" % operation_file_upload["result"],
"adName": "店铺首页轮播图片",
"path": "http://www.eslink.cc/",
"orders": "1",
"adMemo": "店铺首页轮播图片",
"status": "1",
"type": "1",
"commont": "%s" % operation_file_upload["result"],
}
data = ExcelUtil(report_xlsx, Sheet_Name).dict_data()
test_id = 2
s = requests.session()
res = send_requests(s,
data[test_id],
send_load=save_index_load,
cookie=self.token)
if str(res["responseCode"]) == '100000':
logger_message.loginfo("接口返回信息：%s" % res)
else:
logger_message.logwarning("接口返回信息：%s" % res)
except Exception as Error:
logger_message.logwarning(
u"%s\t方法名：%s\t异常原因：%s" %
(send_time, sys._getframe().f_code.co_name, Error))
raise
def operation_file_upload_1(self):
u"""上传图片接口:900x500像素"""
try:
data = ExcelUtil(report_xlsx, Sheet_Name).dict_data()
test_id = 0
s = requests.session()
res = send_requests(s, data[test_id], cookie=self.token)
return res
except Exception as Error:
logger_message.logwarning(u"%s\t方法名：%s\t异常原因：%s" % (send_time, sys._getframe().f_code.co_name, Error))
raise
def test_ID_3(self):
try:
data = ExcelUtil(reportxlsx, Sheet_Name).dict_data()
login_cookies = Test_Push_Sms_Send.Loging_etbc(self)
c = requests.utils.dict_from_cookiejar(login_cookies.cookies)
test_id = 3
s = requests.session()
res = send_requests(s, data[test_id], c)
self.assertTrue(res)
except Exception as Error:
logger_message.logwarning('%s\t%s\t' % (send_time, Error))
raise
def test_member_cardOperateByCardNo_2(self):
u"""操作流水查询接口,卡号错误"""
try:
data = ExcelUtil(reportxlsx, Sheet_Name).dict_data()
test_id = 1
s = requests.session()
res = send_requests(s, data[test_id], cookie=self.token)
self.assertTrue(res)
except Exception as Error:
logger_message.logwarning(u"%s\t方法名：%s\t异常原因：%s" % (send_time, sys._getframe().f_code.co_name, Error))
raise
def test_member_updateMemberCard_4(self):
u"""状态变更中备注最大字符100个校验"""
try:
data = ExcelUtil(reportxlsx, Sheet_Name).dict_data()
test_id = 3
s = requests.session()
res = send_requests(s, data[test_id], cookie=self.token)
self.assertTrue(res)
except Exception as Error:
logger_message.logwarning(u"%s\t方法名：%s\t异常原因：%s" % (send_time, sys._getframe().f_code.co_name, Error))
raise
def test_queryMemberCardCombox_3(self):
u"""卡关系信息查询，错误用户名正确用户电话"""
try:
data = ExcelUtil(reportxlsx, Sheet_Name).dict_data()
test_id = 2
s = requests.session()
res = send_requests(s, data[test_id], cookie=self.token)
self.assertTrue(res)
except Exception as Error:
logger_message.logwarning(u"%s\t方法名：%s\t异常原因：%s" % (send_time, sys._getframe().f_code.co_name, Error))
raise
def operation_queryCircleIndexList_1(self):
u"""查询店铺首页轮播图片列表"""
try:
data = ExcelUtil(report_xlsx, Sheet_Name).dict_data()
test_id = 0
s = requests.session()
res = send_requests(s, data[test_id], cookie=self.token)
return res["result"]
except Exception as Error:
logger_message.logwarning(
u"%s\t方法名：%s\t异常原因：%s" %
(send_time, sys._getframe().f_code.co_name, Error))
raise
def test_member_updateDiscountActivity_3(self):
u"""会员设备信息接口,当用户重复绑定设备的情况"""
try:
data = ExcelUtil(reportxlsx, Sheet_Name).dict_data()
test_id = 2
s = requests.session()
res = send_requests(s, data[test_id], cookie=self.token)
self.assertTrue(res)
except Exception as Error:
logger_message.logwarning(
u"%s\t方法名：%s\t异常原因：%s" %
(send_time, sys._getframe().f_code.co_name, Error))
raise
def test_member_updateDiscountActivity_1(self):
u"""删除优惠活动接口"""
try:
data = ExcelUtil(reportxlsx, Sheet_Name).dict_data()
discountactivity_id = member_updateDiscountActivity.member_selectDiscountActivity_id(self)
load_id = {"id": "%s" % discountactivity_id[0][0]}
test_id = 0
s = requests.session()
res = send_requests(s, data[test_id], send_load=load_id, cookie=self.token)
self.assertTrue(res)
except Exception as Error:
logger_message.logwarning(u"%s\t方法名：%s\t异常原因：%s" % (send_time, sys._getframe().f_code.co_name, Error))
raise
def test_uploadMenuIcon_3(self):
u"""上传图片:jpg格式"""
try:
data = ExcelUtil(reportxlsx, Sheet_Name).dict_data()
test_id = 1
s = requests.session()
res = send_requests(s, data[test_id])
return res
except Exception as Error:
logger_message.logwarning(
u"%s\t方法名：%s\t异常原因：%s" %
(send_time, sys._getframe().f_code.co_name, Error))
raise
def test_member_updateMemberDeviceInfo_2(self):
u"""修改会员设备信息接口,设备信息修改用户已经绑定设备"""
try:
data = ExcelUtil(reportxlsx, Sheet_Name).dict_data()
test_id = 1
s = requests.session()
res = send_requests(s, data[test_id], cookie=self.token)
self.assertTrue(res)
except Exception as Error:
logger_message.logwarning(
u"%s\t方法名：%s\t异常原因：%s" %
(send_time, sys._getframe().f_code.co_name, Error))
raise
def test_member_querySuccessCardRecharge_4(self):
u"""充值成功记录查询接口,会员卡号错误条件"""
try:
data = ExcelUtil(reportxlsx, Sheet_Name).dict_data()
test_id = 3
s = requests.session()
res = send_requests(s, data[test_id], cookie=self.token)
self.assertTrue(res)
except Exception as Error:
logger_message.logwarning(
u"%s\t方法名：%s\t异常原因：%s" %
(send_time, sys._getframe().f_code.co_name, Error))
raise
def test_member_saveDiscountActivity_4(self):
u"""添加优惠活动接口,气费消费满100减10元，限制一次"""
try:
data = ExcelUtil(reportxlsx, Sheet_Name).dict_data()
test_id = 3
s = requests.session()
res = send_requests(s, data[test_id], cookie=self.token)
self.assertTrue(res)
except Exception as Error:
logger_message.logwarning(
u"%s\t方法名：%s\t异常原因：%s" %
(send_time, sys._getframe().f_code.co_name, Error))
raise
def test_member_businessHallCardRecharge_3(self):
u"""会员卡充值接口，汽油卡充值"""
try:
data = ExcelUtil(reportxlsx, Sheet_Name).dict_data()
test_id = 2
s = requests.session()
res = send_requests(s, data[test_id], cookie=self.token)
self.assertTrue(res)
except Exception as Error:
logger_message.logwarning(
u"%s\t方法名：%s\t异常原因：%s" %
(send_time, sys._getframe().f_code.co_name, Error))
raise
def test_addClientInfo_1(self):
u"""新增设备版本信息，正确的数据"""
try:
data = ExcelUtil(reportxlsx, Sheet_Name).dict_data()
login_cookies = Login_ecc()
cookie = requests.utils.dict_from_cookiejar(login_cookies.cookies)
test_id = 0
s = requests.session()
res = send_requests(s, data[test_id], cookie)
self.assertTrue(res)
except Exception as Error:
logger_message.logwarning(
u"%s\t方法名：%s\t异常原因：%s" %
(send_time, sys._getframe().f_code.co_name, Error))
raise
def test_addmerchantMenu_5(self):
u"""商户菜单配置必选项缺少：voucherConfig"""
try:
data = ExcelUtil(reportxlsx, Sheet_Name).dict_data()
login_cookies = Login_ecc()
cookie = requests.utils.dict_from_cookiejar(login_cookies.cookies)
test_id = 4
s = requests.session()
res = send_requests(s, data[test_id], cookie)
self.assertTrue(res)
except Exception as Error:
logger_message.logwarning(
u"%s\t方法名：%s\t异常原因：%s" %
(send_time, sys._getframe().f_code.co_name, Error))
raise
def operation_saveIndex_1(self):
u"""保存店铺首页公告接口"""
try:
data = ExcelUtil(report_xlsx, Sheet_Name).dict_data()
test_id = 0
s = requests.session()
res = send_requests(s, data[test_id], cookie=self.token)
if str(res["responseCode"]) == '100000':
logger_message.loginfo("接口返回信息：%s" % res)
else:
logger_message.logwarning("接口返回信息：%s" % res)
except Exception as Error:
logger_message.logwarning(
u"%s\t方法名：%s\t异常原因：%s" %
(send_time, sys._getframe().f_code.co_name, Error))
raise
def test_Push_wechat_template(self):
u"""微信模版推送"""
try:
data = ExcelUtil(reportxlsx, Sheet_Name).dict_data()
login_cookies = Test_push_wechat_template.Loging_etbc(self)
c = requests.utils.dict_from_cookiejar(login_cookies.cookies)
test_id = 0
s = requests.session()
res = send_requests(s, data[test_id], c)
self.assertTrue(res)
except Exception as Error:
logger_message.logwarning(
u"%s\t方法名：%s\t异常原因：%s" %
(send_time, sys._getframe().f_code.co_name, Error))
raise
def operation_queryMemberOrderDetail_1(self):
u"""查询交易记录"""
try:
operation_queryMemberOrderList = operation_queryMemberOrderList_1(self) #查询交易列表
get_queryMemberOrderList = operation_queryMemberOrderList["list"][-1]["orderCode"] #选择最后一条记录
queryMemberOrderDetail_data = {
"orderCode": "%s" % get_queryMemberOrderList
}
data = ExcelUtil(report_xlsx, Sheet_Name).dict_data()
test_id = 0
s = requests.session()
res = send_requests(s, data[test_id], send_load=queryMemberOrderDetail_data, cookie=self.token)
return res["result"]
except Exception as Error:
logger_message.logwarning(u"%s\t方法名：%s\t异常原因：%s" % (send_time, sys._getframe().f_code.co_name, Error))
raise
def test_SearchActionCode_3(self):
u"""缺少一个查询参数：status"""
try:
data = ExcelUtil(reportxlsx, Sheet_Name).dict_data()
login_cookies = Login_ecc()
c = requests.utils.dict_from_cookiejar(login_cookies.cookies)
test_id = 2
s = requests.session()
res = send_requests(s, data[test_id], c)
self.assertTrue(res)
except Exception as Error:
logger_message.logwarning(
u"%s\t方法名：%s\t异常原因：%s" %
(send_time, sys._getframe().f_code.co_name, Error))
raise
def test_SearchActionCode_11(self):
u"""创建激活码:输入项字段的特定类型校验：subMerchantCode"""
try:
data = ExcelUtil(reportxlsx, Sheet_Name).dict_data()
login_cookies = Login_ecc()
cookie = requests.utils.dict_from_cookiejar(login_cookies.cookies)
test_id = 10
s = requests.session()
res = send_requests(s, data[test_id], cookie)
self.assertTrue(res)
except Exception as Error:
logger_message.logwarning(
u"%s\t方法名：%s\t异常原因：%s" %
(send_time, sys._getframe().f_code.co_name, Error))
raise
def test_member_updateMemberDeviceInfo_1(self):
u"""修改会员设备信息接口,设备信息修改正确"""
try:
data = ExcelUtil(reportxlsx, Sheet_Name).dict_data()
test_id = 0
s = requests.session()
res = send_requests(s, data[test_id], cookie=self.token)
self.assertTrue(res)
except Exception as Error:
logger_message.logwarning(
u"%s\t方法名：%s\t异常原因：%s" %
(send_time, sys._getframe().f_code.co_name, Error))
raise
finally:
user_id = member_updateMemberDeviceInfo.member_updateMemberDeviceInfo_id(
self)
self.assertEqual(1332, user_id[0][0], msg="修改会员设备信息不匹配")
def test_register_3(self):
u"""注册会员缺少参数：身份证"""
try:
data = ExcelUtil(reportxlsx,Sheet_Name).dict_data()
login_cookies = loggin_wx()
cookie = requests.utils.dict_from_cookiejar(login_cookies.cookies)
cookies = {
"SERVERID": "%s" % cookie,
"SESSION": "%s" % wx_session,
}
test_id = 2
s = requests.session()
res = send_requests(s, data[test_id], cookie=cookies)
self.assertTrue(res)
except Exception as Error:
logger_message.logwarning(u"%s\t方法名：%s\t异常原因：%s" % (send_time, sys._getframe().f_code.co_name, Error))
raise
def test_updateMenu_4(self):
u"""参数最大字符数验证posMenuName:10"""
try:
#登陆Ecc获取登陆
logging_cookie = Login_ecc.Login_ecc()
cookies = requests.utils.dict_from_cookiejar(
logging_cookie.cookies)
#上传图片得到图片id
uploadMenuIcon = clientSet_uploadMenuIcon.uploadMenuIcon(self)
dict_result = json.loads(uploadMenuIcon)
case = dict_result["result"]
send_load = {
"posMenuName": "菜单名称最大字符数限制",
"id": case["id"],
"posMenuRemark": "测试"
}
#发送请求
data = ExcelUtil(reportxlsx, Sheet_Name1).dict_data()
test_id = 3
s = requests.session()
res = send_requests(
s,
data[test_id],
send_load,
cookies,
)
self.assertTrue(res)
#删除照片
delMenuPic_load = {
"fileNames": [case["menuPicName"]],
"ids": [case["id"]],
"doType": 0
}
logger_message.loginfo(u'%s\t入参%s\t' %
(send_time, delMenuPic_load))
delMenuPic = requests.post(
"http://epos-pc-qa.eslink.net.cn/clientSet/delMenuPic",
json=delMenuPic_load)
self.assertTrue(delMenuPic)
except Exception as Error:
logger_message.logwarning(
u"%s\t方法名：%s\t异常原因：%s" %
(send_time, sys._getframe().f_code.co_name, Error))
raise
def test_updateMember_1(self):
u"""上传图片"""
try:
data = ExcelUtil(reportxlsx, Sheet_Name).dict_data()
# login_cookies = member_updateMember.logging_wx(self)
# cookie = requests.utils.dict_from_cookiejar(login_cookies.cookies)
cookies = {
"SERVERID":
"0134fdb44fbd67e7f77378a1b20ddd4e|1525331625|1525330551",
"SESSION": "a476febd-f88d-4a94-ae6e-2d6d3631c63a",
"acw_tc": "AQAAAO+vXWy6awsAiV8RcK9IYhuUdZan",
}
test_id = 0
s = requests.session()
res = send_requests(s, data[test_id], cookie=cookies)
return res
except Exception as Error:
logger_message.logwarning('%s\t%s\t' % (send_time, Error))
raise
def test_member_updateDiscountActivity_1(self):
u"""新增会员设备信息接口"""
try:
data = ExcelUtil(reportxlsx, Sheet_Name).dict_data()
test_id = 0
s = requests.session()
res = send_requests(s, data[test_id], cookie=self.token)
self.assertTrue(res)
except Exception as Error:
logger_message.logwarning(
u"%s\t方法名：%s\t异常原因：%s" %
(send_time, sys._getframe().f_code.co_name, Error))
raise
finally:
Delect_memberdevice = member_saveMemberDeviceInfo.member_saveMemberDeviceInfo_id(
self)
logger_message.loginfo(u"%s\t方法名：%s\t执行结果：%s" %
(send_time, sys._getframe().f_code.co_name,
Delect_memberdevice))
def operation_updateIndex_3(self):
u"""更新店铺首页轮播图片接口"""
try:
queryCircleIndexList = operation_queryCircleIndexList_1(
self) # 执行查询店铺首页最后一条公告的id
get_queryCircleIndexList = queryCircleIndexList[-1]
data = ExcelUtil(report_xlsx, Sheet_Name).dict_data()
test_id = 0
s = requests.session()
res = send_requests(s,
data[test_id],
send_load=get_queryCircleIndexList,
cookie=self.token)
if str(res["responseCode"]) == '100000':
logger_message.loginfo("接口返回信息：%s" % res)
else:
logger_message.logwarning("接口返回信息：%s" % res)
except Exception as Error:
logger_message.logwarning(
u"%s\t方法名：%s\t异常原因：%s" %
(send_time, sys._getframe().f_code.co_name, Error))
raise
