Reading test data from a CSV file using JUnit

We saw a simple data-driven test using JUnit and TestNG. The test data was hardcoded in the test script code. This could become difficult to maintain. It is recommended that we store the test data separately from the test scripts.

Often we use data from the production environment for testing. This data can be exported in CSV format. We will use OpenCSV library to read a CSV file. For more details on OpenCSV, headon to http://opencsv.sourceforge.net/.

In this recipe, we will read data from a CSV file and use this data to execute the test script.

Getting ready

To begin, follow these steps:

• Add OpenCSV dependency to the Maven pom.xml file:

  <dependency>
    <groupId>com.opencsv</groupId>
    <artifactId>opencsv</artifactId>
    <version>3.4</version>
    <scope>test</scope>
  </dependency>
  

• Prepare a CSV file with the required data.

How to do it...

Let's create a new JUnit test and CSV parametrization, as...