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
