def test_quiting_data(self): """投资记录-退出中资产详情数据验证""" entry_page = Entry_page(self.driver,phone='14477650717',pwd='qwe123') MyAssetDetailsPage = entry_page.open_my_assetDetails_quiting_page() #获得资产详情页列表数据,默认获得第index=0 个 time.sleep(1.5) assetdetails_list=MyAssetDetailsPage.get_assetdetails_list() time.sleep(2) pact_title=MyAssetDetailsPage.el_pact_title_btn.text #查询DB 获得理财中第一个理财的合同编号 sql = Exce_SQLserver() contract_number = sql.execSql_getList("SELECT top 1 new_name from new_investdetailBase WHERE new_accountname = '331C4E9C-D93A-E711-80D3-00155D02B414' AND new_status=100000003 order BY new_instreststartdate desc") #查询DB 获得理财产品名称 sql = Exce_SQLserver() product_name = sql.execSql_getList( "SELECT top 1 new_product_name from new_investdetailBase WHERE new_accountname = '331C4E9C-D93A-E711-80D3-00155D02B414' AND new_status=100000003 order BY new_instreststartdate desc") #断言 self.basepage = BasePage(self.driver) self.basepage.saveScreenshot('quiting_data') self.assertIn(assetdetails_list[0],product_name[0][0]) self.assertIn(contract_number[0][0],assetdetails_list[1]) self.assertEqual(pact_title,'资产详情')
def test_Exited_data(self): """投资记录-已退出资产详情数据验证""" entry_page = Entry_page(self.driver, phone='17712345606',pwd='qwe123') MyAssetDetailsPage = entry_page.open_my_assetDetails_Exited_page() time.sleep(1.5) assetdetails_list=MyAssetDetailsPage.get_assetdetails_list() pact_title=MyAssetDetailsPage.el_pact_title_btn.text #查询DB 获得理财中第一个理财的合同编号 sql = Exce_SQLserver() contract_number = sql.execSql_getList("SELECT top 1 new_name from new_investdetailBase WHERE new_accountname = 'F86EEE35-2940-E711-80D3-00155D02B414' AND new_status=100000002 order BY new_instreststartdate desc ") #查询DB 获得理财产品名称 sql = Exce_SQLserver() product_name = sql.execSql_getList( "SELECT top 1 new_product_name from new_investdetailBase WHERE new_accountname = 'F86EEE35-2940-E711-80D3-00155D02B414' AND new_status=100000002 order BY new_instreststartdate desc") #断言 self.basepage = BasePage(self.driver) self.basepage.saveScreenshot('Exited_data') self.assertIn(assetdetails_list[0],product_name[0][0]) self.assertIn(contract_number[0][0],assetdetails_list[1]) self.assertEqual(pact_title,'资产详情')
def test_transaction_list(self): """交易记录-交易列表数据验证""" #mytraderecordpage=self.into_transaction() entry_page = Entry_page(self.driver) mytradeRecordPage = entry_page.open_my_tradeRecord_page() # time.sleep(2) trade_list = mytradeRecordPage.logic_trade_list() # 查询DB 获得理财中第一个理财的合同编号 sql = Exce_SQLserver() txtinvestapply = sql.execSql_getList( "SELECT top 1 new_txtinvestapply from new_tradedetailBase WHERE new_account = '24004F6C-7C08-E711-80C9-00155D01F903' ORDER BY new_paydate DESC" ) # print txtinvestapply[0][0] #print trade_list[0] sql = Exce_SQLserver() paymentno = sql.execSql_getList( "SELECT top 1 new_paymentno from new_tradedetailBase WHERE new_account = '24004F6C-7C08-E711-80C9-00155D01F903' ORDER BY new_paydate DESC" ) #print paymentno[0][0] #print trade_list[1] entry_page.saveScreenshot('transaction_list') self.assertEquals(trade_list[0], txtinvestapply[0][0]) self.assertEquals(trade_list[1], paymentno[0][0])
def test_financial_data(self): """投资记录-理财中资产详情数据验证""" entry_page = Entry_page(self.driver) MyAssetDetailsPage = entry_page.open_my_assetDetails_page() time.sleep(1.5) #获得资产详情页列表数据,默认获得第index=0 个 assetdetails_list=MyAssetDetailsPage.get_assetdetails_list() pact_title=MyAssetDetailsPage.el_pact_title_btn.text #查询DB 获得理财中第一个理财的合同编号 sql = Exce_SQLserver() contract_number = sql.execSql_getList("SELECT top 1 new_name from new_investdetailBase WHERE new_accountname = '24004F6C-7C08-E711-80C9-00155D01F903' AND new_status=100000000 order BY new_paidon desc") #查询DB 获得理财产品名称 sql = Exce_SQLserver() product_name = sql.execSql_getList( "SELECT top 1 new_product_name from new_investdetailBase WHERE new_accountname = '24004F6C-7C08-E711-80C9-00155D01F903' AND new_status=100000000 order BY new_paidon desc") #断言 self.basepage = BasePage(self.driver) self.basepage.saveScreenshot('financial_data') self.assertIn(assetdetails_list[0],product_name[0][0]) self.assertIn(contract_number[0][0],assetdetails_list[1]) self.assertEqual(pact_title,'资产详情')
def test_contract_list(self): """消息中心-合同消息-展示本金确认书合同列表""" # 客户登录并进入消息中心列表 entry_page = Entry_page(self.driver) newspage = entry_page.open_news_page() # 点击合同列表页面 contractspage = newspage.click_el_contract_message_btn() time.sleep(2) #获取列表中第 index 个的详情数据,默认最新的一条数据 con_list=contractspage.get_Contracts_list_text(index=0) # print "con_list is %s" %con_list[0] #从DB中查询购买的最新的理财产品信息 #sql=Exce_SQLserver() # results = sql.execSql_getList( # "SELECT top 1 new_product_name,new_investdate,new_name,new_financeterm from new_investdetailBase WHERE new_accountname = '24004F6C-7C08-E711-80C9-00155D01F903' order BY new_investdate DESC") sql = Exce_SQLserver() product_name = sql.execSql_getList("SELECT top 1 new_product_name from new_investdetailBase WHERE new_accountname = '24004F6C-7C08-E711-80C9-00155D01F903' order BY CreatedOn DESC") #print "product_name is %s" %product_name sql = Exce_SQLserver() contract_number = sql.execSql_getList("SELECT top 1 new_name from new_investdetailBase WHERE new_accountname = '24004F6C-7C08-E711-80C9-00155D01F903' order BY CreatedOn DESC") #print "contract_number is %s" % contract_number #print con_list[2] #print contract_number[0][0] #断言处理 self.basepage = BasePage(self.driver) self.basepage.saveScreenshot('contract_list') self.assertIn(con_list[0],product_name[0][0]) self.assertEqual(con_list[2],contract_number[0][0]) """
def test_financial_list(self): "投资记录-理财中列表数据验证" entry_page = Entry_page(self.driver) myinvsetrecorepage=entry_page.open_my_invset_recore_Page() invest_list_value=myinvsetrecorepage.logic_get_invest_value() sql = Exce_SQLserver() contract_number = sql.execSql_getList("SELECT top 1 new_product_name,new_name,new_instreststartdate,new_quitdate,new_planmoney,new_planmoney_Base from new_investdetailBase WHERE new_accountname = '24004F6C-7C08-E711-80C9-00155D01F903' AND new_status=100000000 order BY new_paidon desc") entry_page.saveScreenshot('financial_data') #断言验证 #断言理财名称 self.assertIn(invest_list_value["invest_text_name"],contract_number[0][0]) #断言合同编号 self.assertIn(contract_number[0][1],invest_list_value["invest_product_no"]) #断言起息日 self.assertEquals(invest_list_value["start_income_day"], (contract_number[0][2].date()+datetime.timedelta(days = 1)).strftime("%Y-%m-%d")) #断言结息日 if '年年生利' in invest_list_value["invest_text_name"]: self.assertIn("随时申请退出",invest_list_value["end_income_day"]) else: self.assertEquals(invest_list_value["end_income_day"],(contract_number[0][3].date().strftime("%Y-%m-%d"))) #断言 实际投资金额 self.assertIn(str(contract_number[0][4])[:-6]+ ","+ str(contract_number[0][4])[-6:],invest_list_value["reality_invest"]) #断言 意向投资金额 self.assertIn(str(contract_number[0][5])[:-6]+ ","+ str(contract_number[0][5])[-6:],invest_list_value["expected_invest"])
def test_Exited_list(self): "投资记录-已退出列表数据验证" entry_page = Entry_page(self.driver,phone='17712345606',pwd='qwe123') myinvsetrecorepage = entry_page.open_my_invset_recore_Page() time.sleep(0.2) myinvsetrecorepage.el_exited_btn.click() invest_list_value = myinvsetrecorepage.logic_get_invest_value() sql = Exce_SQLserver() contract_number = sql.execSql_getList( "SELECT top 1 new_product_name,new_name,new_instreststartdate,new_quitdate,new_planmoney,new_planmoney_Base from new_investdetailBase WHERE new_accountname = 'F86EEE35-2940-E711-80D3-00155D02B414' AND new_status=100000002 order BY new_paidon desc") entry_page.saveScreenshot('test_Exited_list') # 断言验证 # 断言理财名称 self.assertIn(invest_list_value["invest_text_name"], contract_number[0][0]) # 断言合同编号 self.assertIn(contract_number[0][1], invest_list_value["invest_product_no"]) # 断言起息日 self.assertEquals(invest_list_value["start_income_day"], (contract_number[0][2].date() + datetime.timedelta(days=1)).strftime("%Y-%m-%d")) # 断言结息日 self.assertEquals(invest_list_value["end_income_day"], (contract_number[0][3].date() + datetime.timedelta(days=1)).strftime("%Y-%m-%d")) # 断言 实际投资金额 self.assertIn(str(contract_number[0][4])[:-6] + "," + str(contract_number[0][4])[-6:], invest_list_value["reality_invest"]) # 断言 意向投资金额 self.assertIn(str(contract_number[0][5])[:-6] + "," + str(contract_number[0][5])[-6:], invest_list_value["expected_invest"])
def test_Continued_investment(self): """交易记录-续投记录验证""" entry_page = Entry_page(self.driver, phone="14404414441", pwd="qwe123") mytradeRecordPage = entry_page.open_my_tradeRecord_page() mytradeRecordPage.el_trade_list_image.click() trade_list_dict = mytradeRecordPage.logic_get_reinvest_way() sql = Exce_SQLserver() data_trade_list = sql.execSql_getList( "SELECT top 10 new_renewmethod,new_expectprofit,new_newcontractno FROM new_renewapplyBase WHERE new_customer ='47A24DAD-E65A-E711-80C9-00155D01F903'" ) entry_page.saveScreenshot("Continued_investment") #断言续投方式 self.assertEquals(data_trade_list[0][0], 100000001) self.assertEquals(trade_list_dict['reinvest_way'], "本金续投") #断言预期收益 self.assertIn( str(data_trade_list[0][1])[:5], trade_list_dict['expect_incomeself']) #断言续投编号 self.assertEquals(trade_list_dict['el_reinvest_contract_no'], data_trade_list[0][2])
def test_payment_record(self): """交易记录-回款记录验证""" entry_page = Entry_page(self.driver, phone="14454839876", pwd="qwe123") mytradeRecordPage = entry_page.open_my_tradeRecord_page() mytradeRecordPage.el_trade_list_image.click() trade_list_dict = mytradeRecordPage.logic_get_trade_list() sql = Exce_SQLserver() data_trade_list = sql.execSql_getList( "SELECT top 1 new_product_name,new_payamount,new_paydate,new_paymentstatus,new_paymentno,new_txtinvestapply FROM new_tradedetailBase WHERE new_account ='6B5A5084-9C49-E711-80D3-00155D02B414'" ) entry_page.saveScreenshot("payment_record") #断言理财名称 self.assertIn(trade_list_dict['name'], data_trade_list[0][0]) #断言金额 self.assertIn( str(data_trade_list[0][1])[:-6] + "," + str(data_trade_list[0][1])[-6:], trade_list_dict['amount']) #断言时间 self.assertIn((data_trade_list[0][2].date().strftime("%Y-%m-%d")), trade_list_dict['data']) #断言交易流水 self.assertEquals(trade_list_dict['flowing'], data_trade_list[0][4]) #断言理财状态 self.assertEquals(data_trade_list[0][3], 100000003) #断言合同编号 self.assertEquals(trade_list_dict['contract_no'], data_trade_list[0][5])
def test_user_Information(self): """个人中心-个人信息验证""" entry_page = Entry_page(self.driver, phone="18048444414", pwd='qwe123') myPersonalCenterPage = entry_page.open_my_Personal_CenterPage() user_information = myPersonalCenterPage.logic_get_user_information() sql = Exce_SQLserver() sql_user_information = sql.execSql_getList( "SELECT Name,new_telephone1,new_certificatenum from AccountBase WHERE new_telephone1={phone}" .format(phone=entry_page.phone)) "" [('username', u'u***1'), ('phonenum', u'144****8098'), ('ID', u'411***********3286')] [(u'14488888098', u'ufo21', 411224197404103286)] "" username = sql_user_information[0][0] phonenum = sql_user_information[0][1] ID = sql_user_information[0][2] entry_page.saveScreenshot('user_Information') #断言 self.assertEquals(user_information["username"], username[:1] + '*' + username[-1:]) self.assertEquals(user_information["phonenum"], phonenum[:3] + '****' + phonenum[-4:]) self.assertEquals(user_information["ID"], ID[:3] + '***********' + ID[-4:])
def test_Forgot_password(self): """找回密码验证""" entry_page = Entry_page(self.driver) forget_Pass = entry_page.open_forget_pass_page() forget_Pass.el_edit_phone.send_keys(entry_page.phone) forget_Pass.el_get_verify.click() message = Message() yanzma = message.get_sms(entry_page.phone) forget_Pass.el_edit_yanzheng.send_keys(yanzma) forget_Pass.el_tv_nextstepself.click() sql = Exce_SQLserver() contract_number = sql.execSql_getList( "SELECT Name,new_certificatenum FROM AccountBase WHERE new_telephone1={phone}" .format(phone=entry_page.phone)) forget_Pass.el_edit_phone.send_keys(contract_number[0][0]) forget_Pass.el_edit_yanzheng.send_keys(contract_number[0][1]) forget_Pass.el_tv_nextstepself.click() forget_Pass.el_edit_password.send_keys("qwe1234") forget_Pass.el_edit_reinput.send_keys("qwe1234") loginPage = forget_Pass.logic_tv_nextstepself_click() #loginPage=homePage.logic_buy_my_btn() forget_Pass = loginPage.logic_el_forget_pass_click() forget_Pass.el_edit_phone.send_keys(entry_page.phone) forget_Pass.el_get_verify.click() message = Message() yanzma = message.get_sms(entry_page.phone) forget_Pass.el_edit_yanzheng.send_keys(yanzma) forget_Pass.el_tv_nextstepself.click() #sql = Exce_SQLserver() # contract_number = sql.execSql_getList("SELECT Name,new_certificatenum FROM AccountBase WHERE new_telephone1={phone}".format(phone=entry_page.phone)) forget_Pass.el_edit_phone.send_keys(contract_number[0][0]) forget_Pass.el_edit_yanzheng.send_keys(contract_number[0][1]) forget_Pass.el_tv_nextstepself.click() forget_Pass.el_edit_password.send_keys("qwe123") forget_Pass.el_edit_reinput.send_keys("qwe123") self.assertEquals(forget_Pass.el_tb_title.text, '找回密码') forget_Pass.el_tv_nextstepself.click() entry_page.saveScreenshot("Forgot_password")