def test(self):
print('>>>>>>>>>>>>>>>>>>>未填收货地址 >> 跳转至收货地址填写<<<<<<<<<<<<<<<<<<<<<<')
# 环境检测
intializating.initialization.environmentPrepar(self)
time.sleep(1)
# 清空收货地址
MySql.db_NotQuery(self, dict_load['mysql']['清空收货地址db'],
dict_load['mysql']['清空收货地址sql'])
time.sleep(1)
# 选取商品
get_goods.get_goods(self)
time.sleep(1)
loc = (By.CSS_SELECTOR, dict_load['商品']['立即兑换'])
WebDriverWait(self.driver, 5).until(
expected_conditions.visibility_of_element_located(loc))
means.click(self, 'css', dict_load['商品']['立即兑换'])
time.sleep(1)
# 获取跳转收货地址填写页面截图
means.get_img(self)
time.sleep(1)
# 获取收货地址页面元素
text = means.get_text(self, 'css', dict_load['C端页面元素']['收货地址页面'])
text1 = re.search(r"^(....)", str(text))
text2 = text1.group()
time.sleep(1)
print(
'********************************状态*******************************************'
)
print('跳转到页面信息：', format(str(text)))
print(
'********************************断言*******************************************'
)
# 断言
assert text2 == '收货地址'
print('用例通过！')
def test(self):
print(
'###############>>>>>>选择数量大于库存数量，提示库存不足，无法下单>>>>>>>#################'
)
# 环境检测
intializating.initialization.environmentPrepar(self)
time.sleep(1)
# 获取下单前积分值
jifen_before = table.read(self, 0)
time.sleep(1)
# 获取下单前菜籽值
caiz_before = intializating.initialization.get_caizi_values(self)
time.sleep(1)
# 订单下单前订单总数
count_order_on_db_before = intializating.initialization.get_countOrder_values(
self)
time.sleep(1)
# 判断积分是否能足以支付商品
get_goods.get_goods(self)
time.sleep(2)
loc = (By.CSS_SELECTOR, dict_load['商品']['点击规格'])
WebDriverWait(self.driver, 5).until(
expected_conditions.visibility_of_element_located(loc))
means.click(self, 'css', dict_load['商品']['点击规格'])
time.sleep(2)
means.click(self, 'css', dict_load['商品']['输入商品数量'])
means.input(self, 'css', dict_load['商品']['输入商品数量'], '100')
time.sleep(2)
means.click(self, 'css', dict_load['商品']['保存'])
time.sleep(2)
# 这里手动执行不会触发查询库存接口
kucunbuzu = means.get_text(self, 'css', dict_load['商品']['立即兑换'])
'''''' '''
loc = (By.CSS_SELECTOR,dict_load['商品']['兑换'])
WebDriverWait(self.driver,5).until(expected_conditions.visibility_of_element_located(loc))
means.click(self, 'css', dict_load['商品']['兑换'])
time.sleep(2)
loc = (By.CSS_SELECTOR,dict_load['商品']['库存不足'])
WebDriverWait(self.driver,5).until(expected_conditions.visibility_of_element_located(loc))
kucunbuzu = means.get_text(self,'css',dict_load['商品']['库存不足'])
'''
# 购买商品后积分余额
jifen_after_pay = table.read(self, 1)
# 购买商品后菜籽余额
caizi_after_pay = intializating.initialization.get_caizi_values(self)
# 购买商品后总订单量
count_order_on_db_after = intializating.initialization.get_countOrder_values(
self)
print(
'********************************金额*******************************************'
)
print('原先用户菜籽：{1}'.format(self, caiz_before))
print('原先用户积分：{1}'.format(self, jifen_before[0]))
print('原先数据库订单数：{1}'.format(self, count_order_on_db_before))
print(
'******************************剩余金额*****************************************'
)
print('剩余积分：{1}'.format(self, jifen_after_pay[0]))
print('剩余菜籽：{1}'.format(self, caizi_after_pay))
print(
'********************************订单*******************************************'
)
print('数据库订单总数：{1}'.format(self, count_order_on_db_after))
print(
'********************************断言*******************************************'
)
try:
#assert kucunbuzu == '商品库存不足(10000)'
assert kucunbuzu == '库存不足'
print('提示【库存不足】，无法下单！')
assert count_order_on_db_after == count_order_on_db_before
print('数据库用例执行前和用例执行后订单总数一致，无法下单！')
assert jifen_after_pay[0] == jifen_before[0]
print('用例执行前积分余额和用例执行后积分余额一致，无法下单！')
assert caizi_after_pay == caiz_before
print('用例执行前菜籽余额和用例执行后菜籽余额一致，无法下单！')
except:
print('断言出现问题，请检查！')
# excel数据清理
table.wipe_excel(self)
def test(self):
print(
'###############>>>积分不足>>>提示不足，无法下单>>>查看状态，未进入待发货#################'
)
# 环境检测
intializating.initialization.environmentPrepar(self)
time.sleep(1)
# 获取下单前积分值
jifen_before = table.read(self, 0)
time.sleep(1)
# 获取下单前菜籽值
caiz_before = intializating.initialization.get_caizi_values(self)
time.sleep(1)
# 订单下单前订单总数
count_order_on_db_before = intializating.initialization.get_countOrder_values(
self)
time.sleep(1)
# 商品选择
means.click(self, 'css', dict_load['商品']['goods3'])
time.sleep(1)
means.clear(self, 'css', dict_load['商品']['输入商品数量'])
means.input(self, 'css', dict_load['商品']['输入商品数量'], '100')
time.sleep(1)
means.click(self, 'css', dict_load['商品']['保存'])
loc = (By.CSS_SELECTOR, dict_load['商品']['立即兑换文本'])
WebDriverWait(self.driver, 5).until(
expected_conditions.visibility_of_element_located(loc))
text = means.get_text(self, 'css', dict_load['商品']['立即兑换文本'])
# 购买商品后积分余额
jifen_after_pay = table.read(self, 1)
# 购买商品后菜籽余额
caizi_after_pay = intializating.initialization.get_caizi_values(self)
# 购买商品后总订单量
count_order_on_db_after = intializating.initialization.get_countOrder_values(
self)
print(
'********************************金额*******************************************'
)
print('原先用户积分：{1}'.format(self, jifen_before[0]))
print('原先用户菜籽：{1}'.format(self, caiz_before))
print('原先数据库订单数：{1}'.format(self, count_order_on_db_before))
print(
'******************************剩余金额*****************************************'
)
print('test_1后剩余积分：{1}'.format(self, jifen_after_pay[0]))
print('test_1后剩余菜籽：{1}'.format(self, caizi_after_pay))
print(
'********************************订单*******************************************'
)
print('数据库订单总数：{1}'.format(self, count_order_on_db_after))
print(
'********************************断言*******************************************'
)
# 断言提示积分不足，订单数没有增加
try:
assert text == '积分不足'
print('积分不足，无法下单！')
assert int(count_order_on_db_before) == int(
count_order_on_db_after)
print('无法下单！订单没有增加')
assert int(caizi_after_pay) == int(caiz_before)
print('无法下单，菜籽不变！')
assert int(jifen_before[0]) == int(jifen_after_pay[0])
print('无法下单，积分不变！')
except:
print('断言失败！')
# excel数据清理
table.wipe_excel(self)
def test(self):
print('>>>>>>>>>>>>>>>>>>>确认订单页修改地址，下单成功，收货地址更改修改后地址<<<<<<<<<<<<<<<<<<<<<<')
# 环境检测
intializating.initialization.environmentPrepar(self)
time.sleep(1)
# 获取下单前积分值
jifen_before = table.read(self,0)
time.sleep(1)
# 获取下单前菜籽值
caiz_before = intializating.initialization.get_caizi_values(self)
time.sleep(1)
# 订单下单前订单总数
count_order_on_db__before = intializating.initialization.get_countOrder_values(self)
time.sleep(1)
# 判断积分是否能足以支付商品
get_goods.get_goods(self)
# 获取之前的收货地址
address = means.get_text(self,'css',dict_load['收货地址']['收货地址'])
time.sleep(2)
means.click(self,'css',dict_load['商品']['立即兑换'])
# 获取商品价格和商品邮费之和
count_jifen_pay = means.get_text(self,'css',dict_load['商品']['商品积分价格和积分邮费之和'])
time.sleep(1)
# 修改收货地址
means.click(self,'css',dict_load['收货地址']['订单页面修改地址'])
time.sleep(2)
inputAddr.input_addr(self)
time.sleep(1)
means.click(self,'css',dict_load['商品']['兑换'])
time.sleep(1)
means.click(self,'css',dict_load['C端页面元素']['查看订单'])
time.sleep(2)
means.click(self,'css',dict_load['C端页面元素']['待发货列表商品1'])
time.sleep(2)
new_address = means.get_text(self,'css',dict_load['C端页面元素']['收货地址信息'])
time.sleep(1)
# 购买商品后积分余额
jifen_after_pay = table.read(self,1)
# 购买商品后菜籽余额
caizi_after_pay = intializating.initialization.get_caizi_values(self)
# 支付商品的菜籽
caiz_Pay = table.read(self,2)
# C端新增订单号
new_OrderNumber_On_C_h5 = table.read(self,4)
# B端新增订单号
new_OrderNumber_On_B_h5 = table.read(self,3)
# 数据库新增订单号
new_OrderNumber_On_db = intializating.initialization.get_NewOrderNumber_On_db(self)
# 购买商品后总订单量
count_order_on_db_after = intializating.initialization.get_countOrder_values(self)
# 判断订单状态>>>>待发货
status = table.read(self,5)
print('********************************金额*******************************************')
print('原先用户积分:{1}'.format(self,jifen_before[0]))
print('原先用户菜籽：{1}'.format(self,caiz_before))
print('原先数据库订单数：{1}'.format(self,count_order_on_db__before))
print('购买商品花费的积分:{1}'.format(self,count_jifen_pay))
print('购买商品花费的菜籽：{1}'.format(self,caizi_after_pay))
print('******************************剩余金额*****************************************')
print('剩余积分：{1}'.format(self,jifen_after_pay[0]))
print('剩余菜籽：{1}'.format(self,caizi_after_pay))
print('********************************订单*******************************************')
print('B端新增订单号：{1}'.format(self,new_OrderNumber_On_B_h5[0]))
print('C端新增订单号：{1}'.format(self,new_OrderNumber_On_C_h5[0]))
print('数据库新增订单号：{1}'.format(self,new_OrderNumber_On_db))
print('数据库订单总数：{1}'.format(self,count_order_on_db_after))
print('订单状态：{1}'.format(self,status[0]))
print('********************************断言*******************************************')
print(r"修改前地址：",format(address))
print(r"修改后地址：",format(new_address))
assert int(jifen_before[0]) == int(jifen_after_pay) + int(count_jifen_pay)
print('用户积分断言成功！')
assert int(count_order_on_db_after) == int(count_order_on_db__before) + 1
print('订单写入数据库成功！')
assert int(caiz_before) == int(caizi_after_pay[0]) + int(caiz_Pay[0])
print('商家菜籽断言成功！')
# excel数据清理
table.wipe_excel(self)
def test(self):
print('>>>>>>>>>>>>>选择规格/数量/收货地址下单成功积分、菜籽、预存款扣除数额准确,状态切入待发货，C端B端生成订单<<<<<<<<<<<<<<')
# 环境检测
intializating.initialization.environmentPrepar(self)
time.sleep(1)
# 获取下单前积分值
jifen_before = table.read(self,0)
time.sleep(1)
# 获取下单前菜籽值
caiz_before = intializating.initialization.get_caizi_values(self)
time.sleep(1)
# 订单下单前订单总数
count_order_on_db_before = intializating.initialization.get_countOrder_values(self)
time.sleep(1)
# 判断积分是否能足以支付商品
get_goods.get_goods(self)
# 填写收货地址
means.click(self,'css',dict_load['收货地址']['点击收货地址'])
time.sleep(1)
inputAddr.input_addr(self)
time.sleep(1)
means.click(self,'css',dict_load['商品']['立即兑换'])
# 获取商品积分价格和商品积分邮费
Price = means.get_text(self,'css',dict_load['商品']['商品积分价格和积分邮费之和'])
means.click(self, 'css', dict_load['商品']['兑换'])
# 购买商品后积分余额
jifen_after_pay = table.read(self,1)
# 购买商品后菜籽余额
caizi_after_pay = intializating.initialization.get_caizi_values(self)
# 支付商品的菜籽
caiz_Pay = table.read(self,2)
# C端新增订单号
new_OrderNumber_On_C_h5 = table.read(self,4)
# B端新增订单号
new_OrderNumber_On_B_h5 = table.read(self,3)
# 购买商品后总订单量
count_order_on_db_after = intializating.initialization.get_countOrder_values(self)
# 判断订单状态>>>>待发货
status = table.read(self,5)
print('********************************金额*******************************************')
print('原先用户积分:{1}'.format(self,jifen_before[0]))
print('原先用户菜籽：{1}'.format(self,caiz_before))
print('原先数据库订单数：{1}'.format(self, count_order_on_db_before))
print('购买商品花费的积分:{1}'.format(self,Price))
print('购买商品花费的菜籽:{1}'.format(self,caiz_Pay[0]))
print('******************************剩余金额*****************************************')
print('剩余积分：{1}'.format(self,jifen_after_pay[0]))
print('剩余菜籽：{1}'.format(self,caizi_after_pay))
print('********************************订单*******************************************')
print('C端新增订单号：{1}'.format(self,new_OrderNumber_On_C_h5[0]))
print('B端新增订单号：{1}'.format(self,new_OrderNumber_On_B_h5[0]))
print('数据库订单总数：{1}'.format(self,count_order_on_db_after))
print('订单状态：{1}'.format(self,status[0]))
print('********************************断言*******************************************')
# 断言
try:
assert int(jifen_before[0]) == int(Price) + int(jifen_after_pay[0]),int(caiz_before) == int(caiz_before) + int(caiz_Pay[0])
assert int(count_order_on_db_after) == int(count_order_on_db_before) + 1
print('商品积分扣除正确！')
print('商家菜籽扣除正确！')
print('订单写入数据库成功！')
except:
return False
# excel数据清理
table.wipe_excel(self)