org.h2gis.functions.io.csv

Class CSVDriverFunction

java.lang.Object

org.h2gis.functions.io.csv.CSVDriverFunction

All Implemented Interfaces:

org.h2gis.api.DriverFunction

public class CSVDriverFunction
extends Object
implements org.h2gis.api.DriverFunction

Basic CSV importer and exporter

Author:

Erwan Bocher, Sylvain PALOMINOS (UBS 2019)

Nested Class Summary

Nested classes/interfaces inherited from interface org.h2gis.api.DriverFunction

org.h2gis.api.DriverFunction.IMPORT_DRIVER_TYPE

Field Summary

Fields

Modifier and Type	Field and Description
static String	DESCRIPTION

Constructor Summary

Constructors

Constructor and Description
CSVDriverFunction()

Method Summary

Modifier and Type	Method and Description
void	exportTable(Connection connection, String tableReference, File fileName, org.h2gis.api.ProgressVisitor progress)
void	exportTable(Connection connection, String tableReference, File fileName, org.h2gis.api.ProgressVisitor progress, String csvOptions) Export a table or a query to a CSV file
String[]	getExportFormats()
String	getFormatDescription(String format)
org.h2gis.api.DriverFunction.IMPORT_DRIVER_TYPE	getImportDriverType()
String[]	getImportFormats()
void	importFile(Connection connection, String tableReference, File fileName, org.h2gis.api.ProgressVisitor progress)
void	importFile(Connection connection, String tableReference, File fileName, org.h2gis.api.ProgressVisitor progress, boolean deleteTables)
void	importFile(Connection connection, String tableReference, File fileName, org.h2gis.api.ProgressVisitor progress, String csvOptions)
boolean	isSpatialFormat(String extension)

Methods inherited from class java.lang.Object

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

Field Detail

DESCRIPTION

public static String DESCRIPTION

Constructor Detail

CSVDriverFunction

public CSVDriverFunction()

Method Detail

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 void 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 void exportTable(Connection connection,
                        String tableReference,
                        File fileName,
                        org.h2gis.api.ProgressVisitor progress,
                        String csvOptions)
                 throws SQLException,
                        IOException

Export a table or a query to a CSV 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 -

csvOptions - the CSV options ie "charset=UTF-8 fieldSeparator=| fieldDelimiter=,"

Throws:

SQLException

IOException

importFile

public void 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 void importFile(Connection connection,
                       String tableReference,
                       File fileName,
                       org.h2gis.api.ProgressVisitor progress,
                       String csvOptions)
                throws SQLException,
                       IOException

Specified by:

importFile 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 -

csvOptions - the CSV options ie "charset=UTF-8 fieldSeparator=| fieldDelimiter=,"

Throws:

SQLException

IOException

importFile

public void importFile(Connection connection,
                       String tableReference,
                       File fileName,
                       org.h2gis.api.ProgressVisitor progress,
                       boolean deleteTables)
                throws SQLException,
                       IOException

Specified by:

importFile in interface org.h2gis.api.DriverFunction

Throws:

SQLException

IOException