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

    {
        System.out.print("Reading input as "+cls.getName()+" instances: ");
        
        int count = 0;
        CsvMapper mapper = new CsvMapper();
        CsvSchema schema = CsvSchema.builder()
            .setUseHeader(true)
            .build();


        MappingIterator<T> it = mapper.reader(cls)
            .with(schema).readValues(inputFile);

View Full Code Here

    @Override
    public List<ResultType> readFile(File path) throws IOException {
        if (!path.exists()) {
            return Collections.emptyList();
        }
        CsvSchema schema = mapper.schemaFor(resultType);
        try {
            MappingIterator<ResultType> iterator = mapper.reader(schema).withType(resultType)
                .readValues(path);
            return Lists.newArrayList(iterator);
        } catch (IOException e) {

View Full Code Here

        }
    }


    @Override
    public void writeFile(File path, List<ResultType> models) throws IOException {
        CsvSchema schema = mapper.schemaFor(resultType);
        System.out.println(schema.getColumnDesc());
        ObjectWriter writer = mapper.writer(schema);
        // supplying the file directly does not work.
        // java.lang.UnsupportedOperationException: Generator of type com.fasterxml.jackson.core.json.UTF8JsonGenerator
        // does not support schema of type 'CSV'
        writer.writeValue(new FileOutputStream(path), models);

View Full Code Here

import com.google.common.collect.ImmutableMap;


public class TestWriterWithSomeMoreMissingValues extends ModuleTestBase {


    public void testWithAStringAndAUuid() throws JsonProcessingException {
        final CsvSchema schema = new CsvSchema.Builder()
                .addColumn("string1", CsvSchema.ColumnType.STRING)
                .addColumn("string2", CsvSchema.ColumnType.STRING)
                .build();
        final ObjectWriter writer = new CsvMapper().writer().withSchema(schema);

View Full Code Here

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


    public void testWithTwoStringsAndAUuid() throws JsonProcessingException {


        final CsvSchema schema = new CsvSchema.Builder()
                .addColumn("string1", CsvSchema.ColumnType.STRING)
                .addColumn("string2", CsvSchema.ColumnType.STRING)
                .addColumn("string3", CsvSchema.ColumnType.STRING)
                .build();
        final ObjectWriter writer = new CsvMapper().writer().withSchema(schema);

View Full Code Here

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


    public void testWithANullAStringAndAUuid() throws JsonProcessingException {


        final CsvSchema schema = new CsvSchema.Builder()
                .addColumn("string1", CsvSchema.ColumnType.STRING)
                .addColumn("string2", CsvSchema.ColumnType.STRING)
                .addColumn("string3", CsvSchema.ColumnType.STRING)
                .build();
        final ObjectWriter writer = new CsvMapper().writer().withSchema(schema);

View Full Code Here

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


    public void testWithAStringANullAndAUuid() throws JsonProcessingException {


        final CsvSchema schema = new CsvSchema.Builder()
                .addColumn("string1", CsvSchema.ColumnType.STRING)
                .addColumn("string2", CsvSchema.ColumnType.STRING)
                .addColumn("string3", CsvSchema.ColumnType.STRING)
                .build();
        final ObjectWriter writer = new CsvMapper().writer().withSchema(schema);

View Full Code Here

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


    public void testWithThreeStringsAndAUuid() 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,dear,world,\"2a36b911-9699-45d2-abd5-b9f2d2c9c4a3\"\n", csv);
    }


    public void testWithANullAStringAStringAndAUuid() 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 testWithAStringANullAStringAndAUuid() 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

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.