org.jumpmind.symmetric.load
Class TableTemplate

java.lang.Object
  org.jumpmind.symmetric.load.TableTemplate

public class TableTemplate
extends java.lang.Object

An instance of TableTemplate knows how to insert, update, and delete from a single table. It uses metadata from the IDbDialect to get the columns for the table in the target database in case the table is missing or has missing columns. It uses a cache of StatementBuilder objects that contain the SQL and PreparedStatement.

Author:

elong

Field Summary

static java.lang.String	REQUIRED_FIELD_NULL_SUBSTITUTE
static java.lang.String[]	TIMESTAMP_PATTERNS

Constructor Summary

TableTemplate(org.springframework.jdbc.core.JdbcTemplate jdbcTemplate, IDbDialect dbDialect, java.lang.String tableName, IColumnFilter columnFilter, boolean dontIncludeKeysInUpdateStatement)

Method Summary

int	delete(IDataLoaderContext ctx, java.lang.String[] keyValues)
java.lang.String[]	getColumnNames()
java.lang.String[]	getKeyNames()
org.apache.ddlutils.model.Table	getTable()
java.lang.String	getTableName()
int	insert(IDataLoaderContext ctx, java.lang.String[] columnValues)
int	insert(IDataLoaderContext ctx, java.lang.String[] columnValues, BinaryEncoding encoding)
boolean	isIgnoreThisTable()
void	resetMetaData()
void	setColumnNames(java.lang.String[] columnNames)
void	setKeyNames(java.lang.String[] keyNames)
void	setOldData(java.lang.String[] oldData)
int	update(IDataLoaderContext ctx, java.lang.String[] columnValues, java.lang.String[] keyValues)
int	update(IDataLoaderContext ctx, java.lang.String[] columnValues, java.lang.String[] keyValues, BinaryEncoding encoding)

Methods inherited from class java.lang.Object

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

Field Detail

REQUIRED_FIELD_NULL_SUBSTITUTE

public static final java.lang.String REQUIRED_FIELD_NULL_SUBSTITUTE

See Also:

Constant Field Values

TIMESTAMP_PATTERNS

public static final java.lang.String[] TIMESTAMP_PATTERNS

Constructor Detail

TableTemplate

public TableTemplate(org.springframework.jdbc.core.JdbcTemplate jdbcTemplate,
                     IDbDialect dbDialect,
                     java.lang.String tableName,
                     IColumnFilter columnFilter,
                     boolean dontIncludeKeysInUpdateStatement)

Method Detail

resetMetaData

public void resetMetaData()

getTableName

public java.lang.String getTableName()

isIgnoreThisTable

public boolean isIgnoreThisTable()

insert

public int insert(IDataLoaderContext ctx,
                  java.lang.String[] columnValues)

insert

public int insert(IDataLoaderContext ctx,
                  java.lang.String[] columnValues,
                  BinaryEncoding encoding)

update

public int update(IDataLoaderContext ctx,
                  java.lang.String[] columnValues,
                  java.lang.String[] keyValues)

update

public int update(IDataLoaderContext ctx,
                  java.lang.String[] columnValues,
                  java.lang.String[] keyValues,
                  BinaryEncoding encoding)

delete

public int delete(IDataLoaderContext ctx,
                  java.lang.String[] keyValues)

setKeyNames

public void setKeyNames(java.lang.String[] keyNames)

setColumnNames

public void setColumnNames(java.lang.String[] columnNames)

setOldData

public void setOldData(java.lang.String[] oldData)

getKeyNames

public java.lang.String[] getKeyNames()

getColumnNames

public java.lang.String[] getColumnNames()

getTable

public org.apache.ddlutils.model.Table getTable()