class TestInvesto(unittest.TestCase): 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='m季季81602'") connection.commit () t = cursor.fetchall () # a=t['tel'] code= t[0]['code'] print('标的code:',code) def test_login(self): #用户登录 content={'login':'******','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':TestInvesto.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':TestInvesto.code,'token':r,'couponDetailCodeK':'','couponDetailCodeJ':'','confirmAmount':'1000','useAbleMoney':'1000'} 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)
def Login(): # 定义接口函数 excel = DATA_PATH + '/test.csv' with open(excel, "r", encoding="utf-8") as f: reader = csv.reader(f) for col in reader: print(col) 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='m季季81602'") connection.commit() t = cursor.fetchall() # a=t['tel'] code = t[0]['code'] print('标的code:', code) tel = col print('用户:', tel) # 实例化接口对象 #login = postRequest ('http://10.128.6.167/working/login', {"MSG": 00001, "name": u"张三", "password": "******"},"1.login") 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) # 发送请求 login1 = requests.post( 'http://192.168.1.249:9901/hkjf/login.do?method=indexlogin', data=content) # 发送请求 return login1.post()
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='m季季81602'") 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 = { 'access_token': '1b1d5757-9322-4d83-bb79-fed79f973dad', 'amount': '100', '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.mysign2(content_tz) print(a) m = hashlib.md5() # 创建md5对象 m.update( a.encode(encoding='UTF-8')) # 生成加密串,其中password是要加密的字符串 # hashlib.md5('abcdefg'.encode(encoding='UTF-8')).hexdigest() sign = m.hexdigest() print(sign) content_tz2 = { 'access_token': '1b1d5757-9322-4d83-bb79-fed79f973dad', 'amount': '100', '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 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()
# coding = utf-8 import csv import re from urllib import request, parse from urllib.error import URLError import threading import requests from testjf_UI.common.db import Db from utils.config import DATA_PATH 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='m季季81602'") connection.commit() t = cursor.fetchall() # a=t['tel'] code = t[0]['code'] print('标的code:', code) def Login(): excel = DATA_PATH + '/test.csv' with open(excel, "r", encoding="utf-8") as f: reader = csv.reader(f) for col in reader: print(col) # db = Db ()