#conding=utf-8 import time import unittest from selenium import webdriver from page.loginpage import LoginPage import ddt from common.readexcel import ExcelUtil filepath = r"C:\Users\ylzx\PycharmProjects\AUTOui\common\testdata.xlsx" data = ExcelUtil(filepath) testdata = (data.dict_data()) print(testdata) # testdata = [ # {"username":"******","pwd":"123456","res":"18612498560"}, # {"username":"******","pwd":"123123","res":"15810662774"} # ] @ddt.ddt class TestLogin(unittest.TestCase): u'''测试登录功能''' #开始 @classmethod def setUpClass(cls): cls.driver = webdriver.Firefox() cls.loginpage = LoginPage(cls.driver) t = time.strftime("%Y-%m-%d %H_%M_%S") print("用例开始执行" + t) #结束 @classmethod
# -*- coding:utf-8 -*- from page.login_page import LoginPage from selenium import webdriver import unittest import ddt from common.readexcel import ExcelUtil filepath = "testdata.xlsx" data = ExcelUtil(filepath) testdata = data.dict_data() # 读取数据为list print(testdata) # # 参数和代码分离 # testdata = [ # {"username": "******", "psw": "123456", "result": "admin"}, # {"username": "******", "psw": "123456", "result": ""}, # {"username": "******", "psw": "111111", "result": "admin2"}, # {"username": "******", "psw": "111111", "result": "admin3"}] @ddt.ddt # 测试类前面加上@ddt.ddt class LoginCase(unittest.TestCase): @classmethod def setUpClass(cls): cls.driver = webdriver.Firefox() cls.loginpage = LoginPage(cls.driver) def login_case(self, username, psw): # 登录 self.loginpage.login(username, psw)
import ddt from pages.login_page import Login, login_url from selenium import webdriver from common.readexcel import ExcelUtil curpath = os.path.dirname(os.path.realpath(__file__)) #os去获取文件logindata.xlsx的路径, filepath = os.path.join(curpath, "logindata.xlsx") #xls的路径写死:"D:\\test1\\Test\\common\\logindata.xlsx" print("logindata的路径%s" % filepath) data = ExcelUtil(filepath, "Sheet1") test_datas = data.dict_data() print(test_datas) ''' test_datas = [ {"user": "******", "psw": "123456", "expect": True}, {"user": "******", "psw": "123456", "expect": False}, {"user": "******", "psw": "123456", "expect": False}, {"user": "******", "psw": "123456", "expect": True}, ] ''' #AttributeError: 'TestLoader' object has no attribute 'makeTest' 鼠标没放到if下运行 @ddt.ddt class TestLogin(unittest.TestCase):
def datas(): filepath = "../all_Case/testdata.xlsx" sheetName = "Sheet1" data = ExcelUtil(filepath, sheetName) testdata = data.dict_data() return testdata
#coding:utf-8 import ddt import unittest from case.login import login from common.readexcel import ExcelUtil # 参数和代码分离 # testdata = [ # {"username": "******", "psw": "admin123"}, # {"username": "******", "psw": "yifan123"}, # {"username": "******", "psw": "admin123"}, # {"username": "******", "psw": "kangyong"}, # ] readexcel = ExcelUtil("testdata.xlsx") d11 = readexcel.dict_data() print(d11) @ddt.ddt class Test_login(unittest.TestCase): u''' crm系统登录模块''' def setUp(self): self.host = "https://crm-test.jingdaka.com/api/crm" @ddt.data(*d11) def test_01(self, canshu): u''' 运营主管正确帐号密码登录''' print(canshu) self.username = canshu["username"] self.password = canshu["password"] (self.code, self.roleid) = login.login(self.host, self.username,