#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,
