def test_buy_Beauti(self): '''购买美丽田园测试用例''' convergedPage=ConvergedPage(self.drvier) (user_phone,pwd)=convergedPage.register_customer() amount='100000' self.drvier=appium_init.inital.get_driver() startupPage = StartupPage(self.drvier) homePage = startupPage.page_swipe() loginPage = homePage.logic_link_login_page() homePage = loginPage.logic_login(user_phone, pwd) # 点击一次理财产品元素,过滤蒙层 homePage.el_product_btn.click() time.sleep(0.5) productListPage = homePage.logic_link_product() time.sleep(2) productListPage.swipe_to_up() time.sleep(2) productBeautiPage = productListPage.logic_link_beauti() buyInsertMoneyPage=productBeautiPage.logic_link_buy() buyConfirmPage = buyInsertMoneyPage.logic_buy_product(amount) buyTradeResultPage = buyConfirmPage.logic_confirm_info(pwd) time.sleep(20) homePage = buyTradeResultPage.logic_link_buy() myPage = homePage.logic_buy_my_btn() # 数据库断言,查询投资记录最新的记录根据金额判断 SQL = "select top(1) m.new_managemoney,m.new_product_name from dbo.Account t,dbo.new_investdetail m where t.name=m.new_accountnameName and t.new_telephone1=%s ORDER BY m.CreatedOn DESC" % ( user_phone) sql_conn = Exce_SQLserver() sql_result=sql_conn.execSql_getOne(SQL) sql_amount = int(sql_result[0]) sql_product_name=str(sql_result[1]) buyTradeResultPage.saveScreenshot('test_buy_Beauti') self.assertEqual(int(amount), sql_amount) self.logger.info("run case:test_buy_Beauti user_phone is %s,product_name is %s" %(user_phone,sql_product_name)) self.assertEqual("夸客美丽*360天", sql_product_name)
def test_buy_annualInterestRise(self): '''购买年年生利用例''' user_phone = self.inital.excel_info['annualInterestRise']['phone'] pwd = self.inital.excel_info['annualInterestRise']['pwd'] amount = self.inital.excel_info['annualInterestRise']['amount'] startupPage = StartupPage(self.drvier) homePage = startupPage.page_swipe() loginPage = homePage.logic_link_login_page() homePage = loginPage.logic_login(user_phone, pwd) # 点击一次理财产品元素,过滤蒙层 homePage.el_product_btn.click() time.sleep(0.5) productListPage = homePage.logic_link_product() time.sleep(1) productListPage.swipe_to_up() time.sleep(1) productAnnualInterestRisePage = productListPage.logic_link_annualInterestRise( ) buyInsertMoneyPage = productAnnualInterestRisePage.logic_link_buy() buyConfirmPage = buyInsertMoneyPage.logic_buy_product(amount) buyTradeResultPage = buyConfirmPage.logic_confirm_info(pwd) time.sleep(20) homePage = buyTradeResultPage.logic_link_buy() myPage = homePage.logic_buy_my_btn() # 数据库断言,查询投资记录最新的记录根据金额判断 SQL = "select top(1) m.new_managemoney,m.new_product_name from dbo.Account t,dbo.new_investdetail m where t.name=m.new_accountnameName and t.new_telephone1=%s ORDER BY m.CreatedOn DESC" % ( user_phone) sql_conn = Exce_SQLserver() sql_result = sql_conn.execSql_getOne(SQL) sql_amount = int(sql_result[0]) sql_product_name = str(sql_result[1]) buyTradeResultPage.saveScreenshot('test_buy_annualInterestRise') self.assertEqual(int(amount), sql_amount) self.logger.info( "run case:ProductBuyAnnualInterestRise.test_buy_annualInterestRise user_phone is %s,product_name is %s" % (user_phone, sql_product_name)) self.assertEqual("年年生利*360天", sql_product_name)
def test_buy_quarkZX90(self): '''购买夸客尊享90天测试用例''' user_phone=self.inital.excel_info['quarkZX90']['phone'] pwd=self.inital.excel_info['quarkZX90']['pwd'] amount=self.inital.excel_info['quarkZX90']['amount'] startupPage=StartupPage(self.drvier) homePage=startupPage.page_swipe() loginPage=homePage.logic_link_login_page() homePage=loginPage.logic_login(user_phone,pwd) #点击一次理财产品元素,过滤蒙层 homePage.el_product_btn.click() time.sleep(0.5) productListPage=homePage.logic_link_product() productQuarkzxPage=productListPage.logic_link_quarkZX() productQuarkzxPage.logic_choose_product_type(3) buyInsertMoneyPage=productQuarkzxPage.logic_link_buy() buyConfirmPage=buyInsertMoneyPage.logic_buy_product(amount) buyTradeResultPage=buyConfirmPage.logic_confirm_info(pwd) time.sleep(20) homePage=buyTradeResultPage.logic_link_buy() myPage=homePage.logic_buy_my_btn() #数据库断言,查询投资记录最新的记录根据金额判断 SQL="select top(1) m.new_managemoney,m.new_product_name from dbo.Account t,dbo.new_investdetail m where t.name=m.new_accountnameName and t.new_telephone1=%s ORDER BY m.CreatedOn DESC" %(user_phone) sql_conn=Exce_SQLserver() sql_result = sql_conn.execSql_getOne(SQL) sql_amount = int(sql_result[0]) sql_product_name = str(sql_result[1]) self.basepage = BasePage(self.drvier) self.basepage.saveScreenshot('buy_quarkZX90') self.assertEqual(int(amount),sql_amount) self.assertEqual("夸客尊享*90天",sql_product_name) self.logger.info("run case:test_buy_quarkZX90")
def test_buy_van_Gogh180(self): '''购买梵高计划180天脚本,和buy_prodouct_info.xlsx数据源对应''' user_phone = self.inital.buyProduct_info['van_Gogh180']['phone'] pwd = self.inital.buyProduct_info['van_Gogh180']['pwd'] amount = self.inital.buyProduct_info['van_Gogh180']['amount'] times = self.inital.buyProduct_info['van_Gogh180']['times'] exec_flag = self.inital.buyProduct_info['van_Gogh180']['exec'] load_create = self.inital.buyProduct_info['van_Gogh180']['load_create'] if amount == "" or times == "" or exec_flag == "" or load_create == "": self.logger.info( "BuyProductScriptVanGogh.test_buy_van_Gogh180: buy_info excel parms is wrong!" ) return "buy_info excel parms is wrong!" elif exec_flag == 'N' or times == '0': self.logger.info( 'BuyProductScriptVanGogh.test_buy_van_Gogh180: do not buy product van_Gogh180!' ) return "do not buy product van_Gogh180!" if load_create == 'N': self.driver = self.inital.get_driver() convergedPage = ConvergedPage(self.driver) user_phone, pwd = convergedPage.register_customer() elif load_create == "Y" and (user_phone == "" or pwd == ""): self.logger.info( "BuyProductScriptVanGogh.test_buy_van_Gogh180: user_phone pwd value can not be null!" ) return "BuyProductScriptVanGogh.test_buy_van_Gogh180: user_phone pwd value can not be null!" for i in xrange(int(times)): try: self.driver = self.inital.get_driver() startupPage = StartupPage(self.driver) homePage = startupPage.page_swipe() loginPage = homePage.logic_link_login_page() homePage = loginPage.logic_login(user_phone, pwd) # 点击一次理财产品元素,过滤蒙层 homePage.el_product_btn.click() time.sleep(0.5) productListPage = homePage.logic_link_product() productVanGoghPage = productListPage.logic_link_van_Gogh() productVanGoghPage.logic_choose_product_type(1) buyInsertMoneyPage = productVanGoghPage.logic_link_buy() buyConfirmPage = buyInsertMoneyPage.logic_buy_product(amount) buyTradeResultPage = buyConfirmPage.logic_confirm_info(pwd) time.sleep(20) homePage = buyTradeResultPage.logic_link_buy() myPage = homePage.logic_buy_my_btn() SQL = "select top(1) m.new_managemoney,m.new_name from dbo.Account t,dbo.new_investdetail m where t.name=m.new_accountnameName and t.new_telephone1=%s ORDER BY m.CreatedOn DESC" % ( user_phone) sql_conn = Exce_SQLserver() sql_result = sql_conn.execSql_getOne(SQL) sql_amount = int(sql_result[0]) sql_productNo = str(sql_result[1]) self.logger.info( "BuyProductScriptVanGogh.test_buy_van_Gogh180:run {one} time;" "phone is {two};" "pwd is {three};" "product is {four};" "amount is {five}".format(one=(i + 1), two=user_phone, three=pwd, four=sql_productNo, five=sql_amount)) except Exception as e: self.logger.info("buy_van_Gogh180 failed!" + str(e)) finally: self.driver.quit()