Software Testing Learning Notes丨JUnit5 combined with data-driven-csv

This article is transferred from the tester community, original link: https://ceshiren.com/t/topic/28202

POM file import

<dependency>
    <groupId>com.fasterxml.jackson.dataformat</groupId>
    <artifactId>jackson-dataformat-csv</artifactId>
    <version>${jackson.version}</version>
</dependency>

<dependency>
    <groupId>com.fasterxml.jackson.datatype</groupId>
    <artifactId>jackson-datatype-jsr310</artifactId>
    <version>${jackson.version}</version>
</dependency>           

CSV with header

orderLines.csv

item,quantity,unitPrice,orderDate

“No. 9 Sprockets”,12,1.23,2019-04-17

“Widget (10mm)”,4,3.45,2022-01-16

The member variable is the same as the header name

• Member variables of entity classes
• The header name of the CSV

@Data
public class OrderLine{
    private String item;
    private int quantity;
    private BigDecimal unitPrice;
    private LocalDate orderDate;

    public OrderLine() {
    }

    public OrderLine(String item, int quantity, 
    BigDecimal unitPrice, LocalDate orderDate) {
        this.item = item;
        this.quantity = quantity;
        this.unitPrice = unitPrice;
        this.orderDate = orderDate;
    }
}           

Corresponding test methods

@Test
void csvReadWithHeader() throws IOException {
    //带着header读取
    CsvSchema orderLineSchema = CsvSchema.emptySchema().withHeader();
    //功能上等价的便捷方法： mapper.registerModules(mapper.findModules());
    //我们需要使用 findAndRegisterModules方法，以便 Jackson正确处理我们的日期
    //Jackson也可以自动搜索所有模块，不需要我们手动注册
    csvMapper.findAndRegisterModules();
    MappingIterator<OrderLine> orderLines = csvMapper.readerFor(OrderLine.class)
            .with(orderLineSchema)
            .readValues(new File("src/test/resources/csv/orderLines.csv"));
    System.out.println(orderLines.readAll());
}           

The member variable is inconsistent with the header name

• Member variables of entity classes
• The header name of the CSV

@Data
public class OrderList {
    @JsonProperty("item")
    private String otherItem;
    @JsonProperty("quantity")
    private int qua;
    @JsonProperty("unitPrice")
    private BigDecimal price;
    @JsonProperty("orderDate")
    private LocalDate date;
}           

Corresponding test methods

@Test
void csvReadWithHeader1() throws IOException {
    //带着header读取
    CsvSchema orderLineSchema = CsvSchema.emptySchema().withHeader();
    //功能上等价的便捷方法： mapper.registerModules(mapper.findModules());
    //我们需要使用 findAndRegisterModules方法，以便 Jackson正确处理我们的日期
    //Jackson也可以自动搜索所有模块，不需要我们手动注册
    csvMapper.findAndRegisterModules();
    MappingIterator<OrderList> orderLines = csvMapper.readerFor(OrderList.class)
            .with(orderLineSchema)
            .readValues(new File("src/test/resources/csv/orderLines.csv"));
    System.out.println(orderLines.readAll());
}           

Direct declaration type resolution

• readerForMapOf(String.class)

@Test
void csvReadWithHeaderMap() throws IOException {
    //功能上等价的便捷方法： mapper.registerModules(mapper.findModules());
    //我们需要使用 findAndRegisterModules方法，以便 Jackson正确处理我们的日期
    //Jackson也可以自动搜索所有模块，不需要我们手动注册
    csvMapper.findAndRegisterModules();
    //.setSkipFirstDataRow(true) 第一行header不解析
    CsvSchema schema = CsvSchema.builder().setSkipFirstDataRow(true)
            .addColumn("item")
            .addColumn("quantity")
            .addColumn("unitPrice")
            .addColumn("orderDate")
            .build();
    MappingIterator<Object> objectMappingIterator = csvMapper.readerForMapOf(String.class)
            // 注意：不需要包装
            .with(schema)
            .readValues(new File("src/test/resources/csv/orderLines.csv"));
    System.out.println(objectMappingIterator.readAll());
}           

CSV without header

orderlist.csv

“No. 9 Sprockets”,12,1.23,2019-04-17

“Widget (10mm)”,4,3.45,2022-01-16

The member variable is the same as the header name

• Member variables of entity classes
• The header name of the CSV

@Data
public class OrderLine{
    private String item;
    private int quantity;
    private BigDecimal unitPrice;
    private LocalDate orderDate;

    public OrderLine() {
    }

    public OrderLine(String item, int quantity, 
    BigDecimal unitPrice, LocalDate orderDate) {
        this.item = item;
        this.quantity = quantity;
        this.unitPrice = unitPrice;
        this.orderDate = orderDate;
    }
}           

Corresponding test methods

@Test
void csvReadOutHeader() throws IOException {

    //功能上等价的便捷方法： mapper.registerModules(mapper.findModules());
    //我们需要使用 findAndRegisterModules方法，以便 Jackson正确处理我们的日期
    //Jackson也可以自动搜索所有模块，不需要我们手动注册
    csvMapper.findAndRegisterModules();
    CsvSchema schema = CsvSchema.builder()
            .addColumn("item")
            .addColumn("quantity")
            .addColumn("unitPrice")
            .addColumn("orderDate")
            .build();
    MappingIterator<Object> objectMappingIterator = csvMapper.readerFor(OrderLine.class)
            .with(schema)
            .readValues(new File("src/test/resources/csv/orderlist.csv"));
    System.out.println(objectMappingIterator.readAll());
}           

The member variable is inconsistent with the header name

• Member variables of entity classes
• The header name of the CSV

@Data
public class OrderList {
    @JsonProperty("item")
    private String otherItem;
    @JsonProperty("quantity")
    private int qua;
    @JsonProperty("unitPrice")
    private BigDecimal price;
    @JsonProperty("orderDate")
    private LocalDate date;
}           

Corresponding test methods

@Test
void csvReadOutHeader() throws IOException {

    //功能上等价的便捷方法： mapper.registerModules(mapper.findModules());
    //我们需要使用 findAndRegisterModules方法，以便 Jackson正确处理我们的日期
    //Jackson也可以自动搜索所有模块，不需要我们手动注册
    csvMapper.findAndRegisterModules();
    CsvSchema schema = CsvSchema.builder()
            .addColumn("item")
            .addColumn("quantity")
            .addColumn("unitPrice")
            .addColumn("orderDate")
            .build();
    MappingIterator<Object> objectMappingIterator = csvMapper.readerFor(OrderList.class)
            .with(schema)
            .readValues(new File("src/test/resources/csv/orderlist.csv"));
    System.out.println(objectMappingIterator.readAll());
}           

Direct declaration type resolution

• readerForMapOf(String.class)

@Test
void csvReadOutHeaderMap() throws IOException {

    //功能上等价的便捷方法： mapper.registerModules(mapper.findModules());
    //我们需要使用 findAndRegisterModules方法，以便 Jackson正确处理我们的日期
    //Jackson也可以自动搜索所有模块，不需要我们手动注册
    csvMapper.findAndRegisterModules();
    CsvSchema schema = CsvSchema.builder()
            .addColumn("item")
            .addColumn("quantity")
            .addColumn("unitPrice")
            .addColumn("orderDate")
            .build();
    MappingIterator<Object> objectMappingIterator = csvMapper.readerForMapOf(String.class)
            .with(schema)
            .readValues(new File("src/test/resources/csv/orderlist.csv"));
    System.out.println(objectMappingIterator.readAll());
}           

Free video tutorial sharing for software testing and development - Official Account - Tester Community