org.jumpmind.symmetric.db
Class SqlTemplate

java.lang.Object
  org.jumpmind.symmetric.db.SqlTemplate

public class SqlTemplate
extends java.lang.Object

Constructor Summary

SqlTemplate()

Method Summary

java.lang.String	createCsvDataSql(Trigger trig, org.apache.ddlutils.model.Table metaData, java.lang.String whereClause)
java.lang.String	createCsvPrimaryKeySql(Trigger trig, org.apache.ddlutils.model.Table metaData, java.lang.String whereClause)
java.lang.String	createFunctionDDL(java.lang.String name)
java.lang.String	createInitalLoadSql(Node node, IDbDialect dialect, Trigger trig, org.apache.ddlutils.model.Table metaData)
java.lang.String	createPostTriggerDDL(IDbDialect dialect, DataEventType dml, Trigger trigger, TriggerHistory history, java.lang.String tablePrefix, org.apache.ddlutils.model.Table metaData, java.lang.String defaultCatalog, java.lang.String defaultSchema)
java.lang.String	createPurgeSql(Node node, IDbDialect dialect, Trigger trig, TriggerHistory hist)
java.lang.String	createTriggerDDL(IDbDialect dialect, DataEventType dml, Trigger trigger, TriggerHistory history, java.lang.String tablePrefix, org.apache.ddlutils.model.Table metaData, java.lang.String defaultCatalog, java.lang.String defaultSchema) TODO Document all the 'templated' values available for building triggers.
java.lang.String	getBlobColumnTemplate()
java.lang.String	getClobColumnTemplate()
java.lang.String	getFunctionInstalledSql(java.lang.String functionName)
java.lang.String	getFunctionSql(java.lang.String functionName)
java.lang.String[]	getFunctionsToInstall()
java.lang.String	getNewTriggerValue()
java.lang.String	getOldTriggerValue()
java.lang.String	replaceTemplateVariables(IDbDialect dialect, DataEventType dml, Trigger trigger, TriggerHistory history, java.lang.String tablePrefix, org.apache.ddlutils.model.Table metaData, java.lang.String defaultCatalog, java.lang.String defaultSchema, java.lang.String ddl)
void	setBlobColumnTemplate(java.lang.String blobColumnTemplate)
void	setBooleanColumnTemplate(java.lang.String booleanColumnTemplate)
void	setClobColumnTemplate(java.lang.String clobColumnTemplate)
void	setDatetimeColumnTemplate(java.lang.String datetimeColumnTemplate)
void	setFunctionInstalledSql(java.lang.String functionInstalledSql)
void	setFunctionTemplatesToInstall(java.util.Map<java.lang.String,java.lang.String> functionTemplatesToInstall)
void	setNewTriggerValue(java.lang.String newTriggerValue)
void	setNumberColumnTemplate(java.lang.String numberColumnTemplate)
void	setOldTriggerValue(java.lang.String oldTriggerValue)
void	setSqlTemplates(java.util.Map<java.lang.String,java.lang.String> sqlTemplates)
void	setStringColumnTemplate(java.lang.String columnTemplate)
void	setTriggerConcatCharacter(java.lang.String triggerConcatCharacter)
void	setTriggerPrefix(java.lang.String triggerPrefix)

Methods inherited from class java.lang.Object

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

Constructor Detail

SqlTemplate

public SqlTemplate()

Method Detail

createInitalLoadSql

public java.lang.String createInitalLoadSql(Node node,
                                            IDbDialect dialect,
                                            Trigger trig,
                                            org.apache.ddlutils.model.Table metaData)

createPurgeSql

public java.lang.String createPurgeSql(Node node,
                                       IDbDialect dialect,
                                       Trigger trig,
                                       TriggerHistory hist)

createCsvDataSql

public java.lang.String createCsvDataSql(Trigger trig,
                                         org.apache.ddlutils.model.Table metaData,
                                         java.lang.String whereClause)

createCsvPrimaryKeySql

public java.lang.String createCsvPrimaryKeySql(Trigger trig,
                                               org.apache.ddlutils.model.Table metaData,
                                               java.lang.String whereClause)

getFunctionsToInstall

public java.lang.String[] getFunctionsToInstall()

createFunctionDDL

public java.lang.String createFunctionDDL(java.lang.String name)

createTriggerDDL

public java.lang.String createTriggerDDL(IDbDialect dialect,
                                         DataEventType dml,
                                         Trigger trigger,
                                         TriggerHistory history,
                                         java.lang.String tablePrefix,
                                         org.apache.ddlutils.model.Table metaData,
                                         java.lang.String defaultCatalog,
                                         java.lang.String defaultSchema)

TODO Document all the 'templated' values available for building triggers.

createPostTriggerDDL

public java.lang.String createPostTriggerDDL(IDbDialect dialect,
                                             DataEventType dml,
                                             Trigger trigger,
                                             TriggerHistory history,
                                             java.lang.String tablePrefix,
                                             org.apache.ddlutils.model.Table metaData,
                                             java.lang.String defaultCatalog,
                                             java.lang.String defaultSchema)

replaceTemplateVariables

public java.lang.String replaceTemplateVariables(IDbDialect dialect,
                                                 DataEventType dml,
                                                 Trigger trigger,
                                                 TriggerHistory history,
                                                 java.lang.String tablePrefix,
                                                 org.apache.ddlutils.model.Table metaData,
                                                 java.lang.String defaultCatalog,
                                                 java.lang.String defaultSchema,
                                                 java.lang.String ddl)

setStringColumnTemplate

public void setStringColumnTemplate(java.lang.String columnTemplate)

setDatetimeColumnTemplate

public void setDatetimeColumnTemplate(java.lang.String datetimeColumnTemplate)

setNumberColumnTemplate

public void setNumberColumnTemplate(java.lang.String numberColumnTemplate)

setSqlTemplates

public void setSqlTemplates(java.util.Map<java.lang.String,java.lang.String> sqlTemplates)

getClobColumnTemplate

public java.lang.String getClobColumnTemplate()

setClobColumnTemplate

public void setClobColumnTemplate(java.lang.String clobColumnTemplate)

setBooleanColumnTemplate

public void setBooleanColumnTemplate(java.lang.String booleanColumnTemplate)

setTriggerConcatCharacter

public void setTriggerConcatCharacter(java.lang.String triggerConcatCharacter)

getNewTriggerValue

public java.lang.String getNewTriggerValue()

setNewTriggerValue

public void setNewTriggerValue(java.lang.String newTriggerValue)

getOldTriggerValue

public java.lang.String getOldTriggerValue()

setOldTriggerValue

public void setOldTriggerValue(java.lang.String oldTriggerValue)

setTriggerPrefix

public void setTriggerPrefix(java.lang.String triggerPrefix)

getBlobColumnTemplate

public java.lang.String getBlobColumnTemplate()

setBlobColumnTemplate

public void setBlobColumnTemplate(java.lang.String blobColumnTemplate)

setFunctionInstalledSql

public void setFunctionInstalledSql(java.lang.String functionInstalledSql)

setFunctionTemplatesToInstall

public void setFunctionTemplatesToInstall(java.util.Map<java.lang.String,java.lang.String> functionTemplatesToInstall)

getFunctionSql

public java.lang.String getFunctionSql(java.lang.String functionName)

getFunctionInstalledSql

public java.lang.String getFunctionInstalledSql(java.lang.String functionName)