{
"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()
