{ "username": "******", "password": "******", "expect": "余振新", "result": False }, ] # 读取excel # fliepath = r"D:\Web_project\demo\data\datas.xlsx" propath = os.path.dirname(os.path.dirname(os.path.realpath(__file__))) filepath = os.path.join(propath, "data", "datas.xlsx") sheetName = "Sheet1" data = ReadExcel(filepath, sheetName) print(data.dict_data()) url = "http://180.106.83.239:18080/login.html" """ 测试数据驱动: test_01: 输入账号密码后点击登录,获取登录名,判断登录名是否符合预期来断言是否登录成功 (登录失败会有弹窗,无法进入登录成功后的页面,定位登录名会抛出TimeOut异常,实际用例执行成功,但用例会执行失败) test_02: 输入账号密码后点击登录,获取登录名,判断登录名是否符合预期来断言是否登录成功 (在测试数据增加“result”字段,赋值True or False, 调用common方法返回预期与实际为True or False后,与“result”断言,解决没有获取到登录名会使用例失败的问题) """ @ddt.ddt class TestDemo(): """使用数据驱动测试登录功能"""
case5:输入正确的账户和密码,点击登录 ''' '''testdatas = [ {"user":"******","pwd":"123456.","expect":"result"}, {"user":"******","pwd":"123456","expect":"result"}, {"user":"******","pwd":"","expect":"result"}, {"user":"","pwd":"","expect":"result"}, {"user":"******","pwd":"123456.","expect":"result"} ]''' #路径不能写死,不然后面有人要调用的时候就找不到这个文件,这个时候就需要引入os模块,一层一层的往上去找到这个文件 propath = os.path.dirname(os.path.dirname(os.path.realpath(__file__))) filepath = os.path.join(propath, "commom", "datas.xlsx") #join是连接工程路径下的common下的datas print(filepath) data = ReadExcel(filepath) testdatas = data.dict_data() print(testdatas) @ddt.ddt class LoginTestCase(unittest.TestCase, Base): @classmethod def setUpClass(cls): cls.driver = webdriver.Firefox() cls.login_c = LoginPage(cls.driver) cls.driver.get(url) def setUp(self): self.driver.get(url) self.is_alert_present() self.driver.delete_all_cookies()