第15课、参数化-DDT xlrd

 

二、基于上一节课的代码模块，加上ddt

有两个地方需要加修饰符

1.测试类前面：@ddt.ddt

2.测试用例前：@ddt.data

-------

有了ddt模块，就可以实现多组数据串行登录页面，并判断是否登录成功：

在test_login.py中，代码添加ddt：

import unittest
from selenium import webdriver

from t7.pages.login_page import Login,login_url1
import ddt
test_datas =[
    {"user":"admin","psw":"123456","expect":True},
    {"user": "admin9", "psw": "123456", "expect": True},
    {"user": "test1", "psw": "123456", "expect": False}
]

@ddt.ddt
class TestLogin(unittest.TestCase):
    def setUp(self):
        self.driver = webdriver.Firefox()
        self.driver.get(login_url1)
        self.a =Login(self.driver)

    def tearDown(self):
        self.driver.quit()

    @ddt.data(*test_datas)
    def test_login_01(self,data):
        '''测试数据正常-登录成功'''
        print("测试数据：%s"%data)
        self.a.login(data["user"],data["psw"])
        result =self.a.is_login_sucess("后台首页")
        print("登录的实际结果：%s"%result)
        self.assertTrue(result==data["expect"])


if __name__ == '__main__':
    unittest.main()

import unittest
from selenium import webdriver
from t7.pages.login_page import Login,login_url1
from t7.case.readexcel import ExcelUtil
import os
import ddt

userdpath = os.path.dirname(os.path.realpath(__file__))
filepath = os.path.join(userdpath,"logindata.xlsx")
print("logindata的路径：%s"%filepath)
readexcel = ExcelUtil("logindata.xlsx","Sheet1")
test_datas = readexcel.dict_data()
print(test_datas)
'''
test_datas =[
    {"user":"admin","psw":"123456","expect":True},
    {"user": "admin9", "psw": "123456", "expect": True},
    {"user": "test1", "psw": "123456", "expect": False}

]
'''


@ddt.ddt
class TestLogin(unittest.TestCase):
    def setUp(self):
        self.driver = webdriver.Firefox()
        self.driver.get(login_url1)
        self.a =Login(self.driver)

    def tearDown(self):
        self.driver.quit()

    @ddt.data(*test_datas)
    def test_login_01(self,data):
        '''测试数据正常-登录成功'''
        print("测试数据：%s"%data)
        self.a.login(data["user"],data["psw"])
        result =self.a.is_login_sucess("后台首页")
        print("登录的实际结果：%s"%result)
        self.assertTrue(result==data["expect"])


if __name__ == '__main__':
    unittest.main()