def __init__(self): #初始化设备信息 try: self.driver = connecthub(pc_type, pc_ip, 2) if self.driver: Log().info("连接服务器成功") else: Log().info("连接服务器失败") except Exception as e: Log().info(e) #登录相关 self.com1 = appclass(self.driver, cpath2) #订单相关 self.com2 = appclass(self.driver, cpath3)
def __init__(self, con_name, driver, cpath, pc_type, pc_ip, getparam, i): # appclass.__init__(self,driver,cpath) self.com = appclass() self.con_name = con_name self.com.driver = driver self.cpath = cpath self.pc_type = pc_type self.pc_ip = pc_ip self.getparam = getparam self.i = i
def tests_r(self): #流程测试r合同 u'''即有宝流程测试r合同''' # textval = MysqlUtil().mysql_getstring("SELECT t.con_name FROM (SELECT * FROM mobiletest_mobiledata WHERE con_name LIKE '%s%%' ORDER BY create_time DESC) t LIMIT 1"%con_name) #流程测试r合同 textvall = getyaml(PATH("..\config\yaml\jyb\dim.yaml")).get( 'name') #流程测试r合同 Log().info("名称:%s" % textvall) #流程测试r合同 com = appclass(self.driver, self.cpath) #流程测试r合同 com.elm_operate(42, "") #流程测试r合同 time.sleep(1) #流程测试r合同 if self.pc_type.split(':')[0] == "android真机": #流程测试r合同 com.elm_operate(43, "") #流程测试r合同 time.sleep(2) #流程测试r合同 com.elm_operate(44, "") #拍照确认 #流程测试r合同 else: #流程测试r合同 com.elm_operate(82, "") #流程测试r合同 time.sleep(2) #流程测试r合同 com.elm_operate(83, "") #拍照确认 #流程测试r合同 com.elm_operate(54, "") #流程测试r合同 com.elm_operate(51, "") #流程测试r合同 com.elm_operate(45, "") #流程测试r合同 time.sleep(20) #流程测试r合同 com.checkItem("授权", "客户信息页上传照片") #流程测试r合同 com.elm_operate(46, "") #流程测试r合同 time.sleep(10) #等下最新验证码生成 #流程测试r合同 if textvall.startswith('测试'): #流程测试r合同 pcode = "741852" #流程测试r合同 else: #流程测试r合同 pcode = OracleUtil(dbname).oracle_getstring( "select code from (select * from cs_sms_authority where mobile='%s' order by create_time desc) where rownum=1" % mobilephone) #流程测试r合同 time.sleep(3) #流程测试r合同 com.elm_operate(47, pcode) #输入验证码741852 #流程测试r合同 com.elm_operate(48, "") # 征信授权页完成 #流程测试r合同 time.sleep(5) #流程测试r合同 com.checkItem("PDF", "征信授权页保存") #流程测试r合同 com.elm_operate(49, "") #流程测试r合同 time.sleep(12) #流程测试r合同 stpr = MysqlUtil().mysql_getstring( "SELECT con_status FROM mobiletest_mobiledata WHERE con_name ='%s'" % textvall) #流程测试r合同 if com.findItem("基本信息") and stpr == 'pr': #流程测试r合同 Log().info("PDF列表页提交预审保存完成,r合同生成成功") #流程测试r合同 MysqlUtil().mysql_execute( "UPDATE mobiletest_mobiledata SET con_status='r' WHERE con_name='%s'" % textvall) #流程测试r合同 else: #流程测试r合同 Log().info("PDF列表页提交预审,r合同生成失败") #流程测试r合同 raise RunError('r合同生成异常')
def tests_s(self): u'''即有宝流程测试s合同''' com = appclass(self.driver, self.cpath) com.elm_operate(42, "") time.sleep(1) com.elm_operate(43, "") time.sleep(2) com.elm_operate(44, "") #拍照确认 com.elm_operate(45, "") Log().info("客户门店照片页完成") com.elm_operate(46, "") time.sleep(10) #等下最新验证码生成 V = OracleUtil(dbname) pcode = V.oracle_getstring( "select code from (select * from cs_sms_authority where mobile='%s' order by create_time desc) where rownum=1" % mobilephone) time.sleep(2) com.elm_operate(47, pcode) #输入验证码 com.elm_operate(48, "") # 征信授权页完成 Log().info("征信授权页完成") com.elm_operate(49, "") Log().info("PDF列表页面完成") com.elm_operate(50, "") com.elm_operate(51, "") com.elm_operate(52, "") com.elm_operate(53, "") Log().info("其他信息页完成") for a in range(54, 67): com.elm_operate(a, "") com.swipeup() com.elm_operate(67, "") Log().info("基本信息页完成") for b in range(68, 77): com.elm_operate(b, "") com.swipeup() for v in range(77, 82): com.elm_operate(v, "") Log().info("单位信息页完成") self.driver.quit()
def tests_r(self): #流程测试r合同 u'''即有宝流程测试r合同''' # textval = MysqlUtil().mysql_getstring("SELECT t.con_name FROM (SELECT * FROM mobiletest_mobiledata WHERE con_name LIKE '%s%%' ORDER BY create_time DESC) t LIMIT 1"%con_name) #流程测试r合同 com = appclass(self.driver, self.cpath) #流程测试r合同 com.elm_operate(42, "") #流程测试r合同 time.sleep(1) #流程测试r合同 if self.pc_type == "android真机": #流程测试r合同 com.elm_operate(43, "") #流程测试r合同 time.sleep(2) #流程测试r合同 com.elm_operate(44, "") #拍照确认 #流程测试r合同 else: #流程测试r合同 com.elm_operate(82, "") #流程测试r合同 time.sleep(2) #流程测试r合同 com.elm_operate(83, "") #拍照确认 #流程测试r合同 com.elm_operate(45, "") #流程测试r合同 time.sleep(20) #流程测试r合同 com.checkItem("授权", "客户信息页上传照片") #流程测试r合同 com.elm_operate(46, "") #流程测试r合同 time.sleep(10) #等下最新验证码生成 #流程测试r合同 pcode = OracleUtil(dbname).oracle_getstring( "select code from (select * from cs_sms_authority where mobile='%s' order by create_time desc) where rownum=1" % mobilephone) #流程测试r合同 time.sleep(3) #流程测试r合同 com.elm_operate(47, pcode) #输入验证码 #流程测试r合同 com.elm_operate(48, "") # 征信授权页完成 #流程测试r合同 time.sleep(4) #流程测试r合同 com.checkItem("签章", "征信授权页下一步保存") #流程测试r合同 com.elm_operate(49, "") #流程测试r合同 time.sleep(3) #流程测试r合同 com.checkItem("其他信息", "PDF列表页下一步保存") #流程测试r合同 com.elm_operate(50, "") #流程测试r合同 com.elm_operate(51, "") #流程测试r合同 com.elm_operate(52, "") #流程测试r合同 com.elm_operate(53, "") #流程测试r合同 time.sleep(4) #流程测试r合同 if com.findItem("基本信息"): #流程测试r合同 Log().info("其他信息页下一步,r合同生成成功") #流程测试r合同 MysqlUtil().mysql_execute( "UPDATE mobiletest_mobiledata SET con_status='r' WHERE con_name='%s'" % newcon_name) #流程测试r合同 else: #流程测试r合同 Log().info("其他信息页下一步,r合同生成失败") #流程测试r合同
def tests_pr(self): u'''即有宝流程测试pr合同''' Log().info("订单流程开始") time.sleep(5) com = appclass(self.driver,self.cpath) # com.capital_sel(getparam['paramk']) #资金池--暂屏蔽 com.swipeleft(3) time.sleep(1) com.elm_operate(0,"") com.elm_operate(1,self.uname) for x in range(2,4): com.elm_operate(x,"") time.sleep(3) if com.findItem("ok"): com.elm_operate(4,"") if com.findItem("开启手势密码"): # self.driver.tap([(0,60), (1080,210), (100, 100)], 100) # com.elm_operate(5,"") time.sleep(1) if com.findItem("确定"): com.elm_operate(6,"") com.elm_operate(7,"") time.sleep(4) com.get_dbtext(1,self.getparam['parama']) com.elm_operate(8,"") time.sleep(1) com.get_dbtext(0,self.getparam['paramb']) com.elm_operate(9,"") time.sleep(1) com.get_dbtext(0,self.getparam['paramc']) com.elm_allson_send(12,13,0,self.getparam['paramd']) com.elm_allson_send(12,13,1,self.getparam['parame']) com.elm_operate(14,"") time.sleep(4) com.checkItem("选择分期","新建订单页面一下一步保存") #------------15,16 bx_one= self.driver.find_elements_by_id("com.giveu.corder:id/switch_insurance") bbx= self.driver.find_elements_by_id("com.giveu.corder:id/switch_treasure") print(bx_one) if getparam['paramf'] == '不参加' and len(bx_one) > 0: self.driver.find_element_by_id("com.giveu.corder:id/switch_insurance").click() elif getparam['paramf'] == '保险' and len(bbx) > 0: self.driver.find_element_by_id("com.giveu.corder:id/switch_treasure").click() else: print("pass") time.sleep(2) com.get_dbtext(0,self.getparam['paramg']) com.swipeup() com.elm_operate(17,"") time.sleep(4) com.checkItem("商品类型","新建订单页面二下一步保存") etm=self.driver.find_element_by_id("com.giveu.corder:id/ll_item") etms=etm.find_elements_by_id("com.giveu.corder:id/tv_choose_right") time.sleep(1) # com.elm_allson_click(18,19,0) etms[0].click() time.sleep(1) com.get_dbtext(0,self.getparam['paramh']) # com.elm_allson_click(18,19,1) etms[1].click() time.sleep(1) com.get_dbtext(0,self.getparam['parami']) com.elm_operate(20,"") #预留21,22 qmb= self.driver.find_elements_by_id("com.giveu.corder:id/cb_insurance") sspa= self.driver.find_elements_by_id("com.giveu.corder:id/cb_broken") if self.getparam['paramj'] == '全面保' and len(qmb) > 0: self.driver.find_element_by_id("com.giveu.corder:id/cb_insurance").click() elif self.getparam['paramj'] == '碎碎平安' and len(sspa) > 0: self.driver.find_element_by_id("com.giveu.corder:id/cb_broken").click() else: print("pass") com.swipeup() com.elm_operate(23,"") time.sleep(4) com.checkItem("身份证","新建订单页面三下一步保存") #拍照 com.elm_operate(24,"") com.elm_operate(25,"") time.sleep(2) com.swipedown() com.elm_operate(26,con_name+chzw()) textval = com.get_elm_textval(26) n={'name':textval} wryaml(PATH("..\config\yaml\jyb\dim.yaml"),n) time.sleep(2) textvall=getyaml(PATH("..\config\yaml\jyb\dim.yaml")).get('name') # pathcname=os.path.realpath(__file__) # print(pathcname) # change_name(pathcname,textval) # Log().info("合同名更新完成") # time.sleep(4) for s in range(27,41): com.elm_operate(s,"") time.sleep(1) com.swipeup() com.elm_operate(41,"") Log().info("订单名称:%s "%textval) V = OracleUtil(dbname) time.sleep(2) cnoval =V.oracle_getstring("select contract_no from cs_credit where id_person=(select id from (select * from cs_person where name like '%s%%' order by create_time desc) where rownum=1)"%textval) time.sleep(1) print(cnoval) A = MysqlUtil() time.sleep(2) A.mysql_execute("INSERT INTO mobiletest_mobiledata (contract_no,con_name,con_ident,con_phone,create_time,capital_source,con_status,username,runnum) VALUES ('%s','%s','%s','%s',NOW(),'%s','%s','%s','%s')"%(cnoval,textval,idcard,mobilephone,getparam['paramk'],getparam['paraml'],uname,markval)) if com.findItem("客户门店照片"): Log().info("订单pr合同号生成成功:%s"%cnoval) MysqlUtil().mysql_execute("UPDATE mobiletest_mobiledata SET con_status='pr' WHERE con_name='%s'"%textval) else: Log().info("订单pr合同号生成异常:%s"%cnoval)
def tests_s(self): #流程测试s合同 u'''即有宝流程测试s合同''' # textval = MysqlUtil().mysql_getstring("SELECT t.con_name FROM (SELECT * FROM mobiletest_mobiledata WHERE con_name LIKE '%s%%' ORDER BY create_time DESC) t LIMIT 1"%con_name) #流程测试s合同 textvall=getyaml(PATH("..\config\yaml\jyb\dim.yaml")).get('name')#流程测试s合同 Log().info("名称:%s"%textvall) #流程测试s合同 com = appclass(self.driver,self.cpath) #流程测试s合同 for a in range(60,67): #流程测试s合同 com.elm_operate(a,"") #流程测试s合同 com.swipeup() #流程测试s合同 com.elm_operate(67,"") #流程测试s合同 time.sleep(4) #流程测试s合同 com.checkItem("单位信息","基本信息页下一步保存") #流程测试s合同 for b in range(68,77): #流程测试s合同 com.elm_operate(b,"") #流程测试s合同 com.swipeup() #流程测试s合同 for v in range(77,82): #流程测试s合同 com.elm_operate(v,"") #流程测试s合同 time.sleep(4) #流程测试s合同 com.checkItem("联系人","单位信息页下一步保存") #流程测试s合同 #-----Begin----填写联系人信息 --20181015 chenjingxu #流程测试s合同 #填写文本框内容 #流程测试s合同 Log().info("开始填写联系人信息") #流程测试s合同 HF = "未婚" #流程测试s合同 com3 = appclass(self.driver, PATH("..\config\yaml\jyb\jybcase2.yaml")) #流程测试s合同 #填写姓名和手机号 #流程测试s合同 if HF == "已婚": #流程测试s合同 for h in range(0, 7): #流程测试s合同 com3.elm_operate(h, "") #流程测试s合同 else: #流程测试s合同 for h in range(0, 5): #流程测试s合同 com3.elm_operate(h, "") #流程测试s合同 #选择与本人关系 #流程测试s合同 r = 0 #流程测试s合同 for s in range(9, 11): #流程测试s合同 lis = [12, 48] #流程测试s合同 com3.elm_operate(s, "") #流程测试s合同 print("没有点击打开弹窗") #流程测试s合同 time.sleep(0.5) #流程测试s合同 com3.elm_operate(lis[r], "") #流程测试s合同 r = r + 1 #流程测试s合同 #提交 #流程测试s合同 com3.elm_operate(13,"") #流程测试s合同 Log().info("恭喜,填写联系人信息成功!!!") #流程测试s合同 #第一步 填写银行卡号 #流程测试s合同 self.driver.activate_ime_engine("com.sohu.inputmethod.sogou.xiaomi/.SogouIME") #流程测试s合同 com3.elm_operate(21, "") #流程测试s合同 self.driver.activate_ime_engine("io.appium.android.ime/.UnicodeIME") #流程测试s合同 com3.elm_operate(52, "") #流程测试s合同 com3.elm_operate(53, "") #流程测试s合同 time.sleep(3) #流程测试s合同 # com3.elm_operate(30, "") #流程测试s合同 # time.sleep(4) #流程测试s合同 # MysqlUtiltwo().mysql_execute("update credit_bankcard_four set check_result=2000 where name='%s'"%textvall) #流程测试s合同 MysqlUtiltwo().mysql_execute("INSERT INTO credit_bankcard_four (`name`,bank_card,mobile,id_number,check_result,check_msg,sp_code,create_time,service_id,extra) VALUES ('%s','6228481359515816576','13300000000','511000198506020031','2000','全匹配','BAIRONG',NOW(),'10000',NULL)"%textvall) #流程测试s合同 time.sleep(2) #流程测试s合同 com3.elm_operate(55, "") #流程测试s合同 time.sleep(2) #流程测试s合同 send_codee =MysqlUtiltwo().mysql_getstring("SELECT t.sms_code FROM (SELECT * FROM sms_verify_info WHERE phone = '%s' ORDER BY sent_time DESC) t LIMIT 1"%mobilephone) #流程测试s合同 print(send_codee) #流程测试s合同 time.sleep(10) #流程测试s合同 com3.elm_operate(54,send_codee) #流程测试s合同 com3.elm_operate(15, "") #流程测试s合同 com3.checkItem("其他信息","绑定银行卡页保存")#流程测试s合同 #------------------------------------断 #流程测试s合同 #进入其他信息页 #流程测试s合同 com3.elm_operate(32, "") #流程测试s合同 com3.elm_operate(33, "") #流程测试s合同 com3.elm_operate(34, "") #流程测试s合同 com3.elm_operate(15, "") #流程测试s合同 time.sleep(1) #流程测试s合同 com3.checkItem("授权","其他信息页保存")#流程测试s合同 #跳过授权 #流程测试s合同 com3.elm_operate(15, "") #流程测试s合同 com3.checkItem("小问卷","跳过授权保存")#流程测试s合同 #小问卷 #流程测试s合同 com3.elm_operate(36, "") #流程测试s合同 com3.elm_operate(37, "") #流程测试s合同 com3.elm_operate(51, "") #流程测试s合同 com3.checkItem("影像证明","小问卷保存")#流程测试s合同 #上传影像证明 #流程测试s合同 com3.swipedown() #流程测试s合同 com3.elm_operate(38, "") #流程测试s合同 com3.elm_operate(39, "") #流程测试s合同 com3.elm_operate(40, "") #流程测试s合同 time.sleep(2) #流程测试s合同 self.driver.wait_activity("com.giveu.corder.ordercreate.activity.PhotoCertificateActivity", 20, 1) #流程测试s合同 com3.swipeup() #流程测试s合同 com3.elm_operate(41, "") #提交 #流程测试s合同 com3.elm_operate(42, "") #流程测试s合同 com3.elm_operate(43, "") #流程测试s合同 time.sleep(2) #流程测试s合同 if com3.findItem("成功提交"): #流程测试s合同 Log().info("即有宝S合同生成成功") #流程测试s合同 MysqlUtil().mysql_execute("UPDATE mobiletest_mobiledata SET con_status='s' WHERE con_name='%s'"%textvall) #流程测试s合同 else: #流程测试s合同 Log().info("即有宝S合同生成失败") #流程测试s合同
def tests_pr(self): u'''即有宝流程测试pr合同''' Log().info("订单流程开始") time.sleep(5) com = appclass(self.driver, self.cpath) com.swipeleft(3) time.sleep(1) for x in range(4): com.elm_operate(x, "") time.sleep(3) for z in range(4, 7): #300079wei4 842928wei5 com.elm_click(z) time.sleep(0.5) com.elm_operate(7, "") time.sleep(4) com.get_dbtext(1, self.getparam['parama']) com.elm_operate(8, "") time.sleep(1) com.get_dbtext(0, self.getparam['paramb']) com.elm_operate(9, "") time.sleep(1) com.get_dbtext(0, self.getparam['paramc']) com.elm_operate(10, "") time.sleep(1) com.elm_operate(11, "") com.elm_allson_send(12, 13, 0, self.getparam['paramd']) com.elm_allson_send(12, 13, 1, self.getparam['parame']) com.elm_operate(14, "") time.sleep(4) com.checkItem("选择分期", "新建订单页面一下一步保存") #------------15,16 bx_one = self.driver.find_elements_by_id( "com.giveu.corder:id/switch_insurance") bbx = self.driver.find_elements_by_id( "com.giveu.corder:id/switch_treasure") print(bx_one) if getparam['paramf'] == '不参加' and len(bx_one) > 0: self.driver.find_element_by_id( "com.giveu.corder:id/switch_insurance").click() elif getparam['paramf'] == '保险' and len(bbx) > 0: self.driver.find_element_by_id( "com.giveu.corder:id/switch_treasure").click() else: print("pass") time.sleep(2) com.get_dbtext(0, self.getparam['paramg']) com.swipeup() com.elm_operate(17, "") time.sleep(4) com.checkItem("商品类型", "新建订单页面二下一步保存") etm = self.driver.find_element_by_id("com.giveu.corder:id/ll_item") etms = etm.find_elements_by_id("com.giveu.corder:id/tv_choose_right") time.sleep(1) # com.elm_allson_click(18,19,0) etms[0].click() time.sleep(1) com.get_dbtext(0, self.getparam['paramh']) # com.elm_allson_click(18,19,1) etms[1].click() time.sleep(1) com.get_dbtext(0, self.getparam['parami']) com.elm_operate(20, "") #预留21,22 qmb = self.driver.find_elements_by_id( "com.giveu.corder:id/cb_insurance") sspa = self.driver.find_elements_by_id("com.giveu.corder:id/cb_broken") if self.getparam['paramj'] == '全面保' and len(qmb) > 0: self.driver.find_element_by_id( "com.giveu.corder:id/cb_insurance").click() elif self.getparam['paramj'] == '碎碎平安' and len(sspa) > 0: self.driver.find_element_by_id( "com.giveu.corder:id/cb_broken").click() else: print("pass") com.swipeup() com.elm_operate(23, "") time.sleep(4) com.checkItem("身份证", "新建订单页面三下一步保存") #拍照 com.elm_operate(24, "") com.elm_operate(25, "") time.sleep(2) com.elm_operate(26, con_name + chzw()) textval = com.get_elm_textval(26) for s in range(27, 41): com.elm_operate(s, "") time.sleep(1) com.swipeup() com.elm_operate(41, "") Log().info("订单名称:%s " % textval) V = OracleUtil(dbname) time.sleep(2) cnoval = V.oracle_getstring( "select contract_no from cs_credit where id_person=(select id from (select * from cs_person where name like '%s%%' order by create_time desc) where rownum=1)" % textval) time.sleep(1) print(cnoval) A = MysqlUtil() time.sleep(2) A.mysql_execute( "INSERT INTO mobiletest_mobiledata (contract_no,con_name,con_ident,con_phone,create_time) VALUES ('%s','%s','%s','%s',NOW())" % (cnoval, textval, idcard, mobilephone)) if cnoval == None: Log().info("订单pr合同号生成异常:%s" % cnoval) else: Log().info("订单pr合同号生成成功:%s" % cnoval)
def tests_s(self): u'''即有宝流程测试s合同''' # textval = self.tests_pr() textval = MysqlUtil().mysql_getstring( "SELECT t.con_name FROM (SELECT * FROM mobiletest_mobiledata WHERE con_name LIKE '%s%%' ORDER BY create_time DESC) t LIMIT 1" % con_name) print(textval) com = appclass(self.driver, self.cpath) com.elm_operate(42, "") time.sleep(1) if self.pc_type == "android真机": com.elm_operate(43, "") time.sleep(2) com.elm_operate(44, "") #拍照确认 else: com.elm_operate(82, "") time.sleep(2) com.elm_operate(83, "") #拍照确认 com.elm_operate(45, "") time.sleep(20) com.checkItem("授权", "客户信息页上传照片") com.elm_operate(46, "") time.sleep(10) #等下最新验证码生成 pcode = OracleUtil(dbname).oracle_getstring( "select code from (select * from cs_sms_authority where mobile='%s' order by create_time desc) where rownum=1" % mobilephone) time.sleep(3) com.elm_operate(47, pcode) #输入验证码 com.elm_operate(48, "") # 征信授权页完成 time.sleep(4) com.checkItem("签章", "征信授权页下一步保存") com.elm_operate(49, "") time.sleep(3) com.checkItem("其他信息", "PDF列表页下一步保存") com.elm_operate(50, "") com.elm_operate(51, "") com.elm_operate(52, "") com.elm_operate(53, "") time.sleep(4) com.checkItem("基本信息", "其他信息页下一步保存") for a in range(54, 67): com.elm_operate(a, "") com.swipeup() com.elm_operate(67, "") time.sleep(4) com.checkItem("单位信息", "基本信息页下一步保存") for b in range(68, 77): com.elm_operate(b, "") com.swipeup() for v in range(77, 82): com.elm_operate(v, "") time.sleep(4) com.checkItem("联系人", "单位信息页下一步保存") #预留2 #-----Begin----填写联系人信息 --20181015 chenjingxu #PS:新增联系人此处不做处理,但需要上一步提供婚否信息 #填写文本框内容 Log().info("开始填写联系人信息") HF = "未婚" com3 = appclass(self.driver, PATH("..\config\yaml\jyb\jybcase2.yaml")) #填写姓名和手机号 if HF == "已婚": for h in range(0, 7): com3.elm_operate(h, "") else: for h in range(0, 5): com3.elm_operate(h, "") #选择与本人关系 #relation = ["兄弟", "同事-1"] r = 0 for s in range(9, 11): lis = [12, 48] com3.elm_operate(s, "") print("没有点击打开弹窗") time.sleep(0.5) com3.elm_operate(lis[r], "") r = r + 1 #提交 com3.elm_operate(13, "") Log().info("恭喜,填写联系人信息成功!!!") #----End --填写联系人信息 -------------20181020 chenjingxu #---Begin 绑定银行卡-------------------20181020 chenjingxu #第一步 填写银行卡号 self.driver.activate_ime_engine( "com.sohu.inputmethod.sogou.xiaomi/.SogouIME") com3.elm_operate(14, "6228481359515816576") self.driver.activate_ime_engine("io.appium.android.ime/.UnicodeIME") com3.elm_operate(15, "") Log().info("恭喜,绑定银行卡1成功!!!") #第二步 先只填写支行,其它信息不校验 com3.elm_operate(23, "") time.sleep(0.5) com3.elm_operate(49, "") com3.elm_operate(50, "") com3.elm_operate(15, "") time.sleep(4) # sql = "update credit_bankcard_four set check_result=2000 where mobile=13300000000 and name like'回归%' and check_result=2008" MysqlUtiltwo().mysql_execute( "update credit_bankcard_four set check_result=2000 where name='%s'" % textval) time.sleep(2) com3.elm_operate(15, "") Log().info("恭喜,绑定银行卡2成功!!!") #判断手机号跟银行预留手机号是否一致,然后执行SQL语句 #第四步,填写验证码 send_codee = MysqlUtiltwo().mysql_getstring( "SELECT t.sms_code FROM (SELECT * FROM sms_verify_info WHERE phone = '%s' ORDER BY sent_time DESC) t LIMIT 1" % mobilephone) print(send_codee) time.sleep(10) com3.elm_operate(31, send_codee) time.sleep(1) com3.elm_operate(15, "") time.sleep(5) if com3.findItem("绑定银行卡"): send_codee2 = MysqlUtiltwo().mysql_getstring( "SELECT t.sms_code FROM (SELECT * FROM sms_verify_info WHERE phone = '%s' ORDER BY sent_time DESC) t LIMIT 1" % mobilephone) com3.elm_operate(31, send_codee2) time.sleep(1) com3.elm_operate(15, "") Log().info("恭喜,绑定银行卡3成功!!!") else: Log().info("恭喜,绑定银行卡3成功!!!") # ---End 绑定银行卡-------------------20181020 chenjingxu # ---Begin 其它信息-------------------20181020 chenjingxu com3.elm_operate(32, "") com3.elm_operate(33, "") com3.elm_operate(34, "") com3.elm_operate(15, "") Log().info("恭喜,填写其它信息成功!!!") # ---End 其它信息-------------------20181020 chenjingxu #跳过京东认证,富数认证,运营商认证--20181020 chenjingxu com3.elm_operate(35, "") com3.elm_operate(35, "") com3.elm_operate(35, "") Log().info("恭喜,跳过京东,富数,运营商认证成功!!!") # ---Begin 小问卷-------------------20181020 chenjingxu com3.elm_operate(36, "") #单选写死,后续通过字典来实现动态选择 com3.elm_operate(37, "") com3.elm_operate(51, "") Log().info("恭喜,填写小问卷成功!!!") # ---End 小问卷---------------------20181020 chenjingxu #等待页面跳转完毕 time.sleep(2) # ---Begin 影像证明-----------------20181020 chenjingxu Log().info("上传影像证明") com3.swipeup() com3.swipeup() com3.elm_operate(38, "") time.sleep(1) # ---start 影像证明-------------------20181020 chenjingxu #act_camera = "com.android.camera/com.android.camera.Camera" #driver.wait_activity(act_camera, 20, 1) com3.elm_operate(39, "") com3.elm_operate(40, "") time.sleep(2) self.driver.wait_activity( "com.giveu.corder.ordercreate.activity.PhotoCertificateActivity", 20, 1) com3.elm_operate(41, "") Log().info("恭喜,上传影像证明成功!!!") # ---End 影像证明-------------------20181020 chenjingxu # ---Begin 输入登录密码进行验证-------------------20181020 chenjingxu com3.elm_operate(42, "") com3.elm_operate(43, "") time.sleep(2) com3.checkItem("成功提交", "即有宝S合同生成")
def tests_s(self): #流程测试s合同 u'''即有宝流程测试s合同''' # textval = MysqlUtil().mysql_getstring("SELECT t.con_name FROM (SELECT * FROM mobiletest_mobiledata WHERE con_name LIKE '%s%%' ORDER BY create_time DESC) t LIMIT 1"%con_name) #流程测试s合同 com = appclass(self.driver, self.cpath) #流程测试s合同 for a in range(54, 67): #流程测试s合同 com.elm_operate(a, "") #流程测试s合同 com.swipeup() #流程测试s合同 com.elm_operate(67, "") #流程测试s合同 time.sleep(4) #流程测试s合同 com.checkItem("单位信息", "基本信息页下一步保存") #流程测试s合同 for b in range(68, 77): #流程测试s合同 com.elm_operate(b, "") #流程测试s合同 com.swipeup() #流程测试s合同 for v in range(77, 82): #流程测试s合同 com.elm_operate(v, "") #流程测试s合同 time.sleep(4) #流程测试s合同 com.checkItem("联系人", "单位信息页下一步保存") #流程测试s合同 #-----Begin----填写联系人信息 --20181015 chenjingxu #流程测试s合同 #填写文本框内容 #流程测试s合同 Log().info("开始填写联系人信息") #流程测试s合同 HF = "未婚" #流程测试s合同 com3 = appclass(self.driver, PATH("..\config\yaml\jyb\jybcase2.yaml")) #流程测试s合同 #填写姓名和手机号 #流程测试s合同 if HF == "已婚": #流程测试s合同 for h in range(0, 7): #流程测试s合同 com3.elm_operate(h, "") #流程测试s合同 else: #流程测试s合同 for h in range(0, 5): #流程测试s合同 com3.elm_operate(h, "") #流程测试s合同 #选择与本人关系 #流程测试s合同 r = 0 #流程测试s合同 for s in range(9, 11): #流程测试s合同 lis = [12, 48] #流程测试s合同 com3.elm_operate(s, "") #流程测试s合同 print("没有点击打开弹窗") #流程测试s合同 time.sleep(0.5) #流程测试s合同 com3.elm_operate(lis[r], "") #流程测试s合同 r = r + 1 #流程测试s合同 #提交 #流程测试s合同 com3.elm_operate(13, "") #流程测试s合同 Log().info("恭喜,填写联系人信息成功!!!") #流程测试s合同 #----End --填写联系人信息 -------------20181020 chenjingxu #流程测试s合同 #---Begin 绑定银行卡-------------------20181020 chenjingxu #流程测试s合同 #第一步 填写银行卡号 #流程测试s合同 self.driver.activate_ime_engine( "com.sohu.inputmethod.sogou.xiaomi/.SogouIME") #流程测试s合同 com3.elm_operate(14, "6228481359515816576") #流程测试s合同 self.driver.activate_ime_engine( "io.appium.android.ime/.UnicodeIME") #流程测试s合同 com3.elm_operate(15, "") #流程测试s合同 Log().info("恭喜,绑定银行卡1成功!!!") #流程测试s合同 #第二步 先只填写支行,其它信息不校验 #流程测试s合同 com3.elm_operate(23, "") #流程测试s合同 time.sleep(0.5) #流程测试s合同 com3.elm_operate(49, "") #流程测试s合同 com3.elm_operate(50, "") #流程测试s合同 com3.elm_operate(15, "") #流程测试s合同 time.sleep(4) #流程测试s合同 MysqlUtiltwo().mysql_execute( "update credit_bankcard_four set check_result=2000 where name='%s'" % newcon_name) #流程测试s合同 time.sleep(2) #流程测试s合同 com3.elm_operate(15, "") #流程测试s合同 Log().info("恭喜,绑定银行卡2成功!!!") #流程测试s合同 #第四步,填写验证码 #流程测试s合同 send_codee = MysqlUtiltwo().mysql_getstring( "SELECT t.sms_code FROM (SELECT * FROM sms_verify_info WHERE phone = '%s' ORDER BY sent_time DESC) t LIMIT 1" % mobilephone) #流程测试s合同 print(send_codee) #流程测试s合同 time.sleep(10) #流程测试s合同 com3.elm_operate(31, send_codee) #流程测试s合同 time.sleep(1) #流程测试s合同 com3.elm_operate(15, "") #流程测试s合同 time.sleep(5) #流程测试s合同 if com3.findItem("绑定银行卡"): #流程测试s合同 send_codee2 = MysqlUtiltwo().mysql_getstring( "SELECT t.sms_code FROM (SELECT * FROM sms_verify_info WHERE phone = '%s' ORDER BY sent_time DESC) t LIMIT 1" % mobilephone) #流程测试s合同 com3.elm_operate(31, send_codee2) #流程测试s合同 time.sleep(1) #流程测试s合同 com3.elm_operate(15, "") #流程测试s合同 Log().info("恭喜,绑定银行卡3成功!!!") #流程测试s合同 else: #流程测试s合同 Log().info("恭喜,绑定银行卡3成功!!!") #流程测试s合同 # ---End 绑定银行卡-------------------20181020 chenjingxu #流程测试s合同 # ---Begin 其它信息-------------------20181020 chenjingxu #流程测试s合同 com3.elm_operate(32, "") #流程测试s合同 com3.elm_operate(33, "") #流程测试s合同 com3.elm_operate(34, "") #流程测试s合同 com3.elm_operate(15, "") #流程测试s合同 Log().info("恭喜,填写其它信息成功!!!") #流程测试s合同 # ---End 其它信息-------------------20181020 chenjingxu #流程测试s合同 #跳过京东认证,富数认证,运营商认证--20181020 chenjingxu #流程测试s合同 com3.elm_operate(35, "") #流程测试s合同 com3.elm_operate(35, "") #流程测试s合同 com3.elm_operate(35, "") #流程测试s合同 Log().info("恭喜,跳过京东,富数,运营商认证成功!!!") #流程测试s合同 # ---Begin 小问卷-------------------20181020 chenjingxu #流程测试s合同 com3.elm_operate(36, "") #流程测试s合同 #单选写死,后续通过字典来实现动态选择 #流程测试s合同 com3.elm_operate(37, "") #流程测试s合同 com3.elm_operate(51, "") #流程测试s合同 Log().info("恭喜,填写小问卷成功!!!") #流程测试s合同 # ---End 小问卷---------------------20181020 chenjingxu #流程测试s合同 #等待页面跳转完毕 #流程测试s合同 time.sleep(2) #流程测试s合同 # ---Begin 影像证明-----------------20181020 chenjingxu #流程测试s合同 Log().info("上传影像证明") #流程测试s合同 com3.swipeup() #流程测试s合同 com3.swipeup() #流程测试s合同 com3.elm_operate(38, "") #流程测试s合同 time.sleep(1) #流程测试s合同 # ---start 影像证明-------------------20181020 chenjingxu #流程测试s合同 #act_camera = "com.android.camera/com.android.camera.Camera" #流程测试s合同 #driver.wait_activity(act_camera, 20, 1) #流程测试s合同 com3.elm_operate(39, "") #流程测试s合同 com3.elm_operate(40, "") #流程测试s合同 time.sleep(2) #流程测试s合同 self.driver.wait_activity( "com.giveu.corder.ordercreate.activity.PhotoCertificateActivity", 20, 1) #流程测试s合同 com3.elm_operate(41, "") #流程测试s合同 Log().info("恭喜,上传影像证明成功!!!") #流程测试s合同 # ---End 影像证明-------------------20181020 chenjingxu #流程测试s合同 # ---Begin 输入登录密码进行验证-------------------20181020 chenjingxu #流程测试s合同 com3.elm_operate(42, "") #流程测试s合同 com3.elm_operate(43, "") #流程测试s合同 time.sleep(2) #流程测试s合同 if com3.findItem("成功提交"): #流程测试s合同 Log().info("即有宝S合同生成成功") #流程测试s合同 MysqlUtil().mysql_execute( "UPDATE mobiletest_mobiledata SET con_status='s' WHERE con_name='%s'" % newcon_name) #流程测试s合同 else: #流程测试s合同 Log().info("即有宝S合同生成失败") #流程测试s合同 print("合同:'%s'" % conval) raise RunError('指定合同未找到') print("合同:'%s'" % conval) raise RunError('指定合同未找到') print("合同:'%s'" % conval) raise RunError('指定合同未找到')
def tests_run(self): u'''即有宝流程测试''' driver = connecthub(self.pc_type,self.pc_ip) if driver: Log().info("连接服务器成功") else: Log().info("连接服务器失败") time.sleep(5) com = appclass(driver,self.cpath) com.swipeleft(3) time.sleep(1) # for x in range(4): # com.elm_operate(x,"") com.elm_operate(0,"") com.elm_operate(1,self.uname) for x in range(2,4): com.elm_operate(x,"") time.sleep(1) for z in range(4,7): com.elm_click(z) com.elm_operate(7,"") time.sleep(4) com.get_dbtext(1,self.getparam['parama']) com.elm_operate(8,"") time.sleep(1) com.get_dbtext(0,self.getparam['paramb']) com.elm_operate(9,"") time.sleep(1) com.get_dbtext(0,self.getparam['paramc']) com.elm_operate(10,"") time.sleep(1) com.elm_operate(11,"") com.elm_allson_send(12,13,0,self.getparam['paramd']) com.elm_allson_send(12,13,1,self.getparam['parame']) com.elm_operate(14,"") Log().info("订单页面一完成") #------------15,16 bx_one= driver.find_elements_by_id("com.giveu.corder:id/switch_insurance") bbx= driver.find_elements_by_id("com.giveu.corder:id/switch_treasure") print(bx_one) if getparam['paramf'] == '不参加' and len(bx_one) > 0: driver.find_element_by_id("com.giveu.corder:id/switch_insurance").click() elif getparam['paramf'] == '免还大礼包' and len(bbx) > 0: driver.find_element_by_id("com.giveu.corder:id/switch_treasure").click() else: print("pass") time.sleep(2) com.get_dbtext(0,self.getparam['paramg']) com.swipeup() com.elm_operate(17,"") Log().info("订单页面二完成") etm=driver.find_element_by_id("com.giveu.corder:id/ll_item") etms=etm.find_elements_by_id("com.giveu.corder:id/tv_choose_right") time.sleep(1) # com.elm_allson_click(18,19,0) etms[0].click() time.sleep(1) com.get_dbtext(0,self.getparam['paramh']) # com.elm_allson_click(18,19,1) etms[1].click() time.sleep(1) com.get_dbtext(0,self.getparam['parami']) com.elm_operate(20,"") #预留21,22 qmb= driver.find_elements_by_id("com.giveu.corder:id/cb_insurance") sspa= driver.find_elements_by_id("com.giveu.corder:id/cb_broken") if self.getparam['paramj'] == '全面保' and len(qmb) > 0: driver.find_element_by_id("com.giveu.corder:id/cb_insurance").click() elif self.getparam['paramj'] == '碎碎平安' and len(sspa) > 0: driver.find_element_by_id("com.giveu.corder:id/cb_broken").click() else: print("pass") com.swipeup() com.elm_operate(23,"") Log().info("订单页面三完成") #拍照 com.elm_operate(24,"") com.elm_operate(25,"") time.sleep(2) com.elm_operate(26,con_name+chzw()) textval = com.get_elm_textval(26) for s in range(27,41): com.elm_operate(s,"") time.sleep(1) com.swipeup() com.elm_operate(41,"") Log().info("订单:%s 已生成"%textval) V = OracleUtil(dbname) time.sleep(2) cnoval =V.oracle_getstring("select contract_no from cs_credit where id_person=(select id from (select * from cs_person where name like '%s%%' order by create_time desc) where rownum=1)"%textval) time.sleep(1) print(cnoval) A = MysqlUtil() time.sleep(2) A.mysql_execute("INSERT INTO mobiletest_mobiledata (contract_no,con_name,con_ident,con_phone,create_time) VALUES ('%s','%s','%s','%s',NOW())"%(cnoval,textval,idcard,mobilephone)) Log().info("订单合同号:%s"%cnoval) #预留1 com.elm_operate(42,"") time.sleep(1) com.elm_operate(43,"") time.sleep(2) com.elm_operate(44,"") #拍照确认 com.elm_operate(45,"") Log().info("客户门店照片页完成") com.elm_operate(46,"") time.sleep(10) #等下最新验证码生成 pcode =V.oracle_getstring("select code from (select * from cs_sms_authority where mobile='%s' order by create_time desc) where rownum=1"%mobilephone) time.sleep(2) com.elm_operate(47,pcode) #输入验证码 com.elm_operate(48,"") # 征信授权页完成 Log().info("征信授权页完成") com.elm_operate(49,"") Log().info("PDF列表页面完成") com.elm_operate(50,"") com.elm_operate(51,"") com.elm_operate(52,"") com.elm_operate(53,"") Log().info("其他信息页完成") for a in range(54,67): com.elm_operate(a,"") com.swipeup() com.elm_operate(67,"") Log().info("基本信息页完成") for b in range(68,77): com.elm_operate(b,"") com.swipeup() for v in range(77,82): com.elm_operate(v,"") Log().info("单位信息页完成") driver.quit()