Package org.h2gis.functions.io.tsv

Class TSVDriverFunction

java.lang.Object
org.h2gis.functions.io.tsv.TSVDriverFunction
All Implemented Interfaces:
org.h2gis.api.DriverFunction
public class TSVDriverFunction extends Object implements org.h2gis.api.DriverFunction
This driver allow to import and export the Tab Separated Values (TSV): a format for tabular data exchange A file in TSV format consists of lines. Each line contain fields separated from each other by TAB characters (horizontal tab, HT, Ascii control code 9). "Field" means here just any string of characters, excluding TABs. The point is simply that TABs divide a line into pieces, components. Each line must contain the same number of fields. The first line contains the names for the fields (on all lines), i.e. column headers. Please read : http://www.cs.tut.fi/~jkorpela/TSV.html
Author:
Erwan Bocher, Sylvain PALOMINOS (UBS 2019)

  • Field Details

    • DESCRIPTION

      public static String DESCRIPTION

  • Constructor Details

    • TSVDriverFunction

      public TSVDriverFunction()

  • Method Details

    • getImportDriverType

      public org.h2gis.api.DriverFunction.IMPORT_DRIVER_TYPE getImportDriverType()
      Specified by:
      getImportDriverType in interface org.h2gis.api.DriverFunction

    • getImportFormats

      public String[] getImportFormats()
      Specified by:
      getImportFormats in interface org.h2gis.api.DriverFunction

    • getExportFormats

      public String[] getExportFormats()
      Specified by:
      getExportFormats in interface org.h2gis.api.DriverFunction

    • getFormatDescription

      public String getFormatDescription(String format)
      Specified by:
      getFormatDescription in interface org.h2gis.api.DriverFunction

    • isSpatialFormat

      public boolean isSpatialFormat(String extension)
      Specified by:
      isSpatialFormat in interface org.h2gis.api.DriverFunction

    • exportTable

      public String[] exportTable(Connection connection, String tableReference, File fileName, org.h2gis.api.ProgressVisitor progress) throws SQLException, IOException
      Specified by:
      exportTable in interface org.h2gis.api.DriverFunction
      Throws:
      SQLException
      IOException

    • exportTable

      public String[] exportTable(Connection connection, String tableReference, File fileName, boolean deleteFiles, org.h2gis.api.ProgressVisitor progress) throws SQLException, IOException
      Specified by:
      exportTable in interface org.h2gis.api.DriverFunction
      Throws:
      SQLException
      IOException

    • exportTable

      public String[] exportTable(Connection connection, String tableReference, File fileName, String encoding, boolean deleteFiles, org.h2gis.api.ProgressVisitor progress) throws SQLException, IOException
      Specified by:
      exportTable in interface org.h2gis.api.DriverFunction
      Throws:
      SQLException
      IOException

    • exportTable

      public String[] exportTable(Connection connection, String tableReference, File fileName, String encoding, org.h2gis.api.ProgressVisitor progress) throws SQLException, IOException
      Export a table or a query to as TSV file
      Specified by:
      exportTable in interface org.h2gis.api.DriverFunction
      Parameters:
      connection - Active connection, do not close this connection.
      tableReference - [[catalog.]schema.]table reference
      fileName - File path to read
      progress -
      encoding -
      Throws:
      SQLException
      IOException

    • exportFromResultSet

      public void exportFromResultSet(Connection connection, ResultSet res, Writer writer, String encoding, org.h2gis.api.ProgressVisitor progress) throws SQLException
      Export a resultset to a TSV file
      Parameters:
      connection -
      res -
      writer -
      progress -
      encoding -
      Throws:
      SQLException

    • importFile

      public String[] importFile(Connection connection, String tableReference, File fileName, org.h2gis.api.ProgressVisitor progress) throws SQLException, IOException
      Specified by:
      importFile in interface org.h2gis.api.DriverFunction
      Throws:
      SQLException
      IOException

    • importFile

      public String[] importFile(Connection connection, String tableReference, File fileName, String options, org.h2gis.api.ProgressVisitor progress) throws SQLException, IOException
      Specified by:
      importFile in interface org.h2gis.api.DriverFunction
      Throws:
      SQLException
      IOException

    • importFile

      public String[] importFile(Connection connection, String tableReference, File fileName, boolean deleteTables, org.h2gis.api.ProgressVisitor progress) throws SQLException, IOException
      Specified by:
      importFile in interface org.h2gis.api.DriverFunction
      Throws:
      SQLException
      IOException

    • importFile

      public String[] importFile(Connection connection, String tableReference, File fileName, String options, boolean deleteTables, org.h2gis.api.ProgressVisitor progress) throws SQLException, IOException
      Specified by:
      importFile in interface org.h2gis.api.DriverFunction
      Throws:
      SQLException
      IOException