org.jumpmind.symmetric.db.SqlTemplate Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of symmetric-ds Show documentation
Show all versions of symmetric-ds Show documentation
SymmetricDS is an open source database synchronization solution. It is platform-independent,
web-enabled, and database-agnostic. SymmetricDS was first built to replicate changes between 'retail store'
databases and ad centralized 'corporate' database.
The newest version!
/*
* Licensed to JumpMind Inc under one or more contributor
* license agreements. See the NOTICE file distributed
* with this work for additional information regarding
* copyright ownership. JumpMind Inc licenses this file
* to you under the GNU Lesser General Public License (the
* "License"); you may not use this file except in compliance
* with the License.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, see
* sqlTemplates;
private Map functionTemplatesToInstall;
private String functionInstalledSql;
private String emptyColumnTemplate;
private String stringColumnTemplate;
private String xmlColumnTemplate;
private String numberColumnTemplate;
private String datetimeColumnTemplate;
private String timeColumnTemplate;
public String getTimeColumnTemplate() {
return timeColumnTemplate;
}
public void setTimeColumnTemplate(String timeColumnTemplate) {
this.timeColumnTemplate = timeColumnTemplate;
}
public String getDateColumnTemplate() {
return dateColumnTemplate;
}
public void setDateColumnTemplate(String dateColumnTemplate) {
this.dateColumnTemplate = dateColumnTemplate;
}
private String dateColumnTemplate;
private String clobColumnTemplate;
private String blobColumnTemplate;
private String wrappedBlobColumnTemplate;
private String booleanColumnTemplate;
private String triggerConcatCharacter;
private String newTriggerValue;
private String oldTriggerValue;
private String oldColumnPrefix = "";
private String newColumnPrefix = "";
public String createInitalLoadSql(Node node, IDbDialect dialect, TriggerRouter triggerRouter, Table metaData, TriggerHistory triggerHistory) {
String sql = sqlTemplates.get(INITIAL_LOAD_SQL_TEMPLATE);
Column[] columns = dialect.orderColumns(triggerHistory.getParsedColumnNames(), metaData);
String columnsText = buildColumnString(dialect, dialect.getInitialLoadTableAlias(), dialect.getInitialLoadTableAlias(),
"", columns, dialect, DataEventType.INSERT, false).columnString;
sql = AppUtils.replace("columns", columnsText, sql);
sql = AppUtils.replace("whereClause", StringUtils.isBlank(triggerRouter.getInitialLoadSelect()) ? "1=1" : triggerRouter.getInitialLoadSelect(), sql);
sql = AppUtils.replace("tableName", metaData.getName(), sql);
sql = AppUtils.replace("schemaName", triggerRouter.qualifiedSourceTablePrefix(), sql);
sql = AppUtils.replace("primaryKeyWhereString", getPrimaryKeyWhereString(dialect.getInitialLoadTableAlias(), metaData
.getPrimaryKeyColumns()), sql);
// Replace these parameters to give the initiaLoadContition a chance to
// reference the node that is being loaded
sql = AppUtils.replace("groupId", node.getNodeGroupId(), sql);
sql = AppUtils.replace("externalId", node.getExternalId(), sql);
sql = AppUtils.replace("nodeId", node.getNodeId(), sql);
return sql;
}
public String createCsvDataSql(IDbDialect dialect, Trigger trig, Table metaData, String whereClause) {
String sql = sqlTemplates.get(INITIAL_LOAD_SQL_TEMPLATE);
Column[] columns = trig.orderColumnsForTable(metaData);
String columnsText = buildColumnString(dialect, dialect.getInitialLoadTableAlias(), dialect.getInitialLoadTableAlias(),
"", columns, dialect, DataEventType.INSERT, false).columnString;
sql = AppUtils.replace("columns", columnsText, sql);
sql = AppUtils.replace("tableName", trig.getSourceTableName(), sql);
sql = AppUtils.replace("schemaName", trig.getSourceSchemaName() != null ? trig.getSourceSchemaName() + "." : "", sql);
sql = AppUtils.replace("whereClause", whereClause, sql);
sql = AppUtils.replace("primaryKeyWhereString", getPrimaryKeyWhereString(dialect.getInitialLoadTableAlias(), metaData
.getPrimaryKeyColumns()), sql);
return sql;
}
public String createCsvPrimaryKeySql(IDbDialect dialect, Trigger trig, Table metaData, String whereClause) {
String sql = sqlTemplates.get(INITIAL_LOAD_SQL_TEMPLATE);
Column[] columns = metaData.getPrimaryKeyColumns();
String columnsText = buildColumnString(dialect, dialect.getInitialLoadTableAlias(), dialect.getInitialLoadTableAlias(),
"", columns, dialect, DataEventType.INSERT, false).toString();
sql = AppUtils.replace("columns", columnsText, sql);
sql = AppUtils.replace("tableName", trig.getSourceTableName(), sql);
sql = AppUtils.replace("schemaName", trig.getSourceSchemaName() != null ? trig.getSourceSchemaName() + "." : "", sql);
sql = AppUtils.replace("whereClause", whereClause, sql);
sql = AppUtils.replace("primaryKeyWhereString", getPrimaryKeyWhereString(dialect.getInitialLoadTableAlias(), columns),
sql);
return sql;
}
public String[] getFunctionsToInstall() {
if (functionTemplatesToInstall != null) {
return functionTemplatesToInstall.keySet().toArray(new String[functionTemplatesToInstall.size()]);
} else {
return new String[0];
}
}
public String createTriggerDDL(IDbDialect dialect, DataEventType dml, Trigger trigger, TriggerHistory history,
String tablePrefix, Table metaData, String defaultCatalog, String defaultSchema) {
String ddl = sqlTemplates.get(dml.name().toLowerCase() + "TriggerTemplate");
if (ddl == null) {
throw new NotImplementedException(dml.name() + " trigger is not implemented for "
+ dialect.getPlatform().getName());
}
return replaceTemplateVariables(dialect, dml, trigger, history, tablePrefix, metaData, defaultCatalog,
defaultSchema, ddl);
}
public String createPostTriggerDDL(IDbDialect dialect, DataEventType dml, Trigger trigger, TriggerHistory history,
String tablePrefix, Table metaData, String defaultCatalog, String defaultSchema) {
String ddl = sqlTemplates.get(dml.name().toLowerCase() + "PostTriggerTemplate");
return replaceTemplateVariables(dialect, dml, trigger, history, tablePrefix, metaData, defaultCatalog,
defaultSchema, ddl);
}
private String getDefaultTargetTableName(Trigger trigger, TriggerHistory history) {
String targetTableName = null;
if (history != null) {
targetTableName = history.getSourceTableName();
} else {
targetTableName = trigger.getSourceTableName();
}
return targetTableName;
}
public String replaceTemplateVariables(IDbDialect dialect, DataEventType dml, Trigger trigger,
TriggerHistory history, String tablePrefix, Table metaData, String defaultCatalog, String defaultSchema,
String ddl) {
boolean resolveSchemaAndCatalogs = trigger.getSourceCatalogName() != null
|| trigger.getSourceSchemaName() != null;
ddl = AppUtils.replace("targetTableName", getDefaultTargetTableName(trigger, history), ddl);
ddl = AppUtils.replace("defaultSchema",
resolveSchemaAndCatalogs && defaultSchema != null && defaultSchema.length() > 0 ? defaultSchema + "."
: "", ddl);
ddl = AppUtils.replace("defaultCatalog", resolveSchemaAndCatalogs && defaultCatalog != null
&& defaultCatalog.length() > 0 ? defaultCatalog + "." : "", ddl);
ddl = AppUtils.replace("triggerName", history.getTriggerNameForDmlType(dml), ddl);
ddl = AppUtils.replace("prefixName", tablePrefix, ddl);
ddl = AppUtils.replace("channelName", trigger.getChannelId(), ddl);
ddl = AppUtils.replace("triggerHistoryId", Integer.toString(history == null ? -1 : history.getTriggerHistoryId()), ddl);
String triggerExpression = dialect.getTransactionTriggerExpression(defaultCatalog, defaultSchema, trigger);
if (dialect.isTransactionIdOverrideSupported() && !StringUtils.isBlank(trigger.getTxIdExpression())) {
triggerExpression = trigger.getTxIdExpression();
}
ddl = AppUtils.replace("txIdExpression", dialect.preProcessTriggerSqlClause(triggerExpression), ddl);
ddl = AppUtils.replace("externalSelect", (trigger.getExternalSelect() == null ? "null" : "(" + dialect.preProcessTriggerSqlClause(trigger.getExternalSelect()) + ")"), ddl);
ddl = AppUtils.replace("syncOnInsertCondition", dialect.preProcessTriggerSqlClause(trigger.getSyncOnInsertCondition()),
ddl);
ddl = AppUtils.replace("syncOnUpdateCondition", dialect.preProcessTriggerSqlClause(trigger.getSyncOnUpdateCondition()),
ddl);
ddl = AppUtils.replace("syncOnDeleteCondition", dialect.preProcessTriggerSqlClause(trigger.getSyncOnDeleteCondition()),
ddl);
ddl = AppUtils.replace("dataHasChangedCondition", dialect.preProcessTriggerSqlClause(dialect.getDataHasChangedCondition()),
ddl);
ddl = AppUtils.replace("sourceNodeExpression", dialect.getSourceNodeExpression(), ddl);
String syncTriggersExpression = dialect.getSyncTriggersExpression();
syncTriggersExpression = AppUtils.replace("defaultCatalog", resolveSchemaAndCatalogs && defaultCatalog != null
&& defaultCatalog.length() > 0 ? defaultCatalog + "." : "", syncTriggersExpression);
syncTriggersExpression = AppUtils.replace("defaultSchema", resolveSchemaAndCatalogs && defaultSchema != null
&& defaultSchema.length() > 0 ? defaultSchema + "." : "", syncTriggersExpression);
ddl = AppUtils.replace("syncOnIncomingBatchCondition", trigger.isSyncOnIncomingBatch() ? "1=1"
: syncTriggersExpression, ddl);
ddl = AppUtils.replace("origTableAlias", ORIG_TABLE_ALIAS, ddl);
Column[] columns = trigger.orderColumnsForTable(metaData);
ColumnString columnString = buildColumnString(dialect, ORIG_TABLE_ALIAS, newTriggerValue, newColumnPrefix, columns, dialect, dml, false);
ddl = AppUtils.replace("columns", columnString.toString(), ddl);
ddl = AppUtils.replace("virtualOldNewTable", buildVirtualTableSql(dialect, oldColumnPrefix, newColumnPrefix, metaData.getColumns()),
ddl);
ddl = AppUtils.replace("oldColumns", buildColumnString(dialect, ORIG_TABLE_ALIAS, oldTriggerValue, oldColumnPrefix, columns, dialect, dml, true).toString(), ddl);
ddl = eval(columnString.isBlobClob, "containsBlobClobColumns", ddl);
// some column templates need tableName and schemaName
ddl = AppUtils.replace("tableName", history == null ? trigger.getSourceTableName() : history.getSourceTableName(), ddl);
ddl = AppUtils.replace("schemaName", (history == null ? (resolveSchemaAndCatalogs
&& trigger.getSourceSchemaName() != null ? trigger.getSourceSchemaName() + "." : "")
: (resolveSchemaAndCatalogs && history.getSourceSchemaName() != null ? history.getSourceSchemaName()
+ "." : "")), ddl);
columns = metaData.getPrimaryKeyColumns();
ddl = AppUtils.replace("oldKeys", buildColumnString(dialect, ORIG_TABLE_ALIAS, oldTriggerValue, oldColumnPrefix, columns, dialect, dml, true).toString(), ddl);
ddl = AppUtils.replace("oldNewPrimaryKeyJoin", aliasedPrimaryKeyJoin(oldTriggerValue, newTriggerValue, columns), ddl);
ddl = AppUtils.replace("tableNewPrimaryKeyJoin", aliasedPrimaryKeyJoin(ORIG_TABLE_ALIAS, newTriggerValue, columns), ddl);
ddl = AppUtils.replace("primaryKeyWhereString", getPrimaryKeyWhereString(dml == DataEventType.DELETE ? oldTriggerValue : newTriggerValue, columns), ddl);
ddl = AppUtils.replace("declareOldKeyVariables", buildKeyVariablesDeclare(columns, "old"), ddl);
ddl = AppUtils.replace("declareNewKeyVariables", buildKeyVariablesDeclare(columns, "new"), ddl);
ddl = AppUtils.replace("oldKeyNames", buildColumnNameString(oldTriggerValue, columns), ddl);
ddl = AppUtils.replace("newKeyNames", buildColumnNameString(newTriggerValue, columns), ddl);
ddl = AppUtils.replace("oldKeyVariables", buildKeyVariablesString(columns, "old"), ddl);
ddl = AppUtils.replace("newKeyVariables", buildKeyVariablesString(columns, "new"), ddl);
ddl = AppUtils.replace("varNewPrimaryKeyJoin", aliasedPrimaryKeyJoinVar(newTriggerValue, "new", columns), ddl);
ddl = AppUtils.replace("varOldPrimaryKeyJoin", aliasedPrimaryKeyJoinVar(oldTriggerValue, "old", columns), ddl);
// replace $(newTriggerValue) and $(oldTriggerValue)
ddl = AppUtils.replace("newTriggerValue", newTriggerValue, ddl);
ddl = AppUtils.replace("oldTriggerValue", oldTriggerValue, ddl);
ddl = AppUtils.replace("newColumnPrefix", newColumnPrefix, ddl);
ddl = AppUtils.replace("oldColumnPrefix", oldColumnPrefix, ddl);
switch (dml) {
case DELETE:
ddl = AppUtils.replace("curTriggerValue", oldTriggerValue, ddl);
ddl = AppUtils.replace("curColumnPrefix", oldColumnPrefix, ddl);
break;
case INSERT:
case UPDATE:
default:
ddl = AppUtils.replace("curTriggerValue", newTriggerValue, ddl);
ddl = AppUtils.replace("curColumnPrefix", newColumnPrefix, ddl);
break;
}
return ddl;
}
private String buildVirtualTableSql(IDbDialect dialect, String oldTriggerValue, String newTriggerValue,
Column[] columns) {
if (oldTriggerValue.indexOf(".") >= 0) {
oldTriggerValue = oldTriggerValue.substring(oldTriggerValue.indexOf(".") + 1);
}
if (newTriggerValue.indexOf(".") >= 0) {
newTriggerValue = newTriggerValue.substring(newTriggerValue.indexOf(".") + 1);
}
StringBuilder b = new StringBuilder("(SELECT ");
for (Column columnType : columns) {
String column = columnType.getName();
b.append("? as ");
b.append("\"").append(newTriggerValue).append(column).append("\",");
}
for (Column columnType : columns) {
String column = columnType.getName();
b.append("? AS ");
b.append("\"").append(oldTriggerValue).append(column).append("\",");
}
b.deleteCharAt(b.length() - 1);
b.append(" FROM DUAL) T ");
return b.toString();
}
private String eval(boolean condition, String prop, String ddl) {
if (ddl != null) {
String ifStmt = "$(if:" + prop + ")";
String elseStmt = "$(else:" + prop + ")";
String endStmt = "$(end:" + prop + ")";
int ifIndex = ddl.indexOf(ifStmt);
if (ifIndex >= 0) {
int endIndex = ddl.indexOf(endStmt);
if (endIndex >= 0) {
String onTrue = ddl.substring(ifIndex + ifStmt.length(), endIndex);
String onFalse = "";
int elseIndex = onTrue.indexOf(elseStmt);
if (elseIndex >= 0) {
onFalse = onTrue.substring(elseIndex + elseStmt.length());
onTrue = onTrue.substring(0, elseIndex);
}
if (condition) {
ddl = ddl.substring(0, ifIndex) + onTrue + ddl.substring(endIndex + endStmt.length());
} else {
ddl = ddl.substring(0, ifIndex) + onFalse + ddl.substring(endIndex + endStmt.length());
}
} else {
throw new IllegalStateException(ifStmt + " has to have a " + endStmt);
}
}
}
return ddl;
}
private String aliasedPrimaryKeyJoin(String aliasOne, String aliasTwo, Column[] columns) {
StringBuilder b = new StringBuilder();
for (Column column : columns) {
b.append(aliasOne).append(".\"").append(column.getName()).append("\"");
b.append("=").append(aliasTwo).append(".\"").append(column.getName()).append("\"");
if (!column.equals(columns[columns.length - 1])) {
b.append(" and ");
}
}
return b.toString();
}
private String aliasedPrimaryKeyJoinVar(String alias, String prefix, Column[] columns) {
String text = "";
for (int i = 0; i < columns.length; i++) {
text += alias + ".\"" + columns[i].getName() + "\"";
text += "=@" + prefix + "pk" + i;
if (i + 1 < columns.length) {
text += " and ";
}
}
return text;
}
// TODO: move to DerbySqlTemplate or change language for use in all DBMSes
private String getPrimaryKeyWhereString(String alias, Column[] columns) {
StringBuilder b = new StringBuilder("'");
for (Column column : columns) {
b.append("\"").append(column.getName()).append("\"=");
switch (column.getTypeCode()) {
case Types.BIT:
case Types.TINYINT:
case Types.SMALLINT:
case Types.INTEGER:
case Types.BIGINT:
case Types.FLOAT:
case Types.REAL:
case Types.DOUBLE:
case Types.NUMERIC:
case Types.DECIMAL:
case Types.BOOLEAN:
b.append("'").append(triggerConcatCharacter);
b.append("rtrim(char(").append(alias).append(".\"").append(column.getName()).append("\"))");
b.append(triggerConcatCharacter).append("'");
break;
case Types.CHAR:
case Types.VARCHAR:
case Types.LONGVARCHAR:
b.append("'''").append(triggerConcatCharacter);
b.append(alias).append(".\"").append(column.getName()).append("\"");
b.append(triggerConcatCharacter).append("'''");
break;
case Types.DATE:
case Types.TIMESTAMP:
b.append("{ts '''").append(triggerConcatCharacter);
b.append("rtrim(char(").append(alias).append(".\"").append(column.getName()).append("\"))");
b.append(triggerConcatCharacter).append("'''}");
break;
}
if (!column.equals(columns[columns.length - 1])) {
b.append(" and ");
}
}
b.append("'");
return b.toString();
}
private ColumnString buildColumnString(IDbDialect dialect, String origTableAlias, String tableAlias, String columnPrefix, Column[] columns, IDbDialect dbDialect, DataEventType dml, boolean isOld) {
String columnsText = "";
boolean isBlobClob = false;
for (Column column : columns) {
if (column != null) {
String templateToUse = null;
switch (column.getTypeCode()) {
case Types.TINYINT:
case Types.SMALLINT:
case Types.INTEGER:
case Types.BIGINT:
case Types.FLOAT:
case Types.REAL:
case Types.DOUBLE:
case Types.NUMERIC:
case Types.DECIMAL:
templateToUse = numberColumnTemplate;
break;
case Types.CHAR:
case Types.VARCHAR:
case Types.LONGVARCHAR:
templateToUse = stringColumnTemplate;
break;
case Types.SQLXML:
templateToUse = xmlColumnTemplate;
break;
case Types.CLOB:
if (isOld && dbDialect.needsToSelectLobData()) {
templateToUse = emptyColumnTemplate;
} else {
templateToUse = clobColumnTemplate;
}
isBlobClob = true;
break;
case Types.BLOB:
if (dialect instanceof PostgreSqlDbDialect) {
templateToUse = wrappedBlobColumnTemplate;
isBlobClob = true;
break;
}
case Types.BINARY:
case Types.VARBINARY:
case Types.LONGVARBINARY:
// SQL-Server ntext binary type
case -10:
if (isOld && dbDialect.needsToSelectLobData()) {
templateToUse = emptyColumnTemplate;
} else {
templateToUse = blobColumnTemplate;
}
isBlobClob = true;
break;
case Types.DATE:
if (noDateColumnTemplate()) {
templateToUse = datetimeColumnTemplate;
break;
}
templateToUse = dateColumnTemplate;
break;
case Types.TIME:
if (noTimeColumnTemplate()) {
templateToUse = datetimeColumnTemplate;
break;
}
templateToUse = timeColumnTemplate;
break;
case Types.TIMESTAMP:
templateToUse = datetimeColumnTemplate;
break;
case Types.BOOLEAN:
case Types.BIT:
templateToUse = booleanColumnTemplate;
break;
case Types.NULL:
case Types.OTHER:
case Types.JAVA_OBJECT:
case Types.DISTINCT:
case Types.STRUCT:
case Types.REF:
case Types.DATALINK:
throw new NotImplementedException(column.getName() + " is of type "
+ column.getType());
}
if (dml == DataEventType.DELETE && isBlobClob
&& dbDialect instanceof MsSqlDbDialect) {
templateToUse = emptyColumnTemplate;
}
if (templateToUse != null) {
templateToUse = templateToUse.trim();
} else {
throw new NotImplementedException();
}
columnsText = columnsText
+ "\n "
+ AppUtils.replace("columnName", String.format("%s%s", columnPrefix, column
.getName()), templateToUse);
}
}
String lastCommandToken = triggerConcatCharacter + "','" + triggerConcatCharacter;
if (columnsText.endsWith(lastCommandToken)) {
columnsText = columnsText.substring(0, columnsText.length() - lastCommandToken.length());
}
// H2 (and maybe other embedded java triggers) escape the ' character so
// it may be inserted into the
// database as SQL that can be used by the trigger code.
lastCommandToken = triggerConcatCharacter + "'',''" + triggerConcatCharacter;
if (columnsText.endsWith(lastCommandToken)) {
columnsText = columnsText.substring(0, columnsText.length() - lastCommandToken.length());
}
columnsText = AppUtils.replace("origTableAlias", origTableAlias, columnsText);
columnsText = AppUtils.replace("tableAlias", tableAlias, columnsText);
return new ColumnString(columnsText, isBlobClob);
}
private boolean noTimeColumnTemplate() {
return timeColumnTemplate == null || timeColumnTemplate.equals("null") || timeColumnTemplate.trim().equals("");
}
private boolean noDateColumnTemplate() {
return dateColumnTemplate == null || dateColumnTemplate.equals("null") || dateColumnTemplate.trim().equals("");
}
private String buildColumnNameString(String tableAlias, Column[] columns) {
String columnsText = "";
for (int i = 0; i < columns.length; i++) {
columnsText += tableAlias + ".\"" + columns[i].getName() + "\"";
if (i + 1 < columns.length) {
columnsText += ", ";
}
}
return columnsText;
}
private String buildKeyVariablesDeclare(Column[] columns, String prefix) {
String text = "";
for (int i = 0; i < columns.length; i++) {
text += "declare @" + prefix + "pk" + i + " ";
switch (columns[i].getTypeCode()) {
case Types.TINYINT:
case Types.SMALLINT:
case Types.INTEGER:
case Types.BIGINT:
text += "bigint\n";
break;
case Types.NUMERIC:
case Types.DECIMAL:
text += "decimal\n";
break;
case Types.FLOAT:
case Types.REAL:
case Types.DOUBLE:
text += "float\n";
break;
case Types.CHAR:
case Types.VARCHAR:
case Types.LONGVARCHAR:
text += "varchar(1000)\n";
break;
case Types.DATE:
text += "date\n";
break;
case Types.TIME:
text += "time\n";
break;
case Types.TIMESTAMP:
text += "datetime\n";
break;
case Types.BOOLEAN:
case Types.BIT:
text += "bit\n";
break;
case Types.CLOB:
text += "varchar(max)\n";
break;
case Types.BLOB:
case Types.BINARY:
case Types.VARBINARY:
case Types.LONGVARBINARY:
case -10: // SQL-Server ntext binary type
text += "varbinary(max)\n";
break;
default:
throw new NotImplementedException(columns[i] + " is of type " + columns[i].getType());
}
}
return text;
}
private String buildKeyVariablesString(Column[] columns, String prefix) {
String text = "";
for (int i = 0; i < columns.length; i++) {
text += "@" + prefix + "pk" + i;
if (i + 1 < columns.length) {
text += ", ";
}
}
return text;
}
public void setStringColumnTemplate(String columnTemplate) {
this.stringColumnTemplate = columnTemplate;
}
public void setXmlColumnTemplate(String columnTemplate) {
this.xmlColumnTemplate = columnTemplate;
}
public void setDatetimeColumnTemplate(String datetimeColumnTemplate) {
this.datetimeColumnTemplate = datetimeColumnTemplate;
}
public void setNumberColumnTemplate(String numberColumnTemplate) {
this.numberColumnTemplate = numberColumnTemplate;
}
public void setSqlTemplates(Map sqlTemplates) {
this.sqlTemplates = sqlTemplates;
}
public String getClobColumnTemplate() {
return clobColumnTemplate;
}
public void setClobColumnTemplate(String clobColumnTemplate) {
this.clobColumnTemplate = clobColumnTemplate;
}
public void setBooleanColumnTemplate(String booleanColumnTemplate) {
this.booleanColumnTemplate = booleanColumnTemplate;
}
public void setTriggerConcatCharacter(String triggerConcatCharacter) {
this.triggerConcatCharacter = triggerConcatCharacter;
}
public String getNewTriggerValue() {
return newTriggerValue;
}
public void setNewTriggerValue(String newTriggerValue) {
this.newTriggerValue = newTriggerValue;
}
public String getOldTriggerValue() {
return oldTriggerValue;
}
public void setOldTriggerValue(String oldTriggerValue) {
this.oldTriggerValue = oldTriggerValue;
}
public String getBlobColumnTemplate() {
return blobColumnTemplate;
}
public void setBlobColumnTemplate(String blobColumnTemplate) {
this.blobColumnTemplate = blobColumnTemplate;
}
public String getWrappedBlobColumnTemplate() {
return wrappedBlobColumnTemplate;
}
public void setWrappedBlobColumnTemplate(String wrappedBlobColumnTemplate) {
this.wrappedBlobColumnTemplate = wrappedBlobColumnTemplate;
}
public void setFunctionInstalledSql(String functionInstalledSql) {
this.functionInstalledSql = functionInstalledSql;
}
public void setFunctionTemplatesToInstall(Map functionTemplatesToInstall) {
this.functionTemplatesToInstall = functionTemplatesToInstall;
}
public void setOldColumnPrefix(String oldColumnPrefix) {
this.oldColumnPrefix = oldColumnPrefix;
}
public void setEmptyColumnTemplate(String emptyColumnTemplate) {
this.emptyColumnTemplate = emptyColumnTemplate;
}
public void setNewColumnPrefix(String newColumnPrefix) {
this.newColumnPrefix = newColumnPrefix;
}
public String getFunctionSql(String functionKey, String functionName, String defaultSchema) {
if (this.functionTemplatesToInstall != null) {
String ddl = AppUtils.replace("functionName", functionName, this.functionTemplatesToInstall.get(functionKey));
ddl = AppUtils.replace("version", Version.versionWithUnderscores(), ddl);
ddl = AppUtils.replace("defaultSchema",
defaultSchema != null && defaultSchema.length() > 0 ? defaultSchema + "." : "", ddl);
return ddl;
} else {
return null;
}
}
public String getFunctionInstalledSql(String functionName, String defaultSchema) {
if (functionInstalledSql != null) {
String ddl = AppUtils.replace("functionName", functionName, functionInstalledSql);
ddl = AppUtils.replace("version", Version.versionWithUnderscores(), ddl);
ddl = AppUtils.replace("defaultSchema",
defaultSchema != null && defaultSchema.length() > 0 ? defaultSchema + "." : "", ddl);
return ddl;
} else {
return null;
}
}
private class ColumnString {
String columnString;
boolean isBlobClob = false;
ColumnString(String columnExpression, boolean isBlobClob) {
this.columnString = columnExpression;
this.isBlobClob = isBlobClob;
}
public String toString() {
return StringUtils.isBlank(columnString) ? "null" : columnString;
}
}
}