Python data-driven-DDT

Directory

[TOC]

First, data-driven introduction

Data-driven, my understanding, the simple point is that the data test data parameterization.

Ii. Basic use of DDT Introduction 2.0 test base class

classTest:def __init__( Self, A, B): Self. A=A Self. b=BdefAdd Self):return  Self. A+  Self. bdefSub Self):return  Self. A-  Self. bdefMulti Self):return  Self. A*  Self. bdefDiv Self):return  Self. A/  Self. b

2.1 Use steps

1. Guide Package

   fromimport ddt, data, unpack

2. Use of DDT

2.1 DDT reads single data

Not many applications in this way

2.2.1 Case

@ddtclass TestExample0428(unittest.TestCase):    def setUp(self):        pass    @data(123)    def test_add(self***kwargs):        print(*args)

Print 3 times, 1, 2, 3, respectively

2.2 DDT reading data from a combination (@unpack)

This approach is a more common way to enable parameterization of multi-parameter use cases

2.2.1 Plus Unpack

@ddtclass TestExample0428(unittest.TestCase):    def setUp(self):        pass            @data((123), (235), (111))    @unpack    def test_dict(self***kwargs):        print("开始打印数据")        # print(*args, **kwargs)        print(*args)

Print results

开始打印数据123开始打印数据235开始打印数据111

2.2.2 Don't add unpack

@ddtclass TestExample0428(unittest.TestCase):    def setUp(self):        pass            @data((123), (235), (111))    def test_dict(self***kwargs):        print("开始打印数据")        # print(*args, **kwargs)        print(*args)

Print results

开始打印数据(123)开始打印数据(235)开始打印数据(111)

2.3 Reading Dictionaries

@ddtclass TestExample0428(unittest.TestCase):    def setUp(self):        pass            @data({"name":"gupan""length":"170cm"}, {"age":"12"})    def test_dict(self***kwargs):        print("开始打印数据")        print(***kwargs)

Print results

开始打印数据{‘name‘‘gupan‘‘length‘‘170cm‘}开始打印数据{‘age‘‘12‘}

Third, DDT and Excel combine 3.1 Excel parsing class notation

#-*-Coding:utf-8-*-# __author__ = ' Gupan ' fromConfigImportSettingsImportOsImportSys fromSrc.utilsImportUtilsImportXlrdImportTracebackclassExcelparse:"""Excel parsing classesself.file_path: Test data storage Pathself.workbook: Open an Excel objectself.sheet_obj: Open Form Objectself.nrows: Number of rows with data in the formself.ncols: Number of columns with data in the form__init__ (Self, file_path):Aquire_cell_data (self, Row, col): Gets the data of a cell, does not need-1heads (Self, *args, **kwargs): Get test Data HeaderAquire_methodname_col (self): Gets the test method nameAquire_each_col_type (self): Gets the data type of each data columndatas (self, *args, **kwargs): Gets all the test data, stored by dictionary according to the method name    """    def __init__( Self, File_path):" ":p Aram File_path: Test data storage Path" "         Self. file_path=File_pathif  notOs.path.exists ( Self. File_path): Utils.print_log_error ( Self. file_path+ "does not exist, please confirm the path!!!!! ") Sys.exit (1)Try: Self. workbook=Xlrd.open_workbook ( Self. File_path)except Exception  asErr:utils.print_log_error ("file should be in XLS format data\ n") Utils.print_log_error (Traceback.format_exc ())RaiseErr# Only one form is stored in the default Excel table, and you only need to get the first one.         Self. sheet_obj=  Self. Workbook.sheets () [0]# Get the number of table lines         Self. nrows=  Self. sheet_obj.nrows# Get the number of forms in a single row         Self. ncols=  Self. sheet_obj.ncolsif  Self. nrows== 1 or  Self. ncols== 0: Utils.print_log_error (File_path+ "The form is empty, please fill in the test data!!!!! ") Sys.exit (1)defAquire_cell_data ( Self, Row, col):" "Get Cell data:p Aram Row: The number of rows in the cell (do not have to be active-1):p Aram Col: The number of columns in the cell (do not have to be active-1): Return: The cell data (str type)" "        return  Self. Sheet_obj.cell_value (Row- 1, col- 1)defHeads Self,*Args**Kwargs):" "Get table Header:p Aram args::p Aram Kwargs:: Return: Table header list" "Heads_info=[] forColinch Range(0, Self. Ncols): Heads_info.append ( Self. Sheet_obj.cell_value (0, col))returnHeads_infodefAquire_methodname_col ( Self):" "gets the number of columns that the test method name lock occupies: Return: Test method name Storage path" "Heads=  Self. Heads ()Try: IDX=Heads.index (SETTINGS.METHOD_DESC)except Indexerror  asErr:utils.print_log_error ( Self. file_path+"does not exist in "+Settings.method_desc+ '\ n') Utils.print_log_error (Traceback.format_exc ())RaiseErrreturnIdxdefAquire_each_col_type ( Self):" "gets the number of columns that the test method name lock occupies: Return: Gets the data type of each data column, returned as a list" "Col_type_desc_list=[] forColinch Range(0, Self. Ncols): Col_type_desc_list.append ( Self. Sheet_obj.cell_value (Settings.desc_type_row- 1, col))returnCol_type_desc_listdefDatas Self,*Args**Kwargs):" "gets the test data, returned by the dictionary according to the test method name:p Aram args::p Aram Kwargs:: Return: The test data in the dictionary format, the key value for each test method name is a list form" "Test_datas={}# test data start data column CountData_begin_col=Settings.data_begin_col- 1        # Gets the number of test start data rowsData_begin_row=Settings.data_begin_row- 1        # Get a list of data types corresponding to each column of dataType_list=  Self. Aquire_each_col_type ()# Test the number of columns in the test method nameMethod_col=  Self. Aquire_methodname_col ()# Initialize test method namePre_method_name=  Self. Sheet_obj.cell_value (Data_begin_row, Method_col)# Store test data for a methodMethod_datas=[] Method_count= 0        # table Header no test data, remove table header         forRowinch Range(Settings.data_begin_row- 1, Self. nrows): Row_data=[] Cur_method_name=  Self. Sheet_obj.cell_value (Row, Method_col)# start getting data             forColinch Range(Data_begin_col, Self. Ncols): Type_desc=Type_list[col] Cell_data=  Self. Sheet_obj.cell_value (Row, col) cell_data=Utils.type_switch (Cell_data, Type_desc) row_data.append (cell_data)ifPre_method_name==Cur_method_name:method_datas.append (Row_data) method_count+= 1            Else: Test_datas[pre_method_name]=Method_datas.copy ()# After the test method is changed, the test data pre-condition is emptiedMethod_datas.clear () Method_count= 0Pre_method_name=Cur_method_name Method_datas.append (Row_data)# No 0 means some data is not added        ifMethod_count!= 0: Test_datas[pre_method_name]=Method_datasreturnTest_datas

3.2 DDT and Excel combined case

@ddtclassTestExample0428 (unittest. TestCase):defSetUp ( Self):Pass    @data(*test_datas[' Test_add '])@unpack    defTest_add ( Self,*Args**Kwargs): P1, P2, value=Args result=Test (P1, p2). Add ()Try: Self. Assertequal (result, value,"Addition error, please reenter") Utils.print_log_info ("addition Test succeeded")except Assertionerror  asErr:err_str=Traceback.format_exc () utils.print_log_error (ERR_STR)RaiseErr

Test results

test_add_1__2__2__4_ (src.test.case.testExample.TestExample0428) ... 加法测试成功ok加法测试成功test_add_2__2__2__4_ (src.test.case.testExample.TestExample0428) ... ok加法测试成功test_add_3__3__3__6_ (src.test.case.testExample.TestExample0428) ... ok加法测试成功test_add_4__4__4__8_ (src.test.case.testExample.TestExample0428) ... oktest_dict (src.test.case.testExample.TestExample0428) ... oktest_div (src.test.case.testExample.TestExample0428) ... oktest_multi (src.test.case.testExample.TestExample0428) ... oktest_sub (src.test.case.testExample.TestExample0428) ... ok

Python data-driven-DDT