weixin_49855251的博客

使用数据驱动就可以简化测试用例比如用户登录：分为用户登录成功和失败from time import sleepimport pytestfrom selenium import webdriverfrom selenium.webdriver.support import expected_conditions as ECfrom selenium.webdriver.support.wait import WebDriverWaitimport pyautogui #通过定位坐标来找到

首先要安装ddtpip install ddt实例：import osfrom ddt import ddt, data, unpack, file_dataimport unittestdef get_data(): testdata = [{'name': 'tom', 'age': 20}, {'name': 'kite', 'age': 30}] return testdata@ddtclass MyTestCase(unittest.TestCase):.

链接数据库后创建库：create database testing_db;创建表：create table user_tbl(id int primary key auto_increment,username char(20),pwd varchar(20));插入数据：mysql> insert into user_tbl(username,pwd)values(‘tom’,‘123’);Query OK, 1 row affected (0.20 sec)mysql> i..

1.调用xlrd：import xlrd2.使用xlrd模块调用excel表格3.结合pytest参数化格式处理方式来实现DDT首先创建个excel表格：代码：import pytestimport xlrdfrom openpyxl.workbook import Workbookdef get_data(): filename = 'test_data.xlsx' wb = xlrd.open_workbook(filename) sheet = wb.shee

例子：import pytestimport jsondef get_data(): with open('test.json') as f: lst = [] data = json.load(f) #读取数据 lst.extend(data['keys']) return lst@pytest.mark.parametrize('name', get_data())def test01(name): print.

#DDT数据驱动，调用csv文件来实现参数化的驱动测试import csvimport pytestdef test_get_data(): with open('test.csv') as f: lst=csv.reader(f)# 一行行读出来 my_data=[] for row in lst: my_data.extend(row) print(my_data) return my_d.