package com.opencsv.bean;

/*
 Copyright 2007 Kyle Miller.

 Licensed under the Apache License, Version 2.0 (the "License");
 you may not use this file except in compliance with the License.
 You may obtain a copy of the License at

 http://www.apache.org/licenses/LICENSE-2.0

 Unless required by applicable law or agreed to in writing, software
 distributed under the License is distributed on an "AS IS" BASIS,
 WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 See the License for the specific language governing permissions and
 limitations under the License.
 */

import com.opencsv.CSVReader;
import com.opencsv.ICSVParser;
import com.opencsv.bean.concurrent.CompleteFileReader;
import com.opencsv.bean.concurrent.LineExecutor;
import com.opencsv.bean.concurrent.ProcessCsvLine;
import com.opencsv.bean.concurrent.SingleLineReader;
import com.opencsv.bean.exceptionhandler.CsvExceptionHandler;
import com.opencsv.bean.exceptionhandler.ExceptionHandlerQueue;
import com.opencsv.bean.exceptionhandler.ExceptionHandlerThrow;
import com.opencsv.bean.util.OrderedObject;
import com.opencsv.exceptions.CsvException;
import com.opencsv.exceptions.CsvValidationException;
import org.apache.commons.lang3.ObjectUtils;

import java.io.IOException;
import java.util.*;
import java.util.concurrent.ArrayBlockingQueue;
import java.util.concurrent.BlockingQueue;
import java.util.stream.Collectors;
import java.util.stream.Stream;
import java.util.stream.StreamSupport;

Converts CSV data to objects. Mixing the parse() method with the Iterator is not supported and will lead to unpredictable results. Additionally, reusing an instance of this class after all beans have been read is not supported and will certainly break something.
Type parameters:
  • <T> – Class to convert the objects to.
/** * Converts CSV data to objects. * Mixing the {@link #parse()} method with the {@link #iterator() Iterator} is * not supported and will lead to unpredictable results. Additionally, reusing * an instance of this class after all beans have been read is not supported * and will certainly break something. * * @param <T> Class to convert the objects to. */
public class CsvToBean<T> implements Iterable<T> {
A list of all exceptions during parsing and mapping of the input.
/** A list of all exceptions during parsing and mapping of the input. */
private final List<CsvException> capturedExceptions = new LinkedList<>();
The mapping strategy to be used by this CsvToBean.
/** The mapping strategy to be used by this CsvToBean. */
private MappingStrategy<? extends T> mappingStrategy;
The reader this class will use to access the data to be read.
/** The reader this class will use to access the data to be read. */
private CSVReader csvReader;
The filter this class will use on the beans it reads.
/** The filter this class will use on the beans it reads. */
private CsvToBeanFilter filter = null;
Determines how exceptions thrown during processing will be handled.
/** * Determines how exceptions thrown during processing will be handled. */
private CsvExceptionHandler exceptionHandler = new ExceptionHandlerThrow();
Determines whether resulting data sets have to be in the same order as the input.
/** * Determines whether resulting data sets have to be in the same order as * the input. */
private boolean orderedResults = true;
The ExecutorService for parallel processing of beans.
/** * The {@link java.util.concurrent.ExecutorService} for parallel processing * of beans. */
private LineExecutor<T> executor;
The errorLocale for error messages.
/** * The errorLocale for error messages. */
private Locale errorLocale = Locale.getDefault();
All verifiers that should be run on beans after creation but before returning them to the caller.
/** * All verifiers that should be run on beans after creation but before * returning them to the caller. */
private List<BeanVerifier<T>> verifiers = Collections.<BeanVerifier<T>>emptyList();
When an empty line is encountered (not part of the data) then it is ignored. By default this is false, which means an exception is thrown if there are required fields or the number of fields do not match the number of headers.
/** * When an empty line is encountered (not part of the data) then it is * ignored. * By default this is {@code false}, which means an exception is thrown if * there are required fields or the number of fields do not match the * number of headers. */
private boolean ignoreEmptyLines = false;
Default constructor.
/** * Default constructor. */
public CsvToBean() { }
Parses the input based on parameters already set through other methods.
Throws:
See Also:
Returns:A list of populated beans based on the input
/** * Parses the input based on parameters already set through other methods. * * @return A list of populated beans based on the input * @throws IllegalStateException If either MappingStrategy or CSVReader is * not specified * @see #stream() * @see #iterator() */
public List<T> parse() throws IllegalStateException { return stream().collect(Collectors.toList()); }
Parses the input based on parameters already set through other methods. This method saves a marginal amount of time and storage compared to parse() because it avoids the intermediate storage of the results in a List. If you plan on further processing the results as a Stream, use this method.
Throws:
See Also:
Returns:A stream of populated beans based on the input
/** * Parses the input based on parameters already set through other methods. * This method saves a marginal amount of time and storage compared to * {@link #parse()} because it avoids the intermediate storage of the * results in a {@link java.util.List}. If you plan on further processing * the results as a {@link java.util.stream.Stream}, use this method. * * @return A stream of populated beans based on the input * @throws IllegalStateException If either MappingStrategy or CSVReader is * not specified * @see #parse() * @see #iterator() */
public Stream<T> stream() throws IllegalStateException { prepareToReadInput(); CompleteFileReader<T> completeFileReader = new CompleteFileReader<>( csvReader, filter, ignoreEmptyLines, mappingStrategy, exceptionHandler, verifiers); executor = new LineExecutor<T>(orderedResults, errorLocale, completeFileReader); executor.prepare(); return StreamSupport.stream(executor, false); }
Returns the list of all exceptions that would have been thrown during the import, but were queued by the exception handler.
See Also:
Returns:The list of exceptions captured while processing the input file
/** * Returns the list of all exceptions that would have been thrown during the * import, but were queued by the exception handler. * * @return The list of exceptions captured while processing the input file * @see #setExceptionHandler(CsvExceptionHandler) * @see #setThrowExceptions(boolean) */
public List<CsvException> getCapturedExceptions() { // The exceptions are stored in different places, dependent on // whether or not the iterator is used. return executor != null ? executor.getCapturedExceptions() : capturedExceptions; }
Sets the mapping strategy to be used by this bean.
Params:
  • mappingStrategy – Mapping strategy to convert CSV input to a bean
/** * Sets the mapping strategy to be used by this bean. * @param mappingStrategy Mapping strategy to convert CSV input to a bean */
public void setMappingStrategy(MappingStrategy<? extends T> mappingStrategy) { this.mappingStrategy = mappingStrategy; }
Sets the reader to be used to read in the information from the CSV input.
Params:
  • csvReader – Reader for input
/** * Sets the reader to be used to read in the information from the CSV input. * @param csvReader Reader for input */
public void setCsvReader(CSVReader csvReader) { this.csvReader = csvReader; }
Sets a filter to selectively remove some lines of input before they become beans.
Params:
  • filter – A class that filters the input lines
/** * Sets a filter to selectively remove some lines of input before they * become beans. * @param filter A class that filters the input lines */
public void setFilter(CsvToBeanFilter filter) { this.filter = filter; }
Determines whether errors during import should be thrown or kept in a list for later retrieval via getCapturedExceptions().

This is a convenience function and is maintained for backwards compatibility. Passing in true is equivalent to setExceptionHandler(new ExceptionHandlerThrow()) and false is equivalent to setExceptionHandler(new ExceptionHandlerQueue())

Please note that if both this method and setExceptionHandler(CsvExceptionHandler) are called, the last call wins.

Params:
  • throwExceptions – Whether or not to throw exceptions during processing
See Also:
/** * Determines whether errors during import should be thrown or kept in a * list for later retrieval via {@link #getCapturedExceptions()}. * <p>This is a convenience function and is maintained for backwards * compatibility. Passing in {@code true} is equivalent to * {@code setExceptionHandler(new ExceptionHandlerThrow())} * and {@code false} is equivalent to * {@code setExceptionHandler(new ExceptionHandlerQueue())}</p> * <p>Please note that if both this method and * {@link #setExceptionHandler(CsvExceptionHandler)} are called, * the last call wins.</p> * * @param throwExceptions Whether or not to throw exceptions during * processing * @see #setExceptionHandler(CsvExceptionHandler) */
public void setThrowExceptions(boolean throwExceptions) { if(throwExceptions) { exceptionHandler = new ExceptionHandlerThrow(); } else { exceptionHandler = new ExceptionHandlerQueue(); } }
Sets the handler for recoverable exceptions raised during processing of records.

If neither this method nor setThrowExceptions(boolean) is called, the default exception handler is ExceptionHandlerThrow.

Please note that if both this method and setThrowExceptions(boolean) are called, the last call wins.

Params:
  • handler – The exception handler to be used. If null, this method does nothing.
Since:5.2
/** * Sets the handler for recoverable exceptions raised during processing of * records. * <p>If neither this method nor {@link #setThrowExceptions(boolean)} is * called, the default exception handler is * {@link ExceptionHandlerThrow}.</p> * <p>Please note that if both this method and * {@link #setThrowExceptions(boolean)} are called, the last call wins.</p> * * @param handler The exception handler to be used. If {@code null}, * this method does nothing. * @since 5.2 */
public void setExceptionHandler(CsvExceptionHandler handler) { if(handler != null) { exceptionHandler = handler; } }
Sets whether or not results must be returned in the same order in which they appear in the input. The default is that order is preserved. If your data do not need to be ordered, you can get a slight performance boost by setting orderedResults to false. The lack of ordering then also applies to any captured exceptions, if you have chosen not to have exceptions thrown.
Params:
  • orderedResults – Whether or not the beans returned are in the same order they appeared in the input
Since:4.0
/** * Sets whether or not results must be returned in the same order in which * they appear in the input. * The default is that order is preserved. If your data do not need to be * ordered, you can get a slight performance boost by setting * {@code orderedResults} to {@code false}. The lack of ordering then also * applies to any captured exceptions, if you have chosen not to have * exceptions thrown. * @param orderedResults Whether or not the beans returned are in the same * order they appeared in the input * @since 4.0 */
public void setOrderedResults(boolean orderedResults) { this.orderedResults = orderedResults; }
Sets the locale for error messages.
Params:
  • errorLocale – Locale for error messages. If null, the default locale is used.
Since:4.0
/** * Sets the locale for error messages. * @param errorLocale Locale for error messages. If null, the default locale * is used. * @since 4.0 */
public void setErrorLocale(Locale errorLocale) { this.errorLocale = ObjectUtils.defaultIfNull(errorLocale, Locale.getDefault()); if(csvReader != null) { csvReader.setErrorLocale(this.errorLocale); } if(mappingStrategy != null) { mappingStrategy.setErrorLocale(this.errorLocale); } }
Sets the list of verifiers to be run on all beans after creation.
Params:
  • verifiers – A list of verifiers. May be null, in which case, no verifiers are run.
Since:4.4
/** * Sets the list of verifiers to be run on all beans after creation. * * @param verifiers A list of verifiers. May be {@code null}, in which * case, no verifiers are run. * @since 4.4 */
public void setVerifiers(List<BeanVerifier<T>> verifiers) { this.verifiers = ObjectUtils.defaultIfNull(verifiers, Collections.<BeanVerifier<T>>emptyList()); } private void prepareToReadInput() throws IllegalStateException { // First verify that the user hasn't failed to give us the information // we need to do his or her work for him or her. if(mappingStrategy == null || csvReader == null) { throw new IllegalStateException(ResourceBundle.getBundle(ICSVParser.DEFAULT_BUNDLE_NAME, errorLocale).getString("specify.strategy.reader")); } // Get the header information try { mappingStrategy.captureHeader(csvReader); } catch (Exception e) { throw new RuntimeException(ResourceBundle.getBundle(ICSVParser.DEFAULT_BUNDLE_NAME, errorLocale).getString("header.error"), e); } }
The iterator returned by this method takes one line of input at a time and returns one bean at a time.

The advantage to this method is saving memory. The cost is the loss of parallel processing, reducing throughput.

The iterator respects all aspects of CsvToBean, including filters and capturing exceptions.

See Also:
Returns:An iterator over the beans created from the input
/** * The iterator returned by this method takes one line of input at a time * and returns one bean at a time. * <p>The advantage to this method is saving memory. The cost is the loss of * parallel processing, reducing throughput.</p> * <p>The iterator respects all aspects of {@link CsvToBean}, including * filters and capturing exceptions.</p> * @return An iterator over the beans created from the input * @see #parse() * @see #stream() */
@Override public Iterator<T> iterator() { prepareToReadInput(); return new CsvToBeanIterator(); }
Ignores any blank lines in the data that are not part of a field.
Params:
  • ignoreEmptyLines – true to ignore empty lines, false otherwise
/** * Ignores any blank lines in the data that are not part of a field. * * @param ignoreEmptyLines {@code true} to ignore empty lines, {@code false} otherwise */
public void setIgnoreEmptyLines(boolean ignoreEmptyLines) { this.ignoreEmptyLines = ignoreEmptyLines; }
A private inner class for implementing an iterator for the input data.
/** * A private inner class for implementing an iterator for the input data. */
private class CsvToBeanIterator implements Iterator<T> { private BlockingQueue<OrderedObject<T>> resultantBeansQueue; private BlockingQueue<OrderedObject<CsvException>> thrownExceptionsQueue; private final SingleLineReader lineReader = new SingleLineReader(csvReader, ignoreEmptyLines); private String[] line = null; private long lineProcessed = 0; private T bean; CsvToBeanIterator() { resultantBeansQueue = new ArrayBlockingQueue<>(1); thrownExceptionsQueue = new ArrayBlockingQueue<>(1); readSingleLine(); } private void processException() { // An exception was thrown OrderedObject<CsvException> o = thrownExceptionsQueue.poll(); if(o != null && o.getElement() != null) { capturedExceptions.add(o.getElement()); } } private void readLineWithPossibleError() throws IOException, CsvValidationException { // Read a line bean = null; while(bean == null && null != (line = lineReader.readNextLine())) { lineProcessed = lineReader.getLinesRead(); // Create a bean ProcessCsvLine<T> proc = new ProcessCsvLine<>( lineProcessed, mappingStrategy, filter, verifiers, line, resultantBeansQueue, thrownExceptionsQueue, new TreeSet<>(), exceptionHandler); proc.run(); if (!thrownExceptionsQueue.isEmpty()) { processException(); } else { // No exception, so there really must always be a bean // . . . unless it was filtered OrderedObject<T> o = resultantBeansQueue.poll(); bean = o==null?null:o.getElement(); } } if(line == null) { // There isn't any more bean = null; } } private void readSingleLine() { try { readLineWithPossibleError(); } catch (IOException | CsvValidationException e) { line = null; throw new RuntimeException(String.format(ResourceBundle.getBundle(ICSVParser.DEFAULT_BUNDLE_NAME, errorLocale).getString("parsing.error"), lineProcessed, Arrays.toString(line)), e); } } @Override public boolean hasNext() { return bean != null; } @Override public T next() { if(bean == null) { throw new NoSuchElementException(); } T intermediateBean = bean; readSingleLine(); return intermediateBean; } @Override public void remove() { throw new UnsupportedOperationException(ResourceBundle .getBundle(ICSVParser.DEFAULT_BUNDLE_NAME, errorLocale) .getString("read.only.iterator")); } } }