Univocity - how to provide date formats dynamically

Question

I am trying to validate Date fields in my project with univocity parser.

I know there are custom validators and format annotation in univocity. But there we need to provide static date formats while implementing bean classes.

@Format(formats = "yyyy-MM-dd")
private Date createdAt

I have a specific requirement that I need to provide date formats dynamically. This means I need to parse date fields as a string and then validate them against DateTimeFormatter after parsing csv file (kind of post verifier).

Is there a way to provide either passing validation arguments at runtime? Or does univocity support a verifier that is to process all beans after creation?

Thanks!

score 3 · Accepted Answer · answered Feb 23 '21 at 11:30

There is a possibility by setting converter to the processor:

import java.io.ByteArrayInputStream;
import java.util.Date;
import java.util.List;

import com.univocity.parsers.annotations.Parsed;
import com.univocity.parsers.common.processor.BeanListProcessor;
import com.univocity.parsers.conversions.Conversions;
import com.univocity.parsers.csv.CsvParser;
import com.univocity.parsers.csv.CsvParserSettings;

public class DynamicDateFormatParser {
    public static void main(String[] args) {
        BeanListProcessor<CsvRecord> rowProcessor = new BeanListProcessor<CsvRecord>(CsvRecord.class);
        rowProcessor.convertIndexes(Conversions.toDate("dd.MM.yyyy")).set(1);

        CsvParserSettings settings = new CsvParserSettings();
        settings.setProcessor(rowProcessor);

        CsvParser parser = new CsvParser(settings);

        parser.parse(new ByteArrayInputStream("foo,31.12.2021,bar".getBytes()));

        List<CsvRecord> allRows = rowProcessor.getBeans();

        // 1 rows
        System.out.println(allRows.size() + " rows");
        
        // Fri Dec 31 00:00:00 CET 2021
        System.out.println(allRows.get(0).field2);
    }

    static class CsvRecord {
        @Parsed(index = 0)
        String field1;

        @Parsed(index = 1)
        Date field2;

        @Parsed(index = 3)
        String field3;
    }
}

Note that this will work only if your date is in the second column !!! Use this instead, if you want to set the column name to be formatted: rowProcessor.convertFields(Conversions.toDate("MM.dd.yyyy")).set("fieldName"); — Bobin, Dec 08 '21 at 14:17

Univocity - how to provide date formats dynamically

1 Answers1