com.qmetry.qaf.automation.testng.dataprovider

Annotation Type QAFDataProvider

@Retention(value=RUNTIME)
 @Target(value={METHOD,TYPE})
public @interface QAFDataProvider

Values of this annotation parameters can be overridden by providing property <tc_name>.testdata=<value>

The value contains comma separated parameter and value combination: <tc_name>.testdata=<param>=value,<param>=value Supported parameters are

• datafile : data file url, csv or excel file url
• sheetname: sheet name for excel data file, default is the first sheet
• labelname: name of label, if data start and end cell marked with label in excel sheet
• hasheaderrow: true/false, indicates excel sheet has header row
• sqlquery: database query, will not be used if data file provided. Must required other db properties

com.qmetry.qaf.automation.testng.dataprovider.QAFDataProvider.java

Author:

chirag

Field Summary

Fields

Modifier and Type	Fields and Description
static java.lang.String	NAME
static java.lang.String	NAME_PARALLEL

Optional Element Summary

Optional Elements

Modifier and Type	Optional Element and Description
java.lang.String	dataFile Used to provide csv or excel file.
java.lang.String	filter Filter to apply on data set returned by the data-provider that returns List of Maps.
boolean	hasHeaderRow Optional flag to indicate excel data contains header row that need to be skipped.
java.lang.String	key Optional data label name in excel sheet.
java.lang.String	sheetName Optional sheet name (value or property) for excel file.
java.lang.String	sqlQuery Used to provide database query.

Field Detail

NAME

public static final java.lang.String NAME

NAME_PARALLEL

public static final java.lang.String NAME_PARALLEL

Element Detail

dataFile

public abstract java.lang.String dataFile

Used to provide csv or excel file. Can be overridden by property <tc_name>.testdata

Returns:

Default:

""

sheetName

public abstract java.lang.String sheetName

Optional sheet name (value or property) for excel file. If not provided first sheet will be considered. Can be overridden by property <tc_name>.testdata

Returns:

Default:

""

hasHeaderRow

public abstract boolean hasHeaderRow

Optional flag to indicate excel data contains header row that need to be skipped. Default value is false. Can be overridden by property <tc_name>.testdata

Returns:

Default:

false

key

public abstract java.lang.String key

Optional data label name in excel sheet. Required if want to provide data start/end cell marked with label. Can be overridden by property <tc_name>.testdata

Returns:

Default:

""

sqlQuery

public abstract java.lang.String sqlQuery

Used to provide database query. Will not be considered if data file is provided.

Returns:

Default:

""

filter

public abstract java.lang.String filter

Filter to apply on data set returned by the data-provider that returns List of Maps. It must represent logical expression that returns true or false. You can use map key as context variable and test meta-data as parameter. For example you test data has "first-name", "last-name", "age" and "country", you can have expression that filters records for age above 18 as below:

• filter="age>18"
• filter="country.equalsIgnoreCase('India') && age>18"

As you can use test case meta-data, method name as "method" and class name as "class" as parameters, Another example of using test case meta-data in filter assuming test case meta-data has meta-data "testCaseID" and test data has "ID".

• filter="ID=='${testCaseID}'"
• filter="ID.equalsIgnoreCase(\"${method}\")"

Returns:

Default:

""