使用Python ddt数据驱动,为自动化测试用例提供数据
首先安装ddt, 命令:pip install ddt
安装完成后就可以使用ddt了,直接上例子,代码如下所示:
# -*- coding: utf-8 -*-
# Name: ddt_study
# Description:
# Author: Jake Yu
# Date: 2019/11/13
import unittest
from ddt import ddt,data,unpack
from common import configDB
localConfigDB = configDB.MyDB()
def get_user_info():
db = localConfigDB.connectDB()
sql = "select username,password from user_info"
cursor = localConfigDB.executeSQL(sql, params=None)
result = localConfigDB.get_all(cursor)
localConfigDB.closeDB()
return result
datas = get_user_info()
print(datas)
@ddt
class MyTesting(unittest.TestCase):
def setUp(self):
print("This is the setUp")
@data(*datas)
def test_one(self, data):
self.username = data[0]
print(f'\n用户名:{ self.username }')
self.passsword = data[1]
print(f'\n密码:{self.passsword}')
def tearDown(self):
print('this is tearDown')