Example of data driven Testing

In this post, i will given an example of data driven test that i carried out on google.com.

I saved a excel with data – Input string for search box & the xpath of the links in search result that i want to click. The above snap shows the excel with data.

package DataDrivePackage;
import com.thoughtworks.selenium.*;

import junit.framework.TestCase;
import org.junit.AfterClass;
import org.openqa.selenium.By;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.WebElement;
import org.openqa.selenium.ie.InternetExplorerDriver;
import org.openqa.selenium.server.SeleniumServer;
import org.testng.annotations.*;

import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import java.util.Iterator;
import java.util.concurrent.TimeUnit;

import jxl.*;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRichTextString;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;

public class googleTest {
        
    WebDriver d    = new InternetExplorerDriver ();

    @BeforeClass
    public void envSetup()throws Exception
    {
        d.get(“http://www.google.co.in/”);
        System.out.println(“opened the browser”);
    }
    
    
    public void checkUrl()throws Exception
    {
        if (d.getCurrentUrl() != “http://www.google.co.in/” )
        {
            System.out.println(“yes google is not on”);
            d.get(“http://www.google.co.in/”);
            d.manage().timeouts().implicitlyWait(5, TimeUnit.SECONDS);
        }    
    }
    
    
    @Test (dataProvider = “dp”)
    public void gTest (String searchString, String clickLink)throws Exception
    {
        System.out.println(searchString+” “+ clickLink);
        d.findElement(By.xpath(“//INPUT[@id=’gbqfq’]”)). sendKeys (searchString);
        WebElement e = d.findElement(By.xpath(“//INPUT[@id=’gbqfq’]”));
        e.submit();
        d.manage().timeouts().implicitlyWait(5, TimeUnit.SECONDS);
        d.findElement (By.xpath(clickLink)).click();
        checkUrl();
    }
    
    
    @DataProvider(name = “dp”)
    public Object[][] sendData ()throws Exception
    {
       Object[][] retData = getArrayTable (“C:\\selDataFolder\\googleTest.xls”);
       return (retData);
    }

    public static String[][] getArrayTable (String xlPath) throws Exception
    {    
        int r = 0, c =0;
        
        InputStream inputStream = new FileInputStream(xlPath);
        POIFSFileSystem fileSystem = new POIFSFileSystem (inputStream);
        HSSFWorkbook workBook = new HSSFWorkbook (fileSystem);
            
        HSSFSheet sheet = workBook.getSheetAt(0);
        Iterator<Row> rows = sheet.rowIterator();
        
        int totalRows = sheet.getPhysicalNumberOfRows();
        HSSFRow row1 = sheet.getRow(1);
        int totalCols = row1.getLastCellNum();
        String[][] tabArray = new String[totalRows][totalCols];
    
        while (rows.hasNext())
        {
            Row row = rows.next();
            
            Iterator<Cell> cells = row.cellIterator();
            while (cells.hasNext())
            {
                Cell cell = cells.next ();
                tabArray[r][c] = cell.getStringCellValue ();
                ++c;
            }
            
            c=0;
            ++r;
        }
        return tabArray;
    }
}

Explaination

1. I create a input stream of type file inputstream.

2. Created a POIFSFileSystem, taking this file input stream as parametr.

3. Created a HSSF workbook, to access the excel.

4. Created a Iterator of Row class type. Using this iterator, i can get a collection of rows in the sheet with the pointer at row beginning.

5. using hasNext() method, i move thru the rows.

6. I create a object of type Row class to store the pointer to the next row as i iterate.

7. Similarly, i iterate thru the cells in the same way as i explainted for the rows above.

8. Store the result in a array and return it.