def test_30(self): '''已过期计费配置''' print("\n--------------用例30------------------") try: time.sleep(2) print("点击已过期计费配置") self.dr.Clickxpath(xlrd.read_excel_two(95, 1)) print("勾选已过期缴费出场配置") self.dr.Clickxpath_select(xlrd.read_excel_two(96, 1)) print("点击保存") self.dr.Clickxpath_last(xlrd.read_excel_two(97, 1)) time.sleep(2) print("点击保存确定") self.dr.Clickxpath(xlrd.read_excel_two(98, 1)) time.sleep(1) print("开始断言") MySQL.Mysql(xlrd.read_excel_four(14, 1)) print("用例成功") except Exception as msg: self.dr.getImage() print("异常原因%s" % msg) # raise抛出异常 raise
def test_30_1(self): '''推送过车消息到公众号''' print("\n--------------用例30_1------------------") try: time.sleep(2) print("点击推送过车消息到公众号") self.dr.Clickxpath(xlrd.read_excel_two(156, 1)) print("勾选启用消息推送") self.dr.Clickxpath_select(xlrd.read_excel_two(157, 1)) print("输入过车地点") self.dr.send_keys(xlrd.read_excel_two(158, 1), xlrd.read_excel_two(158, 1), xlrd.read_excel(95, 5)) print("点击保存") self.dr.Clickxpath(xlrd.read_excel_two(159, 1)) time.sleep(2) print("点击保存确定") self.dr.Clickxpath(xlrd.read_excel_two(160, 1)) time.sleep(1) print("开始断言") MySQL.Mysql(xlrd.read_excel_four(21, 1)) print("用例成功") except Exception as msg: self.dr.getImage() print("异常原因%s" % msg) # raise抛出异常 raise
def test_28(self): '''访客-黑白名单配置''' print("\n--------------用例28------------------") try: time.sleep(2) print("点击访客-黑白名单配置") self.dr.Clickxpath(xlrd.read_excel_two(88, 1)) print("勾选启用访客放行") print("勾选启用黑名单") print("勾选启用白名单") print("点击保存") self.dr.Clickxpath(xlrd.read_excel_two(89, 1)) time.sleep(2) print("点击保存确定") self.dr.Clickxpath(xlrd.read_excel_two(90, 1)) time.sleep(2) print("开始断言") MySQL.Mysql(xlrd.read_excel_four(12, 1)) print("用例成功") except Exception as msg: self.dr.getImage() print("异常原因%s" % msg) # raise抛出异常 raise
def test_19(self): '''VIP车修改为固定临停车''' print("--------------用例19------------------") try: time.sleep(2) print("搜索车牌") self.dr.send_keysid(xlrd.read_excel_two(62, 1), xlrd.read_excel_two(62, 1), xlrd.read_excel(45, 5)) print("查询") self.dr.Clickxpath(xlrd.read_excel_two(53, 1)) time.sleep(2) print("车辆编辑") self.dr.Clickxpath(xlrd.read_excel_two(54, 1)) time.sleep(2) print("修改为固定临停车") self.dr.drop_down(xlrd.read_excel_two(55, 1), xlrd.read_excel_two(61, 1)) time.sleep(2) print("点击保存") self.dr.Clickxpath(xlrd.read_excel_two(50, 1)) time.sleep(2) print("点击保存确认") self.dr.Clickxpath(xlrd.read_excel_two(51, 1)) time.sleep(2) print("开始断言") # 数据库中查询该车辆是否修改成固定临停车 MySQL.Mysql(xlrd.read_excel_four(6, 1)) print("用例成功") except Exception as msg: self.dr.getImage() print("异常原因%s" % msg) # raise抛出异常 raise
def test_21(self): '''删除车辆信息''' print("--------------用例21------------------") try: time.sleep(1) print("搜索车牌") self.dr.send_keysid(xlrd.read_excel_two(62, 1), xlrd.read_excel_two(62, 1), xlrd.read_excel(45, 5)) print("查询") self.dr.Clickxpath(xlrd.read_excel_two(53, 1)) time.sleep(2) print("勾选车辆") self.dr.Clickxpath(xlrd.read_excel_two(67, 1)) print("点击删除") self.dr.Clickxpath(xlrd.read_excel_two(68, 1)) time.sleep(2) print("删除确定") self.dr.Clickxpath(xlrd.read_excel_two(69, 1)) time.sleep(2) print("开始断言") # 数据库中查询该车辆是否被删除 MySQL.Mysql_delete(xlrd.read_excel_four(7, 1)) print("用例成功") except Exception as msg: self.dr.getImage() print("异常原因%s" % msg) # raise抛出异常 raise
def test_45(self): '''过车记录信息导入''' print("\n--------------用例45------------------") try: time.sleep(2) print("点击导入") self.dr.Clickxpath(xlrd.read_excel_two(151, 1)) print("打开选择文件,导入文件") self.dr.send_keysdao(xlrd.read_excel_two(152, 1), xlrd.read_excel(93, 5)) time.sleep(2) print("点击保存") self.dr.Clickid(xlrd.read_excel_two(153, 1)) time.sleep(5) print("保存确定") self.dr.Clickxpath(xlrd.read_excel_two(154, 1)) time.sleep(2) print("关闭导入框") self.dr.Clickxpath(xlrd.read_excel_two(161, 1)) time.sleep(4) print("开始断言") MySQL.Mysql(xlrd.read_excel_four(20, 1)) print("用例完成") except Exception as msg: self.dr.getImage() print("异常原因%s" % msg) # raise抛出异常 raise
def test_31(self): '''无牌车核销配置''' print("\n--------------用例31------------------") try: time.sleep(2) print("点击进入停车场") self.dr.Clickid(xlrd.read_excel_two(7, 1)) time.sleep(1) print("点击无牌车核销配置") self.dr.Clickxpath(xlrd.read_excel_two(99, 1)) print("输入核销天数") self.dr.send_keysname(xlrd.read_excel_two(100, 1), xlrd.read_excel(71, 1)) print("点击保存") self.dr.Clickxpath(xlrd.read_excel_two(101, 1)) time.sleep(2) print("点击保存确定") self.dr.Clickxpath(xlrd.read_excel_two(102, 1)) time.sleep(1) print("开始断言") MySQL.Mysql(xlrd.read_excel_four(15, 1)) print("用例成功") except Exception as msg: self.dr.getImage() print("异常原因%s" % msg) # raise抛出异常 raise
def test_27(self): '''找零配置-多收记账,下次停车抵扣''' print("\n--------------用例27------------------") try: time.sleep(2) print("勾选多收记账,下次停车抵扣") self.dr.Clickxpath(xlrd.read_excel_two(85, 1)) print("点击保存") self.dr.Clickxpath(xlrd.read_excel_two(86, 1)) time.sleep(3) print("点击保存确定") self.dr.Clickxpath(xlrd.read_excel_two(87, 1)) time.sleep(2) print("开始断言") MySQL.Mysql_two(xlrd.read_excel_four(11, 1), xlrd.read_excel_four(11, 2), xlrd.read_excel_four(11, 3)) print("用例成功") except Exception as msg: self.dr.getImage() print("异常原因%s" % msg) # raise抛出异常 raise
def test_25(self): '''找零配置-少收记账,但不进行追缴''' print("\n--------------用例25------------------") try: time.sleep(2) print("勾选少收记账,但不进行追缴") self.dr.Clickxpath(xlrd.read_excel_two(83, 1)) print("点击保存") self.dr.Clickxpath(xlrd.read_excel_two(86, 1)) time.sleep(3) print("点击保存确定") self.dr.Clickxpath(xlrd.read_excel_two(87, 1)) time.sleep(4) print("开始断言") MySQL.Mysql_two(xlrd.read_excel_four(9, 1), xlrd.read_excel_four(9, 2), xlrd.read_excel_four(9, 3)) print("用例成功") except Exception as msg: self.dr.getImage() print("异常原因%s" % msg) # raise抛出异常 raise
def test_16(self): '''添加包期车''' print("--------------用例16------------------") try: time.sleep(2) print("点击添加") self.dr.Clickxpath(xlrd.read_excel_two(42, 1)) time.sleep(8) print("输入车牌号") self.dr.send_keysname(xlrd.read_excel_two(43, 1), xlrd.read_excel(45, 5)) time.sleep(2) print("输入车主姓名") self.dr.send_keysname(xlrd.read_excel_two(44, 1), xlrd.read_excel(46, 5)) time.sleep(1) print("输入联系电话") self.dr.send_keysname(xlrd.read_excel_two(45, 1), xlrd.read_excel(47, 5)) print("点击车位编号") self.dr.Clickxpath(xlrd.read_excel_two(46, 1)) time.sleep(1) print("输入车位编号") self.dr.send_keysid(xlrd.read_excel_two(47, 1), xlrd.read_excel_two(47, 1), xlrd.read_excel(48, 5)) print("点击查询") self.dr.Clickxpath(xlrd.read_excel_two(48, 1)) time.sleep(1) print("点击选择该车位") self.dr.Clickxpath(xlrd.read_excel_two(49, 1)) time.sleep(3) print("点击保存") self.dr.Clickxpath(xlrd.read_excel_two(50, 1)) time.sleep(3) print("点击保存确认") self.dr.Clickxpath(xlrd.read_excel_two(51, 1)) time.sleep(2) print("开始断言") # 数据库中查询该车辆是否已经添加 MySQL.Mysql(xlrd.read_excel_four(3, 1)) print("用例成功") except Exception as msg: self.dr.getImage() print("异常原因%s" % msg) # raise抛出异常 raise
def setUpClass(cls): driver = webdriver.Chrome( 'C:\\Users\\ChenYang\\AppData\\Local\\Google\\Chrome\\Application\\chromedriver.exe' ) driver.maximize_window() print("---------------系统设置测试开始----------------------") # 获取辅助功能driver cls.dr = Driver(driver) # 获取login的driver cls.lo = Login(driver) # 打开网页,读取excel文档内容3列3行url cls.dr.open_url(xlrd.read_excel(1, 3)) time.sleep(2) # 登录后台 cls.lo.login() # 开始运行前删除数据库中的所有表 MySQL.Mysql_delete_tables(xlrd.read_excel_four(51, 1))
def test_14(self): '''删除固定临停车收费规则''' print("--------------用例14------------------") try: time.sleep(2) print("点击固定临停车收费规则删除按钮") self.dr.Clickxpath(xlrd.read_excel_two(39,1)) time.sleep(1) print("点击确定") self.dr.Clickid(xlrd.read_excel_two(23,1)) time.sleep(1) print("再次点击确定") self.dr.Clickxpath(xlrd.read_excel_two(24,1)) print("删除成功") time.sleep(1) print("通过数据库确认是否删除成功进行断言") MySQL.Mysql_delete(xlrd.read_excel_four(2,1)) except Exception as msg: self.dr.getImage() print("异常原因%s"%msg) # raise抛出异常 raise
def test_11(self): '''添加普通临停车收费规则''' print("--------------用例11------------------") try: time.sleep(2) print("点击普通临停车收费规则") self.dr.Clickxpath(xlrd.read_excel_two(27,1)) time.sleep(8) print("输入规则名称") self.dr.send_keysname(xlrd.read_excel_two(29,1),xlrd.read_excel(25,5)) print("输入免费停车时长") self.dr.send_keysname(xlrd.read_excel_two(30,1),xlrd.read_excel(26,5)) print("输入首段收费时长") self.dr.send_keysname(xlrd.read_excel_two(31,1),xlrd.read_excel(27,5)) print("输入间隔收费时长") self.dr.send_keysname(xlrd.read_excel_two(32,1),xlrd.read_excel(28,5)) print("输入首段收费金额") self.dr.send_keysname(xlrd.read_excel_two(33,1),xlrd.read_excel(29,5)) print("输入间隔收费金额") self.dr.send_keysname(xlrd.read_excel_two(34,1),xlrd.read_excel(30,5)) print("下拉框选择车辆类型为小型车") self.dr.drop_down(xlrd.read_excel_two(35,1),xlrd.read_excel_two(36,1)) print("点击保存") self.dr.Clickxpath(xlrd.read_excel_two(37,1)) time.sleep(10) print("点击保存确定") self.dr.Clickxpath(xlrd.read_excel_two(38,1)) time.sleep(5) print("通过数据库确认是否添加成功进行断言") MySQL.Mysql(xlrd.read_excel_four(1,1)) print("用例成功") except Exception as msg: self.dr.getImage() print("异常原因%s"%msg) # raise抛出异常 raise
def test_29(self): '''优惠券配置''' print("\n--------------用例29------------------") try: time.sleep(2) print("点击优惠券配置") self.dr.Clickxpath(xlrd.read_excel_two(91, 1)) print("勾选转成“现金券”") self.dr.Clickxpath_select(xlrd.read_excel_two(92, 1)) print("点击保存") self.dr.Clickxpath(xlrd.read_excel_two(93, 1)) time.sleep(2) print("点击保存确定") self.dr.Clickxpath(xlrd.read_excel_two(94, 1)) time.sleep(1) print("开始断言") MySQL.Mysql(xlrd.read_excel_four(13, 1)) print("用例成功") except Exception as msg: self.dr.getImage() print("异常原因%s" % msg) # raise抛出异常 raise
def test_35(self): '''非系统放行记车位-记车位''' print("\n--------------用例35------------------") try: time.sleep(2) print("点击非系统放行记车位") self.dr.Clickxpath(xlrd.read_excel_two(115, 1)) print("勾选记车位") self.dr.Clickxpath_select(xlrd.read_excel_two(116, 1)) print("点击保存") self.dr.Clickxpath(xlrd.read_excel_two(117, 1)) time.sleep(2) print("点击保存确定") self.dr.Clickxpath(xlrd.read_excel_two(118, 1)) time.sleep(1) print("开始断言") MySQL.Mysql(xlrd.read_excel_four(19, 1)) print("用例成功") except Exception as msg: self.dr.getImage() print("异常原因%s" % msg) # raise抛出异常 raise
def test_34(self): '''冲卡配置''' print("\n--------------用例34------------------") try: time.sleep(2) print("点击冲卡配置") self.dr.Clickxpath(xlrd.read_excel_two(111, 1)) print("勾选处理冲卡车辆") self.dr.Clickxpath_select(xlrd.read_excel_two(112, 1)) print("点击保存") self.dr.Clickxpath(xlrd.read_excel_two(113, 1)) time.sleep(2) print("点击保存确定") self.dr.Clickxpath(xlrd.read_excel_two(114, 1)) time.sleep(1) print("开始断言") MySQL.Mysql(xlrd.read_excel_four(18, 1)) print("用例成功") except Exception as msg: self.dr.getImage() print("异常原因%s" % msg) # raise抛出异常 raise
def test_33(self): '''抓拍配置''' print("\n--------------用例33------------------") try: time.sleep(2) print("点击抓拍配置") self.dr.Clickxpath(xlrd.read_excel_two(107, 1)) print("勾选地感抓拍") self.dr.Clickxpath_select(xlrd.read_excel_two(108, 1)) print("点击保存") self.dr.Clickxpath(xlrd.read_excel_two(109, 1)) time.sleep(2) print("点击保存确定") self.dr.Clickxpath(xlrd.read_excel_two(110, 1)) time.sleep(1) print("开始断言") MySQL.Mysql(xlrd.read_excel_four(17, 1)) print("用例成功") except Exception as msg: self.dr.getImage() print("异常原因%s" % msg) # raise抛出异常 raise
def test_32(self): '''所有车牌记车位''' print("\n--------------用例32------------------") try: time.sleep(2) print("点击所有车牌记车位") self.dr.Clickxpath(xlrd.read_excel_two(103, 1)) print("勾选所有车牌记车位") self.dr.Clickxpath_select(xlrd.read_excel_two(104, 1)) print("点击保存") self.dr.Clickxpath(xlrd.read_excel_two(105, 1)) time.sleep(2) print("点击保存确定") self.dr.Clickxpath(xlrd.read_excel_two(106, 1)) time.sleep(1) print("开始断言") MySQL.Mysql(xlrd.read_excel_four(16, 1)) print("用例成功") except Exception as msg: self.dr.getImage() print("异常原因%s" % msg) # raise抛出异常 raise