Data-Driven Testing with Selenium WebDriver

Data-driven testing is a robust testing methodology that focuses on testing the functionality of an application using multiple sets of data. Instead of hardcoding input values and expected results, this approach separates test logic from the test data, enhancing reusability and maintainability. Selenium, being a popular automation tool, supports data-driven testing seamlessly when integrated with testing frameworks like TestNG or JUnit.

In this blog, we’ll delve into the concept of data-driven testing, explore its benefits, and demonstrate how to implement it using Selenium with detailed coding examples.

What is Data-Driven Testing?

Data-driven testing involves executing test scripts multiple times with different sets of input data. The test data is typically stored in external sources such as:

• Excel files

• CSV files

• Databases

• JSON or XML files

This approach is particularly useful for validating applications where the same functionality needs to be tested with various input combinations.

Benefits of Data-Driven Testing

1. Reusability: Test scripts are reusable for different data sets.

2. Maintainability: Test logic is separated from test data, making maintenance easier.

3. Scalability: Allows extensive test coverage with diverse data.

4. Efficiency: Reduces redundancy in writing test scripts.

Tools Required

1. Selenium WebDriver: For browser automation.

2. Apache POI: To read/write data from Excel files.

3. TestNG/JUnit: For test execution and data provider functionality.

Setting Up Your Project

Add Dependencies

Include the following dependencies in your pom.xml if you’re using Maven:

<div><pre><span><dependencies></span>
    <span><dependency></span>
        <span><groupId></span>org.seleniumhq.selenium<span></groupId></span>
        <span><artifactId></span>selenium-java<span></artifactId></span>
        <span><version></span>4.10.0<span></version></span>
    <span></dependency></span>
    <span><dependency></span>
        <span><groupId></span>org.apache.poi<span></groupId></span>
        <span><artifactId></span>poi<span></artifactId></span>
        <span><version></span>5.2.3<span></version></span>
    <span></dependency></span>
    <span><dependency></span>
        <span><groupId></span>org.apache.poi<span></groupId></span>
        <span><artifactId></span>poi-ooxml<span></artifactId></span>
        <span><version></span>5.2.3<span></version></span>
    <span></dependency></span>
    <span><dependency></span>
        <span><groupId></span>org.testng<span></groupId></span>
        <span><artifactId></span>testng<span></artifactId></span>
        <span><version></span>7.8.0<span></version></span>
    <span></dependency></span>
<span></dependencies></span></pre>
</div>
<p></p>

Code Example: Data-Driven Testing Using Excel and TestNG
Step 1: Create the Test Data
Create an Excel file named TestData.xlsx with the following columns:



Username
Password




user1
pass1


user2
pass2



Save this file in the project directory.
Step 2: Utility Class to Read Excel Data
Create a utility class ExcelUtils.java:

<div><pre><span>import</span> <span>java.io.FileInputStream</span>;
<span>import</span> <span>java.io.IOException</span>;
<span>import</span> <span>org.apache.poi.ss.usermodel.*</span>;

<span>public</span> <span>class</span> <span>ExcelUtils</span> {
    <span>private</span> <span>static</span> Workbook workbook;
    <span>private</span> <span>static</span> Sheet sheet;

    <span>public</span> <span>static</span> <span>void</span> <span>loadExcel</span>(String filePath) <span>throws</span> IOException {
        FileInputStream fis = <span>new</span> FileInputStream(filePath);
        workbook = WorkbookFactory.<span>create</span>(fis);
    }

    <span>public</span> <span>static</span> String <span>getCellData</span>(<span>int</span> row, <span>int</span> column) {
        sheet = workbook.<span>getSheetAt</span>(<span>0</span>);
        Row rowData = sheet.<span>getRow</span>(row);
        Cell cell = rowData.<span>getCell</span>(column);
        <span>return</span> cell.<span>toString</span>();
    }

    <span>public</span> <span>static</span> <span>int</span> <span>getRowCount</span>() {
        <span>return</span> sheet.<span>getLastRowNum</span>();
    }
}</pre>
</div>
<p></p>
Step 3: Test Class with Data Provider
Create a test class LoginTest.java:

<div><pre><span>import</span> <span>org.openqa.selenium.By</span>;
<span>import</span> <span>org.openqa.selenium.WebDriver</span>;
<span>import</span> <span>org.openqa.selenium.WebElement</span>;
<span>import</span> <span>org.openqa.selenium.chrome.ChromeDriver</span>;
<span>import</span> <span>org.testng.annotations.*</span>;

<span>public</span> <span>class</span> <span>LoginTest</span> {

    WebDriver driver;

    <span>@BeforeClass</span>
    <span>public</span> <span>void</span> <span>setup</span>() {
        System.<span>setProperty</span>(<span>"webdriver.chrome.driver"</span>, <span>"path_to_chromedriver"</span>);
        driver = <span>new</span> ChromeDriver();
        driver.<span>get</span>(<span>"https://example.com/login"</span>);
    }

    <span>@DataProvider</span>(name = <span>"loginData"</span>)
    <span>public</span> Object[][] <span>loginData</span>() <span>throws</span> Exception {
        ExcelUtils.<span>loadExcel</span>(<span>"TestData.xlsx"</span>);
        <span>int</span> rowCount = ExcelUtils.<span>getRowCount</span>();
        Object[][] data = <span>new</span> Object[rowCount][<span>2</span>];

        <span>for</span> (<span>int</span> i = <span>1</span>; i <= rowCount; i++) {
            data[i - <span>1</span>][<span>0</span>] = ExcelUtils.<span>getCellData</span>(i, <span>0</span>);
            data[i - <span>1</span>][<span>1</span>] = ExcelUtils.<span>getCellData</span>(i, <span>1</span>);
        }
        <span>return</span> data;
    }

    <span>@Test</span>(dataProvider = <span>"loginData"</span>)
    <span>public</span> <span>void</span> <span>testLogin</span>(String username, String password) {
        WebElement usernameField = driver.<span>findElement</span>(By.<span>id</span>(<span>"username"</span>));
        WebElement passwordField = driver.<span>findElement</span>(By.<span>id</span>(<span>"password"</span>));
        WebElement loginButton = driver.<span>findElement</span>(By.<span>id</span>(<span>"login"</span>));

        usernameField.<span>sendKeys</span>(username);
        passwordField.<span>sendKeys</span>(password);
        loginButton.<span>click</span>();

        <span>// Add assertions here to verify login success or failure</span>
    }

    <span>@AfterClass</span>
    <span>public</span> <span>void</span> <span>teardown</span>() {
        driver.<span>quit</span>();
    }
}</pre>
</div>
<p></p>

Best Practices for Data-Driven Testing


Use External Data: Store test data in external files to reduce script changes.


Parameterize Test Cases: Avoid hardcoding data in test scripts.


Error Handling: Implement robust error handling for file operations.


Optimize Performance: Load test data only once if possible.


Clear Test Data: Ensure the test environment is reset before each run.



Advantages of Data-Driven Testing with Selenium


Flexibility: Easily test multiple scenarios by changing input data.


Enhanced Coverage: Test edge cases by providing varied data sets.


Reduced Redundancy: Write fewer scripts for multiple test cases.



Conclusion
Data-driven testing is a vital strategy for efficient and thorough test automation. By combining Selenium with tools like Apache POI and TestNG, you can create scalable and maintainable test suites that cover a wide range of scenarios. Implement this approach to enhance your testing process and ensure high-quality software delivery.

Keywords: Data-Driven Testing, Selenium, TestNG, Apache POI, Automation Testing, Excel Integration, Test Automation Framework.
Source: Read More