Data-driven testing in ATS allows you to run tests using tables of data as direct test input. This way, you test different input values without having to write extra tests.
Data sets are easy to create and maintain, so you can add more values later on without changing your test cases.
You can access the Test Data tab from the Test Cases page. Here you create a data set by clicking New Data Set. A dialog box opens, where you give the data set a name and an optional description.
Data sets consist of one or more fields and records. You can think of fields as columns in a table. Corresponding to that, records are the rows in a table and represent the values of a field.
Fields can have following data types: text or number.
|Field||A column of a table for specific data (for example, username.|
|Record||A row in a data table containing a text or number value.|
2 Using Test Data in Test Cases
To use your data sets in test cases, you need to select a Master data set under the Test Data tab inside a test case. Click the arrow to open the Select Data Set dialog box.
You can only select one master data set at a time per test case. Your selected data set affects which fields you can use as parameters in your selected test case. You can only choose fields that are in the selected master data set. On execution, ATS picks the corresponding record values for each field.
If you connect a data set with a test case, ATS executes a session for each record row in the data set. For example, if there are three rows, ATS executes three sessions.
3 Importing and Exporting Data Sets
When creating and editing a data set, select the Create/Update fields from file option to provide a template Excel file. Create or update fields and records of your data set using this Excel file. ATS recognizes the first row of the Excel sheet as the field names. ATS considers all extra rows as records and also uses them to determine the field data type.
When importing data from Excel, ATS tries to convert data that doesn’t match the expected data type. If a conversion is not possible (for example, from a string to an integer), the resulting value is empty. Always check your data after import to ensure all the data was completely imported.
Export a data set to Excel by clicking Export to Excel.
4 Exporting a Test Case
When exporting a test case that has a data set assigned to it, ATS also exports that connection. ATS automatically looks for the same data set when importing that test case. If no such data set exists yet, ATS connects it when created.
5 Error Types
There are two error types that can occur when setting a data set. These are described below.
ATS lists the test step and parameter for each error for easy identification.
5.1 Missing fields
For this type of error, fields are shown that are not in the selected master data set currently used in the test case.
5.2 Incompatible Data Types
For this error type, parameters are shown that need a different data type than the data type of the field.