package org.djutils.data.csv; import java.io.FileReader; import java.io.FileWriter; import java.io.IOException; import java.io.Reader; import java.io.Writer; import org.djutils.data.DataTable; import org.djutils.data.serialization.TextSerializationException; import com.opencsv.ICSVWriter; import com.opencsv.exceptions.CsvValidationException; /** * TSVData takes care of reading and writing of table data in Tab-Separated-Value format. The class can be used, e.g., as * follows: * *
 * DataTable dataTable = new ListDataTable("data", "dataTable", columns);
 * Writer writer = new FileWriter("c:/data/data.tsv");
 * Writer metaWriter = new FileWriter("c:/data/data.meta.tsv");
 * TSVData.writeData(writer, metaWriter, dataTable);
 * 
* * Copyright (c) 2020-2020 Delft University of Technology, Jaffalaan 5, 2628 BX Delft, the Netherlands. All rights reserved. See * for project information https://djutils.org. The DJUTILS project is * distributed under a three-clause BSD-style license, which can be found at * https://djutils.org/docs/license.html.
* @author Alexander Verbraeck * @author Peter Knoppers * @author Wouter Schakel */ public final class TSVData { /** * Utility class, no public constructor. */ private TSVData() { // utility class } /** * Write the data from the data table in TSV format. The writer writes the data, whereas the metaWriter writes the metadata. * The metadata consists of a TSV file with three columns: the id, the description, and the class. The first row after the * header contains the id, description, and class of the data table itself. The second and further rows contain information * about the columns of the data table. The writers are closed after finishing the writing of the data. * @param writer Writer; the writer that writes the data, e.g. to a file * @param metaWriter Writer; the writer for the metadata * @param dataTable the data table to write * @throws IOException on I/O error when writing the data * @throws TextSerializationException on unknown data type for serialization */ public static void writeData(final Writer writer, final Writer metaWriter, final DataTable dataTable) throws IOException, TextSerializationException { CSVData.writeData(writer, metaWriter, dataTable, '\t', '\u0000', '\\', ICSVWriter.DEFAULT_LINE_END); } /** * Write the data from the data table in TSV format. * @param filename String; the file name to write the data to * @param metaFilename String; the file name to write the metadata to * @param dataTable the data table to write * @throws IOException on I/O error when writing the data * @throws TextSerializationException on unknown data type for serialization */ public static void writeData(final String filename, final String metaFilename, final DataTable dataTable) throws IOException, TextSerializationException { writeData(new FileWriter(filename), new FileWriter(metaFilename), dataTable); } /** * Read the data from the tsv-file into the data table. Use the metadata to reconstruct the data table. * @param reader Reader; the reader that can read the data, e.g. from a file * @param metaReader Reader; the writer for the metadata * @return dataTable the data table reconstructed from the meta data and filled with the data * @throws IOException on I/O error when reading the data * @throws CsvValidationException when the TSV data was not formatted right * @throws TextSerializationException on unknown data type for serialization */ public static DataTable readData(final Reader reader, final Reader metaReader) throws IOException, CsvValidationException, TextSerializationException { return CSVData.readData(reader, metaReader, '\t', '\u0000', '\\', ICSVWriter.DEFAULT_LINE_END); } /** * Read the data from the tsv-file into the data table. Use the metadata to reconstruct the data table. * @param filename String; the file name to read the data from * @param metaFilename String; the file name to read the metadata from * @return dataTable the data table reconstructed from the meta data and filled with the data * @throws IOException on I/O error when reading the data * @throws CsvValidationException when the TSV data was not formatted right * @throws TextSerializationException on unknown data type for serialization */ public static DataTable readData(final String filename, final String metaFilename) throws IOException, CsvValidationException, TextSerializationException { return readData(new FileReader(filename), new FileReader(metaFilename)); } }