unittest框架，读取csv的数据应用到测试用例中

是谁a

已于 2024-07-01 15:33:38 修改

阅读量94

点赞数 3

文章标签：测试用例 python

于 2024-07-01 15:08:13 首次发布

本文链接：https://blog.csdn.net/weixin_54312661/article/details/140101658

版权

def read_excel():
    xlsx = openpyxl.load_workbook("D:\pythonProjects\order.xlsx")
    sheet1 = xlsx['Sheet1']
    print(sheet1.max_row)  # 行
    print(sheet1.max_column)  # 列
    print('=======================================================')
    allList = []
    for row in range(1, sheet1.max_row + 1):
        rowlist = []
        for column in range(1, sheet1.max_column + 1):
            rowlist.append(sheet1.cell(row, column).value)
        allList.append(rowlist)
        print(allList)
    return allList
#和数据有关的要用@ddt
@ddt
class TestDemo(unittest.TestCase):

    def setUpClass(self):

    def tearDownClass(self):
        
    #调用上面的读取csv的方法read_excel()
    @data(*read_excel())
    @unpack
#    除了self以外，read_excel()获取到多少列值，下方就应该有多少个参数
    def ttest_1(self, phone, products, integral, activity):
        print("test_1")



if __name__ == '__main__':
    unittest.main(verbosity=2)
else:
    pass