/
AdditiveColumnTransform.java
131 lines (111 loc) · 5.18 KB
/
AdditiveColumnTransform.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
package org.jumpmind.symmetric.io.data.transform;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import org.apache.commons.lang.StringUtils;
import org.jumpmind.db.model.Column;
import org.jumpmind.db.model.Table;
import org.jumpmind.db.platform.IDatabasePlatform;
import org.jumpmind.extension.IBuiltInExtensionPoint;
import org.jumpmind.symmetric.io.data.DataContext;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
public class AdditiveColumnTransform implements ISingleValueColumnTransform, IBuiltInExtensionPoint {
static final Logger log = LoggerFactory.getLogger(AdditiveColumnTransform.class);
public static final String NAME = "additive";
public String getName() {
return NAME;
}
public boolean isExtractColumnTransform() {
return false;
}
public boolean isLoadColumnTransform() {
return true;
}
public String getFullyQualifiedTableName(IDatabasePlatform platform, String schema, String catalog, String tableName) {
String quote = platform.getDdlBuilder().isDelimitedIdentifierModeOn() ? platform
.getDatabaseInfo().getDelimiterToken() : "";
tableName = quote + tableName + quote;
if (!StringUtils.isBlank(schema)) {
tableName = schema + "." + tableName;
}
if (!StringUtils.isBlank(catalog)) {
tableName = catalog + "." + tableName;
}
return tableName;
}
public String transform(IDatabasePlatform platform, DataContext context,
TransformColumn column, TransformedData data, Map<String, String> sourceValues, String newValue, String oldValue) throws IgnoreColumnException,
IgnoreRowException {
BigDecimal multiplier = new BigDecimal(1.00);
if (StringUtils.isNotBlank(column.getTransformExpression())) {
multiplier = new BigDecimal(column.getTransformExpression());
}
Table table = platform.getTableFromCache(data.getCatalogName(), data.getSchemaName(),
data.getTableName(), false);
if (table == null) {
if (log.isDebugEnabled()) {
log.debug("Could not find the target table {}" , data.getFullyQualifiedTableName());
}
throw new IgnoreColumnException();
} else if (table.getColumnWithName(column.getTargetColumnName()) == null) {
if (log.isDebugEnabled()) {
log.debug("Could not find the target column {}" , column.getTargetColumnName());
}
throw new IgnoreColumnException();
} else {
if (log.isDebugEnabled()) {
log.debug("Old, new, transform expression as received: "+oldValue+", "+newValue+", "+column.getTransformExpression());
}
if (!StringUtils.isNotBlank(newValue)) {
newValue="0";
}
if (!StringUtils.isNotBlank(oldValue)) {
oldValue="0";
}
BigDecimal delta = new BigDecimal(newValue);
delta = delta.subtract(new BigDecimal(oldValue));
delta = delta.multiply(multiplier);
newValue = delta.toString();
String quote = platform.getDdlBuilder().isDelimitedIdentifierModeOn() ? platform
.getDatabaseInfo().getDelimiterToken() : "";
StringBuilder sql = new StringBuilder(String.format("update %s set %s=%s+(%s) where ",
getFullyQualifiedTableName(platform, data.getSchemaName(), data.getCatalogName(), data.getTableName()),
quote + column.getTargetColumnName() + quote,
quote + column.getTargetColumnName() + quote,
newValue));
String[] keyNames = data.getKeyNames();
List<Column> columns = new ArrayList<Column>();
List<String> keyValuesList = new ArrayList<String>();
boolean addedFirstKey = false;
for (int i = 0; i < keyNames.length; i++) {
Column targetCol = table.getColumnWithName(keyNames[i]);
if (targetCol != null) {
columns.add(targetCol);
keyValuesList.add(sourceValues.get(keyNames[i]));
if (addedFirstKey) {
sql.append("and ");
} else {
addedFirstKey = true;
}
sql.append(quote);
sql.append(keyNames[i]);
sql.append(quote);
sql.append("=? ");
}
}
if (log.isDebugEnabled()) {
log.debug("SQL: "+sql);
}
if (0 < platform.getSqlTemplate().update(
sql.toString(),
platform.getObjectValues(context.getBatch().getBinaryEncoding(),
keyValuesList.toArray(new String[keyValuesList.size()]),
columns.toArray(new Column[columns.size()])))) {
throw new IgnoreColumnException();
}
}
return newValue;
}
}