Python ddt数据驱动

使用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')