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
