The following pages and posts are tagged with

Title	Type	Excerpt
CSV Data Provider	Page	CSV data provider supports character separated values including standard comma separated values. Each line in file represents one record except blank line or comment line. The file extension can be csv or txt. Following are examples of CSV data file used to provide test data where...
Database Data Provider	Page	Below are the properties which required to configure in property file to configure database. db.driver.class=com.mysql.jdbc.Driver db.connection.url=jdbc:mysql://localhost:3306/db db.user=username db.pwd=password Usage Java @QAFDataProvider(sqlQuery="select username,password,isvalid from login_table") BDD Meta-data:{"sqlQuery":"select username,password,isvalid...
Excel Data Provider	Page	Following is the example of xls data file used to provide test data where first row is header. The test gets executed 3 times as there are 3 data set in data file. It assumes by default first sheet. If sheet is not first sheet you need to provide sheet...
JSON Data Provider	Page	Following is the example of JSON data file used to provide test data. The test gets executed 3 times as there are 3 data set in data file. logintestdata.json [ { "Username" : "admin" , "password":"123abc123" , "isvalid":false }, { "Username" : "Admin" , "password":"test" ,...
XML Data Provider	Page	If we want to provide data using xml file below is the sample xml file. The test gets executed 4 times as there are 4 data set in data file. <root> <!-- data for login test --> <login> <data> <user_name>ruchita.shah1989+02@gmail.com</user_name>...
Test data Filter	Page	Consider following test data return by data provider. TestcaseID uname password id name price 12345 user1 @Test123# 101 Item-1 10.50 12346 user1 @Test123# 102 Item-2 50.0 12347 user1 @Test123# 103 Item-3 125.99 12348 user2 @Test123# 104 Item-4...
Make Tests Data driven	Page	QAF enhances TestNG data provider by providing intercepter and in built data providers that supports different external data sources. To make any test data driven you can use @QAFDataProvider or @Metadata annotation on java test method, where test get executed for each data set provided in...
Make Tests Data driven	Page	To make any test data driven you can use QAFDataProvider annotation on test method, where test get executed for each data set provided in external data file. QAF supports following file formats to provide data for data driven tests. CSV MS-EXCEL JSON XML DATABASE TXT <div...