Module io.ebean.api

Interface CsvReader<T>

Type Parameters:
T - the entity bean type

public interface CsvReader<T>
Reads CSV data turning it into object graphs that you can be saved (inserted) or processed yourself.

This first example doesn't use a CsvCallback and this means it will automatically create a transaction, save the customers and commit the transaction when successful.


 try {
   File f = new File("src/test/resources/test1.csv");

   FileReader reader = new FileReader(f, encoding);

   CsvReader<Customer> csvReader = DB.createCsvReader(Customer.class);

   csvReader.setPersistBatchSize(20);

   csvReader.addProperty("status");
   // ignore the next property
   csvReader.addIgnore();
   csvReader.addProperty("name");
   csvReader.addDateTime("anniversary", "dd-MMM-yyyy");
   csvReader.addProperty("billingAddress.line1");
   csvReader.addProperty("billingAddress.city");

   csvReader.process(reader);

 } catch (Exception e) {
   throw new RuntimeException(e);
 }
 
  • Method Summary

    Modifier and Type
    Method
    Description
    void
    addDateTime(String propertyName, String dateTimeFormat)
    Add a property with a custom Date/Time/Timestamp format using the default Locale.
    void
    addDateTime(String propertyName, String dateTimeFormat, Locale locale)
    Add a property with a custom Date/Time/Timestamp format.
    void
    Ignore the next column of data.
    void
    addProperty(String propertyName)
    Define the property which will be loaded from the next column of data.
    void
    addProperty(String propertyName, StringParser parser)
    Define the next property and use a custom StringParser to convert the string content into the appropriate type for the property.
    void
    process(Reader reader)
    Automatically create a transaction if required to process all the CSV content from the reader.
    void
    process(Reader reader, CsvCallback<T> callback)
    Process the CSV content passing the bean to the CsvCallback after each row.
    void
    Same as setHasHeader(true,true);
    void
    setDefaultDateFormat(String defaultDateFormat)
    Set the default format to use for Date types.
    void
    setDefaultLocale(Locale defaultLocale)
    Explicitly set the default Locale.
    void
    setDefaultTimeFormat(String defaultTimeFormat)
    Set the default format to use for Time types.
    void
    setDefaultTimestampFormat(String defaultTimestampFormat)
    Set the default format to use for Timestamp types.
    void
    setHasHeader(boolean hasHeader, boolean addPropertiesFromHeader)
    Set to true if there is a header row that should be ignored.
    void
    Same as setHasHeader(true, false);
    void
    setLogInfoFrequency(int logInfoFrequency)
    Set the frequency with which a INFO message will be logged showing the progress of the processing.
    void
    setPersistBatchSize(int persistBatchSize)
    Set the batch size for using JDBC statement batching.
  • Method Details

    • setDefaultLocale

      void setDefaultLocale(Locale defaultLocale)
      Explicitly set the default Locale.
    • setDefaultTimeFormat

      void setDefaultTimeFormat(String defaultTimeFormat)
      Set the default format to use for Time types.
    • setDefaultDateFormat

      void setDefaultDateFormat(String defaultDateFormat)
      Set the default format to use for Date types.
    • setDefaultTimestampFormat

      void setDefaultTimestampFormat(String defaultTimestampFormat)
      Set the default format to use for Timestamp types.
    • setPersistBatchSize

      void setPersistBatchSize(int persistBatchSize)
      Set the batch size for using JDBC statement batching.

      By default this is set to 20 and setting this to 1 will disable the use of JDBC statement batching.

    • setHasHeader

      void setHasHeader(boolean hasHeader, boolean addPropertiesFromHeader)
      Set to true if there is a header row that should be ignored.

      If addPropertiesFromHeader is true then all the properties are added using the default time,date and timestamp formats.

      If you have a mix of dateTime formats you can not use this method and must add the properties yourself.

    • setAddPropertiesFromHeader

      void setAddPropertiesFromHeader()
      Same as setHasHeader(true,true);

      This will use a header to define all the properties to load using the default formats for time, date and datetime types.

    • setIgnoreHeader

      void setIgnoreHeader()
      Same as setHasHeader(true, false);

      This indicates that there is a header but that it should be ignored.

    • setLogInfoFrequency

      void setLogInfoFrequency(int logInfoFrequency)
      Set the frequency with which a INFO message will be logged showing the progress of the processing. You might set this to 1000 or 10000 etc.

      If this is not set then no INFO messages will be logged.

    • addIgnore

      void addIgnore()
      Ignore the next column of data.
    • addProperty

      void addProperty(String propertyName)
      Define the property which will be loaded from the next column of data.

      This takes into account the data type of the property and handles the String to object conversion automatically.

    • addProperty

      void addProperty(String propertyName, StringParser parser)
      Define the next property and use a custom StringParser to convert the string content into the appropriate type for the property.
    • addDateTime

      void addDateTime(String propertyName, String dateTimeFormat)
      Add a property with a custom Date/Time/Timestamp format using the default Locale. This will convert the string into the appropriate java type for the given property (Date, Calendar, SQL Date, Time, Timestamp, JODA etc).
    • addDateTime

      void addDateTime(String propertyName, String dateTimeFormat, Locale locale)
      Add a property with a custom Date/Time/Timestamp format. This will convert the string into the appropriate java type for the given property (Date, Calendar, SQL Date, Time, Timestamp, JODA etc).
    • process

      void process(Reader reader) throws Exception
      Automatically create a transaction if required to process all the CSV content from the reader.

      This will check for a current transaction. If there is no current transaction then one is started and will commit (or rollback) at the end of processing. This will also set the persistBatchSize on the transaction.

      Throws:
      Exception
    • process

      void process(Reader reader, CsvCallback<T> callback) throws Exception
      Process the CSV content passing the bean to the CsvCallback after each row.

      This provides you with the ability to modify and process the bean.

      When using a CsvCallback the reader WILL NOT create a transaction or save the bean(s) for you. If you want to insert the processed beans you must create your own transaction and save the bean(s) yourself.

      Throws:
      Exception