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_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_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_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_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 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_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 Recharge_statistics(self):
'''进入固定临停车充值统计'''
# 悬停在停车场信息管理上,读取excel文档内容
print("商标悬停在车辆管理上")
self.driver.Action_xpath(xlrd.read_excel_two(40, 1))
self.driver.impicitly()
# 进入固定临停车充值统计,读取excel文档内容
print("点击固定临停车充值统计")
self.driver.Clickxpath(xlrd.read_excel_two(70, 1))
print("进入固定临停车充值统计")
time.sleep(5)
# 选择物业,读取excel文档内容
self.driver.Clickxpath(xlrd.read_excel_two(71, 1))
print("已选择物业")
time.sleep(5)
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 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_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 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_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_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_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_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 Vehicles_and_recharge(self):
'''进入车辆与充值管理'''
# 进入停车场二代管理,读取excel文档内容
print("点击停车场二代管理")
self.driver.Clickxpath(xlrd.read_excel_two(4, 1))
time.sleep(10)
# 悬停在停车场信息管理上,读取excel文档内容
print("商标悬停在车辆管理上")
self.driver.Action_xpath(xlrd.read_excel_two(40, 1))
self.driver.impicitly()
# 进入车位管理,读取excel文档内容
print("点击车辆与充值管理")
self.driver.Clickxpath(xlrd.read_excel_two(41, 1))
print("进入车辆与充值管理")
time.sleep(5)
# 选择停车场,读取excel文档内容
self.driver.Clickid(xlrd.read_excel_two(7, 1))
print("已选择停车场")
time.sleep(5)
def Charge_Management(self):
'''进入收费规则管理'''
# 进入停车场二代管理,读取excel文档内容
print("点击停车场二代管理")
self.driver.Clickxpath(xlrd.read_excel_two(4, 1))
time.sleep(10)
# 悬停在停车场信息管理上,读取excel文档内容
print("商标悬停在收费规则管理上")
self.driver.Action_xpath(xlrd.read_excel_two(25, 1))
self.driver.impicitly()
# 进入车位管理,读取excel文档内容
print("点击收费规则管理")
self.driver.Clickxpath(xlrd.read_excel_two(26, 1))
print("进入收费规则管理")
time.sleep(5)
# 选择停车场,读取excel文档内容
self.driver.Clickid(xlrd.read_excel_two(7, 1))
print("已选择停车场")
time.sleep(5)
def Vehicle_Passing_record(self):
'''进入过车记录查询'''
# 进入停车场二代管理,读取excel文档内容
print("点击停车场二代管理")
self.driver.Clickxpath(xlrd.read_excel_two(4, 1))
time.sleep(15)
# 悬停在报表信息上,读取excel文档内容
print("商标悬停在报表信息上")
self.driver.Action_xpath(xlrd.read_excel_two(120, 1))
self.driver.impicitly()
# 进入过车记录查询,读取excel文档内容
print("点击过车记录查询")
self.driver.Clickxpath(xlrd.read_excel_two(132, 1))
print("进入过车记录查询")
time.sleep(5)
# 选择停车场,读取excel文档内容
self.driver.Clickid(xlrd.read_excel_two(7, 1))
print("已选择过车记录")
time.sleep(5)
def Charge_statemen(self):
'''进入收费报表'''
# 进入停车场二代管理,读取excel文档内容
print("点击停车场二代管理")
self.driver.Clickxpath(xlrd.read_excel_two(4, 1))
time.sleep(15)
# 悬停在报表信息上,读取excel文档内容
print("商标悬停在报表信息上")
self.driver.Action_xpath(xlrd.read_excel_two(120, 1))
self.driver.impicitly()
# 进入收费报表,读取excel文档内容
print("点击收费报表")
self.driver.Clickxpath(xlrd.read_excel_two(121, 1))
print("进入收费报表")
time.sleep(5)
# 选择停车场,读取excel文档内容
self.driver.Clickid(xlrd.read_excel_two(7, 1))
print("已选择收费报表")
time.sleep(5)
def System_settings(self):
'''进入系统设置'''
# 进入停车场二代管理,读取excel文档内容
print("点击停车场二代管理")
self.driver.Clickxpath(xlrd.read_excel_two(4, 1))
time.sleep(15)
# 悬停在系统设置上,读取excel文档内容
print("商标悬停在系统设置上")
self.driver.Action_xpath(xlrd.read_excel_two(79, 1))
self.driver.impicitly()
# 进入系统设置,读取excel文档内容
print("点击系统设置")
self.driver.Clickxpath(xlrd.read_excel_two(80, 1))
print("进入系统设置")
time.sleep(5)
# 选择物业,读取excel文档内容
self.driver.Clickxpath(xlrd.read_excel_two(81, 1))
print("已选择系统设置")
time.sleep(5)
def Parking_Management(self):
'''进入车位管理'''
# 进入停车场二代管理,读取excel文档内容
print("点击停车场二代管理")
self.driver.Clickxpath(xlrd.read_excel_two(4, 1))
time.sleep(10)
# 悬停在停车场信息管理上,读取excel文档内容
print("商标悬停在车位管理上")
self.driver.Action(xlrd.read_excel_two(5, 1))
# 隐式等待30秒
self.driver.impicitly()
# 进入车位管理,读取excel文档内容
print("点击车位管理")
self.driver.Clickid(xlrd.read_excel_two(6, 1))
print("进入车位管理")
time.sleep(5)
# 选择停车场,读取excel文档内容
self.driver.Clickid(xlrd.read_excel_two(7, 1))
print("已选择停车场")
time.sleep(5)
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_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_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_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_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
