com.healthmarketscience.jackcess
Class ExportUtil

java.lang.Object
  com.healthmarketscience.jackcess.ExportUtil

public class ExportUtil
extends java.lang.Object

Nested Class Summary

static class

ExportUtil.Builder Builder which simplifies configuration of an export operation.

Field Summary

static java.lang.String	DEFAULT_DELIMITER
static java.lang.String	DEFAULT_FILE_EXT
static char	DEFAULT_QUOTE_CHAR

Method Summary

static void	exportAll(Database db, java.io.File dir) Copy all tables into new delimited text files Equivalent to: exportAll(db, dir, "csv");
static void	exportAll(Database db, java.io.File dir, java.lang.String ext) Copy all tables into new delimited text files Equivalent to: exportFile(db, name, f, false, null, '"', SimpleExportFilter.INSTANCE);
static void	exportAll(Database db, java.io.File dir, java.lang.String ext, boolean header) Copy all tables into new delimited text files Equivalent to: exportFile(db, name, f, false, null, '"', SimpleExportFilter.INSTANCE);
static void	exportAll(Database db, java.io.File dir, java.lang.String ext, boolean header, java.lang.String delim, char quote, ExportFilter filter) Copy all tables into new delimited text files Equivalent to: exportFile(db, name, f, false, null, '"', SimpleExportFilter.INSTANCE);
static void	exportFile(Database db, java.lang.String tableName, java.io.File f) Copy a table into a new delimited text file Equivalent to: exportFile(db, name, f, false, null, '"', SimpleExportFilter.INSTANCE);
static void	exportFile(Database db, java.lang.String tableName, java.io.File f, boolean header, java.lang.String delim, char quote, ExportFilter filter) Copy a table into a new delimited text file Nearly equivalent to: exportWriter(db, name, new BufferedWriter(f), header, delim, quote, filter);
static void	exportWriter(Cursor cursor, java.io.BufferedWriter out, boolean header, java.lang.String delim, char quote, ExportFilter filter) Copy a table in this database into a new delimited text file.
static void	exportWriter(Database db, java.lang.String tableName, java.io.BufferedWriter out) Copy a table in this database into a new delimited text file Equivalent to: exportWriter(db, name, out, false, null, '"', SimpleExportFilter.INSTANCE);
static void	exportWriter(Database db, java.lang.String tableName, java.io.BufferedWriter out, boolean header, java.lang.String delim, char quote, ExportFilter filter) Copy a table in this database into a new delimited text file.

Methods inherited from class java.lang.Object

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

Field Detail

DEFAULT_DELIMITER

public static final java.lang.String DEFAULT_DELIMITER

See Also:

Constant Field Values

DEFAULT_QUOTE_CHAR

public static final char DEFAULT_QUOTE_CHAR

See Also:

Constant Field Values

DEFAULT_FILE_EXT

public static final java.lang.String DEFAULT_FILE_EXT

See Also:

Constant Field Values

Method Detail

exportAll

public static void exportAll(Database db,
                             java.io.File dir)
                      throws java.io.IOException

Copy all tables into new delimited text files
Equivalent to: exportAll(db, dir, "csv");

Parameters:

db - Database the table to export belongs to

dir - The directory where the new files will be created

Throws:

java.io.IOException

See Also:

exportAll(Database,File,String), ExportUtil.Builder

exportAll

public static void exportAll(Database db,
                             java.io.File dir,
                             java.lang.String ext)
                      throws java.io.IOException

Copy all tables into new delimited text files
Equivalent to: exportFile(db, name, f, false, null, '"', SimpleExportFilter.INSTANCE);

Parameters:

db - Database the table to export belongs to

dir - The directory where the new files will be created

ext - The file extension of the new files

Throws:

java.io.IOException

See Also:

exportFile(Database,String,File,boolean,String,char,ExportFilter), ExportUtil.Builder

exportAll

public static void exportAll(Database db,
                             java.io.File dir,
                             java.lang.String ext,
                             boolean header)
                      throws java.io.IOException

Copy all tables into new delimited text files
Equivalent to: exportFile(db, name, f, false, null, '"', SimpleExportFilter.INSTANCE);

Parameters:

db - Database the table to export belongs to

dir - The directory where the new files will be created

ext - The file extension of the new files

header - If true the first line contains the column names

Throws:

java.io.IOException

See Also:

exportFile(Database,String,File,boolean,String,char,ExportFilter), ExportUtil.Builder

exportAll

public static void exportAll(Database db,
                             java.io.File dir,
                             java.lang.String ext,
                             boolean header,
                             java.lang.String delim,
                             char quote,
                             ExportFilter filter)
                      throws java.io.IOException

Copy all tables into new delimited text files
Equivalent to: exportFile(db, name, f, false, null, '"', SimpleExportFilter.INSTANCE);

Parameters:

db - Database the table to export belongs to

dir - The directory where the new files will be created

ext - The file extension of the new files

header - If true the first line contains the column names

delim - The column delimiter, null for default (comma)

quote - The quote character

filter - valid export filter

Throws:

java.io.IOException

See Also:

exportFile(Database,String,File,boolean,String,char,ExportFilter), ExportUtil.Builder

exportFile

public static void exportFile(Database db,
                              java.lang.String tableName,
                              java.io.File f)
                       throws java.io.IOException

Copy a table into a new delimited text file
Equivalent to: exportFile(db, name, f, false, null, '"', SimpleExportFilter.INSTANCE);

Parameters:

db - Database the table to export belongs to

tableName - Name of the table to export

f - New file to create

Throws:

java.io.IOException

See Also:

exportFile(Database,String,File,boolean,String,char,ExportFilter), ExportUtil.Builder

exportFile

public static void exportFile(Database db,
                              java.lang.String tableName,
                              java.io.File f,
                              boolean header,
                              java.lang.String delim,
                              char quote,
                              ExportFilter filter)
                       throws java.io.IOException

Copy a table into a new delimited text file
Nearly equivalent to: exportWriter(db, name, new BufferedWriter(f), header, delim, quote, filter);

Parameters:

db - Database the table to export belongs to

tableName - Name of the table to export

f - New file to create

header - If true the first line contains the column names

delim - The column delimiter, null for default (comma)

quote - The quote character

filter - valid export filter

Throws:

java.io.IOException

See Also:

exportWriter(Database,String,BufferedWriter,boolean,String,char,ExportFilter), ExportUtil.Builder

exportWriter

public static void exportWriter(Database db,
                                java.lang.String tableName,
                                java.io.BufferedWriter out)
                         throws java.io.IOException

Copy a table in this database into a new delimited text file
Equivalent to: exportWriter(db, name, out, false, null, '"', SimpleExportFilter.INSTANCE);

Parameters:

db - Database the table to export belongs to

tableName - Name of the table to export

out - Writer to export to

Throws:

java.io.IOException

See Also:

exportWriter(Database,String,BufferedWriter,boolean,String,char,ExportFilter), ExportUtil.Builder

exportWriter

public static void exportWriter(Database db,
                                java.lang.String tableName,
                                java.io.BufferedWriter out,
                                boolean header,
                                java.lang.String delim,
                                char quote,
                                ExportFilter filter)
                         throws java.io.IOException

Copy a table in this database into a new delimited text file.
Equivalent to: exportWriter(Cursor.createCursor(db.getTable(tableName)), out, header, delim, quote, filter);

Parameters:

db - Database the table to export belongs to

tableName - Name of the table to export

out - Writer to export to

header - If true the first line contains the column names

delim - The column delimiter, null for default (comma)

quote - The quote character

filter - valid export filter

Throws:

java.io.IOException

See Also:

exportWriter(Cursor,BufferedWriter,boolean,String,char,ExportFilter), ExportUtil.Builder

exportWriter

public static void exportWriter(Cursor cursor,
                                java.io.BufferedWriter out,
                                boolean header,
                                java.lang.String delim,
                                char quote,
                                ExportFilter filter)
                         throws java.io.IOException

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

Parameters:

cursor - Cursor to export

out - Writer to export to

header - If true the first line contains the column names

delim - The column delimiter, null for default (comma)

quote - The quote character

filter - valid export filter

Throws:

java.io.IOException

See Also:

ExportUtil.Builder