Examples of com.fasterxml.jackson.dataformat.csv.CsvSchema

Package com.fasterxml.jackson.dataformat.csv

Examples of com.fasterxml.jackson.dataformat.csv.CsvSchema

com.fasterxml.jackson.dataformat.csv.CsvSchema
Simple {@link FormatSchema} sub-type that defines properties ofa CSV document to read or write. Properties supported currently are:
- columns (List of ColumnDef) [default: empty List]: Ordered list of columns (which may be empty, see below). Each column has name (mandatory) as well as type (optional; if not defined, defaults to "String"). Note that
- useHeader (boolean) [default: false]: whether the first line of physical document defines column names (true) or not (false): if enabled, parser will take first-line values to define column names; and generator will output column names as the first line
- quoteChar (char) [default: double-quote ('")]: character used for quoting values that contain quote characters or linefeeds.
- columnSeparator (char) [default: comma (',')]: character used to separate values. Other commonly used values include tab ('\t') and pipe ('|')
- lineSeparator (String) [default: "\n"]: character used to separate data rows. Only used by generator; parser accepts three standard linefeeds ("\r", "\r\n", "\n").
- escapeChar (int) [default: -1 meaning "none"]: character, if any, used to escape values. Most commonly defined as backslash ('\'). Only used by parser; generator only uses quoting, including doubling up of quotes to indicate quote char itself.
- skipFirstDataRow (boolean) [default: false]: whether the first data line (either first line of the document, if useHeader=false, or second, if useHeader=true) should be completely ignored by parser. Needed to support CSV-like file formats that include additional non-data content before real data begins (specifically some database dumps do this)
Note that schemas without any columns are legal, but if no columns are added, behavior of parser/generator is usually different and content will be exposed as logical Arrays instead of Objects.
There are 4 ways to create CsvSchema instances:
- Manually build one, using {@link Builder}
- Modify existing schema (using withXxx methods or {@link #rebuild} for creating {@link Builder})
- Create schema based on a POJO definition (Class), using {@link CsvMapper} methods like {@link CsvMapper#schemaFor(java.lang.Class)}.
- Request that {@link CsvParser} reads schema from the first line:enable "useHeader" property for the initial schema, and let parser read column names from the document itself.
@since 1.9

        assertEquals("hello,,world,\"2a36b911-9699-45d2-abd5-b9f2d2c9c4a3\"\n", csv);
    }


    public void testWithTwoStringsANullAndAUuid() throws JsonProcessingException {


        final CsvSchema schema = new CsvSchema.Builder()
                .addColumn("string1", CsvSchema.ColumnType.STRING)
                .addColumn("string2", CsvSchema.ColumnType.STRING)
                .addColumn("string3", CsvSchema.ColumnType.STRING)
                .addColumn("string4", CsvSchema.ColumnType.STRING)
                .build();

View Full Code Here

        assertEquals("hello,world,,\"2a36b911-9699-45d2-abd5-b9f2d2c9c4a3\"\n", csv);
    }


    public void testWithTwoStringsANullAndAString() throws JsonProcessingException {


        final CsvSchema schema = new CsvSchema.Builder()
                .addColumn("string1", CsvSchema.ColumnType.STRING)
                .addColumn("string2", CsvSchema.ColumnType.STRING)
                .addColumn("string3", CsvSchema.ColumnType.STRING)
                .addColumn("string4", CsvSchema.ColumnType.STRING)
                .build();

View Full Code Here

    public void testWriteNullThirdColumn() throws JsonProcessingException {
        final CsvSchema.Builder csvSchemaBuilder = new CsvSchema.Builder();
        csvSchemaBuilder.addColumn("timestamp", CsvSchema.ColumnType.STRING);
        csvSchemaBuilder.addColumn("value", CsvSchema.ColumnType.NUMBER);
        csvSchemaBuilder.addColumn("id", CsvSchema.ColumnType.STRING);
        final CsvSchema schema = csvSchemaBuilder.build();
        final ObjectWriter writer = new CsvMapper().writer().withSchema(schema);


        final String string = writer.writeValueAsString(
                ImmutableMap.of("timestamp", 0L, "value", 42));
        assertEquals("0,42,\n", string);

View Full Code Here

0 1

TOP

Related Classes of com.fasterxml.jackson.dataformat.csv.CsvSchema

com.fasterxml.jackson.dataformat.csv.TestWriterWithSomeMoreMissingValues

org.openengsb.connector.virtual.filewatcher.internal.CSVParser

perf.F5500Reader

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.