def test_02(self):
'''发送验证码,并校验'''
phone = '13152637543'
# print(phone)
# H5Method().H5_Post_register(phone,'ff123456') #注册成功
# self.logger.info('------------注册成功-----------')
# print(phone)
H5Method().reset_post_password(phone) #发送验证码
code = MyMethod().redisCode_key(
'mall:shoppingmall:smsVeriCode:FIND_BACK_LOGIN_PWD:', phone)
# print(code,type(code))
# print(eval(code),type(eval(code)))
# response=H5Method().reset_password(phone,eval(code))
# key=response.json()['data']['key'] #获取key
dict = H5Method().Excel_Dict('H5商城', '忘记密码', 2, 6, 3, 2) #核验验证码
dict['data']['phoneNum'] = phone
# dict['data']['key']=key
dict['data']['code'] = eval(code)
dict['headers']['Referer'] = 'http://192.168.12.21:81/forgetpsw/2'
data = json.dumps(dict['data'])
response = H5Method().Post_H5(dict['url'], dict['headers'],
data) #输入验证码
print(response.json())
self.assertEqual(response.json()['msg'],
MyMethod().duQu_Excel('H5商城', '忘记密码', 2, 8),
msg='点击忘记密码，无法获取或验核验验证码')
def test_009(self):
'''获取pageNum1和2，验证数据不重复'''
token = MyMethod().readToken(path)
dict = H5Method().Excel_Dict('H5商城', '分类', 9, 4, 3, 2)
# dict['url'] = dict['url'] + dict['data']['shopId']
dict['headers']['token'] = token[-1]
dict['data']['pageNum'] = 1
response = H5Method().Post_H5(dict['url'], dict['headers'],
json.dumps(dict['data']))
list_1 = response.json()['data']['list']
page_1 = []
for list_code_1 in list_1:
id_1 = list_code_1['id']
page_1.append(id_1)
#获取page_2的商品id，列表
dict['data']['pageNum'] = 2
response = H5Method().Post_H5(dict['url'], dict['headers'],
json.dumps(dict['data']))
list_2 = response.json()['data']['list']
page_2 = []
for list_code_2 in list_2:
id_2 = list_code_2['id']
page_2.append(id_2)
print(page_1, page_2)
page = page_1 + page_2
self.assertEqual(len(page),
len(list(set(page))),
msg='数据有重复，第一次加载出来的和第二次加载出来的数据重复')
def test_002(self):
'''修改一个收货地址'''
uid = eval(H5Method().token_code(
self.token))['user']['id'] #根据token获取uid
self.logger.info('读出该用户uid为：%s' % uid)
AddressUseList = Address().Address_use(uid)
self.logger.info('获取可使用收货地址列表为：{}'.format(AddressUseList))
AddressId = str(random.choice(AddressUseList)[0])
self.logger.info('获取收货地址id为：%s' % AddressId)
timeCode = time.strftime('%y%d%H%M%S', time.localtime())
phone = MyMethod().createPhone()
print(type(phone))
self.logger.info('修改后手机号码为：%s' % phone)
userName = '******'
detail = 'test地址' + timeCode
dict = H5Method().Excel_Dict('H5商城', '收货地址', 2, 4, 3, 2)
dict['headers']['token'] = self.token
dict['headers']['Referer'] = dict['headers']['Referer'] + AddressId
dict['data']['phone'] = phone
dict['data']['userName'] = userName
dict['data']['detail'] = detail
dict['data']['id'] = AddressId
response = H5Method().Post_H5(dict['url'], dict['headers'],
json.dumps(dict['data']))
self.logger.info('编辑收货地址成功')
self.assertEqual(eval(table.cell(2, 8).value)['msg'],
response.json()['msg'],
msg='编辑收货地址成功')
def test_009(self):
'''验证删除收货地址，自动默认第一个收货地址'''
#获取默认地址
dict = H5Method().Excel_Dict('H5商城', '收货地址', 9, 4, 3, 2)
dict['headers']['token'] = self.token
# 根据token里面的uid获取到该用户除默认收货地址以为的收货地址id
uid = eval(H5Method().token_code(
self.token))['user']['id'] # 根据token获取uid
self.logger.info('读出该用户uid为：%s' % uid)
a = Address().Address_OldDefault(uid)[0][0] #取出收货地址id
self.logger.info('取出该默认地址的地址id为：%s' % str(a))
dict = H5Method().Excel_Dict('H5商城', '收货地址', 9, 4, 3, 2)
dict['headers']['token'] = self.token
dict['data']['addressId'] = str(a)
response = H5Method().Post_H5(dict['url'], dict['headers'],
json.dumps(dict['data'])) #删除默认收货地址
self.assertEqual(eval(table.cell(9, 8).value)['msg'],
response.json()['msg'],
msg='删除默认地址失败')
b = Address().Address_OldDefault(uid)[0][0] # 删除之后，取出新的默认收货地址id
AddressUseList = []
print(Address().Address_use(uid))
for m in Address().Address_use(uid):
AddressUseList.append(str(m[0]))
self.logger.info('此时可用收货地址为列表：{}'.format(AddressUseList))
self.assertIn(str(b), AddressUseList, msg='新的收获地址不属于可以用的列表')
def test_008(self):
'''设置默认地址'''
dict = H5Method().Excel_Dict('H5商城', '收货地址', 4, 4, 3, 2)
dict['headers']['token'] = self.token
#根据token里面的uid获取到该用户除默认收货地址以为的收货地址id
uid = eval(H5Method().token_code(
self.token))['user']['id'] # 根据token获取uid
self.logger.info('读出该用户uid为：%s' % uid)
# 原来的默认收货地址为
OldDefault = Address().Address_OldDefault(uid)[0][0]
self.logger.info('原来的默认收货地址为：%s' % str(OldDefault))
AddressUseList = Address().Address_default(uid)
self.logger.info('获取除默认地址以外的收货地址列表为：%s' % str(AddressUseList))
AddressId = str(random.choice(AddressUseList)[0])
self.logger.info('取出预设默认收货地址为：%s' % AddressId)
self.logger.info('将原默认收货地址id：%s改为：%s' % (OldDefault, AddressId))
dict = H5Method().Excel_Dict('H5商城', '收货地址', 8, 4, 3, 2)
dict['headers']['token'] = self.token
dict['data']['addressId'] = AddressId
H5Method().Post_H5(dict['url'], dict['headers'],
json.dumps(dict['data']))
a = Address().Address_OldDefault(uid)[0][0]
print(a)
self.logger.info('原默认收货地址:%s已修改为：%s' % (OldDefault, a))
self.assertNotEqual(OldDefault, a, msg='更改之后收货地址还是一样！')
def test_002(self):
'''shop_id为空'''
token = MyMethod().readToken(path)
dict = H5Method().Excel_Dict('H5商城', '购物车', 2, 4, 3, 2)
dict['headers']['token'] = token[-1]
response = H5Method().Get_H5(dict['url'], dict['headers'], json.dumps(dict['data']))
print(response.json())
self.assertEqual(eval(table.cell(2, 8).value)['msg'], response.json()['msg'], msg='购物车列表请求未成功')
def test_004(self):
'''一件商品查看收货地址列表'''
dict = H5Method().Excel_Dict('H5商城', '收货地址', 4, 4, 3, 2)
dict['headers']['token'] = self.token
response = H5Method().Get_H5(dict['url'], dict['headers'], None)
self.logger.info('收货地址返回列表为：%s' % response.json())
self.assertEqual(eval(table.cell(4, 8).value)['systemCode'],
response.json()['systemCode'],
msg='获取收货地址未成功')
def test_005(self):
'''传入的商品id为空'''
dict = H5Method().Excel_Dict('H5商城', '商品详情', 5, 4, 3, 2)
dict['headers']['token'] = self.token
response = H5Method().Post_H5(dict['url'], dict['headers'],
json.dumps(dict['data']))
self.logger.info('商品id与shopid不一致请求后接口返回信息为：%s' % response.json())
self.assertEqual(eval(table.cell(5, 8).value)['msg'],
response.json()['msg'],
msg='提示信息不对或者未给出正确提示亦或者可以查看出商品信息')
def test_05(self):
'''shopId为空加载首页列表'''
token = MyMethod().readToken(path)
dict = H5Method().Excel_Dict('H5商城', '首页', 5, 4, 3, 2)
dict['headers']['token'] = token[-1]
response = H5Method().Post_H5(dict['url'], dict['headers'],
json.dumps(dict['data']))
self.assertEqual(eval(MyMethod().duQu_Excel('H5商城', '首页', 5,
8))['msg'],
response.json()['msg'],
msg='获取首页模板失败')
def test_003(self):
'''获取分类商品列表，传入id为空'''
token = MyMethod().readToken(path)
dict = H5Method().Excel_Dict('H5商城', '分类', 3, 4, 3, 2)
dict['url'] = dict['url'] + dict['data']['shopId']
dict['headers']['token'] = token[-1]
response = H5Method().Get_H5(dict['url'], dict['headers'],
json.dumps(dict['data']))
self.assertEqual(eval(table.cell(3, 8).value)['msg'],
response.json()['msg'],
msg='没有提示店铺不存在') # 断言msg执行成功
def test_002(self):
'''购买0件商品，确认订单'''
goodsId = Shopping().GouWuChe_add(self.token) # goodsId为商品id列表，len()之后为2
goodId = goodsId[0]
self.logger.info('确认订单页面的id为：%s' % goodId)
dict = H5Method().Excel_Dict('H5商城', '确认订单', 2, 4, 3, 2)
dict['headers']['token'] = self.token
dict['headers']['Referer'] = dict['headers']['Referer'] + str(goodId)
dict['data']['goodsId'] = goodId # 购买请求商品id 购买请求商品数量默认为1
response = H5Method().Post_H5(dict['url'], dict['headers'], json.dumps(dict['data']))
self.logger.info('返回内容为：\n%s' % response.json())
self.assertEqual(eval(table.cell(2, 8).value)['msg'], response.json()['msg'], msg='跳转确认订单页面未成功') # 断言是否成功
def test_012(self):
'''已过期列表'''
dict = H5Method().Excel_Dict('H5商城', '确认订单', 11, 4, 3, 2)
dict['headers']['token'] = self.token
response = H5Method().Post_H5(dict['url'], dict['headers'], json.dumps(dict['data']))
numberCode = len(response.json()['data'])
self.logger.info('查询所有可用优惠券内容，返回列表为：%s' % response.json())
self.logger.info('查询该用已使用优惠券数量为：%s' % numberCode)
tokenCode = eval(H5Method().token_code(self.token))
shopId = tokenCode['user']['shopId']
userId = tokenCode['user']['id']
couponNumber = ProductDetails().CouponNumber(2, shopId, userId)
self.assertEqual(couponNumber, numberCode, msg='该用户预期返回条数和实际返回条数不相符')
def test_08(self):
'''goodsId为空，查看商品详情'''
token = MyMethod().readToken(path) # 取出token保持登录
dict = H5Method().Excel_Dict('H5商城', '首页', 8, 4, 3, 2) # 取出Excel表格内容
# goodsId = int(dict['data']['goodsId']) # 从Excel表格中获取分销商商品id
# dict['headers']['Referer'] = dict['headers']['Referer'] + str(goodsId) # Referer+id
dict['headers']['token'] = token[-1]
response = H5Method().Post_H5(dict['url'], dict['headers'],
json.dumps(dict['data']))
self.assertEqual(eval(MyMethod().duQu_Excel('H5商城', '首页', 8,
8))['msg'],
response.json()['msg'],
msg='goodsId与shopid不一致可以查看商品详情')
def test08(self):
'''输入密码低于六位'''
response = H5Method().set_password()
key = response.json()['data']['key']
a = H5Method().Excel_Dict('H5商城', '注册', 8, 4, 3, 2)
data = a['data']
data['key'] = key
data = json.dumps(data)
print(type(data), data)
response = H5Method().Post_H5(a['url'], a['headers'], data)
self.assertEqual(MyMethod().duQu_Excel('H5商城', '注册', 8, 8),
response.json()['msg'],
msg='注册不成功')
def test_007(self):
'''验证shopId与分类id不匹配'''
token = MyMethod().readToken(path)
dict = H5Method().Excel_Dict('H5商城', '分类', 7, 4, 3, 2)
# dict['url'] = dict['url'] + dict['data']['shopId']
dict['headers']['token'] = token[-1]
response = H5Method().Post_H5(dict['url'], dict['headers'],
json.dumps(dict['data']))
self.assertEqual(eval(table.cell(7, 8).value)['msg'],
response.json()['msg'],
msg='没有提示店铺不存在') # 断言msg执行成功
number_response = len(response.json()['data']['list']) #返回list商品数量
self.assertEqual(0, number_response, msg='分类id不存在，出现了商品')
def test03(self):
'''验证一分种内只能申请一次'''
a = H5Method().Excel_Dict('H5商城', '注册', 3, 4, 3, 2)
self.logger.info('注册登录/注册-Excel表格获取内容为：\n%s' % a)
phoneNum = MyMethod().createPhone()
self.logger.info('随机生成手机号码为：%s' % phoneNum)
data = {'phoneNum': phoneNum, 'shopId': str(a['data'])}
data = json.dumps(data)
self.logger.info('待传入json格式内容data是：%s' % data)
msg_ = MyMethod().duQu_Excel('H5商城', '注册', 3, 8)
H5Method().Post_H5(a['url'], a['headers'], data)
response1 = H5Method().Post_H5(a['url'], a['headers'], data)
self.assertEqual(msg_, response1.json()['msg'], msg='连续发送验证码存在异常')
def test_01(self):
'''获取店铺模板信息'''
token = MyMethod().readToken(path)
dict = H5Method().Excel_Dict('H5商城', '首页', 1, 4, 3, 2)
dict['headers']['token'] = token[-1]
response = H5Method().Post_H5(dict['url'], dict['headers'],
json.dumps(dict['data']))
self.assertEqual(eval(MyMethod().duQu_Excel('H5商城', '首页', 1,
8))['msg'],
response.json()['msg'],
msg='获取首页模板失败')
self.assertIn(eval(MyMethod().duQu_Excel('H5商城', '首页', 1,
8))['data']['templateType'],
[1, 2, 3],
msg='获取首页模板失败')
def test_003(self):
'''查看收货地址内容'''
uid = eval(H5Method().token_code(
self.token))['user']['id'] # 根据token获取uid
self.logger.info('读出该用户uid为：%s' % uid)
AddressUseList = Address().Address_use(uid)
AddressId = str(random.choice(AddressUseList)[0])
dict = H5Method().Excel_Dict('H5商城', '收货地址', 3, 4, 3, 2)
self.logger.info('获取的参数列表为：%s' % dict)
dict['headers']['token'] = self.token
dict['headers']['Referer'] = dict['headers']['Referer'] + AddressId
dict['data']['addressId'] = AddressId
response = H5Method().Post_H5(dict['url'], dict['headers'],
json.dumps(dict['data']))
print(response.json())
def test_005(self):
goodsId = Shopping().GouWuChe_add(self.token) # goodsId为商品id列表，len()之后为2
goodId = goodsId[0]
self.logger.info('确认订单页面的id为：%s' % goodId)
dict = H5Method().Excel_Dict('H5商城', '确认订单', 5, 4, 3, 2)
dict['headers']['token'] = self.token
dict['headers']['Referer'] = dict['headers']['Referer'] + str(goodId)
dict['data']['goodsId'] = goodId # 购买请求商品id 购买请求商品数量默认为1
H5Method().updateSQl(goodId, 1, 1) # 修改商品库存以及状态
response = H5Method().Post_H5(dict['url'], dict['headers'], json.dumps(dict['data']))
H5Method().updateSQl(goodId, 4546545, 1) # 还原商品库存以及状态
self.logger.info('返回内容为：\n%s' % response.json())
# self.assertEqual(eval(table.cell(2, 8).value)['msg'], response.json()['msg'], msg='跳转确认订单页面未成功') # 断言是否成功
self.assertEqual(eval(table.cell(5, 8).value),
response.json(), msg='购买数量大于库存数量，该接口判断异常')
def test01(self):
'''未注册手机号码第一次注册'''
msg_ = MyMethod().duQu_Excel('H5商城', '注册', 1, 8)
response = H5Method().Post_register('H5商城', '注册', 1, 4, 3, 2)
self.assertEqual(msg_, response.json()['msg'], msg='短信验证码未发送成功')
def test_01(self):
'''发送验证码'''
response = H5Method().Post_register('H5商城', '忘记密码', 1, 4, 3, 2)
print(response.json()['msg'])
self.assertEqual(MyMethod().duQu_Excel('H5商城', '忘记密码', 1, 8),
response.json()['msg'],
msg='忘记密码，无法发送验证码')
def test_12(self):
'''buyNum 传入大于1'''
token = MyMethod().readToken(path) # 取出token保持登录
dict = H5Method().Excel_Dict('H5商城', '首页', 12, 4, 3, 2) # 取出Excel表格内容
id = int(dict['data']['goodId'])
H5Method().updateSQl(id, 1, 1)
goodId = int(dict['data']['goodId']) # 从Excel表格中获取分销商商品id
dict['headers']['Referer'] = dict['headers']['Referer'] + str(
goodId) # Referer+id
dict['headers']['token'] = token[-1]
response = H5Method().Post_H5(dict['url'], dict['headers'],
json.dumps(dict['data']))
self.assertEqual(eval(MyMethod().duQu_Excel('H5商城', '首页', 12,
8))['msg'],
response.json()['msg'],
msg='存在库存，加入购物车不成功')
def test_07(self):
'''验证码小于六位'''
phone = '15220331480'
response = H5Method().resetPassWordMthod(phone, 7, '12345') # 修改密码
self.assertEqual(response.json()['msg'],
MyMethod().duQu_Excel('H5商城', '忘记密码', 7, 8),
msg='修改密码失败')
def test_005(self):
'''获取指定分类的商品数量'''
token = MyMethod().readToken(path)
dict = H5Method().Excel_Dict('H5商城', '分类', 5, 4, 3, 2)
# dict['url'] = dict['url'] + dict['data']['shopId']
dict['headers']['token'] = token[-1]
response = H5Method().Post_H5(dict['url'], dict['headers'],
json.dumps(dict['data']))
self.assertEqual(eval(table.cell(5, 8).value)['msg'],
response.json()['msg'],
msg='没有提示店铺不存在') # 断言msg执行成功
#判断数据库该分类商品数-对比接口返回数量是否OK
numberSQL = IfiCation().SumShopping(dict['data']['categoryId'])
number = numberSQL[-1][-1] #数据库该商品分类商品数量
number_response = len(response.json()['data']['list'])
self.assertEqual(number, number_response, msg='接口返回数据与查询数据数量不一致')
def test_005(self):
'''验证最大添加收货地址数量'''
#第一步获取收货地址list总数量
dict = H5Method().Excel_Dict('H5商城', '收货地址', 4, 4, 3, 2)
dict['headers']['token'] = self.token
response = H5Method().Get_H5(dict['url'], dict['headers'], None)
oldNumber = len(response.json()['data'])
AddressNumber = 10 - oldNumber
for a in range(1, AddressNumber + 1): #循环添加使收货地址列表达到十个数量
Address().Address_add(self.token, 1, 4, 3, 2)
self.logger.info('添加第【%s】个收货地址成功' % (oldNumber + a))
response = Address().Address_add(self.token, 1, 4, 3, 2)
self.logger.info('添加第【11】个收货地址')
self.assertEqual(eval(table.cell(5, 8).value)['msg'],
response['msg'],
msg='允许添加第11个收货地址')
self.logger.info('添加第【11】个收货地址失败')
def test_08(self):
'''验证码大于20位'''
phone = '15090451148'
response = H5Method().resetPassWordMthod(
phone, 8, '123456789912345678991') # 修改密码
self.assertEqual(response.json()['msg'],
MyMethod().duQu_Excel('H5商城', '忘记密码', 8, 8),
msg='修改密码失败')
def test_001(self):
'''获取分类列表'''
token = MyMethod().readToken(path)
dict = H5Method().Excel_Dict('H5商城', '分类', 1, 4, 3, 2)
dict['url'] = dict['url'] + dict['data']['shopId']
dict['headers']['token'] = token[-1]
response = H5Method().Get_H5(dict['url'], dict['headers'],
json.dumps(dict['data']))
list_data = eval(table.cell(1, 8).value)['data'] #预期返回商品分类数量
list_data_sql = IfiCation().selectSQL(
dict['data']['shopId']) #获取数据库商品分类数量
self.assertEqual(eval(table.cell(1, 8).value)['msg'],
response.json()['msg'],
msg='获取分类列表失败') # 断言msg执行成功
self.assertEqual(len(list_data),
len(list_data_sql),
msg='数据库商品分类与接口返回数量不一致') # 断言分类数量
def test_05(self):
'''密码纯英文'''
phone = '15843675850'
response = H5Method().resetPassWordMthod(phone, 5, 'fffffff')
self.logger.info('修改密码为：fffffff')
self.assertEqual(MyMethod().duQu_Excel('H5商城', '忘记密码', 5, 8),
response.json()['msg'],
msg='修改密码失败')
def test_06(self):
'''密码存数字'''
phone = '18670030712'
response = H5Method().resetPassWordMthod(phone, 6, '123456') #修改密码
self.assertEqual(response.json()['msg'],
MyMethod().duQu_Excel('H5商城', '忘记密码', 6, 8),
msg='修改密码失败')
def test_006(self):
'''删除一个收货地址'''
dict = H5Method().Excel_Dict('H5商城', '收货地址', 4, 4, 3, 2) #查看商品数量总和
dict['headers']['token'] = self.token
response = H5Method().Get_H5(dict['url'], dict['headers'], None)
oldNumber = len(response.json()['data'])
uid = eval(H5Method().token_code(
self.token))['user']['id'] # 根据token获取uid
self.logger.info('读出该用户uid为：%s' % uid)
AddressUseList = Address().Address_use(uid)
self.logger.info('获取到可使用的收货地址列表：%s' % str(AddressUseList))
AddressId = str(random.choice(AddressUseList)[0])
self.logger.info('预删除的收货地址id为：%s' % AddressId) #根据uid获取收货地址列表
dict = H5Method().Excel_Dict('H5商城', '收货地址', 6, 4, 3, 2)
dict['headers']['token'] = self.token
dict['data']['addressId'] = AddressId
H5Method().Post_H5(dict['url'], dict['headers'],
json.dumps(dict['data']))
self.logger.info('删除收货地址成功')
dict = H5Method().Excel_Dict('H5商城', '收货地址', 4, 4, 3, 2) # 查看商品数量总和
dict['headers']['token'] = self.token
response = H5Method().Get_H5(dict['url'], dict['headers'], None)
newNumber = len(response.json()['data'])
self.assertEqual(oldNumber - 1, newNumber, msg='删除之后和删除之前的收货地址数量一样！')