def test_20(self): '''固定临停车充值''' print("--------------用例20------------------") 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(63, 1)) time.sleep(2) print("输入充值金额") self.dr.send_keysname(xlrd.read_excel_two(64, 1), xlrd.read_excel(58, 5)) print("点击保存") self.dr.Clickxpath(xlrd.read_excel_two(65, 1)) time.sleep(2) print("点击保存确定") self.dr.Clickxpath(xlrd.read_excel_two(66, 1)) time.sleep(1) print("开始断言") # self.dr.text_duanyan(xlrd.read_excel_three(11,1),xlrd.read_excel_three(11,2)) print("用例成功") except Exception as msg: self.dr.getImage() print("异常原因%s" % msg) # raise抛出异常 raise
def test_38(self): '''退款记录导出''' print("\n--------------用例38------------------") try: time.sleep(2) print("点击进入退款记录") self.dr.Clickxpath(xlrd.read_excel_two(124, 1)) time.sleep(2) print("选择开始时间") self.dr.send_keysid(xlrd.read_excel_two(139, 1), xlrd.read_excel_two(139, 1), xlrd.read_excel(80, 5)) print("选择结束时间") self.dr.send_keysid(xlrd.read_excel_two(140, 1), xlrd.read_excel_two(140, 1), xlrd.read_excel(81, 5)) print("点击查询") self.dr.Clickxpath(xlrd.read_excel_two(146, 1)) time.sleep(5) print("点击导出") self.dr.Clickxpath(xlrd.read_excel_two(125, 1)) time.sleep(10) print("开始断言") self.dr.daochu(xlrd.read_excel_three(18, 1)) print("用例结束") except Exception as msg: self.dr.getImage() print("异常原因%s" % msg) # raise抛出异常 raise
def test_02(self): '''输入错误的账号密码''' print("--------------用例2------------------") try: time.sleep(2) # 登录后台 # 输入账号,读取excel文档内容 logger.info("输入正确的账号") self.dr.send_keysid(xlrd.read_excel_two(1, 1), xlrd.read_excel_two(1, 1), xlrd.read_excel(4, 5)) logger.info("输入错误的密码") # 输入密码,读取excel文档内容 logger.info("错误的密码:%s" % xlrd.read_excel(5, 5)) self.dr.send_keysid(xlrd.read_excel_two(2, 1), xlrd.read_excel_two(2, 1), xlrd.read_excel(5, 5)) # 点击确定,读取excel文档内容 logger.info("点击确认") self.dr.Clickid(xlrd.read_excel_two(3, 1)) time.sleep(2) # 断言文本是否正确,读取excel文档内容 logger.info("开始断言") self.dr.is_login_sucess(xlrd.read_excel_three(2, 1)) logger.info("用例成功") except Exception as msg: logger.info("异常原因%s" % msg) self.dr.getImage() # raise抛出异常 raise
def test_40(self): '''包期充值记录记录导出''' print("\n--------------用例40------------------") try: time.sleep(2) print("点击进入包期车充值记录") self.dr.Clickxpath(xlrd.read_excel_two(128, 1)) time.sleep(2) print("选择开始时间") self.dr.send_keysid(xlrd.read_excel_two(141, 1), xlrd.read_excel_two(141, 1), xlrd.read_excel(84, 5)) print("选择结束时间") self.dr.send_keysid(xlrd.read_excel_two(142, 1), xlrd.read_excel_two(142, 1), xlrd.read_excel(85, 5)) print("点击查询") self.dr.Clickxpath(xlrd.read_excel_two(147, 1)) time.sleep(5) print("点击导出") self.dr.Clickxpath(xlrd.read_excel_two(129, 1)) time.sleep(10) print("开始断言") self.dr.daochu(xlrd.read_excel_three(19, 1)) print("用例结束") except Exception as msg: self.dr.getImage() print("异常原因%s" % msg) # raise抛出异常 raise
def test_08(self): '''车位导入''' print("--------------用例8------------------") try: time.sleep(5) print("点击导入") self.dr.Clickxpath(xlrd.read_excel_two(18, 1)) print("打开选择文件,导入文件") self.dr.send_keysdao(xlrd.read_excel_two(19, 1), xlrd.read_excel(19, 5)) time.sleep(2) print("点击保存") self.dr.Clickid(xlrd.read_excel_two(21, 1)) time.sleep(5) self.dr.Clickxpath(xlrd.read_excel_two(22, 1)) time.sleep(5) print("开始断言") # 在搜索框输入3333 self.dr.send_keysid(xlrd.read_excel_two(13, 1), xlrd.read_excel_two(13, 1), xlrd.read_excel(20, 5)) # 点击查询 self.dr.Clickid(xlrd.read_excel_two(14, 1)) # 断言 time.sleep(5) self.assertEqual(self.dr.Assert1(xlrd.read_excel_three(8, 1)), self.dr.Assert2(xlrd.read_excel_three(8, 2))) print("用例成功") except Exception as msg: self.dr.getImage() print("异常原因%s" % msg) # raise抛出异常 print("用例失败") raise
def test_41(self): '''收费合计导出''' print("\n--------------用例41------------------") try: time.sleep(2) print("点击进入退款记录") self.dr.Clickxpath(xlrd.read_excel_two(130, 1)) time.sleep(2) print("选择开始时间") self.dr.send_keysid(xlrd.read_excel_two(143, 1), xlrd.read_excel_two(143, 1), xlrd.read_excel(86, 5)) print("选择结束时间") self.dr.send_keysid(xlrd.read_excel_two(144, 1), xlrd.read_excel_two(144, 1), xlrd.read_excel(87, 5)) print("点击查询") self.dr.Clickxpath(xlrd.read_excel_two(148, 1)) time.sleep(5) print("点击导出") self.dr.Clickxpath(xlrd.read_excel_two(131, 1)) time.sleep(10) print("开始断言") self.dr.daochu(xlrd.read_excel_three(20, 1)) print("用例结束") except Exception as msg: self.dr.getImage() print("异常原因%s" % msg) # raise抛出异常 raise
def test_43(self): '''导出过车记录信息''' print("\n--------------用例43------------------") try: time.sleep(2) print("点击进入过车记录") self.dr.Clickxpath(xlrd.read_excel_two(133, 1)) time.sleep(2) print("选择开始时间") self.dr.send_keysid(xlrd.read_excel_two(135, 1), xlrd.read_excel_two(135, 1), xlrd.read_excel(90, 5)) print("选择结束时间") self.dr.send_keysid(xlrd.read_excel_two(136, 1), xlrd.read_excel_two(136, 1), xlrd.read_excel(91, 5)) print("点击查询") self.dr.Clickxpath(xlrd.read_excel_two(149, 1)) time.sleep(5) print("点击导出") self.dr.Clickxpath(xlrd.read_excel_two(134, 1)) time.sleep(10) print("开始断言") self.dr.daochu(xlrd.read_excel_three(23, 1)) print("用例结束") except Exception as msg: self.dr.getImage() print("异常原因%s" % msg) # raise抛出异常 raise
def test_37(self): '''临停收费记录导出''' print("\n--------------用例37------------------") try: time.sleep(2) print("点击进入临停收费记录") self.dr.Clickxpath(xlrd.read_excel_two(122, 1)) time.sleep(2) print("选择开始时间") self.dr.send_keysid(xlrd.read_excel_two(137, 1), xlrd.read_excel_two(137, 1), xlrd.read_excel(78, 5)) print("选择结束时间") self.dr.send_keysid(xlrd.read_excel_two(138, 1), xlrd.read_excel_two(138, 1), xlrd.read_excel(79, 5)) print("点击查询") self.dr.Clickxpath(xlrd.read_excel_two(145, 1)) time.sleep(5) print("点击导出") self.dr.Clickxpath(xlrd.read_excel_two(123, 1)) time.sleep(10) print("开始断言") self.dr.daochu(xlrd.read_excel_three(17, 1)) print("用例结束") except Exception as msg: self.dr.getImage() print("异常原因%s" % msg) # raise抛出异常 raise
def login(self): '''进入后台登录''' # 输入账号,读取excel文档内容 self.driver.send_keysid(xlrd.read_excel_two(1, 1), xlrd.read_excel_two(1, 1), xlrd.read_excel(1, 5)) # 输入密码,读取excel文档内容 self.driver.send_keysid(xlrd.read_excel_two(2, 1), xlrd.read_excel_two(2, 1), xlrd.read_excel(2, 5)) # 点击确定,读取excel文档内容 self.driver.Clickid(xlrd.read_excel_two(3, 1))
def test_09(self): '''车位删除''' print("--------------用例9------------------") try: time.sleep(5) print("-----删除0001-----") # 在搜索框输入0001 self.dr.send_keysid(xlrd.read_excel_two(13, 1), xlrd.read_excel_two(13, 1), xlrd.read_excel(13, 5)) print("点击查询") # 点击查询 self.dr.Clickid(xlrd.read_excel_two(14, 1)) time.sleep(2) # 点击删除 print("点击删除") self.dr.Clickxpath(xlrd.read_excel_two(20, 1)) time.sleep(1) print("点击弹窗确定") self.dr.Clickid(xlrd.read_excel_two(23, 1)) time.sleep(3) print("点击成功确定") self.dr.Clickxpath(xlrd.read_excel_two(24, 1)) time.sleep(3) print("-----删除3333-----") # 在搜索框输入3333 self.dr.send_keysid(xlrd.read_excel_two(13, 1), xlrd.read_excel_two(13, 1), xlrd.read_excel(20, 5)) print("点击查询") # 点击查询 self.dr.Clickid(xlrd.read_excel_two(14, 1)) time.sleep(2) # 点击删除 print("点击删除") self.dr.Clickxpath(xlrd.read_excel_two(20, 1)) time.sleep(1) print("点击弹窗确定") self.dr.Clickid(xlrd.read_excel_two(23, 1)) time.sleep(3) print("点击成功确定") self.dr.Clickxpath(xlrd.read_excel_two(24, 1)) except Exception as msg: self.dr.getImage() print("异常原因%s" % msg) # raise抛出异常 print("用例失败") 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 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_17(self): '''包期车充值''' print("--------------用例17------------------") 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(57, 1)) time.sleep(2) print("选择充值规则") self.dr.drop_down(xlrd.read_excel_two(58, 1), xlrd.read_excel_two(59, 1)) print("点击保存") self.dr.Clickxpath(xlrd.read_excel_two(60, 1)) time.sleep(2) print("开始断言") # 数据库中查询该车辆是否已经充值 # MySQL.Mysql(xlrd.read_excel_four(5,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_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_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_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_22(self): '''固定临停车撤单''' print("--------------用例22------------------") try: time.sleep(2) print("进入固定临停车充值统计") self.lo.Recharge_statistics() print("搜索车牌") self.dr.send_keysid(xlrd.read_excel_two(72, 1), xlrd.read_excel_two(72, 1), xlrd.read_excel(60, 5)) print("查询") self.dr.Clickxpath(xlrd.read_excel_two(73, 1)) time.sleep(2) print("点击撤单") self.dr.Clickxpath(xlrd.read_excel_two(74, 1)) time.sleep(1) print("输入备注") self.dr.send_keysname(xlrd.read_excel_two(75, 1), xlrd.read_excel(61, 5)) time.sleep(1) print("撤单确定") self.dr.Clickxpath(xlrd.read_excel_two(76, 1)) time.sleep(1) print("撤单成功确定") self.dr.Clickxpath(xlrd.read_excel_two(77, 1)) print("撤单完成") time.sleep(2) print("开始断言") print("再次搜索车牌") self.dr.send_keysid(xlrd.read_excel_two(72, 1), xlrd.read_excel_two(72, 1), xlrd.read_excel(60, 5)) print("查询") self.dr.Clickxpath(xlrd.read_excel_two(73, 1)) time.sleep(2) self.dr.text_duanyan(xlrd.read_excel_three(12, 1), xlrd.read_excel_three(12, 2)) print("断言成功,用例完成") except Exception as msg: self.dr.getImage() print("异常原因%s" % msg) # raise抛出异常 raise
def setUp(self): driver = webdriver.Chrome( 'C:\\Users\\ChenYang\\AppData\\Local\\Google\\Chrome\\Application\\chromedriver.exe' ) driver.maximize_window() self.dr = Driver(driver) self.lo = Login(driver) # 打开网页,读取excel文档内容1行3列url self.dr.open_url(xlrd.read_excel(1, 3))
def test_04(self): '''添加新的车位''' print("--------------用例4------------------") try: time.sleep(2) print("点击添加") self.dr.Clickid(xlrd.read_excel_two(8, 1)) time.sleep(5) print("添加新车位") # 输入业主名称 print("输入业主名称") self.dr.send_keysname(xlrd.read_excel_two(9, 1), xlrd.read_excel(12, 5)) # 输入车位号 print("输入车位号") self.dr.send_keysname(xlrd.read_excel_two(10, 1), xlrd.read_excel(13, 5)) # 输入设备ID print("输入设备ID") self.dr.send_keysname(xlrd.read_excel_two(11, 1), xlrd.read_excel(14, 5)) time.sleep(1) # 点击保存 print("点击保存") self.dr.Clickclass_last(xlrd.read_excel_two(12, 1)) print("搜索新添加的车位") time.sleep(4) # 在搜索框输入0001 self.dr.send_keysid(xlrd.read_excel_two(13, 1), xlrd.read_excel_two(13, 1), xlrd.read_excel(13, 5)) # 点击查询 self.dr.Clickid(xlrd.read_excel_two(14, 1)) # 断言 time.sleep(5) print("开始断言") self.assertEqual(self.dr.Assert1(xlrd.read_excel_three(4, 1)), self.dr.Assert2(xlrd.read_excel_three(4, 2))) print("用例成功") except Exception as msg: self.dr.getImage() logger.info("异常原因%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()
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_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