data driven testing in cucumber using excel files code example

Example: data driven testing in cucumber

CUCUMBER / JUNIT:
	1. Scenario outline
	2. Excel file with the help of Apache POI
	3. JSON or CSV file for API testing
	4. Data which comes from Database and stores in collections
	5. @ParameterizedTest --> If you use JUnit-5
		
	
	Examples for ParameterizedTest:

	@ParameterizedTest
    @ValueSource(ints = {1,2,3,4})  ==> it can be ints/
                       strings/booleans/chars (those are keywords)
    public void validateRegionNameTest1(int id) {
     xxxxx
    }

    @ParameterizedTest
    @CsvSource({
            "1, Europe",
            "2, Americas",
            "3, Asia",
            "4, Middle East and Africa"})
    public void validateRegionNameTest2(int id, String name){ 
    xxxx
    }

    @ParameterizedTest
    @CsvFileSource(resources = "/regions.csv")

    @ParameterizedTest(name = "{index} => a={0}, b={1}, sum={2}")
    @MethodSource("sumProvider")
  
    @ParameterizedTest(name = "{index} => pet=''{0}''")
    @EnumSource(value = Pet.class, names = {"CAT"})

    @ParameterizedTest(name = "{index} => a={0}, b={1}, sum={2}")
    @ArgumentsSource(CustomArgumentProvider.class)

Tags:

Misc Example