def test_newniannianying(self): datas = ExcelReader (self.excel).data for d in datas: with self.subTest (data=d): driver = selenium.webdriver.Chrome () driver.get("http://192.168.1.249:9901/hkjf/loginAdmin.do?method=tologin") driver.find_element_by_xpath (".//*[@id='login']").send_keys ("yradmin") driver.find_element_by_xpath (".//*[@id='password']").send_keys ("a12345") time.sleep (5) driver.find_element_by_id("button").submit() # driver.find_element_by_name('verifyCode').clear() #driver.find_element_by_xpath (".//*[@id='apLogin']/div[1]/ul/li[3]/p[3]/img").send_keys(text) #driver.find_element_by_xpath (".//*[@id='button']").click() driver.find_element_by_xpath(".//*[@id='left']/div/ul/li[5]/div/span[1]").click() driver.find_element_by_link_text("筹款中的借款标").click() time.sleep(1) handles=driver.current_window_handle print(handles) driver.switch_to_frame("contentIframe") driver.find_element_by_link_text("添加").click() time.sleep(2) driver.find_element_by_id("select1_input").click() #季季赢 按月付息 到期还本 年年li1_input_89bbee85-c85f-11e4-90b2-d89d67270c78_4 driver.find_element_by_id("li1_input_89bbee85-c85f-11e4-90b2-d89d67270c78_4").click() driver.find_element_by_id("select2_input").click() driver.find_element_by_id("li2_input_1").click() # title="m爆款标201822802" driver.find_element_by_id("loanTitle").send_keys(d['title']) driver.find_element_by_id("loanBorrowershowname").send_keys(d['title']) driver.find_element_by_id("projectCode").send_keys(d['title']) driver.find_element_by_id("amount").send_keys("10000") # 月数 driver.find_element_by_id("termvalue").send_keys("12") driver.find_element_by_id("biddlimit").send_keys("365") # 年利率 driver.find_element_by_id("rate").send_keys("10") driver.find_element_by_id("raiseRate").send_keys("0") driver.find_element_by_id("loanrate").send_keys("0") driver.find_element_by_id("loanServiceRate").send_keys("0") driver.find_element_by_id("select4_input").click() #标的属性 # 标的属性 # driver.find_element_by_id("li4_input_2").click() #选择借款人 driver.find_element_by_xpath(".//*[@id='prodetail']/div[1]/table/tbody/tr[40]/td/input[2]").send_keys(Keys.SPACE) # time.sleep(5) WebDriverWait (driver, 10).until (EC.presence_of_element_located ((By.XPATH, "//html/body/div/div/div/div[2]/iframe"))) # a=driver.find_elements_by_xpath(".//*[@id='d86zjCDbir']/div[1]/div[2]/iframe") # a=driver.find_element_by_xpath("//html/body/div[2]/div[1]/div[1]/div[2]") a=driver.find_element_by_xpath("//html/body/div/div/div/div[2]/iframe") driver.switch_to_frame(a) # driver.switch_to_frame(a) #dr.find_element_by_xpath(".//*[@id='d86zjCDbir']/div[1]/div[2]/iframe") # driver.find_element_by_xpath("//form[@id='queryForm']/ul/li/span/input").send_keys("123") driver.find_element_by_xpath(".//*[@id='loginName']").send_keys("transfer") driver.find_element_by_link_text("查询").click() time.sleep(3) driver.find_element_by_link_text("选择").click() time.sleep(1) driver.switch_to_default_content() driver.switch_to_frame("contentIframe") driver.find_element_by_link_text("保存").submit() time.sleep(2) al=driver.switch_to_alert() al.accept() # 返回列表上架 driver.switch_to_default_content() driver.find_element_by_link_text("筹款中的借款标").click() driver.switch_to_frame("contentIframe") driver.find_element_by_name("title").send_keys(d['title']) driver.find_element_by_link_text("查询").click() driver.find_element_by_link_text("上架").click() time.sleep(1) # i=driver.find_element_by_class_name("___boxDialog").find_elements_by_tag_name("input") # driver.find_element(i[0]).click() # a=driver.find_element_by_xpath("//html/body/div/div/div/div[2]/iframe") ??? driver.find_element_by_xpath("//html/body/div/div/div/div[3]/input[1]").click()
def test_newyyy(self): datas = ExcelReader (self.excel).data for d in datas: with self.subTest(data=d): driver=selenium.webdriver.Chrome() # driver.get("http://192.168.1.249:8501/management/login.html") driver.get ("http://192.168.1.249:8484/hk-management-services/index.html#/creditorProperty?bidInfoId=467") driver.find_element_by_id("login").send_keys("18812345678") driver.find_element_by_id("password").send_keys("a12345") driver.find_element_by_id("submit").click() time.sleep (1) driver.find_element_by_xpath (".//*[@id='side-menu']/li[2]/a/span[1]").click () driver.find_element_by_xpath (".//*[@id='side-menu']/li[2]/ul[1]/li/a/span").click () time.sleep (1) driver.find_element_by_link_text("添加").click() time.sleep(1) driver.find_element_by_name("bidProductId").click() # 选择产品 散标 driver.find_element_by_xpath(".//*[@id='bidForm']/div/div/div[1]/select/option[8]").click() driver.find_element_by_name ("loanUse").click () driver.find_element_by_xpath(".//*[@id='bidForm']/div/div/div[2]/select/option[2]").click() driver.find_element_by_name("title").send_keys(d['title']) driver.find_element_by_name("bidCode").send_keys(d['title']) # 金额 driver.find_element_by_name("totalAmount").send_keys("10000") # 几个月 driver.find_element_by_name("termValue").send_keys("12") # 年利率 driver.find_element_by_name("interestRate").send_keys("10") driver.find_element_by_name("raiseRate").send_keys("0") driver.find_element_by_name("commissionRate").send_keys("0") driver.find_element_by_name("serviceRate").send_keys("0") # 是否允许提前还本 driver.find_element_by_name ("advanceRepayState").click () # 按日 默认 # driver.find_element_by_xpath (".//*[@id='repayCapArea']/span/div[1]/input[2]").click () driver.find_element_by_id ("returnCapDays").send_keys ("0") # 选择借款人 driver.find_element_by_link_text ("请选择").click () time.sleep(1) driver.find_element_by_name("login").send_keys("15302602360") driver.find_element_by_id("searchForm-searchBtn").click() driver.find_element_by_link_text("选择").click() time.sleep (1) driver.find_element_by_name("type").click() time.sleep (1) # 正常标 爆款标 推荐标 driver.find_element_by_xpath (".//*[@id='bidForm']/div/div/div[27]/select/option[2]").click () time.sleep(1) # driver.find_element_by_xpath (".//*[@id='bidForm']/div/div/div[26]/select/option[3]").click () # driver.find_element_by_xpath(".//*[@id='bidForm']/div/div/div[26]/select/option[4]").click() # 直投 or 匹配 默认直投 # driver.find_element_by_xpath(".//*[@id='matchTypeSpan']/div/input[2]").click() driver.find_element_by_id ("startDate").click () # time.sleep(1) frame = driver.find_element_by_xpath ("html/body/div[4]/iframe") driver.switch_to_frame (frame) driver.find_element_by_xpath (".//*[@id='dpTodayInput']").click () # time.sleep(1) driver.switch_to_default_content () # time.sleep(1) driver.find_element_by_id ("endDate").click () # time.sleep(1) driver.switch_to_frame (frame) # time.sleep(1) driver.find_element_by_xpath (".//*[@id='dpTitle']/div[6]/a").click () driver.find_element_by_xpath (".//*[@id='dpTitle']/div[6]/a").click () driver.find_element_by_xpath ("html/body/div[1]/div[3]/table/tbody/tr[4]/td[3]").click () driver.find_element_by_xpath ("html/body/div[1]/div[3]/table/tbody/tr[4]/td[3]").click () # time.sleep(1) driver.switch_to_default_content () # time.sleep (1) driver.find_element_by_xpath (".//*[@id='bidForm']/div/div/div[28]/button[1]").click () time.sleep(1)
def test_Login(self): datas = ExcelReader(self.excel).data for d in datas: with self.subTest(data=d): login_page = LoginPage() # Step3: 输入用户名 login_page.set_username("88812345678") # Step4: 输入密码 login_page.set_password("a12345") # Step5: 单击登录按钮 login_page.click_login() time.sleep(1) # login_page.driver.close() login_page.click_jkbgl() login_page.click_ckzjkb() time.sleep(1) login_page.click_new() time.sleep(1) login_page.click_bidProduct() # 选择产品 login_page.click_yyyay() #月月赢按月 # login_page.click_yyydq() #月月赢到期 login_page.click_loanuse() login_page.click_loanuseli() login_page.set_title(d['title']) login_page.set_bidcode(d['title']) login_page.set_totalAmount("10000") login_page.set_termValue("12") login_page.set_interestRate("10") login_page.set_raiseRate("0") login_page.set_shouxufei("0") login_page.click_choose() time.sleep(2) login_page.set_loanuser("18888888888") login_page.click_search() login_page.click_searchok() time.sleep(1) login_page.click_type() # 正常标、爆款标、推荐标 login_page.click_zcbiao() login_page.click_save() time.sleep(1) login_page.click_ok() time.sleep(1) login_page.click_ckzjkb() time.sleep(1) login_page.set_mingcheng(d['title']) login_page.click_sousuo() time.sleep(1) login_page.click_shangjia() time.sleep(1) login_page.click_shangjiaok() login_page.driver.close() con = db.Db() connection = con.connection fname = DATA_PATH + '/yueyueying.xlsx' bk = xlrd.open_workbook(fname) try: sh = bk.sheet_by_name("Sheet1") except: print "no sheet in %s named Sheet1" % fname # 获取第一行第一列数据 cell_value = sh.cell_value(1, 0) print("表格", cell_value) # 通过cursor创建游标 cursor = con.cursor cursor.execute("SELECT * from bid_info where name=%s", (d['title'], )) # 提交SQL connection.commit() t = cursor.fetchall() print(t) bidname = t[0]['name'] print(bidname) cursor = con.cursor cursor.execute("SELECT id from bid_info where name=%s", (bidname, )) # 提交SQL connection.commit() t = cursor.fetchall() # a=t['tel'] a = t[0]['id'] content = { 'login': '******', 'passwd': 'QW8EQ4lM09bcIHZM86COM0462PoQ+1QibJUzLsD0b7JuCUdAPrqTTvGmHSHYj3/4ME6OSTIBrjdBFmtDomdy0OcURcTEljx9LetZpEHz7uHaDje9iguklu/KfguL8QZrWQ8LgIyWe2Hxr+GfNyP0mIihASYFQGGSGtKi/Drcqn4=' } headers = { 'User-Agent': 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:47.0) Gecko/20100101 Firefox/47.0', 'Accept': 'application/json, text/javascript, */*; q=0.01', 'Accept-Language': 'zh-CN,zh;q=0.8,en-US;q=0.5,en;q=0.3', 'Accept-Encoding': 'gzip, deflate', 'Content-Type': 'application/x-www-form-urlencoded; charset=UTF-8', 'X-Requested-With': 'XMLHttpRequest', 'Referer': 'http://192.168.1.249:8584/hk-financial-services/index.html', 'Content-Length': '215', 'Cookie': 'container_flag=container_flag; JSESSIONID=4C9658B8B1E2B04BBD1A5121BDA80EB3;', 'submitToken': '"SUBMIT_TOKEN:1f5832f3-3e02-4e8a-b264-fa5ce0eaf011";', 'ticket_admin': 'lNNabgYFTOyvXgCvOP1X9YB0B7bnzslM; submitToken_admin="SUBMIT_TOKEN:1f810b88-eb9f-4a88-ade9-50f0a5d64827"; ticket=2617gSHVCRVpSoyGybrt7DZQNEoszqPY', 'Connection': 'keep-alive' } r = requests.post( 'http://192.168.1.249:8584/hk-financial-services/indexController/fasterLogin.do', data=content, headers=headers) # 发送请求 print(r.text) # 获取响应报文 print(r.status_code) print("登录") c = r.cookies # def test_invest(self): --投标 141 170 content1 = { 'bidId': a, 'money': '10000', 'investRedPacketId': '', 'investRaiseInterestId': '' } r1 = requests.post( 'http://192.168.1.249:8584/hk-financial-services/bidInfoController/invest.do', data=content1, cookies=c) # 发送请求 # return r.json print(r1.text) # 获取响应报文 print(r1.status_code) print("投资")
def test_Login(self): # excel = DATA_PATH + '/register.xlsx' datas = ExcelReader(self.excel).data db = Db() connection = db.connection cursor = db.cursor for d in datas: with self.subTest(data=d): cursor.execute( "SELECT code from bidd_info where title='推荐季季按月1703'") connection.commit() t = cursor.fetchall() # a=t['tel'] code = t[0]['code'] print('标的code:', code) tel = int(float(d['title'])) print('用户:', tel) # 用户登录 content = { 'access_token': '1b1d5757-9322-4d83-bb79-fed79f973dad', 'mobileUDID': '2cae768b2925730a', 'password': '******', 'appVersion': 'v2.6.3', 'mobileModel': 'MI 4LTE', 'login': tel, 'mobileVersion': '6.0.1', 'mobileIp': '02:00:00:00:00:00', 'mobileMAC': '02:00:00:00:00:00', 'passLength': '6', } r = requests.post( 'http://192.168.1.249:9921/hkjfapp/user/doLogin', data=content) # 发送请求 print('登录响应状态', r.status_code) txt = r.text print(r.text) c = r.cookies # r = re.findall (r'<input name="token" type="hidden" value="(.+?)"/>', txt) usercode = re.findall(r'资","code":"(.+?)","gender":"', txt) sessionid = re.findall(r',"sessionId":"(.+?)","userType', txt) print(usercode, ' ', sessionid) # 投标 content_tz = { 'amount': '10000', 'biddCode': code, 'investType': '1', 'sessionId': sessionid[0], 'signType': 'MD5', 'source': '4', 'userCode': usercode[0] } #描述 用户对标的进行指定金额的投资接口 签名生成方式,key保证a-z有序并且组装成URL请求形式,使用RSA生成签名,sign和空值key不参与组装,当使用md5签名时,将MD5秘钥加在原串的最后 &key=****** # URL1 = "http://192.168.1.249:9921/hkjfapp/invest/invest?" a = Mysign.mysign(content_tz) print(a) a1 = a + '&key=AMvFWdickzxK/sCwiG5BVKu8HkqxcrQEjSKmvCfZ44QfNsKiV7pG1' print(a1) m = hashlib.md5() # 创建md5对象 m.update( a1.encode(encoding='UTF-8')) # 生成加密串,其中password是要加密的字符串 # hashlib.md5('abcdefg'.encode(encoding='UTF-8')).hexdigest() sign = m.hexdigest() print(sign) # # urlll=a+'&sign='+sign # # print(urlll) content_tz2 = { 'access_token': '1b1d5757-9322-4d83-bb79-fed79f973dad', 'amount': '10000', 'biddCode': code, 'investType': '1', 'sessionId': sessionid[0], 'sign': sign, 'signType': 'MD5', 'source': '4', 'userCode': usercode[0] } rtz = requests.post( "http://192.168.1.249:9921/hkjfapp/invest/invest", params=content_tz2, cookies=c) print('投资状态', rtz.status_code) print(rtz.text)
def test_Login(self): datas = ExcelReader(self.excel).data for d in datas: with self.subTest(data=d): login_page = LoginPage() # Step3: 输入用户名 login_page.set_username("88812345678") # Step4: 输入密码 login_page.set_password("a12345") # Step5: 单击登录按钮 login_page.click_login() time.sleep(1) # login_page.driver.close() login_page.click_jkbgl() login_page.click_ckzjkb() time.sleep(1) login_page.click_new() time.sleep(1) login_page.click_bidProduct() # 选择产品 login_page.click_yyyay() #月月赢按月 # login_page.click_yyydq() #月月赢到期 login_page.click_loanuse() login_page.click_loanuseli() login_page.set_title(d['title']) login_page.set_bidcode(d['title']) login_page.set_totalAmount("10000") login_page.set_termValue("12") login_page.set_interestRate("10") login_page.set_raiseRate("0") login_page.set_shouxufei("0") login_page.click_choose() time.sleep(2) login_page.set_loanuser("18888888888") login_page.click_search() login_page.click_searchok() time.sleep(1) login_page.click_type() # 正常标、爆款标、推荐标 login_page.click_zcbiao() login_page.click_save() time.sleep(1) login_page.click_ok() time.sleep(1) login_page.click_ckzjkb() time.sleep(1) login_page.set_mingcheng(d['title']) login_page.click_sousuo() time.sleep(1) login_page.click_shangjia() time.sleep(1) login_page.click_shangjiaok() login_page.driver.close() con = db.Db() connection = con.connection fname = DATA_PATH + '/yueyueying.xlsx' bk = xlrd.open_workbook(fname) try: sh = bk.sheet_by_name("Sheet1") except: print "no sheet in %s named Sheet1" % fname # 获取第一行第一列数据 cell_value = sh.cell_value(1, 0) print("表格", cell_value) # 通过cursor创建游标 cursor = con.cursor cursor.execute("SELECT * from bid_info where name=%s", (d['title'], )) # 提交SQL connection.commit() t = cursor.fetchall() print(t) bidname = t[0]['name'] print(bidname) cursor = con.cursor cursor.execute("SELECT id from bid_info where name=%s", (bidname, )) # 提交SQL connection.commit() t = cursor.fetchall() # a=t['tel'] a = t[0]['id'] #前台用户登录 user = '******' content = { 'login': user, 'passwd': 'QW8EQ4lM09bcIHZM86COM0462PoQ+1QibJUzLsD0b7JuCUdAPrqTTvGmHSHYj3/4ME6OSTIBrjdBFmtDomdy0OcURcTEljx9LetZpEHz7uHaDje9iguklu/KfguL8QZrWQ8LgIyWe2Hxr+GfNyP0mIihASYFQGGSGtKi/Drcqn4=' } headers = { 'User-Agent': 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:47.0) Gecko/20100101 Firefox/47.0', 'Accept': 'application/json, text/javascript, */*; q=0.01', 'Accept-Language': 'zh-CN,zh;q=0.8,en-US;q=0.5,en;q=0.3', 'Accept-Encoding': 'gzip, deflate', 'Content-Type': 'application/x-www-form-urlencoded; charset=UTF-8', 'X-Requested-With': 'XMLHttpRequest', 'Referer': 'http://192.168.1.249:8584/hk-financial-services/index.html', 'Content-Length': '215', 'Cookie': 'container_flag=container_flag; JSESSIONID=4C9658B8B1E2B04BBD1A5121BDA80EB3;', 'submitToken': '"SUBMIT_TOKEN:1f5832f3-3e02-4e8a-b264-fa5ce0eaf011";', 'ticket_admin': 'lNNabgYFTOyvXgCvOP1X9YB0B7bnzslM; submitToken_admin="SUBMIT_TOKEN:1f810b88-eb9f-4a88-ade9-50f0a5d64827"; ticket=2617gSHVCRVpSoyGybrt7DZQNEoszqPY', 'Connection': 'keep-alive' } r = requests.post( 'http://192.168.1.249:8584/hk-financial-services/indexController/fasterLogin.do', data=content, headers=headers) # 发送请求 print(r.text) # 获取响应报文 print(r.status_code) print("登录") c = r.cookies # 查询名下的可使用的加息券 user = '******' cursor.execute("SELECT id from reg_user where login=%s", (user, )) # 用户id # 提交SQL connection.commit() uid = cursor.fetchall() user_id = uid[0]['id'] print(user_id) cursor.execute( "SELECT id from vas_coupon_product where type='0'" ) # 卡券类型产品id # 提交SQL connection.commit() pid = cursor.fetchall() # pro_id = pid[0]['id'] print(pid) # print(pro_id) num = len(pid) # print(len(pid)) lis = [] for p in pid: pro_id = pid[num - 1]['id'] num = num - 1 # print(pro_id) # 某某的加息券,适用于月月赢的id cur.execute("select * from user where userid = '%s' and password = '******'" %(userid,password)) # cursor.execute("SELECT * from vas_coupon_detail where acceptor_user_id='%s' and coupon_product_id in('%s') and state=1 and bid_product_type_range like'%2%'" # %(user_id, pro_id)) cursor.execute( "SELECT id from vas_coupon_detail where acceptor_user_id='%s' and coupon_product_id in('%s') and state=1 and find_in_set('2', bid_product_type_range)" % (user_id, pro_id)) # userid='15510000011' # password='******' # cursor.execute("SELECT * from reg_user where login= '******' and passwd = '%s'" %(userid,password)) connection.commit() jxqid = cursor.fetchall() if type(jxqid) is tuple: pass else: lis.append(jxqid) print("lis 是:", lis) n = len(lis) # for a in lis: # a=lis[n-1][0] # n=n-1 # print(a['id']) jxq_id = lis[n - 1][0]['id'] print(jxq_id) # def test_invest(self): --投标 141 170 content1 = { 'bidId': a, 'money': '10000', 'investRedPacketId': '', 'investRaiseInterestId': jxq_id } r1 = requests.post( 'http://192.168.1.249:8584/hk-financial-services/bidInfoController/invest.do', data=content1, cookies=c) # 发送请求 # return r.json print(r1.text) # 获取响应报文 print(r1.status_code) print("投资") # 后台登录 conten2 = { 'randomCode': '123', 'rememberMe': '0', 'login': '******', 'passwd': 'H/SOSDPHotw0L2qVobGWQkipJ7HWEkabs5Q63qU8PW8NvPy5HYNwMZuu2bG03VxixQczvSQRaWlEDror33LOflH7DJUPRiwD/1iYB1w1qsBN0z/1KwargVhtGw/SMDUd9yTotjfG4NbiGH9yiiba8t1hHVVVCCJbv6PvEn1bBYs=' } r2 = requests.post( 'http://192.168.1.249:8584/hk-management-services/managementLoginController/login', data=conten2) # 发送请求 print(r2.text) # 获取响应报文 print(r2.status_code) print("123") c2 = r2.cookies # def test_invest(self): --投标 141 170 content3 = {'id': a, 'reason': '满标审核通过', 'state': '4'} # http://192.168.1.249:8584/hk-management-services/bidInfoController/auditBid r3 = requests.post( 'http://192.168.1.249:8584/hk-management-services/bidInfoController/auditBid', data=content3, cookies=c2) # 发送请求 # return r.json print(r3.text) # 获取响应报文 print(r3.status_code) print("审核") # http://192.168.1.249:8501/management/loanController/makeLoans?bidInfoId=302 # http://192.168.1.249:8584/hk-management-services/bidInfoController/auditBid a1 = 'http://192.168.1.249:8584/hk-management-services/loanController/makeLoans?bidInfoId=' a2 = str(a) add = a1 + a2 r4 = requests.post(add, cookies=c2) # return r.json print(r4.text) # 获取响应报文 print(r4.status_code) print("放款")
def test_Login(self): tels = ExcelReader (self.tel).data for d in tels: with self.subTest (data=d): regtel=int(d['login']) print(regtel) cursor = Db ().get_cursor () connection = Db.get_connection (self) # cursor.execute ("SELECT id from bid_info where name=%s", (bidname,)) cursor.execute("SELECT code from loginuser where LOGIN=%s",(regtel,)) #查询code connection.commit () t1 = cursor.fetchall () code=t1[0]['code'] print (code) cursor.execute ("SELECT ENTITY_STATUS from fn_account where user_code=%s", (code,)) #查询银行卡状态 connection.commit () t2 = cursor.fetchall () print(t2) status = t2[0]['ENTITY_STATUS'] # 判断是否已经绑卡 0未绑卡 if status == 0: print ('hello null') cursor.execute ("update fn_account set bank_code=null,bank_account=null,entity_no=null,entity_status=0,entity_name=null,entity_bank=null,entity_dept=null,entity_province=null,entity_city=null,entity_addr=null where user_code=%s", (code,)) # SELECT * FROM personinfo WHERE LOGIN_NAME='牟泓霏' # UPDATE personinfo set login_name='',login_card='' where login_name='牟泓霏' connection.commit () driver = webdriver.Chrome () driver.get (qturl) WebDriverWait (driver, 10).until (EC.presence_of_element_located ((By.ID, 'login'))) driver.find_element_by_id ('login').send_keys (regtel) time.sleep (1) e1 = driver.find_element_by_xpath (".//*[@id='txt2']") action = ActionChains (driver) action.move_to_element (e1).click ().send_keys ('a12345').perform () driver.find_element_by_xpath (".//*[@id='logindiv']/div/div[2]").click () driver.find_element_by_link_text ("我的账号").click () time.sleep(2) driver.find_element_by_link_text ("提现").click () time.sleep (3) driver.find_element_by_id("entityNo").send_keys("6214830103287743") driver.find_element_by_id("province").click() driver.find_element_by_xpath(".//*[@id='province']/option[2]").click() driver.find_element_by_id("city").click() driver.find_element_by_xpath(".//*[@id='city']/option[1]").click() driver.find_element_by_id("bank_entity_addr").send_keys("某支行") driver.find_element_by_id("btn_sub").click() driver.find_element_by_link_text("提现").click() time.sleep(1) driver.find_element_by_id ("tranAmt").send_keys ("0.02") driver.find_element_by_id ("btn_sub").click () #已经绑卡 status=1 else: print ('not null') driver=webdriver.Chrome() driver.get ('http://192.168.1.249:9901/hkjf/index.do?method=getIndexPage') WebDriverWait (driver, 10).until (EC.presence_of_element_located ((By.ID, 'login'))) driver.find_element_by_id ('login').send_keys (regtel) time.sleep (1) e1 = driver.find_element_by_xpath (".//*[@id='txt2']") action = ActionChains (driver) action.move_to_element (e1).click ().send_keys ('a12345').perform () driver.find_element_by_xpath (".//*[@id='logindiv']/div/div[2]").click() driver.find_element_by_link_text("我的账号").click() driver.find_element_by_link_text("提现").click() time.sleep(1) # driver.find_element_by_id("entityNo").send_keys("6228481200290317812") # driver.find_element_by_id("province").click() # driver.find_element_by_xpath(".//*[@id='province']/option[2]").click() # driver.find_element_by_id("city").click() # driver.find_element_by_xpath(".//*[@id='city']/option[1]").click() # driver.find_element_by_id("bank_entity_addr").send_keys("某支行") # driver.find_element_by_id("btn_sub").click() # driver.find_element_by_link_text("提现").click() driver.find_element_by_id("tranAmt").send_keys("0.01") driver.find_element_by_id("btn_sub").click() #登录后台审核 driver.get("http://192.168.1.249:9901/hkjf/loginAdmin.do?method=tologin") driver.find_element_by_id("login").send_keys("yradmin") driver.find_element_by_id("password").send_keys("a12345") time.sleep(8) driver.find_element_by_id("button").click() #提现审核 driver.find_element_by_xpath(".//*[@id='left']/div/ul/li[7]/div/span[1]").click() time.sleep(0.5) driver.find_element_by_link_text("提现审核").click() driver.switch_to_frame("contentIframe") time.sleep(1) driver.find_element_by_id("tel").send_keys(regtel) driver.find_element_by_link_text("查询").click() time.sleep(1) driver.find_element_by_xpath("//html/body/div/div[2]/div[2]/div/table/tbody/tr/td/input").click() #选择复选框 #交易流水号提取 driver.find_element_by_link_text("审核").click() tfno = driver.find_element_by_xpath (".//*[@id='bindingfrom']/table/tbody/tr[3]/td[6]").text driver.find_element_by_link_text("通过").click() driver.switch_to_default_content () time.sleep(0.5) #提现放款 driver.find_element_by_xpath(".//*[@id='left']/div/ul/li[7]/div/span[1]").click() driver.find_element_by_link_text("提现放款审核").click() driver.switch_to_frame("contentIframe") time.sleep(0.5) driver.find_element_by_id("flowId").send_keys(tfno) driver.find_element_by_link_text("查询").click() driver.find_element_by_link_text("放款").click() time.sleep(0.5) driver.find_element_by_link_text("通过").click() time.sleep(0.5) driver.close()
def test_ppy2s1(self): connection = pymysql.connect(host='192.168.1.249', port=3307, user='******', password='******', db='p2p_product_hotcopy', charset='utf8mb4', cursorclass=pymysql.cursors.DictCursor) fname = DATA_PATH + '/yueyueying.xlsx' fname2 = DATA_PATH + '/sanbiao.xlsx' bk = xlrd.open_workbook(fname) bk2 = xlrd.open_workbook(fname2) shxrange = range(bk.nsheets) shxrange2 = range(bk2.nsheets) try: sh = bk.sheet_by_name("Sheet1") sh2 = bk2.sheet_by_name("Sheet1") except: print "no sheet in %s named Sheet1" % fname "no sheet in %s named Sheet1" % fname2 # 获取第一行第一列数据 cell_value = sh.cell_value(1, 0) youxuan2 = sh.cell_value(2, 0) cell_value2 = sh2.cell_value(1, 0) print(cell_value) print(youxuan2) print(cell_value2) # 通过cursor创建游标 cursor = connection.cursor() # sql = "SELECT code FROM bidd_info where title='%s'",(cell_value) # 加str确认与%s匹配 # # # 创建sql 语句,并执行 # # sql = "SELECT code FROM bidd_info ORDER BY id LIMIT 1" # cursor.execute (sql) # cursor.execute ("SELECT code FROM bidd_info where title=%s", (cell_value,)) cursor.execute("SELECT code FROM bidd_info where title=%s", (cell_value, )) # 提交SQL connection.commit() t = cursor.fetchall() # a=t['tel'] biddtitle = t biddcode = biddtitle[0]['code'] # [{'tel': '15912345678'}] print(biddtitle) print(biddcode) # 查第二个名字 cursor.execute("SELECT code FROM bidd_info where title=%s", (youxuan2, )) # 提交SQL connection.commit() t2 = cursor.fetchall() # a=t['tel'] biddtitle2 = t2 biddcode2 = biddtitle2[0]['code'] # [{'tel': '15912345678'}] print(biddtitle2) print(biddcode2) datas = ExcelReader(self.excel).data tzusers = ExcelReader(self.user).data tzbidds = ExcelReader(self.bidd).data for d in datas: with self.subTest(data=d): driver = webdriver.Chrome() driver.get( 'http://192.168.1.249:9901/hkjf/index.do?method=getIndexPage' ) WebDriverWait(driver, 10).until( EC.presence_of_element_located((By.ID, 'login'))) for u in tzusers: with self.subTest(tzuser=u): # driver = webdriver.Chrome () # driver.get ('http://192.168.1.249:9901/hkjf/index.do?method=getIndexPage') # WebDriverWait (driver, 10).until (EC.presence_of_element_located ((By.ID, 'login'))) driver.find_element_by_id('login').send_keys( int(u['user'])) time.sleep(1) e1 = driver.find_element_by_xpath(".//*[@id='txt2']") action = ActionChains(driver) action.move_to_element(e1).click().send_keys( "2971055a690ad019e9fc08a9971080ccfd6a8b588c69acc28383a12d9cfdcb135a60550a4df643b9967c5fab90ce4eb8e3970c2c093fefe299662ac44e868763d281e8708ab625528d55c6a777b2700bcb9daf7e7e0c6805ffd13760d4ac0120d6f43c2dc05fc38fcff485eedd8859d79200ddb7a9a606b8548fa1d8def1dacc" ).perform() driver.find_element_by_xpath( ".//*[@id='logindiv']/div/div[2]").submit() # address=("http://192.168.1.249:9901/hkjf/investControllerFront.do?method=detail&code=ed791706-92f7-4435-b6f6-aa944ed87f4c") ad1 = "http://192.168.1.249:9901/hkjf/investControllerFront.do?method=detail&code=" ad2 = biddcode add = ad1 + ad2 driver.get(add) time.sleep(1) # driver.find_element_by_id ("projectCode").send_keys (d['title']) t = driver.find_element_by_xpath( "html/body/div[2]/div[2]/div[2]/div[2]/div[1]/span" ).text # string转换为float类型 setlocale(LC_NUMERIC, 'English_US') # 剩余可投金额 t1 = int(atof(t)) # 123456.0 print(t) print(t1) # 根据表格配置金额投资 # driver.find_element_by_id ("amount").send_keys (int (d['amount'])) # 剩余可投金额--全投 driver.find_element_by_id("amount").send_keys(t1) driver.find_element_by_link_text("立即投资").click() time.sleep(3) driver.find_element_by_class_name("dialogBtn").click() time.sleep(3) # input class="dialogBtn" type="button" value="确定" # 投第二个标 # ad1 = "http://192.168.1.249:9901/hkjf/investControllerFront.do?method=detail&code=" ad3 = biddcode2 addd = ad1 + ad3 driver.get(addd) time.sleep(2) # driver.find_element_by_id ("projectCode").send_keys (d['title']) t = driver.find_element_by_xpath( "html/body/div[2]/div[2]/div[2]/div[2]/div[1]/span" ).text # string转换为float类型 setlocale(LC_NUMERIC, 'English_US') # 剩余可投金额 t1 = int(atof(t)) # 123456.0 print(t) print(t1) # 根据表格配置金额投资 # driver.find_element_by_id ("amount").send_keys (int (d['amount'])) # 剩余可投金额--全投 driver.find_element_by_id("amount").send_keys(t1) driver.find_element_by_link_text("立即投资").click() time.sleep(3) driver.find_element_by_class_name("dialogBtn").click() # input class="dialogBtn" type="button" value="确定" for d in datas: with self.subTest(data=d): driver = webdriver.Chrome() driver.get( "http://192.168.1.249:9901/hkjf/loginAdmin.do?method=tologin" ) driver.find_element_by_xpath( ".//*[@id='login']").send_keys("yradmin") driver.find_element_by_xpath( ".//*[@id='password']").send_keys("a12345") time.sleep(5) # 手动输入验证码 # driver.find_element_by_xpath (".//*[@id='apLogin']/div[1]/ul/li[3]/p[3]/img").send_keys(text) driver.find_element_by_id("button").submit() # driver.find_element_by_name('verifyCode').clear() #driver.find_element_by_xpath (".//*[@id='apLogin']/div[1]/ul/li[3]/p[3]/img").send_keys(text) #driver.find_element_by_xpath (".//*[@id='button']").click() driver.find_element_by_xpath( ".//*[@id='left']/div/ul/li[5]/div/span[1]" ).click() time.sleep(1) driver.find_element_by_link_text( "待审核的借款标").click() driver.switch_to_frame("contentIframe") # driver.find_element_by_name ("title").send_keys(biddtitle) driver.find_element_by_name("title").send_keys( cell_value) driver.find_element_by_link_text("查询").click() driver.find_element_by_link_text("审核").click() time.sleep(1) driver.find_element_by_id("content").send_keys( "满标审核通过") driver.find_element_by_link_text("通过").click() time.sleep(2) driver.find_element_by_name("title").send_keys( youxuan2) time.sleep(2) driver.find_element_by_link_text("查询").click() driver.find_element_by_link_text("审核").click() time.sleep(1) driver.find_element_by_id("content").send_keys( "满标审核通过") driver.find_element_by_link_text("通过").click() time.sleep(2) driver.switch_to_default_content() time.sleep(2) # 财务管理-放款 driver.find_element_by_xpath( ".//*[@id='left']/div/ul/li[7]/div/span[1]" ).click() time.sleep(1) driver.find_element_by_link_text( "待放款的借款标").click() driver.switch_to_frame("contentIframe") driver.find_element_by_name("title").send_keys( cell_value) time.sleep(1) driver.find_element_by_link_text("查询").click() driver.find_element_by_link_text("放款").click() time.sleep(1) driver.find_element_by_xpath( "//html/body/div/div/div/div[3]/input[1]" ).click() time.sleep(2) al1 = driver.switch_to_alert() time.sleep(1) al1.accept() time.sleep(2) # # 重新点击菜单 待放款的借款标 driver.switch_to_frame("contentIframe") driver.find_element_by_name("title").send_keys( youxuan2) time.sleep(2) driver.find_element_by_link_text("查询").click() driver.find_element_by_link_text("放款").click() time.sleep(2) # a = driver.find_element_by_xpath ("//html/body/div/div/div/div[2]/iframe") driver.find_element_by_xpath( "//html/body/div/div/div/div[3]/input[1]" ).click() time.sleep(3) al1 = driver.switch_to_alert() al1.accept() time.sleep(2) # # 匹配管理 # driver.switch_to_default_content () # time.sleep (2) driver.find_element_by_xpath( ".//*[@id='left']/div/ul/li[6]/div/span[1]" ).click() time.sleep(2) driver.find_element_by_link_text( "一个散标匹配多个优选").click() driver.switch_to_frame("contentIframe") driver.find_element_by_name("title").send_keys( cell_value2) driver.find_element_by_link_text("查询").click() driver.find_element_by_link_text("匹配").click() driver.find_element_by_link_text("选择").click() time.sleep(2) # 选择优选 a = driver.find_element_by_xpath( "//html/body/div/div/div/div[2]/iframe") driver.switch_to_frame(a) driver.find_element_by_name("title").send_keys( "m月月匹配201803190") driver.find_element_by_link_text("查询").click() time.sleep(2) driver.find_element_by_id("types").click() time.sleep(1) driver.find_element_by_id("btn_sub").click() time.sleep(2) driver.switch_to_frame("contentIframe") time.sleep(2) driver.find_element_by_id("btn_sub").click()
def test_Login(self): datas = ExcelReader(self.excel).data login_page = TiyanjinPage() driver = login_page.driver # Step3: 输入用户名 login_page.set_admin("yradmin") # Step4: 输入密码 login_page.set_password("a12345") time.sleep(6) # Step5: 单击登录按钮 login_page.click_login() db = Db() connection = db.connection cursor = db.cursor for d in datas: with self.subTest(data=d): # 获取用户code cursor.execute("SELECT code from loginuser where tel=%s", (d['tel'])) connection.commit() t = cursor.fetchall() # a=t['tel'] usercode = t[0]['code'] print('用户code:', usercode) cursor.execute( "SELECT * from fn_sim_account where STATUS=0 and USER_CODE=%s", usercode) connection.commit() t = cursor.fetchall() l = len(t) if l == 0: pass else: # DELETE from fn_sim_account where USER_CODE= cursor.execute( "DELETE from fn_sim_account where USER_CODE=%s", usercode) connection.commit() login_page.click_tyjgl() login_page.click_tyjff() time.sleep(1) driver.switch_to_frame("contentIframe") login_page.set_tel(int(d['tel'])) login_page.click_sousuo() login_page.click_choose() # 发放体验金 login_page.click_fftyj() login_page.set_money("10000") #金额 login_page.click_qrff() driver.switch_to_default_content() #新建体验标 login_page.click_jkbgl() login_page.click_ckzjkb() time.sleep(1) driver.switch_to_frame("contentIframe") login_page.click_new() time.sleep(1) login_page.click_bidProduct() # 选择产品 login_page.click_tyb() # 体验标 login_page.click_loanuse() login_page.click_loanuseli() login_page.set_title(d['bidd']) login_page.set_loanBorrowershowname(d['bidd']) login_page.set_bidcode(d['bidd']) login_page.set_totalAmount("10000") login_page.set_termValue("12") login_page.set_biddlimit("365") login_page.set_interestRate("10") login_page.set_raiseRate("0") login_page.set_shouxufei("0") login_page.click_type() # 是否是新手标 # driver.find_element_by_xpath (".//*[@id='prodetail']/div[1]/table/tbody/tr[22]/td/span[1]/div[1]/input").send_keys (Keys.SPACE) # 选择借款人 login_page.set_choose() WebDriverWait(driver, 10).until( EC.presence_of_element_located( (By.XPATH, "//html/body/div/div/div/div[2]/iframe"))) a = driver.find_element_by_xpath( "//html/body/div/div/div/div[2]/iframe") driver.switch_to_frame(a) login_page.set_loanuser("张效伟") # login_page.set_loanuser("18301306330") login_page.click_search() time.sleep(3) login_page.click_searchok() time.sleep(1) driver.switch_to_default_content() driver.switch_to_frame("contentIframe") # login_page.click_type() # # 正常标、爆款标、推荐标 # login_page.click_zcbiao() time.sleep(1) login_page.click_save() time.sleep(2) al = driver.switch_to_alert() al.accept() # 返回列表上架 driver.switch_to_default_content() login_page.click_ckzjkb() driver.switch_to_frame("contentIframe") login_page.set_mingcheng(d['bidd']) login_page.click_sousuo2() login_page.click_shangjia() time.sleep(1) driver.find_element_by_xpath( "//html/body/div/div/div/div[3]/input[1]").click() #用户投资 # cursor.execute ("SELECT code FROM bidd_info where title=%s", (cell_value,)) cursor.execute("SELECT code from bidd_info where title=%s", (d['bidd'])) connection.commit() t = cursor.fetchall() # a=t['tel'] code = t[0]['code'] print('标的code:', code) tel = int(float(d['tel'])) print('用户:', tel) #SELECT * from fn_sim_account where USER_CODE=(SELECT code from loginuser where tel='13010000012')and STATUS=0; #获取用户code cursor.execute("SELECT code from loginuser where tel=%s", (d['tel'])) connection.commit() t = cursor.fetchall() # a=t['tel'] usercode = t[0]['code'] print('用户code:', usercode) # 用户登录 content = { 'login': tel, 'password': '******', 'pwdLevel': '2', 'verify_code': '请输入计算结果', 'randCode': '请输入您的6位验证码', 'commendPhone': '请输入推荐码(推荐人手机号后8位)', 'loginregister': '请输入您的手机号', 'passwordresgister': '', 'token': '', 'modulus': '', 'exponent': '', 'newToken': '', 'phoneId': '', 'code': '', 'utype': '', 'csrftoken': '', 'pwdLevel': '' } r = requests.post( 'http://192.168.1.249:9901/hkjf/login.do?method=indexlogin', data=content) # 发送请求 print('登录响应状态', r.status_code) c = r.cookies # 请求标的详情 content_xq = {'code': code, 'tempType': '2'} rxq = requests.get( "http://192.168.1.249:9901/hkjf/investControllerFront.do?method=detail", params=content_xq, cookies=c) txt = rxq.text r = re.findall( r'<input name="token" type="hidden" value="(.+?)"/>', txt) # print("token的值是:",r) print('详情响应code:', rxq.status_code) # 用户投资 contenttz = { 'code': code, 'token': r, 'couponDetailCodeK': '', 'couponDetailCodeJ': '', 'confirmAmount': '10000', 'useAbleMoney': '10000' } rtz = requests.post( 'http://192.168.1.249:9901/hkjf/investController.do?method=goodsOpenInvest', data=contenttz, cookies=c) # 发送请求 # print (r1.text) # 获取响应报文 print('投资响应状态', rtz.status_code) # #后台满标审核 driver.switch_to_default_content() driver.find_element_by_xpath( ".//*[@id='left']/div/ul/li[5]/div/span[1]").click() driver.find_element_by_link_text("待审核的借款标").click() driver.switch_to_frame("contentIframe") time.sleep(1) driver.find_element_by_name("title").send_keys(d['bidd']) driver.find_element_by_link_text("查询").click() time.sleep(1) driver.find_element_by_link_text("审核").click() driver.find_element_by_id("content").send_keys("ok") driver.find_element_by_link_text("通过").click() #放款 driver.switch_to_default_content() time.sleep(1) driver.find_element_by_xpath( ".//*[@id='left']/div/ul/li[7]/div/span[1]").click() time.sleep(0.5) driver.find_element_by_link_text("待放款的借款标").click() driver.switch_to_frame("contentIframe") time.sleep(1) driver.find_element_by_name("title").send_keys(d['bidd']) driver.find_element_by_link_text("查询").click() time.sleep(1) driver.find_element_by_link_text("放款").click() driver.find_element_by_xpath( "//html/body/div/div/div/div[3]/input[1]").click() driver.close()
def test_newyyy(self): datas = ExcelReader (self.excel).data for d in datas: with self.subTest(data=d): driver = selenium.webdriver.Chrome () driver.get (self.URL) # http://192.168.1.249:8501/management/login.html driver.find_element_by_id("login").send_keys("88812345678") driver.find_element_by_id("password").send_keys("cxjmanage8123") driver.find_element_by_id("submit").click() time.sleep (1) driver.find_element_by_xpath (".//*[@id='side-menu']/li[2]/a/span[1]").click () driver.find_element_by_xpath (".//*[@id='side-menu']/li[2]/ul[1]/li/a/span").click () time.sleep (1) driver.find_element_by_link_text("添加").click() time.sleep(1) driver.find_element_by_name("bidProductId").click() # 选择产品 月月赢 # 月月按月付息 .//*[@id='bidForm']/div/div/div[1]/select/option[2] driver.find_element_by_xpath(".//*[@id='bidForm']/div/div/div[1]/select/option[2]").click() # 季季按月付息 .//*[@id='bidForm']/div/div/div[1]/select/option[4] # driver.find_element_by_xpath (".//*[@id='bidForm']/div/div/div[1]/select/option[4]").click () # 年年按月付息 .//*[@id='bidForm']/div/div/div[1]/select/option[6] # driver.find_element_by_xpath (".//*[@id='bidForm']/div/div/div[1]/select/option[6]").click () driver.find_element_by_name ("loanUse").click() driver.find_element_by_xpath(".//*[@id='bidForm']/div/div/div[2]/select/option[2]").click() driver.find_element_by_name("title").send_keys(d['title']) driver.find_element_by_name("bidCode").send_keys(d['title']) # 金额 driver.find_element_by_name("totalAmount").send_keys("10000") # 几个月 driver.find_element_by_name("termValue").send_keys("12") # driver.find_element_by_name("stepValue").send_keys("100") # 年利率 driver.find_element_by_name("interestRate").send_keys("10") driver.find_element_by_name("raiseRate").send_keys("0") # 手续费 driver.find_element_by_name("commissionRate").send_keys("0") driver.find_element_by_name("serviceRate").send_keys("0") driver.find_element_by_link_text("请选择").click() time.sleep(1) # 选择借款人 # 18301306330 14510000500 driver.find_element_by_name("login").send_keys("18888888888") driver.find_element_by_id("searchForm-searchBtn").click() driver.find_element_by_link_text("选择").click() time.sleep (1) driver.find_element_by_name("type").click() # 正常标 爆款标 推荐标 driver.find_element_by_xpath (".//*[@id='bidForm']/div/div/div[27]/select/option[2]").click () # driver.find_element_by_xpath (".//*[@id='bidForm']/div/div/div[27]/select/option[3]").click () # driver.find_element_by_xpath(".//*[@id='bidForm']/div/div/div[27]/select/option[4]").click() driver.find_element_by_id ("startDate").click () # time.sleep(1) frame = driver.find_element_by_xpath ("html/body/div[4]/iframe") driver.switch_to_frame (frame) driver.find_element_by_xpath (".//*[@id='dpTodayInput']").click () # time.sleep(1) driver.switch_to_default_content () # time.sleep(1) driver.find_element_by_id ("endDate").click () # time.sleep(1) driver.switch_to_frame (frame) # # # time.sleep(1) driver.find_element_by_xpath (".//*[@id='dpTitle']/div[6]/a").click () driver.find_element_by_xpath (".//*[@id='dpTitle']/div[6]/a").click () driver.find_element_by_xpath ("html/body/div[1]/div[3]/table/tbody/tr[4]/td[3]").click () driver.find_element_by_id ("dpOkInput").click () driver.switch_to_default_content () time.sleep (1) driver.find_element_by_xpath (".//*[@id='bidForm']/div/div/div[28]/button[1]").click () time.sleep (1) driver.find_element_by_id ("alertOkBtn").click () time.sleep (1) # 返回上架 # driver.find_element_by_xpath (".//*[@id='side-menu']/li[1]/ul[1]/li/a/span").click () # driver.find_element_by_xpath (".//*[@id='side-menu']/li[2]/a/span[1]").click () driver.find_element_by_xpath (".//*[@id='side-menu']/li[2]/ul[1]/li/a/span").click () time.sleep (1) driver.find_element_by_name ("title").send_keys (d['title']) driver.find_element_by_id ("searchForm-searchBtn").click () time.sleep (1) driver.find_element_by_xpath (".//*[@id='mDataTable']/tbody/tr[1]/td[14]/a[2]").click () time.sleep (1) driver.find_element_by_id ("confirmOkBtn").click () time.sleep(2) logger.info(d['title'])
def test_Login(self): datas = ExcelReader (self.excel).data login_page = LoginPage () driver = login_page.driver # Step3: 输入用户名 login_page.set_admin ("yradmin") # Step4: 输入密码 login_page.set_password ("a12345") time.sleep (6) # Step5: 单击登录按钮 login_page.click_login () for d in datas: with self.subTest (data=d): # login_page = LoginPage () # driver=login_page.driver # # Step3: 输入用户名 # login_page.set_admin ("yradmin") # # Step4: 输入密码 # login_page.set_password ("a12345") # time.sleep (6) # # Step5: 单击登录按钮 # login_page.click_login () login_page.click_jkbgl() login_page.click_ckzjkb() time.sleep (1) driver.switch_to_frame("contentIframe") login_page.click_new() time.sleep (1) login_page.click_bidProduct() # 选择产品 login_page.click_yyyay() #月月赢按月 # login_page.click_yyydq() #月月赢到期 login_page.click_loanuse() login_page.click_loanuseli() login_page.set_title(d['title']) login_page.set_loanBorrowershowname(d['title']) login_page.set_bidcode(d['title']) login_page.set_totalAmount("1000000") login_page.set_termValue("12") login_page.set_biddlimit("365") login_page.set_interestRate("10") login_page.set_raiseRate("0") login_page.set_shouxufei("0") login_page.set_choose() WebDriverWait (driver, 10).until (EC.presence_of_element_located ((By.XPATH, "//html/body/div/div/div/div[2]/iframe"))) a = driver.find_element_by_xpath ("//html/body/div/div/div/div[2]/iframe") driver.switch_to_frame (a) login_page.set_loanuser("张效伟") # login_page.set_loanuser("18301306330") login_page.click_search() time.sleep(3) login_page.click_searchok() time.sleep(1) driver.switch_to_default_content () driver.switch_to_frame ("contentIframe") # login_page.click_type() # # 正常标、爆款标、推荐标 # login_page.click_zcbiao() time.sleep(1) login_page.click_save() time.sleep(2) al = driver.switch_to_alert () al.accept () # 返回列表上架 driver.switch_to_default_content () login_page.click_ckzjkb() driver.switch_to_frame ("contentIframe") login_page.set_mingcheng(d['title']) login_page.click_sousuo() login_page.click_shangjia() time.sleep(1) driver.find_element_by_xpath ("//html/body/div/div/div/div[3]/input[1]").click () driver.switch_to_default_content() driver.close()
def test_Login(self): tels = ExcelReader(self.tel).data for d in tels: with self.subTest(data=d): regtel = int(d['login']) driver = webdriver.Chrome() zcurl = qturl + '/regist.do?method=toRegist' driver.get(zcurl) driver.find_element_by_id("nickName").send_keys("hkjf") driver.find_element_by_id("login").send_keys(regtel) # 手动输入问题 time.sleep(5) # driver.find_element_by_id("verify_code").send_keys('1') driver.find_element_by_id("sendSmsBtn").click() time.sleep(0.5) time.sleep(2.5) connection = Db().get_connection() cursor = Db().get_cursor() # cursor.execute ("SELECT id from bid_info where name=%s", (bidname,)) #SELECT * from sys_tel_message where tel='15912345678' cursor.execute( "SELECT * from sys_tel_message where tel=%s order by id desc limit 1", (regtel, )) connection.commit() t = cursor.fetchall() yzm = t[0]['MESSAGE_NOTE'] print(yzm) cursor.execute("SELECT * FROM personinfo WHERE LOGIN_NAME=%s", (d['name'], )) # SELECT * FROM personinfo WHERE LOGIN_NAME='牟泓霏' # UPDATE personinfo set login_name='',login_card='' where login_name='牟泓霏' connection.commit() t1 = cursor.fetchall() print(t1) print() l = len(t1) # print (l) # 输入密码 txt2 = driver.find_element_by_id("txt2") action_a = ActionChains(driver) action_a.move_to_element(txt2).click().send_keys( 'a12345').send_keys(Keys.RETURN).perform() # 推荐码 # driver.find_element_by_id("commendPhone").send_keys("01307172") # 定位焦点方法 elem = driver.find_element_by_id("randCode") action_a0 = ActionChains(driver) action_a0.move_to_element(elem).click().send_keys( yzm).send_keys(Keys.RETURN).perform() driver.find_element_by_id("btn_sub").submit() # #判断身份证,姓名是否已经被使用 # if l == 0: # print ('hello null') # driver.find_element_by_id ("loginName").send_keys (d['name']) # 姓名 # driver.find_element_by_id ("idCard").send_keys (d['idcard']) # 身份证 # driver.find_element_by_id ("email").send_keys ("*****@*****.**") # 邮箱 # driver.find_element_by_id ("btn_sub").click () # else: # print ('not null') # cursor.execute ("UPDATE personinfo set login_name='',login_card='' where login_name=%s", (d['name'],)) # # SELECT * FROM personinfo WHERE LOGIN_NAME='牟泓霏' # # UPDATE personinfo set login_name='',login_card='' where login_name='牟泓霏' # connection.commit () # # t1 = cursor.fetchall () # # print (t1) # driver.find_element_by_id("loginName").send_keys(d['name']) #姓名 # driver.find_element_by_id("idCard").send_keys(d['idcard']) #身份证 # driver.find_element_by_id("email").send_keys("*****@*****.**") #邮箱 # driver.find_element_by_id("btn_sub").click() # # time.sleep() # # driver.find_element_by_link_text("跳过该环节>>").click() driver.close()
def test_Login(self): datas = ExcelReader(self.excel).data for d in datas: with self.subTest(data=d): login_page = LoginPage() # Step3: 输入用户名 login_page.set_username("88812345678") # Step4: 输入密码 login_page.set_password("a12345") # Step5: 单击登录按钮 login_page.click_login() time.sleep(1) # login_page.driver.close() login_page.click_jkbgl() login_page.click_ckzjkb() time.sleep(1) login_page.click_new() time.sleep(1) login_page.click_bidProduct() # 选择产品 login_page.click_sanbiao() login_page.click_loanuse() login_page.click_loanuseli() login_page.set_title(d['title']) login_page.set_bidcode(d['title']) login_page.set_totalAmount("10000") login_page.set_termValue("6") login_page.set_interestRate("10") login_page.set_raiseRate("1") login_page.set_shouxufei("1") login_page.set_serviceRate("1") login_page.click_tqhb() #提前还本 login_page.click_ayjx() #按月计息 login_page.set_returnCapDays("0") login_page.click_choose() time.sleep(2) #13010000040 login_page.set_loanuser("13010000017") login_page.click_search() login_page.click_searchok() time.sleep(1) login_page.click_type() # 正常标、爆款标、推荐标 login_page.click_zcbiao() #匹配or直投 # login_page.click_zhitou() #直投类型 login_page.click_pipei() #匹配类型 login_page.click_save() time.sleep(1) login_page.click_ok() # time.sleep (1) # login_page.click_ckzjkb () #返回上架 # time.sleep (1) # login_page.set_mingcheng(d['title']) # login_page.click_sousuo() # time.sleep(1) # login_page.click_shangjia() # time.sleep(1) # login_page.click_shangjiaok() login_page.driver.close()
import time from utils.config import Config, DATA_PATH, REPORT_PATH from utils.file_reader import ExcelReader from selenium import webdriver from selenium.webdriver.common.by import By excel = DATA_PATH + '/renzi.xlsx' datas = ExcelReader(excel).data for d in datas: driver = webdriver.Firefox() driver.implicitly_wait(10) driver.get('http://10.1.27.52:9011/') driver.find_element( By.XPATH, "//input[@widgetcode='JGTextBox1']").send_keys(d['username']) driver.find_element(By.XPATH, "//input[@widgetcode='JGPasswordBox1']").send_keys( d['password']) driver.find_element(By.XPATH, "//*[@widgetcode='JGButton1']").click() time.sleep(1) # fail_text = driver.find_element(By.ID, "dialog_content_div").text # print("----->%s" % fail_text) # if fail_text: # print("fail_text %s" % fail_text) # # else: # sucess_text = driver.find_element(By.XPATH, "//span[contains(text(),'登录时间')] ").text # print('sucess_text %s' % sucess_text) # driver.quit() driver.find_element( By.XPATH,
import os from selenium.webdriver.common.by import By import unittest from utils.config import Config, DATA_PAHT from utils.log import logger from utils.file_reader import ExcelReader from parameterized import parameterized from test.page.login_page import LoginPage from test.page.index_page import IndexPage account_path = DATA_PAHT + '\\user_account.xlsx' account = ExcelReader(account_path, sheet=1).data class TestLogin(unittest.TestCase): URL = Config().get('EAF-URL') txtAccount = (By.ID, 'txtAccount') txtPassword = (By.ID, 'txtPassword') print('文件路径', account_path) def setUp(self): os.system('taskkill /f /im chromedriver.exe') self.page = LoginPage().get(self.URL) self.page.sleep(2) def tearDown(self): self.page.sleep(1.5) self.page.quit() @parameterized.expand(account) def test_login(self, username, password):
def test_Login(self): tels = ExcelReader(self.tel).data for d in tels: with self.subTest(data=d): regtel = int(d['login']) print(regtel) driver = webdriver.Chrome() driver.get(jkurl + '/hk-financial-services/register/register.html') driver.find_element_by_id("nickName").send_keys("hkjf") driver.find_element_by_id("loginTmp").send_keys(regtel) # 手动输入问题 time.sleep(8) # input('请输入?计算结果!') # driver.find_element_by_id("verify_code")sendSmsBtn driver.find_element_by_id("smsCodeBtn").click() time.sleep(0.5) driver.find_element_by_xpath( ".//*[@id='dialog']/div/div/div[1]/button").click() time.sleep(3) con = db.Db() connection = con.connection cursor = con.cursor # cursor.execute ("SELECT id from bid_info where name=%s", (bidname,)) #SELECT * from sys_tel_message where tel='15912345678' cursor.execute( "SELECT msg from sms_tel_msg WHERE tel=%s order by id desc limit 1", (regtel, )) # 提交SQL connection.commit() t = cursor.fetchall() yzm = t[0]['msg'] print(yzm) cursor.execute( "SELECT real_name from reg_user_detail WHERE real_name=%s", (d['name'], )) # SELECT * FROM personinfo WHERE LOGIN_NAME='牟泓霏' # UPDATE personinfo set login_name='',login_card='' where login_name='牟泓霏' connection.commit() t1 = cursor.fetchall() print(t1) print() l = len(t1) print(l) # 输入密码 driver.find_element_by_id("passwdTmp").send_keys("a12345") # 推荐码 driver.find_element_by_id("commendNo").send_keys("69321686") # 定位焦点方法 elem = driver.find_element_by_id("smsCode") action_a0 = ActionChains(driver) action_a0.move_to_element(elem).click().send_keys( yzm).send_keys(Keys.RETURN).perform() driver.find_element_by_id("submitBtn").submit() time.sleep(0.5) #判断身份证,姓名是否已经被使用 if l == 0: print('hello null') driver.find_element_by_id("realName").send_keys( d['name']) # 姓名 driver.find_element_by_id("idCard").send_keys( d['idcard']) # 身份证 driver.find_element_by_id("email").send_keys( "*****@*****.**") # 邮箱 driver.find_element_by_id("submitBtn").click() else: print('not null') cursor.execute( "SELECT reg_user_id from reg_user_detail where real_name=%s", (d['name'], )) connection.commit() t2 = cursor.fetchall() id = t2[0]['reg_user_id'] print(id) # cursor.execute ("SELECT identify from reg_user where id=%s", (id,)) # connection.commit () cursor.execute( "update reg_user set identify=0 where id=%s", (id, )) # 清理实名状态 connection.commit() cursor.execute( "UPDATE reg_user_detail set real_name='',id_card='' where real_name=%s", (d['name'], )) # 清理实名 connection.commit() # t1 = cursor.fetchall () # print (t1) driver.find_element_by_id("realName").send_keys( d['name']) #姓名 driver.find_element_by_id("idCard").send_keys( d['idcard']) #身份证 driver.find_element_by_id("email").send_keys( "*****@*****.**") #邮箱 driver.find_element_by_id("submitBtn").click() time.sleep(2) # driver.find_element_by_link_text("跳过该环节>>").click() driver.close()
def test_newsanbiaomonth(self): datas = ExcelReader(self.excel).data for d in datas: with self.subTest(data=d): driver = webdriver.Chrome() driver.get( "http://192.168.1.249:9901/hkjf/loginAdmin.do?method=tologin" ) driver.find_element_by_xpath(".//*[@id='login']").send_keys( "yradmin") driver.find_element_by_xpath(".//*[@id='password']").send_keys( "a12345") time.sleep(5) # 手动输入验证码 # driver.find_element_by_xpath (".//*[@id='apLogin']/div[1]/ul/li[3]/p[3]/img").send_keys(text) driver.find_element_by_id("button").submit() # driver.find_element_by_name('verifyCode').clear() #driver.find_element_by_xpath (".//*[@id='apLogin']/div[1]/ul/li[3]/p[3]/img").send_keys(text) #driver.find_element_by_xpath (".//*[@id='button']").click() driver.find_element_by_xpath( ".//*[@id='left']/div/ul/li[5]/div/span[1]").click() driver.find_element_by_link_text("筹款中的借款标").click() time.sleep(1) handles = driver.current_window_handle print(handles) driver.switch_to_frame("contentIframe") driver.find_element_by_link_text("添加").click() time.sleep(5) driver.find_element_by_id("select1_input").click() #月月赢 按月付息 到期还本 driver.find_element_by_id( "li1_input_934981df-2ac6-11e5-9ecc-1051721c3a3e_0").click( ) driver.find_element_by_id("select2_input").click() driver.find_element_by_id("li2_input_1").click() # title="m爆款标201822802" driver.find_element_by_id("loanTitle").send_keys(d['title']) driver.find_element_by_id("loanBorrowershowname").send_keys( d['title']) driver.find_element_by_id("projectCode").send_keys(d['title']) driver.find_element_by_id("amount").send_keys("100000") driver.find_element_by_id("termvalue").send_keys("1") driver.find_element_by_id("biddlimit").send_keys("365") driver.find_element_by_id("rate").send_keys("10") driver.find_element_by_id("raiseRate").send_keys("0") driver.find_element_by_id("loanrate").send_keys("0") driver.find_element_by_id("loanServiceRate").send_keys("0") driver.find_element_by_id("select4_input").click() # 标的属性 # driver.find_element_by_id("li4_input_2").click() # 是否提前还款 driver.find_element_by_name("isAdvReturnCap").send_keys( Keys.SPACE) # driver.find_element_by_id("returnCapDays").send_keys("0") #选择借款人 # .//*[@id='prodetail']/div[1]/table/tbody/tr[22]/td/span[1]/div[1]/input # .//*[@id='prodetail']/div[1]/table/tbody/tr[32] # .//*[@id='prodetail']/div[1]/table/tbody/tr[44]/td/input[2] driver.find_element_by_xpath( ".//*[@id='prodetail']/div[1]/table/tbody/tr[44]/td/input[2]" ).send_keys(Keys.SPACE) # time.sleep(5) WebDriverWait(driver, 15).until( EC.presence_of_element_located( (By.XPATH, "//html/body/div/div/div/div[2]/iframe"))) # a=driver.find_elements_by_xpath(".//*[@id='d86zjCDbir']/div[1]/div[2]/iframe") # a=driver.find_element_by_xpath("//html/body/div[2]/div[1]/div[1]/div[2]") a = driver.find_element_by_xpath( "//html/body/div/div/div/div[2]/iframe") driver.switch_to_frame(a) # driver.switch_to_frame(a) #dr.find_element_by_xpath(".//*[@id='d86zjCDbir']/div[1]/div[2]/iframe") # driver.find_element_by_xpath("//form[@id='queryForm']/ul/li/span/input").send_keys("123")T driver.find_element_by_xpath( ".//*[@id='loginName']").send_keys("颜祖佑") driver.find_element_by_link_text("查询").click() time.sleep(3) driver.find_element_by_link_text("选择").click() time.sleep(1) driver.switch_to_default_content() driver.switch_to_frame("contentIframe") driver.find_element_by_link_text("保存").submit() time.sleep(2) al = driver.switch_to_alert() al.accept() # 返回列表上架 driver.switch_to_default_content() driver.find_element_by_link_text("筹款中的借款标").click() driver.switch_to_frame("contentIframe") driver.find_element_by_name("title").send_keys(d['title']) driver.find_element_by_link_text("查询").click()
def test_Login(self): datas = ExcelReader(self.excel).data for d in datas: with self.subTest(data=d): amount = 10000 # Step3: 输入用户名 # login_page.set_admin ("yradmin") # # Step4: 输入密码 # login_page.set_password ("a12345") # time.sleep (6) # # Step5: 单击登录按钮 # login_page.click_login () # # login_page.click_jkbgl () # login_page.click_ckzjkb () # time.sleep (1) # driver.switch_to_frame ("contentIframe") # login_page.click_new () # time.sleep (1) # login_page.click_bidProduct () # # 选择产品 # login_page.click_yyyay() # 月月赢按月 # # login_page.click_nnydq () # 年年赢到期 # login_page.click_loanuse () # login_page.click_loanuseli () # login_page.set_title (d['title']) # login_page.set_loanBorrowershowname (d['title']) # login_page.set_bidcode (d['title']) # login_page.set_totalAmount (amount) # login_page.set_termValue ("3") # login_page.set_biddlimit ("365") # login_page.set_interestRate ("10") # login_page.set_raiseRate ("0") # login_page.set_shouxufei ("0") # login_page.set_choose () # WebDriverWait (driver, 10).until ( # EC.presence_of_element_located ((By.XPATH, "//html/body/div/div/div/div[2]/iframe"))) # a = driver.find_element_by_xpath ("//html/body/div/div/div/div[2]/iframe") # driver.switch_to_frame (a) # login_page.set_loanuser ("transfer") # # # login_page.set_loanuser("18301306330") # login_page.click_search () # time.sleep (3) # login_page.click_searchok () # time.sleep (1) # driver.switch_to_default_content () # driver.switch_to_frame ("contentIframe") # # login_page.click_type() # # # 正常标、爆款标、推荐标 # # login_page.click_zcbiao() # time.sleep (1) # login_page.click_save () # time.sleep (2) # al = driver.switch_to_alert () # al.accept () # # 返回列表上架 # driver.switch_to_default_content () # login_page.click_ckzjkb () # driver.switch_to_frame ("contentIframe") # login_page.set_mingcheng (d['title']) # login_page.click_sousuo () # # login_page.click_shangjia () # time.sleep (1) # driver.find_element_by_xpath ("//html/body/div/div/div/div[3]/input[1]").click () connection = Db().get_connection() cursor = Db().get_cursor() # 通过cursor创建游标 cursor.execute("SELECT * from bidd_info where title=%s", (d['title'], )) # 提交SQL connection.commit() t = cursor.fetchall() print(t) bidname = t[0]['TITLE'] print(bidname) cursor.execute("SELECT code from bidd_info where title=%s", (bidname, )) # 提交SQL connection.commit() t = cursor.fetchall() # a=t['tel'] a = t[0]['code'] #登录前台投资 driver = webdriver.Chrome() driver.get( 'http://192.168.1.249:9901/hkjf/index.do?method=getIndexPage' ) WebDriverWait(driver, 10).until( EC.presence_of_element_located((By.ID, 'login'))) driver.find_element_by_id('login').send_keys('13010000013') time.sleep(1) e1 = driver.find_element_by_xpath(".//*[@id='txt2']") action = ActionChains(driver) action.move_to_element(e1).click().send_keys( "8b08c0bd2c536072a4bed2ddebcc4f01a73549106e04d12659aed56cf938d6b72f3a53149b488e4a309f2fe9851d8d3ad60a429cbe4e82dd16cfb1206dc7c7752ddf861a79374247777d76d3188061738b196fddd53e3f0ae1044c525fa9f35de6cfa0ce69dd2f2e30e4211acfd8a4d806d9c22bb5130aa68eceda6cc78c9630" ).perform() driver.find_element_by_xpath( ".//*[@id='logindiv']/div/div[2]").submit() time.sleep(1) # address=("http://192.168.1.249:9901/hkjf/investControllerFront.do?method=detail&code=ed791706-92f7-4435-b6f6-aa944ed87f4c") ad1 = "http://192.168.1.249:9901/hkjf/investControllerFront.do?method=detail&code=" ad2 = a add = ad1 + ad2 driver.get(add) time.sleep(1) # driver.find_element_by_id ("projectCode").send_keys (d['title']) driver.find_element_by_id("amount").send_keys(amount) #投资金额 driver.find_element_by_link_text("立即投资").click() time.sleep(3) driver.find_element_by_class_name("dialogBtn").click() # 后台登录 driver.get( "http://192.168.1.249:9901/hkjf/loginAdmin.do?method=tologin" ) login_page.set_admin("yradmin") # Step4: 输入密码 login_page.set_password("a12345") time.sleep(6) # Step5: 单击登录按钮 login_page.click_login() login_page.click_jkbgl() time.sleep(0.5) #审核标的 driver.find_element_by_link_text("待审核的借款标").click() driver.switch_to_frame("contentIframe") time.sleep(0.5) driver.find_element_by_name("title").send_keys(d['title']) driver.find_element_by_link_text("查询").click() driver.find_element_by_link_text("审核").click() driver.find_element_by_id("content").send_keys("满标审核通过!") driver.find_element_by_link_text("通过").click() driver.switch_to_default_content() #放款 driver.find_element_by_xpath( ".//*[@id='left']/div/ul/li[7]/div/span[1]").click() time.sleep(0.5) driver.find_element_by_link_text("待放款的借款标").click() driver.switch_to_frame("contentIframe") time.sleep(0.5) driver.find_element_by_name("title").send_keys(d['title']) driver.find_element_by_link_text('查询').click() driver.find_element_by_link_text("放款").click() time.sleep(0.8) driver.find_element_by_xpath( "//html/body/div/div/div/div[3]/input[1]").click() driver.close()
def test_Login(self): # excel = DATA_PATH + '/register.xlsx' datas = ExcelReader(self.excel).data for d in datas: with self.subTest(data=d): db = Db() connection = db.connection cursor = db.cursor # cursor.execute ("SELECT message_note from sys_tel_message where tel='13301302026'") cursor.execute( "SELECT code from bidd_info where title='月月9438'") connection.commit() t = cursor.fetchall() # a=t['tel'] code = t[0]['code'] print('标的code:', code) tel = int(float(d['title'])) print('用户:', tel) # 用户登录 content = { 'login': tel, 'password': '******', 'pwdLevel': '2', 'verify_code': '请输入计算结果', 'randCode': '请输入您的6位验证码', 'commendPhone': '请输入推荐码(推荐人手机号后8位)', 'loginregister': '请输入您的手机号', 'passwordresgister': '', 'token': '', 'modulus': '', 'exponent': '', 'newToken': '', 'phoneId': '', 'code': '', 'utype': '', 'csrftoken': '', 'pwdLevel': '' } r = requests.post( 'http://192.168.1.249:9901/hkjf/login.do?method=indexlogin', data=content) # 发送请求 print('登录响应状态', r.status_code) print(r.text) c = r.cookies # 请求标的详情 content_xq = {'code': code, 'tempType': '2'} rxq = requests.get( "http://192.168.1.249:9901/hkjf/investControllerFront.do?method=detail", params=content_xq, cookies=c) txt = rxq.text r = re.findall( r'<input name="token" type="hidden" value="(.+?)"/>', txt) # print("token的值是:",r) print('详情响应code:', rxq.status_code) # 用户投资 contenttz = { 'code': code, 'token': r, 'couponDetailCodeK': '', 'couponDetailCodeJ': '', 'confirmAmount': '1000', 'useAbleMoney': '' } rtz = requests.post( 'http://192.168.1.249:9901/hkjf/investController.do?method=goodsOpenInvest', data=contenttz, cookies=c) # 发送请求 print('投资响应状态', rtz.status_code)