Modifier and Type	Class and Description
public static class	ImportUtil.Builder Builder which simplifies configuration of an import operation.

Modifier and Type	Field and Description
private static final int	COPY_TABLE_BATCH_SIZE Batch commit size for copying other result sets into this database
pack-priv static final String	LINE_SEPARATOR the platform line separator

Access	Constructor and Description
private	ImportUtil()

Method Summary

Modifier and Type	Method and Description
private static Table	createUniqueTable(Database db, String name, List<ColumnBuilder> columns, ResultSetMetaData md, ImportFilter filter) Returns a new table with a unique name and the given table definition.
public static String	Returns: the name of the imported table importFile(File Source file to import f, Database db, String Name of the new table to create name, String Regular expression representing the delimiter string. delim) Copy a delimited text file into a new table in this database.
public static String	Returns: the name of the imported table importFile(File Source file to import f, Database db, String Name of the new table to create name, String Regular expression representing the delimiter string. delim, ImportFilter valid import filter filter) Copy a delimited text file into a new table in this database.
public static String	Returns: the name of the imported table importFile(File Source file to import f, Database db, String Name of the new table to create name, String Regular expression representing the delimiter string. delim, char the quote character quote, ImportFilter valid import filter filter, boolean if `true` use current table if it already exists, otherwise, create new table with unique name useExistingTable) Copy a delimited text file into a new table in this database.
public static String	Returns: the name of the imported table importFile(File Source file to import f, Database db, String Name of the new table to create name, String Regular expression representing the delimiter string. delim, char the quote character quote, ImportFilter valid import filter filter, boolean if `true` use current table if it already exists, otherwise, create new table with unique name useExistingTable, boolean if `false` the first line is not a header row, only valid if useExistingTable is `true` header) Copy a delimited text file into a new table in this database.
public static String	Returns: the name of the imported table importReader(BufferedReader Source reader to import in, Database db, String Name of the new table to create name, String Regular expression representing the delimiter string. delim) Copy a delimited text file into a new table in this database.
public static String	Returns: the name of the imported table importReader(BufferedReader Source reader to import in, Database db, String Name of the new table to create name, String Regular expression representing the delimiter string. delim, ImportFilter valid import filter filter) Copy a delimited text file into a new table in this database.
public static String	Returns: the name of the imported table importReader(BufferedReader Source reader to import in, Database db, String Name of the new table to create name, String Regular expression representing the delimiter string. delim, ImportFilter valid import filter filter, boolean if `true` use current table if it already exists, otherwise, create new table with unique name useExistingTable) Copy a delimited text file into a new (or optionally exixsting) table in this database.
public static String	Returns: the name of the imported table importReader(BufferedReader Source reader to import in, Database db, String Name of the new table to create name, String Regular expression representing the delimiter string. delim, char the quote character quote, ImportFilter valid import filter filter, boolean if `true` use current table if it already exists, otherwise, create new table with unique name useExistingTable) Copy a delimited text file into a new (or optionally exixsting) table in this database.
public static String	Returns: the name of the imported table importReader(BufferedReader Source reader to import in, Database db, String Name of the new table to create name, String Regular expression representing the delimiter string. delim, char the quote character quote, ImportFilter valid import filter filter, boolean if `true` use current table if it already exists, otherwise, create new table with unique name useExistingTable, boolean if `false` the first line is not a header row, only valid if useExistingTable is `true` header) Copy a delimited text file into a new (or optionally exixsting) table in this database.
public static String	Returns: the name of the copied table importResultSet(ResultSet ResultSet to copy from source, Database db, String Name of the new table to create name) Copy an existing JDBC ResultSet into a new table in this database.
public static String	Returns: the name of the imported table importResultSet(ResultSet ResultSet to copy from source, Database db, String Name of the new table to create name, ImportFilter valid import filter filter) Copy an existing JDBC ResultSet into a new table in this database.
public static String	Returns: the name of the imported table importResultSet(ResultSet ResultSet to copy from source, Database db, String Name of the new table to create name, ImportFilter valid import filter filter, boolean if `true` use current table if it already exists, otherwise, create new table with unique name useExistingTable) Copy an existing JDBC ResultSet into a new (or optionally existing) table in this database.
private static Object[]	splitLine(String line, Pattern delim, char quote, BufferedReader in, int numColumns) Splits the given line using the given delimiter pattern and quote character.
public static List<ColumnBuilder>	Returns: a List of Columns toColumns(ResultSetMetaData md) Returns a List of Column instances converted from the given ResultSetMetaData (this is the same method used by the various `importResultSet()` methods).

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

Field Detail

COPY_TABLE_BATCH_SIZE	back to summary
private static final int COPY_TABLE_BATCH_SIZE Batch commit size for copying other result sets into this database

LINE_SEPARATOR	back to summary
pack-priv static final String LINE_SEPARATOR the platform line separator

Constructor Detail

ImportUtil	back to summary
private ImportUtil()

Method Detail

createUniqueTable	back to summary
private static Table createUniqueTable(Database db, String name, List<ColumnBuilder> columns, ResultSetMetaData md, ImportFilter filter) throws IOException Returns a new table with a unique name and the given table definition.

importFile back to summary

importFile	back to summary
public static String importFile(File f, Database db, String name, String delim) throws IOException Copy a delimited text file into a new table in this database. Equivalent to: `importFile(f, name, db, delim, SimpleImportFilter.INSTANCE);` Parameters f:File Source file to import name:String Name of the new table to create delim:String Regular expression representing the delimiter string. Returns:String the name of the imported table See Also `importFile(File, Database, String, String, ImportFilter)`, `Builder`

public static String importFile(File f, Database db, String name, String delim) throws IOException

Copy a delimited text file into a new table in this database.

Equivalent to: importFile(f, name, db, delim, SimpleImportFilter.INSTANCE);

Parameters

f:File: Source file to import
name:String: Name of the new table to create
delim:String: Regular expression representing the delimiter string.

Returns:String

the name of the imported table

importFile back to summary

importFile	back to summary
public static String importFile(File f, Database db, String name, String delim, ImportFilter filter) throws IOException Copy a delimited text file into a new table in this database. Equivalent to: `importFile(f, name, db, delim, "'", filter, false);` Parameters f:File Source file to import name:String Name of the new table to create delim:String Regular expression representing the delimiter string. filter:ImportFilter valid import filter Returns:String the name of the imported table See Also `importReader(BufferedReader, Database, String, String, ImportFilter)`, `Builder`

public static String importFile(File f, Database db, String name, String delim, ImportFilter filter) throws IOException

Copy a delimited text file into a new table in this database.

Equivalent to: importFile(f, name, db, delim, "'", filter, false);

Parameters

f:File: Source file to import
name:String: Name of the new table to create
delim:String: Regular expression representing the delimiter string.
filter:ImportFilter: valid import filter

Returns:String

the name of the imported table

importFile back to summary

importFile	back to summary
public static String importFile(File f, Database db, String name, String delim, char quote, ImportFilter filter, boolean useExistingTable) throws IOException Copy a delimited text file into a new table in this database. Equivalent to: `importReader(new BufferedReader(new FileReader(f)), db, name, delim, "'", filter, useExistingTable, true);` Parameters f:File Source file to import name:String Name of the new table to create delim:String Regular expression representing the delimiter string. quote:char the quote character filter:ImportFilter valid import filter useExistingTable:boolean if `true` use current table if it already exists, otherwise, create new table with unique name Returns:String the name of the imported table See Also `importReader(BufferedReader, Database, String, String, ImportFilter, boolean)`, `Builder`

public static String importFile(File f, Database db, String name, String delim, char quote, ImportFilter filter, boolean useExistingTable) throws IOException

Copy a delimited text file into a new table in this database.

Equivalent to: importReader(new BufferedReader(new FileReader(f)), db, name, delim, "'", filter, useExistingTable, true);

Parameters

f:File: Source file to import
name:String: Name of the new table to create
delim:String: Regular expression representing the delimiter string.
quote:char: the quote character
filter:ImportFilter: valid import filter
useExistingTable:boolean: if true use current table if it already exists, otherwise, create new table with unique name

Returns:String

the name of the imported table

importFile back to summary

importFile	back to summary
public static String importFile(File f, Database db, String name, String delim, char quote, ImportFilter filter, boolean useExistingTable, boolean header) throws IOException Copy a delimited text file into a new table in this database. Equivalent to: `importReader(new BufferedReader(new FileReader(f)), db, name, delim, "'", filter, useExistingTable, header);` Parameters f:File Source file to import name:String Name of the new table to create delim:String Regular expression representing the delimiter string. quote:char the quote character filter:ImportFilter valid import filter useExistingTable:boolean if `true` use current table if it already exists, otherwise, create new table with unique name header:boolean if `false` the first line is not a header row, only valid if useExistingTable is `true` Returns:String the name of the imported table See Also `importReader(BufferedReader, Database, String, String, char, ImportFilter, boolean, boolean)`, `Builder`

public static String importFile(File f, Database db, String name, String delim, char quote, ImportFilter filter, boolean useExistingTable, boolean header) throws IOException

Copy a delimited text file into a new table in this database.

Equivalent to: importReader(new BufferedReader(new FileReader(f)), db, name, delim, "'", filter, useExistingTable, header);

Parameters

f:File: Source file to import
name:String: Name of the new table to create
delim:String: Regular expression representing the delimiter string.
quote:char: the quote character
filter:ImportFilter: valid import filter
useExistingTable:boolean: if true use current table if it already exists, otherwise, create new table with unique name
header:boolean: if false the first line is not a header row, only valid if useExistingTable is true

Returns:String

the name of the imported table

importReader back to summary

importReader	back to summary
public static String importReader(BufferedReader in, Database db, String name, String delim) throws IOException Copy a delimited text file into a new table in this database. Equivalent to: `importReader(in, db, name, delim, SimpleImportFilter.INSTANCE);` Parameters in:BufferedReader Source reader to import name:String Name of the new table to create delim:String Regular expression representing the delimiter string. Returns:String the name of the imported table See Also `importReader(BufferedReader, Database, String, String, ImportFilter)`, `Builder`

public static String importReader(BufferedReader in, Database db, String name, String delim) throws IOException

Copy a delimited text file into a new table in this database.

Equivalent to: importReader(in, db, name, delim, SimpleImportFilter.INSTANCE);

Parameters

in:BufferedReader: Source reader to import
name:String: Name of the new table to create
delim:String: Regular expression representing the delimiter string.

Returns:String

the name of the imported table

importReader back to summary

importReader	back to summary
public static String importReader(BufferedReader in, Database db, String name, String delim, ImportFilter filter) throws IOException Copy a delimited text file into a new table in this database. Equivalent to: `importReader(in, db, name, delim, filter, false);` Parameters in:BufferedReader Source reader to import name:String Name of the new table to create delim:String Regular expression representing the delimiter string. filter:ImportFilter valid import filter Returns:String the name of the imported table See Also `importReader(BufferedReader, Database, String, String, ImportFilter, boolean)`, `Builder`

public static String importReader(BufferedReader in, Database db, String name, String delim, ImportFilter filter) throws IOException

Copy a delimited text file into a new table in this database.

Equivalent to: importReader(in, db, name, delim, filter, false);

Parameters

in:BufferedReader: Source reader to import
name:String: Name of the new table to create
delim:String: Regular expression representing the delimiter string.
filter:ImportFilter: valid import filter

Returns:String

the name of the imported table

importReader back to summary

importReader	back to summary
public static String importReader(BufferedReader in, Database db, String name, String delim, ImportFilter filter, boolean useExistingTable) throws IOException Copy a delimited text file into a new (or optionally exixsting) table in this database. Equivalent to: `importReader(in, db, name, delim, '"', filter, false);` Parameters in:BufferedReader Source reader to import name:String Name of the new table to create delim:String Regular expression representing the delimiter string. filter:ImportFilter valid import filter useExistingTable:boolean if `true` use current table if it already exists, otherwise, create new table with unique name Returns:String the name of the imported table See Also `Builder`

public static String importReader(BufferedReader in, Database db, String name, String delim, ImportFilter filter, boolean useExistingTable) throws IOException

Copy a delimited text file into a new (or optionally exixsting) table in this database.

Equivalent to: importReader(in, db, name, delim, '"', filter, false);

Parameters

in:BufferedReader: Source reader to import
name:String: Name of the new table to create
delim:String: Regular expression representing the delimiter string.
filter:ImportFilter: valid import filter
useExistingTable:boolean: if true use current table if it already exists, otherwise, create new table with unique name

Returns:String

the name of the imported table

See Also

Builder

importReader back to summary

importReader	back to summary
public static String importReader(BufferedReader in, Database db, String name, String delim, char quote, ImportFilter filter, boolean useExistingTable) throws IOException Copy a delimited text file into a new (or optionally exixsting) table in this database. Equivalent to: `importReader(in, db, name, delim, '"', filter, useExistingTable, true);` Parameters in:BufferedReader Source reader to import name:String Name of the new table to create delim:String Regular expression representing the delimiter string. quote:char the quote character filter:ImportFilter valid import filter useExistingTable:boolean if `true` use current table if it already exists, otherwise, create new table with unique name Returns:String the name of the imported table See Also `Builder`

public static String importReader(BufferedReader in, Database db, String name, String delim, char quote, ImportFilter filter, boolean useExistingTable) throws IOException

Copy a delimited text file into a new (or optionally exixsting) table in this database.

Equivalent to: importReader(in, db, name, delim, '"', filter, useExistingTable, true);

Parameters

in:BufferedReader: Source reader to import
name:String: Name of the new table to create
delim:String: Regular expression representing the delimiter string.
quote:char: the quote character
filter:ImportFilter: valid import filter
useExistingTable:boolean: if true use current table if it already exists, otherwise, create new table with unique name

Returns:String

the name of the imported table

See Also

Builder

importReader back to summary

importReader	back to summary
public static String importReader(BufferedReader in, Database db, String name, String delim, char quote, ImportFilter filter, boolean useExistingTable, boolean header) throws IOException Copy a delimited text file into a new (or optionally exixsting) table in this database. Parameters in:BufferedReader Source reader to import name:String Name of the new table to create delim:String Regular expression representing the delimiter string. quote:char the quote character filter:ImportFilter valid import filter useExistingTable:boolean if `true` use current table if it already exists, otherwise, create new table with unique name header:boolean if `false` the first line is not a header row, only valid if useExistingTable is `true` Returns:String the name of the imported table

public static String importReader(BufferedReader in, Database db, String name, String delim, char quote, ImportFilter filter, boolean useExistingTable, boolean header) throws IOException

Copy a delimited text file into a new (or optionally exixsting) table in this database.

Parameters

in:BufferedReader: Source reader to import
name:String: Name of the new table to create
delim:String: Regular expression representing the delimiter string.
quote:char: the quote character
filter:ImportFilter: valid import filter
useExistingTable:boolean: if true use current table if it already exists, otherwise, create new table with unique name
header:boolean: if false the first line is not a header row, only valid if useExistingTable is true

Returns:String

the name of the imported table

importResultSet back to summary

importResultSet	back to summary
public static String importResultSet(ResultSet source, Database db, String name) throws SQLException, IOException Copy an existing JDBC ResultSet into a new table in this database. Equivalent to: `importResultSet(source, db, name, SimpleImportFilter.INSTANCE);` Parameters source:ResultSet ResultSet to copy from name:String Name of the new table to create Returns:String the name of the copied table See Also `importResultSet(ResultSet, Database, String, ImportFilter)`, `Builder`

public static String importResultSet(ResultSet source, Database db, String name) throws SQLException, IOException

Copy an existing JDBC ResultSet into a new table in this database.

Equivalent to: importResultSet(source, db, name, SimpleImportFilter.INSTANCE);

Parameters

source:ResultSet: ResultSet to copy from
name:String: Name of the new table to create

Returns:String

the name of the copied table

importResultSet back to summary

importResultSet	back to summary
public static String importResultSet(ResultSet source, Database db, String name, ImportFilter filter) throws SQLException, IOException Copy an existing JDBC ResultSet into a new table in this database. Equivalent to: `importResultSet(source, db, name, filter, false);` Parameters source:ResultSet ResultSet to copy from name:String Name of the new table to create filter:ImportFilter valid import filter Returns:String the name of the imported table See Also `importResultSet(ResultSet, Database, String, ImportFilter, boolean)`, `Builder`

public static String importResultSet(ResultSet source, Database db, String name, ImportFilter filter) throws SQLException, IOException

Copy an existing JDBC ResultSet into a new table in this database.

Equivalent to: importResultSet(source, db, name, filter, false);

Parameters

source:ResultSet: ResultSet to copy from
name:String: Name of the new table to create
filter:ImportFilter: valid import filter

Returns:String

the name of the imported table

importResultSet back to summary

importResultSet	back to summary
public static String importResultSet(ResultSet source, Database db, String name, ImportFilter filter, boolean useExistingTable) throws SQLException, IOException Copy an existing JDBC ResultSet into a new (or optionally existing) table in this database. Parameters source:ResultSet ResultSet to copy from name:String Name of the new table to create filter:ImportFilter valid import filter useExistingTable:boolean if `true` use current table if it already exists, otherwise, create new table with unique name Returns:String the name of the imported table See Also `Builder`

public static String importResultSet(ResultSet source, Database db, String name, ImportFilter filter, boolean useExistingTable) throws SQLException, IOException

Copy an existing JDBC ResultSet into a new (or optionally existing) table in this database.

Parameters

source:ResultSet: ResultSet to copy from
name:String: Name of the new table to create
filter:ImportFilter: valid import filter
useExistingTable:boolean: if true use current table if it already exists, otherwise, create new table with unique name

Returns:String

the name of the imported table

See Also

Builder

splitLine	back to summary
private static Object[] splitLine(String line, Pattern delim, char quote, BufferedReader in, int numColumns) throws IOException Splits the given line using the given delimiter pattern and quote character. May read additional lines for quotes spanning newlines.

toColumns back to summary

public static List<ColumnBuilder> toColumns(ResultSetMetaData md) throws SQLException, IOException

Returns a List of Column instances converted from the given ResultSetMetaData (this is the same method used by the various importResultSet() methods).

Returns:List<ColumnBuilder>: a List of Columns

io.github.spannm.jackcess.util back to summary

public Class ImportUtil.Builder

Class Inheritance

extends Object

java.lang.Object
io.github.spannm.jackcess.util.ImportUtil.Builder

Builder which simplifies configuration of an import operation.

Field Summary

Modifier and Type	Field and Description
private Database	db
private String	delim
private ImportFilter	filter
private boolean	header
private char	quote
private String	tableName
private boolean	useExistingTable

Constructor Summary

Access	Constructor and Description
public	Builder(Database db)
public	Builder(Database db, String tableName)

Method Summary

Modifier and Type	Method and Description
public String	importFile(File f) Imports the given delimited file into a table, using the settings of this builder.
public String	importReader(BufferedReader reader) Imports delimited data from the given reader into a table, using the settings of this builder.
public String	importResultSet(ResultSet source) Imports the given result set into a table, using the settings of this builder.
public ImportUtil.Builder	withDatabase(Database newDb)
public ImportUtil.Builder	withDelimiter(String newDelim)
public ImportUtil.Builder	withFilter(ImportFilter newFilter)
public ImportUtil.Builder	withHeader(boolean newHeader)
public ImportUtil.Builder	withQuote(char newQuote)
public ImportUtil.Builder	withTableName(String newTableName)
public ImportUtil.Builder	withUseExistingTable(boolean newUseExistingTable)

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

Field Detail

db	back to summary
private Database db

delim	back to summary
private String delim

filter	back to summary
private ImportFilter filter

header	back to summary
private boolean header

quote	back to summary
private char quote

tableName	back to summary
private String tableName

useExistingTable	back to summary
private boolean useExistingTable

Constructor Detail

Builder	back to summary
public Builder(Database db)

Builder	back to summary
public Builder(Database db, String tableName)

Method Detail

importFile back to summary

importFile	back to summary
public String importFile(File f) throws IOException Imports the given delimited file into a table, using the settings of this builder. See Also `ImportUtil#importFile(File, Database, String, String, char, ImportFilter, boolean, boolean)`

public String importFile(File f) throws IOException

Imports the given delimited file into a table, using the settings of this builder.

See Also: ImportUtil#importFile(File, Database, String, String, char, ImportFilter, boolean, boolean)

importReader back to summary

importReader	back to summary
public String importReader(BufferedReader reader) throws IOException Imports delimited data from the given reader into a table, using the settings of this builder. See Also `ImportUtil#importReader(BufferedReader, Database, String, String, char, ImportFilter, boolean, boolean)`

public String importReader(BufferedReader reader) throws IOException

Imports delimited data from the given reader into a table, using the settings of this builder.

See Also: ImportUtil#importReader(BufferedReader, Database, String, String, char, ImportFilter, boolean, boolean)

importResultSet back to summary

importResultSet	back to summary
public String importResultSet(ResultSet source) throws SQLException, IOException Imports the given result set into a table, using the settings of this builder. See Also `ImportUtil#importResultSet(ResultSet, Database, String, ImportFilter, boolean)`

public String importResultSet(ResultSet source) throws SQLException, IOException

Imports the given result set into a table, using the settings of this builder.

See Also: ImportUtil#importResultSet(ResultSet, Database, String, ImportFilter, boolean)

withDatabase	back to summary
public ImportUtil.Builder withDatabase(Database newDb)

withDelimiter	back to summary
public ImportUtil.Builder withDelimiter(String newDelim)

withFilter	back to summary
public ImportUtil.Builder withFilter(ImportFilter newFilter)

withHeader	back to summary
public ImportUtil.Builder withHeader(boolean newHeader)

withQuote	back to summary
public ImportUtil.Builder withQuote(char newQuote)

withTableName	back to summary
public ImportUtil.Builder withTableName(String newTableName)

withUseExistingTable	back to summary
public ImportUtil.Builder withUseExistingTable(boolean newUseExistingTable)

public final Class ImportUtil

Nested and Inner Type Summary

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail

public Class ImportUtil.Builder

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail