org.sfm.csv

Class CsvParser

java.lang.Object

org.sfm.csv.CsvParser

public final class CsvParser
extends Object

CsvParser provides an fluent DSL to parse or map csv content.

It is possible to customize the quote char, the separator, skip lines,and specified the size of the buffer

CsvParser
.quote('\'')
.separator(';')
.skip(2)
.bufferSize(256)
.stream(new StringReader("1;1\n2;2\n3;3\n4;4\n5;5"))
.map(Arrays::toString)
.forEach(System.out::println);
// output
// [3, 3]
// [4, 4]
// [5, 5]

the limit settings does not affect streams or iterator, only parse on DSL and forEach on the mapTo/mapWith DSL.

The DSL provides way to mapTo an object

CsvParser.mapTo(MyClass.class).stream(reader).forEach(System.out::println);


using static mapping when no headers

CsvParser.mapTo(MyClass.class).addHeaders("id", "field").stream(reader).forEach(System.out::println);
// using the addMapping
CsvParser.mapTo(MyClass.class).addMapping("id").addMapping("field").stream(reader).forEach(System.out::println);


using static mapping and ignoring source header

CsvParser.mapTo(MyClass.class).overrideHeaders("id", "field").stream(reader).forEach(System.out::println);
// using the addMapping
CsvParser.skip(1).mapTo(MyClass.class).addMapping("id").addMapping("field").stream(reader).forEach(System.out::println);


or mapping with a predefined jdbcMapper.

CsvMapper<MyClass> jdbcMapper = CsvMapperFactory.newInstance().newMapper(MyClass.class);
CsvParser.mapWith(jdbcMapper).stream(reader).forEach(System.out::println);


Each call to the DSL return an immutable representation of the current setup. So that it is possible to cache step of the DSL without side effect.

CsvParser.DSL semiColumnParser = CsvParser.separator(';');

try (Reader r = new FileReader(file)) {
// the limit does not modify to the semiColumnParser object
semiColumnParser.limit(3).stream(r);
}

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	CsvParser.DSL DSL for csv parsing.
static class	CsvParser.MapToDSL<T> DSL for csv mapping to a dynamic jdbcMapper.
static class	CsvParser.MapWithDSL<T> DSL for csv mapping to a provided jdbcMapper.
static class	CsvParser.StaticMapToDSL<T> DSL for csv mapping to a static jdbcMapper.

Constructor Summary

Constructors

Constructor and Description
CsvParser()

Method Summary

Modifier and Type	Method and Description
static CsvParser.DSL	bufferSize(int size)
static CsvParser.DSL	dsl()
static Iterator<String[]>	iterator(CharSequence content)
static CloseableIterator<String[]>	iterator(File file)
static Iterator<String[]>	iterator(Reader reader)
static CsvParser.DSL	limit(int limit)
static <T> CsvParser.MapToDSL<T>	mapTo(Class<T> type)
static <T1,T2> CsvParser.MapToDSL<Tuple2<T1,T2>>	mapTo(Class<T1> class1, Class<T2> class2)
static <T1,T2,T3> CsvParser.MapToDSL<Tuple3<T1,T2,T3>>	mapTo(Class<T1> class1, Class<T2> class2, Class<T3> class3)
static <T1,T2,T3,T4> CsvParser.MapToDSL<Tuple4<T1,T2,T3,T4>>	mapTo(Class<T1> class1, Class<T2> class2, Class<T3> class3, Class<T4> class4)
static <T1,T2,T3,T4,T5> CsvParser.MapToDSL<Tuple5<T1,T2,T3,T4,T5>>	mapTo(Class<T1> class1, Class<T2> class2, Class<T3> class3, Class<T4> class4, Class<T5> class5)
static <T1,T2,T3,T4,T5,T6> CsvParser.MapToDSL<Tuple6<T1,T2,T3,T4,T5,T6>>	mapTo(Class<T1> class1, Class<T2> class2, Class<T3> class3, Class<T4> class4, Class<T5> class5, Class<T6> class6)
static <T1,T2,T3,T4,T5,T6,T7> CsvParser.MapToDSL<Tuple7<T1,T2,T3,T4,T5,T6,T7>>	mapTo(Class<T1> class1, Class<T2> class2, Class<T3> class3, Class<T4> class4, Class<T5> class5, Class<T6> class6, Class<T7> class7)
static <T1,T2,T3,T4,T5,T6,T7,T8> CsvParser.MapToDSL<Tuple8<T1,T2,T3,T4,T5,T6,T7,T8>>	mapTo(Class<T1> class1, Class<T2> class2, Class<T3> class3, Class<T4> class4, Class<T5> class5, Class<T6> class6, Class<T7> class7, Class<T8> class8)
static <T> CsvParser.MapToDSL<T>	mapTo(Type type)
static <T> CsvParser.MapToDSL<T>	mapTo(TypeReference<T> type)
static <T> CsvParser.MapWithDSL<T>	mapWith(CsvMapper<T> mapper)
static CsvParser.DSL	maxBufferSize(int size)
static <CC extends CellConsumer> CC	parse(CharSequence content, CC cellConsumer)
static <CC extends CellConsumer> CC	parse(File file, CC cellConsumer)
static <CC extends CellConsumer> CC	parse(Reader reader, CC cellConsumer)
static <CC extends CellConsumer> CC	parse(String content, CC cellConsumer)
static CsvParser.DSL	quote(char c)
static CsvReader	reader(CharSequence content)
static CloseableCsvReader	reader(File file)
static CsvReader	reader(Reader reader)
static CsvReader	reader(String content)
static CsvParser.DSL	separator(char c)
static CsvParser.DSL	skip(int skip)
static Stream<String[]>	stream(File file)
static Stream<String[]>	stream(Reader r)
static Stream<String[]>	stream(String content)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

CsvParser

public CsvParser()

Method Detail

separator

public static CsvParser.DSL separator(char c)

Parameters:

c - the separator char

Returns:

the DSL object

bufferSize

public static CsvParser.DSL bufferSize(int size)

maxBufferSize

public static CsvParser.DSL maxBufferSize(int size)

quote

public static CsvParser.DSL quote(char c)

skip

public static CsvParser.DSL skip(int skip)

dsl

public static CsvParser.DSL dsl()

limit

public static CsvParser.DSL limit(int limit)

mapTo

public static <T> CsvParser.MapToDSL<T> mapTo(Type type)

mapTo

public static <T> CsvParser.MapToDSL<T> mapTo(Class<T> type)

mapTo

public static <T> CsvParser.MapToDSL<T> mapTo(TypeReference<T> type)

mapTo

public static <T1,T2> CsvParser.MapToDSL<Tuple2<T1,T2>> mapTo(Class<T1> class1,
                                                              Class<T2> class2)

mapTo

public static <T1,T2,T3> CsvParser.MapToDSL<Tuple3<T1,T2,T3>> mapTo(Class<T1> class1,
                                                                    Class<T2> class2,
                                                                    Class<T3> class3)

mapTo

public static <T1,T2,T3,T4> CsvParser.MapToDSL<Tuple4<T1,T2,T3,T4>> mapTo(Class<T1> class1,
                                                                          Class<T2> class2,
                                                                          Class<T3> class3,
                                                                          Class<T4> class4)

mapTo

public static <T1,T2,T3,T4,T5> CsvParser.MapToDSL<Tuple5<T1,T2,T3,T4,T5>> mapTo(Class<T1> class1,
                                                                                Class<T2> class2,
                                                                                Class<T3> class3,
                                                                                Class<T4> class4,
                                                                                Class<T5> class5)

mapTo

public static <T1,T2,T3,T4,T5,T6> CsvParser.MapToDSL<Tuple6<T1,T2,T3,T4,T5,T6>> mapTo(Class<T1> class1,
                                                                                      Class<T2> class2,
                                                                                      Class<T3> class3,
                                                                                      Class<T4> class4,
                                                                                      Class<T5> class5,
                                                                                      Class<T6> class6)

mapTo

public static <T1,T2,T3,T4,T5,T6,T7> CsvParser.MapToDSL<Tuple7<T1,T2,T3,T4,T5,T6,T7>> mapTo(Class<T1> class1,
                                                                                            Class<T2> class2,
                                                                                            Class<T3> class3,
                                                                                            Class<T4> class4,
                                                                                            Class<T5> class5,
                                                                                            Class<T6> class6,
                                                                                            Class<T7> class7)

mapTo

public static <T1,T2,T3,T4,T5,T6,T7,T8> CsvParser.MapToDSL<Tuple8<T1,T2,T3,T4,T5,T6,T7,T8>> mapTo(Class<T1> class1,
                                                                                                  Class<T2> class2,
                                                                                                  Class<T3> class3,
                                                                                                  Class<T4> class4,
                                                                                                  Class<T5> class5,
                                                                                                  Class<T6> class6,
                                                                                                  Class<T7> class7,
                                                                                                  Class<T8> class8)

mapWith

public static <T> CsvParser.MapWithDSL<T> mapWith(CsvMapper<T> mapper)

reader

public static CsvReader reader(Reader reader)
                        throws IOException

Parameters:

reader - the reader

Returns:

a csv reader based on the default setup.

Throws:

IOException - if an error occurs reading the data

iterator

public static Iterator<String[]> iterator(Reader reader)
                                   throws IOException

Throws:

IOException

parse

public static <CC extends CellConsumer> CC parse(Reader reader,
                                                 CC cellConsumer)
                                          throws IOException

Throws:

IOException

reader

public static CsvReader reader(CharSequence content)
                        throws IOException

Throws:

IOException

reader

public static CsvReader reader(String content)
                        throws IOException

Throws:

IOException

iterator

public static Iterator<String[]> iterator(CharSequence content)
                                   throws IOException

Throws:

IOException

parse

public static <CC extends CellConsumer> CC parse(CharSequence content,
                                                 CC cellConsumer)
                                          throws IOException

Throws:

IOException

parse

public static <CC extends CellConsumer> CC parse(String content,
                                                 CC cellConsumer)
                                          throws IOException

Throws:

IOException

reader

public static CloseableCsvReader reader(File file)
                                 throws IOException

Throws:

IOException

iterator

public static CloseableIterator<String[]> iterator(File file)
                                            throws IOException

Throws:

IOException

parse

public static <CC extends CellConsumer> CC parse(File file,
                                                 CC cellConsumer)
                                          throws IOException

Throws:

IOException

stream

public static Stream<String[]> stream(Reader r)
                               throws IOException

Throws:

IOException

stream

public static Stream<String[]> stream(File file)
                               throws IOException

Throws:

IOException

stream

public static Stream<String[]> stream(String content)
                               throws IOException

Throws:

IOException