def test4(self): # 获取充值前代币的储值 a = MySql.db_Query_233(self, dict['mysql']['datebase233'], dict['mysql']['查询代币']) b = re.findall(r"['](.+?)[.]", str(a)) db_befor = b[0] time.sleep(1) # 获取充值前预存款的储值 mean.wechat_login(self) time.sleep(1) mean.swipe_to_down(self) time.sleep(1) yck_befor = mean.get_text(self, dict['element']['预存款储值']) time.sleep(1) # 登录盈客宝充值代币 mean.wechat_login(self) mean.swipe_to_down(self) mean.click(self, dict['element']['代币充值按钮']) time.sleep(1) # 选择充值套餐 mean.click(self, dict['element']['商品100代币']) time.sleep(1) # 选取预存款支付 mean.click(self, dict['element']['预存款支付']) time.sleep(1) # 点击支付 mean.click(self, dict['element']['支付按钮']) time.sleep(1) # 输入会员密码 mean.input(self, dict['element']['会员密码输入框'], dict['element']['会员密码']) time.sleep(1) # 点击【确定】 mean.click(self, dict['element']['会员密码确定按钮']) time.sleep(1) # 充值后代币的储值 c = MySql.db_Query_233(self, 'YCHMALL', dict['mysql']['查询代币']) d = re.findall(r"['](.+?)[.]", str(c)) db_after = d[0] # 充值后预存款储值 time.sleep(2) mean.click(self, dict['element']['订单完成返回首页按钮']) time.sleep(1) mean.swipe_to_down(self) time.sleep(1) yck_after = mean.get_text(self, dict['element']['预存款储值']) self.driver.close() # 断言 try: assert db_befor + int(100) == db_after and yck_befor - float( 0.01) == yck_after print('代币充值成功,预存款扣款正确!') except Exception as error: print('代币充值失败!', error)
def test5(self): # 获取充值前代币的储值 a = MySql.db_Query_233(self, dict['mysql']['datebase233'], dict['mysql']['查询代币']) b = re.findall(r"['](.+?)[.]", str(a)) db_befor = b[0] # 获取充值前预存款的储值 mean.wechat_login(self) time.sleep(1) mean.swipe_to_down(self) time.sleep(1) yck_befor = mean.get_text(self, dict['element']['预存款储值']) time.sleep(1) # 登录盈客宝充值代币 mean.click(self, dict['element']['代币充值按钮']) time.sleep(1) # 选择充值套餐 mean.click(self, dict['element']['商品100代币']) time.sleep(1) # 选择微信支付 mean.click(self, dict['element']['微信支付']) time.sleep(1) mean.click(self, dict['element']['支付按钮']) time.sleep(1) mean.input(self, dict['element']['微信支付密码输入框'], dict['element']['微信支付密码']) time.sleep(1) # 获取充值后预存款储值 mean.click(self, dict['element']['订单返回按钮']) time.sleep(1) mean.swipe_to_down(self) time.sleep(1) yck_after = mean.get_text(self, dict['element']['预存款储值']) self.driver.close() # 获取充值后的的代币 c = MySql.db_Query_233(self, dict['mysql']['datebase233'], dict['mysql']['查询代币']) d = re.findall(r"['](.+?)[.]", str(c)) db_after = d[0] # 断言 try: assert db_befor + int(100) == db_after and yck_befor - float( 0.01) == yck_after print('微信充值代币成功!') except Exception as e: print('微信充值代币失败!', e)
def test6(self): # 获取当前金币储值 a = MySql.db_Query_233(self, dict['mysql']['datebase233'], dict['mysql']['查询金币']) b = re.findall(r"['](.+?)[.]", str(a)) jb_befor = b[0] # 获取当前预存款储值 mean.wechat_login(self) time.sleep(1) mean.swipe_to_down(self) time.sleep(1) yck_befor = mean.get_text(self, dict['element']['预存款储值']) time.sleep(1) mean.click(self, dict['element']['金币充值按钮']) time.sleep(1) mean.click(self, dict['element']['商品100金币']) time.sleep(1) mean.click(self, dict['element']['预存款支付']) time.sleep(1) mean.click(self, dict['element']['支付按钮']) time.sleep(1) mean.input(self, dict['element']['会员密码输入框'], dict['element']['会员密码']) time.sleep(1) mean.click(self, dict['element']['会员密码确定按钮']) time.sleep(1) mean.click(self, dict['element']['订单完成返回首页按钮']) time.sleep(1) mean.swipe_to_down(self) time.sleep(1) # 获取充值后预存款余额 yck_after = mean.get_text(self, dict['element']['预存款储值']) # 获取充值后金币储值 c = MySql.db_Query_233(self, dict['mysql']['datebase233'], dict['mysql']['查询金币']) d = re.findall(r"['](.+?)[.]", str(c)) jb_after = d[0] self.driver.close() # 断言 try: assert yck_after + float(0.01) == yck_befor and jb_befor + int( 100) == jb_after print('金币充值成功!') except Exception as err: print('金币充值失败!', err)
def BuyMeal(self): self.driver = webdriver.Chrome() url = dict['B端测试环境']['url'] self.driver.get(url) self.driver.implicitly_wait(15) self.driver.maximize_window() self.driver.find_element_by_css_selector( dict['B端测试环境']['用户名输入框']).send_keys(dict['B端测试环境']['登录用户名']) self.driver.find_element_by_css_selector( dict['B端测试环境']['密码输入框']).send_keys(dict['B端测试环境']['登录密码']) time.sleep(1) self.driver.find_element_by_css_selector(dict['B端测试环境']['登录按钮']).click() time.sleep(2) self.driver.find_element_by_css_selector(dict['B端测试环境']['线上']).click() time.sleep(2) self.driver.switch_to_frame(1) time.sleep(1) self.driver.find_element_by_css_selector(dict['B端测试环境']['线上渠道']).click() time.sleep(1) self.driver.switch_to_default_content() time.sleep(1) self.driver.switch_to_frame(2) self.driver.find_element_by_css_selector(dict['B端测试环境']['盈客宝管理']).click() time.sleep(1) self.driver.switch_to_default_content() self.driver.switch_to_frame(3) self.driver.find_element_by_css_selector(dict['B端测试环境']['会员注册设置']).click() time.sleep(1) # 选择购买入会套餐 self.driver.switch_to_frame(1) self.driver.find_element_by_css_selector(dict['B端测试环境']['购买入会套餐']).click() time.sleep(1) self.driver.find_element_by_xpath(dict['B端测试环境']['超级会员套餐复选框']).click() time.sleep(1) # 保存按钮 self.driver.find_element_by_css_selector( dict['B端测试环境']['入会方式保存按钮']).click() time.sleep(1) self.driver.close() # 断言 # 入会方式:0自动注册入会;1购买超级套餐入会 try: sql = dict['mysql']['查询会员入会方式'] result = MySql.db_Query_233(self, dict['mysql']['datebase233'], sql) result2 = re.findall(r"[(](.+?)[,]", str(result)) wayValues = result2[0] if wayValues == '0': print(r'当前入会方式为:自动注册入会!') elif wayValues == '1': print(r'当前入会方式为:购买超级套餐入会!') except Exception: print('查询入会方式失败!', Exception)
def test2(self): # 手机号注册登录 mean.phone_login(self) self.driver.close() # 断言 page_phoneNumber = self.driver.find_element_by_xpath( '//*[@class="android.view.View" and @index="2"]').text sql = 'SELECT phone FROM MEM_UserBase WHERE Phone =' + str( page_phoneNumber) text1 = MySql.db_Query_200(self, dict['mysql']['datebase200'], sql) text2 = re.findall(r"'(.+?)'", str(text1)) db_phoneNumber = text2[0] try: assert page_phoneNumber == db_phoneNumber print('微信快捷注册登录入会成功!') except Exception as e: print(e) # 清空测试数据 delete_localhost_sql = "DELETE FROM saas_member_test_20190428.MEM_UserBase WHERE Phone = " + str( page_phoneNumber) try: MySql.db_NotQuery_200(self, dict['mysql']['datebase200'], delete_localhost_sql) except Exception as err: print(err) delete_ywpt_sql1 = "update dbo.Mall_Leaguer set Phone=null where Phone = " + str( page_phoneNumber) delete_ywpt_sql2 = "update dbo.Mall_LeaguerApply set PhoneNumber=null where PhoneNumber = " + str( page_phoneNumber) delete_ywpt_sql3 = "DELETE FROM dbo.Ykb_NewMembersGivingLog WHERE Phone = " + str( page_phoneNumber) try: MySql.db_NotQuery_233(self, dict['mysql']['datebase233'], delete_ywpt_sql1) MySql.db_NotQuery_233(self, dict['mysql']['datebase233'], delete_ywpt_sql2) MySql.db_NotQuery_233(self, dict['mysql']['datebase233'], delete_ywpt_sql3) except Exception as err: print(err) # 断言数据是否清空 sql = "select Phone from saas_member_test_20190428.MEM_UserBase WHERE Phone = " + str( page_phoneNumber) sql1 = "select Phone from dbo.Mall_Leaguer where Phone = " + str( page_phoneNumber) sql2 = "select Phone from dbo.Ykb_NewMembersGivingLog where Phone = " + str( page_phoneNumber) sql3 = "select PhoneNumber from dbo.Mall_LeaguerApply where PhoneNumber = " + str( page_phoneNumber) locdb = MySql.db_Query_200(self, dict['mysql']['datebase200'], sql) ywpt1 = MySql.db_Query_233(self, dict['mysql']['datebase233'], sql1) ywpt2 = MySql.db_Query_233(self, dict['mysql']['datebase233'], sql2) ywpt3 = MySql.db_Query_233(self, dict['mysql']['datebase233'], sql3) try: assert locdb == () and ywpt1 == [] and ywpt2 == [] and ywpt3 == [] print('用户数据清除成功!') except Exception as er: print(er)