com.northconcepts.datapipeline.sql.h2

Class H2InsertWriter

java.lang.Object

com.northconcepts.datapipeline.core.DataObject

com.northconcepts.datapipeline.core.Endpoint

com.northconcepts.datapipeline.core.DataEndpoint

com.northconcepts.datapipeline.core.DataWriter

com.northconcepts.datapipeline.core.AbstractWriter

com.northconcepts.datapipeline.core.TextWriter

com.northconcepts.datapipeline.sql.h2.H2InsertWriter

public class H2InsertWriter
extends TextWriter

Generates H2 insert statement from records.

Nested Class Summary

Nested classes/interfaces inherited from class com.northconcepts.datapipeline.core.DataEndpoint

DataEndpoint.State

Field Summary

Fields

Modifier and Type	Field and Description
protected int	batchedInserts
protected int	batchSize
protected boolean	pretty
protected String	tableName

Fields inherited from class com.northconcepts.datapipeline.core.AbstractWriter

currentRecord

Fields inherited from class com.northconcepts.datapipeline.core.DataEndpoint

lastRecord, PRODUCT, PRODUCT_VERSION, VENDOR, XML_INPUT_FACTORY_KEY

Fields inherited from class com.northconcepts.datapipeline.core.Endpoint

BUFFER_SIZE, captureElapsedTime, DEFAULT_READ_BUFFER_SIZE

Fields inherited from class com.northconcepts.datapipeline.core.DataObject

id, log, name, TIMESTAMP_FORMAT

Constructor Summary

Constructors

Constructor and Description
H2InsertWriter(String tableName, File file) Constructs an H2InsertWriter for the specified table and file.
H2InsertWriter(String tableName, File file, boolean append) Constructs an H2InsertWriter for the specified table, file, and append mode.
H2InsertWriter(String tableName, Writer writer) Constructs an H2InsertWriter for the specified table and writer.

Method Summary

Modifier and Type	Method and Description
DataException	addExceptionProperties(DataException exception) Adds this endpoint's current state to a DataException.
void	close() Indicates that this endpoint has finished reading or writing.
int	getBatchSize() Returns the batch size.
protected String	getSqlValueLiteral(Field field)
String	getTableName() Returns the table name.
boolean	isBatchMode() Returns whether batch mode is enabled.
boolean	isPretty() Returns whether pretty formatting is enabled.
H2InsertWriter	setBatchSize(int batchSize) Sets the number of records to chunk together in batch inserts.
H2InsertWriter	setFieldNamesInFirstRow(boolean fieldNamesInFirstRow)
H2InsertWriter	setPretty(boolean pretty) Indicates if line breaks and indentations should be added to output insert statement (default false). Example output (pretty = true): INSERT INTO `tableName` (`col1`, `col2`, `col3`) VALUES (val1, val2, val3),
protected void	writeRecord(Record record)

Methods inherited from class com.northconcepts.datapipeline.core.TextWriter

getFile, getWriter, isAppend, isAutoCloseWriter, isFieldNamesInFirstRow, isFlushOnWrite, setAutoCloseWriter, setFlushOnWrite, write

Methods inherited from class com.northconcepts.datapipeline.core.AbstractWriter

createHeaderRecord, isHeaderRow, open, writeImpl

Methods inherited from class com.northconcepts.datapipeline.core.DataWriter

available, getNestedEndpoint, getNestedWriter, getRootEndpoint, getRootWriter, getWriter

Methods inherited from class com.northconcepts.datapipeline.core.DataEndpoint

decrementRecordCount, enableJmx, getLastRecord, getRecordCount, getRecordCountAsBigInteger, getRecordCountAsString, incrementRecordCount, isRecordCountBigInteger, resetRecordCount, toString

Methods inherited from class com.northconcepts.datapipeline.core.Endpoint

addElapsedtime, assertClosed, assertNotOpened, assertOpened, finalize, getClosedOn, getDescription, getElapsedTime, getElapsedTimeAsString, getOpenedOn, getOpenElapsedTime, getOpenElapsedTimeAsString, getSelfTime, getSelfTimeAsString, getState, isCaptureElapsedTime, isClosed, isOpen, setCaptureElapsedTime, setDescription

Methods inherited from class com.northconcepts.datapipeline.core.DataObject

exception, exception, exception, getId, getName, resetID

Methods inherited from class java.lang.Object

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

Field Detail

pretty

protected boolean pretty

batchSize

protected int batchSize

batchedInserts

protected int batchedInserts

tableName

protected final String tableName

Constructor Detail

H2InsertWriter

public H2InsertWriter(String tableName,
                      File file,
                      boolean append)

Constructs an H2InsertWriter for the specified table, file, and append mode.

Parameters:

tableName - the name of the table

file - the file to write to

append - true to append to existing file

H2InsertWriter

public H2InsertWriter(String tableName,
                      File file)

Constructs an H2InsertWriter for the specified table and file.

Parameters:

tableName - the name of the table

file - the file to write to

H2InsertWriter

public H2InsertWriter(String tableName,
                      Writer writer)

Constructs an H2InsertWriter for the specified table and writer.

Parameters:

tableName - the name of the table

writer - the writer to write to

Method Detail

writeRecord

protected void writeRecord(Record record)
                    throws Throwable

Specified by:

writeRecord in class AbstractWriter

Throws:

Throwable

close

public void close()

Description copied from class: DataEndpoint

Indicates that this endpoint has finished reading or writing.

Overrides:

close in class TextWriter

getTableName

public String getTableName()

Returns the table name.

Returns:

the table name

isPretty

public boolean isPretty()

Returns whether pretty formatting is enabled.

Returns:

true if pretty formatting is enabled

setPretty

public H2InsertWriter setPretty(boolean pretty)

Indicates if line breaks and indentations should be added to output insert statement (default false).

Example output (pretty = true):
INSERT INTO `tableName` (`col1`, `col2`, `col3`)
VALUES (val1, val2, val3),

       (val1, val2, val3),

       (val1, val2, val3),...

Example output (pretty = false):
INSERT INTO `tableName` (`col1`, `col2`, `col3`) VALUES (val1, val2, val3), (val1, val2, val3), (val1, val2, val3),...

getBatchSize

public int getBatchSize()

Returns the batch size.

Returns:

the batch size

setBatchSize

public H2InsertWriter setBatchSize(int batchSize)

Sets the number of records to chunk together in batch inserts. Inserts are not batched if this value is 1 or less. H2InsertWriter defaults to non batching inserts.

Example output (batchSize = 2):
INSERT INTO `tableName` (`col1`, `col2`, `col3`)
VALUES (val1, val2, val3),

       (val1, val2, val3);

Example output (batchSize = 0):
INSERT INTO `tableName` (`col1`, `col2`, `col3`) VALUES (val1, val2, val3);
INSERT INTO `tableName` (`col1`, `col2`, `col3`) VALUES (val1, val2, val3);

isBatchMode

public boolean isBatchMode()

Returns whether batch mode is enabled.

Returns:

true if batch mode is enabled

setFieldNamesInFirstRow

public H2InsertWriter setFieldNamesInFirstRow(boolean fieldNamesInFirstRow)

Overrides:

setFieldNamesInFirstRow in class AbstractWriter

addExceptionProperties

public DataException addExceptionProperties(DataException exception)

Description copied from class: Endpoint

Adds this endpoint's current state to a DataException. Since this method is called whenever an exception is thrown, subclasses should override it to add their specific information.

Overrides:

addExceptionProperties in class TextWriter

getSqlValueLiteral

protected String getSqlValueLiteral(Field field)