Package org.jumpmind.symmetric.db.mssql

Class MsSqlTriggerTemplate

java.lang.Object

org.jumpmind.symmetric.db.AbstractTriggerTemplate

org.jumpmind.symmetric.db.mssql.MsSqlTriggerTemplate

Direct Known Subclasses:

MsSql2000TriggerTemplate, MsSql2008TriggerTemplate

public class MsSqlTriggerTemplate
extends AbstractTriggerTemplate

Nested Class Summary

Nested classes/interfaces inherited from class org.jumpmind.symmetric.db.AbstractTriggerTemplate

AbstractTriggerTemplate.ColumnString

Field Summary

Fields inherited from class org.jumpmind.symmetric.db.AbstractTriggerTemplate

arrayColumnTemplate, binaryColumnTemplate, blobColumnTemplate, booleanColumnTemplate, clobColumnTemplate, dateColumnTemplate, datetimeColumnTemplate, dateTimeWithLocalTimeZoneColumnTemplate, dateTimeWithTimeZoneColumnTemplate, emptyColumnTemplate, geographyColumnTemplate, geometryColumnTemplate, hashedValue, imageColumnTemplate, log, longColumnTemplate, newColumnPrefix, newTriggerValue, numberColumnTemplate, oldColumnPrefix, oldTriggerValue, ORIG_TABLE_ALIAS, otherColumnTemplate, sqlTemplates, stringColumnTemplate, symmetricDialect, timeColumnTemplate, triggerConcatCharacter, wrappedBlobColumnTemplate, xmlColumnTemplate

Constructor Summary

Constructors

Constructor	Description
MsSqlTriggerTemplate(ISymmetricDialect symmetricDialect)

Method Summary

Modifier and Type	Method	Description
protected String	getColumnSize(Table table, Column column)
protected String	getCreateTimeExpression()
protected String	getSourceTablePrefix(TriggerHistory triggerHistory)
protected boolean	isNotComparable(Column column)
protected String	replaceTemplateVariables(DataEventType dml, Trigger trigger, TriggerHistory history, Channel channel, String tablePrefix, Table originalTable, Table table, String defaultCatalog, String defaultSchema, String ddl)
protected boolean	requiresEmptyLobTemplateForDeletes()
protected String	toClobExpression(Table table)
protected boolean	useTriggerTemplateForColumnTemplatesDuringInitialLoad(Column column)	When INITIAL_LOAD_USE_COLUMN_TEMPLATES_ENABLED is true, column templates are used for all columns.

Methods inherited from class org.jumpmind.symmetric.db.AbstractTriggerTemplate

adjustColumnTemplate, aliasedPrimaryKeyJoin, aliasedPrimaryKeyJoinVar, buildColumnNameString, buildColumnsString, buildKeyVariablesDeclare, buildKeyVariablesString, buildVirtualTableSql, castDatetimeColumnToString, createCsvDataSql, createCsvPrimaryKeySql, createDdlTrigger, createInitalLoadSql, createPostDdlTriggerDDL, createPostTriggerDDL, createTriggerDDL, eval, fillOutColumnTemplate, getBlobColumnTemplate, getChannelExpression, getClobColumnTemplate, getClobType, getColumnPositionUsingTemplate, getCreateTriggerString, getDateColumnTemplate, getDefaultTargetTableName, getHasPrimaryKeysDefinedString, getImageColumnTemplate, getNewTriggerValue, getOldTriggerValue, getOtherColumnTemplate, getPrimaryKeysUpdatedString, getPrimaryKeyWhereString, getSchemaNameOnly, getSourceTablePrefix, getSourceTableSchema, getSourceTableSchema, getTimeColumnTemplate, getWrappedBlobColumnTemplate, noDateColumnTemplate, noTimeColumnTemplate, replaceDefaultCatalog, replaceDefaultSchema, replaceDefaultSchemaAndCatalog, replaceDefaultSchemaAndCatalog, replaceOracleQueryHint, requiresWrappedBlobTemplateForBlobType, setBooleanColumnTemplate, setDateColumnTemplate, setImageColumnTemplate, setTimeColumnTemplate, toHashedValue, useTriggerTemplateForColumnTemplatesDuringInitialLoad

Methods inherited from class java.lang.Object

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

Constructor Details

MsSqlTriggerTemplate

public MsSqlTriggerTemplate(ISymmetricDialect symmetricDialect)

Method Details

replaceTemplateVariables

protected String replaceTemplateVariables(DataEventType dml,
 Trigger trigger,
 TriggerHistory history,
 Channel channel,
 String tablePrefix,
 Table originalTable,
 Table table,
 String defaultCatalog,
 String defaultSchema,
 String ddl)

Overrides:

replaceTemplateVariables in class AbstractTriggerTemplate

isNotComparable

protected boolean isNotComparable(Column column)

getSourceTablePrefix

protected String getSourceTablePrefix(TriggerHistory triggerHistory)

Overrides:

getSourceTablePrefix in class AbstractTriggerTemplate

getCreateTimeExpression

protected String getCreateTimeExpression()

getColumnSize

protected String getColumnSize(Table table,
 Column column)

Overrides:

getColumnSize in class AbstractTriggerTemplate

useTriggerTemplateForColumnTemplatesDuringInitialLoad

protected boolean useTriggerTemplateForColumnTemplatesDuringInitialLoad(Column column)

Description copied from class: AbstractTriggerTemplate

When INITIAL_LOAD_USE_COLUMN_TEMPLATES_ENABLED is true, column templates are used for all columns. When false, only specific column types have been implemented to format data in code.

Overrides:

useTriggerTemplateForColumnTemplatesDuringInitialLoad in class AbstractTriggerTemplate

requiresEmptyLobTemplateForDeletes

protected boolean requiresEmptyLobTemplateForDeletes()

Overrides:

requiresEmptyLobTemplateForDeletes in class AbstractTriggerTemplate

toClobExpression

protected String toClobExpression(Table table)

Overrides:

toClobExpression in class AbstractTriggerTemplate