python 使用parameterized进行参数

import unittest
from parameterized import parameterized   # 引入parameterized模块
a = [(1,2,3), (4,5,7)]

class ceshi(unittest.TestCase):

    def test01(self):
        self.assertEqual(2,2)

    @parameterized.expand([(1,2,3),(4,6,7)])
    def test02(self,a,b,c):
        s = a+b
        self.assertEqual(s,c)


if __name__=='__main__':
    unittest.main()

结果：

iloc函数
tolist函数把ndarray转化为list对象

import unittest
from parameterized import parameterized   # 引入parameterized模块
import pandas as pa
import requests
list = pa.read_excel('E:\桌面\参数化.xls',)
a=list.iloc[:,4:6].values
b = a.tolist()


class testsearch(unittest.TestCase):


    @parameterized.expand(b)
    def test01(self, a1, b1):
        url = 'http://127.0.0.1:8000/api/get_event_list/'
        a1 = eval(a1)  # 注意将字符串转化成字典在进行请求
        r = requests.get(url, params= a1)
        self.result = r.json()
        print(self.result['status'])
        self.assertEqual(self.result['status'], b1)


if __name__ == '__main__':
    unittest.main()

dict函数用于返回字典对象

eval函数把字符串转化成字典格式