org.jumpmind.symmetric.load.StatementBuilder 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
* keySet = new HashSet();
CollectionUtils.addAll(keySet, keys);
int n = 0;
for (int i = 0; i < columns.length; i++) {
Column column = columns[i];
if (!keySet.contains(column)) {
columnsWithoutKeys[n++] = column;
}
}
return columnsWithoutKeys;
}
protected int[] buildTypes(Column[] keys, Column[] columns, boolean isDateOverrideToTimestamp) {
int[] columnTypes = buildTypes(columns, isDateOverrideToTimestamp);
int[] keyTypes = buildTypes(keys, isDateOverrideToTimestamp);
return ArrayUtils.addAll(columnTypes, keyTypes);
}
protected int[] buildTypes(Column[] columns, boolean isDateOverrideToTimestamp) {
ArrayList list = new ArrayList(columns.length);
for (int i = 0; i < columns.length; i++) {
if (columns[i] != null) {
list.add(columns[i].getTypeCode());
}
}
int[] types = new int[list.size()];
int index = 0;
for (Integer type : list) {
if (type == Types.DATE && isDateOverrideToTimestamp) {
type = Types.TIMESTAMP;
} else if (type == Types.FLOAT || type == Types.DOUBLE) {
type = Types.DECIMAL;
}
types[index++] = type;
}
return types;
}
public String buildInsertSql(String tableName, String[] columnNames) {
StringBuilder sql = new StringBuilder("insert into " + tableName + "(");
appendColumns(sql, columnNames);
sql.append(") values (");
appendColumnQuestions(sql, columnNames.length);
sql.append(")");
return sql.toString();
}
public String buildInsertSql(String tableName, Column[] columns) {
StringBuilder sql = new StringBuilder("insert into " + tableName + "(");
int columnCount = appendColumns(sql, columns);
sql.append(") values (");
appendColumnQuestions(sql, columnCount);
sql.append(")");
return sql.toString();
}
public String buildUpdateSql(String tableName, String[] keyNames, String[] columnNames) {
StringBuilder sql = new StringBuilder("update ").append(tableName).append(" set ");
appendColumnEquals(sql, columnNames, ", ");
sql.append(" where ");
appendColumnEquals(sql, keyNames, " and ");
return sql.toString();
}
public String buildUpdateSql(String tableName, Column[] keyColumns, Column[] columns) {
StringBuilder sql = new StringBuilder("update ").append(tableName).append(" set ");
appendColumnEquals(sql, columns, ", ");
sql.append(" where ");
appendColumnEquals(sql, keyColumns, " and ");
return sql.toString();
}
public String buildDeleteSql(String tableName, String[] keyNames) {
StringBuilder sql = new StringBuilder("delete from ").append(tableName).append(" where ");
appendColumnEquals(sql, keyNames, " and ");
return sql.toString();
}
public String buildDeleteSql(String tableName, Column[] keyColumns) {
StringBuilder sql = new StringBuilder("delete from ").append(tableName).append(" where ");
appendColumnEquals(sql, keyColumns, " and ");
return sql.toString();
}
public String buildCountSql(String tableName, Column[] keyColumns) {
StringBuilder sql = new StringBuilder("select count(*) from ").append(tableName).append(
" where ");
appendColumnEquals(sql, keyColumns, " and ");
return sql.toString();
}
public void appendColumnEquals(StringBuilder sql, String[] names, String separator) {
for (int i = 0; i < names.length; i++) {
sql.append(quote).append(names[i]).append(quote).append(" = ?").append(
i + 1 < names.length ? separator : "");
}
}
public void appendColumnEquals(StringBuilder sql, Column[] columns, String separator) {
int existingCount = 0;
for (int i = 0; i < columns.length; i++) {
if (columns[i] != null) {
if (existingCount++ > 0) {
sql.append(separator);
}
sql.append(quote).append(columns[i].getName()).append(quote).append(" = ?");
}
}
}
public void appendColumns(StringBuilder sql, String[] names) {
for (int i = 0; i < names.length; i++) {
sql.append(quote).append(names[i]).append(quote)
.append(i + 1 < names.length ? "," : "");
}
}
public int appendColumns(StringBuilder sql, Column[] columns) {
int existingCount = 0;
for (int i = 0; i < columns.length; i++) {
if (columns[i] != null) {
if (existingCount++ > 0) {
sql.append(",");
}
sql.append(quote).append(columns[i].getName()).append(quote);
}
}
return existingCount;
}
public void appendColumnQuestions(StringBuilder sql, int number) {
for (int i = 0; i < number; i++) {
sql.append("?").append(i + 1 < number ? "," : "");
}
}
public String getSql() {
return sql;
}
public DmlType getDmlType() {
return dmlType;
}
public int[] getTypes() {
return types;
}
public Column[] getColumns() {
return columns;
}
public Column[] getColumnKeyMetaData(boolean prefiltered) {
if (prefiltered) {
return (Column[]) ArrayUtils.addAll(preFilteredColumns, keys);
} else {
return (Column[]) ArrayUtils.addAll(columns, keys);
}
}
public Column[] getMetaData(boolean prefiltered) {
switch (dmlType) {
case UPDATE:
case UPDATE_NO_KEYS:
return getColumnKeyMetaData(prefiltered);
case INSERT:
return getColumns();
case DELETE:
return getKeys();
}
return null;
}
public Column[] getKeys() {
return keys;
}
public Column[] getPreFilteredColumns() {
return preFilteredColumns;
}
}