/**
* DataCleaner (community edition)
* Copyright (C) 2014 Neopost - Customer Information Management
*
* This copyrighted material is made available to anyone wishing to use, modify,
* copy, or redistribute it subject to the terms and conditions of the GNU
* Lesser General Public License, as published by the Free Software Foundation.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
* or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License
* for more details.
*
* You should have received a copy of the GNU Lesser General Public License
* along with this distribution; if not, write to:
* Free Software Foundation, Inc.
* 51 Franklin Street, Fifth Floor
* Boston, MA 02110-1301 USA
*/
package org.datacleaner.panels.insertintotable;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.datacleaner.api.InputColumn;
import org.datacleaner.beans.writers.InsertIntoTableAnalyzer;
import org.datacleaner.bootstrap.WindowContext;
import org.datacleaner.configuration.DataCleanerConfiguration;
import org.datacleaner.connection.Datastore;
import org.datacleaner.descriptors.AnalyzerDescriptor;
import org.datacleaner.descriptors.ConfiguredPropertyDescriptor;
import org.datacleaner.guice.DCModule;
import org.datacleaner.job.builder.AnalyzerComponentBuilder;
import org.datacleaner.job.builder.ComponentBuilder;
import org.datacleaner.panels.AnalyzerComponentBuilderPanel;
import org.datacleaner.panels.ConfiguredPropertyTaskPane;
import org.datacleaner.panels.TransformerComponentBuilderPresenter;
import org.datacleaner.util.IconUtils;
import org.datacleaner.widgets.properties.MultipleMappedColumnsPropertyWidget;
import org.datacleaner.widgets.properties.MultipleMappedPrefixedColumnsPropertyWidget;
import org.datacleaner.widgets.properties.PropertyWidget;
import org.datacleaner.widgets.properties.PropertyWidgetFactory;
import org.datacleaner.widgets.properties.SchemaNamePropertyWidget;
import org.datacleaner.widgets.properties.SingleDatastorePropertyWidget;
import org.datacleaner.widgets.properties.SingleTableNamePropertyWidget;
/**
* Specialized {@link TransformerComponentBuilderPresenter} for the
* {@link InsertIntoTableAnalyzer}.
*/
class InsertIntoTableJobBuilderPresenter extends AnalyzerComponentBuilderPanel {
private static final long serialVersionUID = 1L;
private final Map<ConfiguredPropertyDescriptor, PropertyWidget<?>> _overriddenPropertyWidgets;
private final ConfiguredPropertyDescriptor _schemaNameProperty;
private final ConfiguredPropertyDescriptor _tableNameProperty;
private final ConfiguredPropertyDescriptor _datastoreProperty;
private final ConfiguredPropertyDescriptor _inputColumnsProperty;
private final ConfiguredPropertyDescriptor _columnNamesProperty;
private final ConfiguredPropertyDescriptor _errorHandlingProperty;
private final ConfiguredPropertyDescriptor _errorFileLocationProperty;
private final ConfiguredPropertyDescriptor _additionalErrorLogValuesProperty;
private final ConfiguredPropertyDescriptor _bufferSizeProperty;
private final ConfiguredPropertyDescriptor _truncateTableProperty;
public InsertIntoTableJobBuilderPresenter(
final AnalyzerComponentBuilder<InsertIntoTableAnalyzer> analyzerJobBuilder,
final WindowContext windowContext, final PropertyWidgetFactory propertyWidgetFactory,
final DataCleanerConfiguration configuration, final DCModule dcModule) {
super(analyzerJobBuilder, propertyWidgetFactory);
_overriddenPropertyWidgets = new HashMap<>();
final AnalyzerDescriptor<InsertIntoTableAnalyzer> descriptor = analyzerJobBuilder.getDescriptor();
assert descriptor.getComponentClass() == InsertIntoTableAnalyzer.class;
_datastoreProperty = descriptor.getConfiguredProperty("Datastore");
_schemaNameProperty = descriptor.getConfiguredProperty("Schema name");
_tableNameProperty = descriptor.getConfiguredProperty("Table name");
_inputColumnsProperty = descriptor.getConfiguredProperty("Values");
_columnNamesProperty = descriptor.getConfiguredProperty("Column names");
_bufferSizeProperty = descriptor.getConfiguredProperty("Buffer size");
_truncateTableProperty = descriptor.getConfiguredProperty("Truncate table");
_errorHandlingProperty = descriptor.getConfiguredProperty("How to handle insertion errors?");
_errorFileLocationProperty = descriptor.getConfiguredProperty("Error log file location");
_additionalErrorLogValuesProperty = descriptor.getConfiguredProperty("Additional error log values");
// the Datastore property
assert _datastoreProperty != null;
assert _datastoreProperty.getType() == Datastore.class;
final SingleDatastorePropertyWidget datastorePropertyWidget =
new SingleDatastorePropertyWidget(analyzerJobBuilder, _datastoreProperty,
configuration.getDatastoreCatalog(), dcModule);
datastorePropertyWidget.setOnlyUpdatableDatastores(true);
_overriddenPropertyWidgets.put(_datastoreProperty, datastorePropertyWidget);
// The schema name (String) property
final SchemaNamePropertyWidget schemaNamePropertyWidget =
new SchemaNamePropertyWidget(analyzerJobBuilder, _schemaNameProperty);
_overriddenPropertyWidgets.put(_schemaNameProperty, schemaNamePropertyWidget);
// The table name (String) property
final SingleTableNamePropertyWidget tableNamePropertyWidget =
new SingleTableNamePropertyWidget(analyzerJobBuilder, _tableNameProperty, windowContext);
_overriddenPropertyWidgets.put(_tableNameProperty, tableNamePropertyWidget);
// the InputColumn<?>[] property
assert _inputColumnsProperty != null;
assert _inputColumnsProperty.getType() == InputColumn[].class;
final MultipleMappedColumnsPropertyWidget inputColumnsPropertyWidget =
new MultipleMappedPrefixedColumnsPropertyWidget(analyzerJobBuilder, _inputColumnsProperty,
_columnNamesProperty, " → ");
_overriddenPropertyWidgets.put(_inputColumnsProperty, inputColumnsPropertyWidget);
// the String[] property
assert _columnNamesProperty != null;
assert _columnNamesProperty.getType() == String[].class;
_overriddenPropertyWidgets
.put(_columnNamesProperty, inputColumnsPropertyWidget.getMappedColumnNamesPropertyWidget());
// chain combo boxes
datastorePropertyWidget.connectToSchemaNamePropertyWidget(schemaNamePropertyWidget);
schemaNamePropertyWidget.connectToTableNamePropertyWidget(tableNamePropertyWidget);
// update the column combo boxes when the table is selected
tableNamePropertyWidget.addComboListener(inputColumnsPropertyWidget::setTable);
// initialize
schemaNamePropertyWidget.setDatastore(datastorePropertyWidget.getValue());
tableNamePropertyWidget.setSchema(datastorePropertyWidget.getValue(), schemaNamePropertyWidget.getSchema());
inputColumnsPropertyWidget.setTable(tableNamePropertyWidget.getTable());
}
@Override
protected List<ConfiguredPropertyTaskPane> createPropertyTaskPanes() {
final ConfiguredPropertyTaskPane taskPane =
new ConfiguredPropertyTaskPane("Insert mapping", "images/model/column.png",
Arrays.asList(_datastoreProperty, _schemaNameProperty, _tableNameProperty,
_inputColumnsProperty, _truncateTableProperty, _bufferSizeProperty));
final ConfiguredPropertyTaskPane errorHandlingPane =
new ConfiguredPropertyTaskPane("Error handling", IconUtils.STATUS_WARNING,
Arrays.asList(_errorHandlingProperty, _errorFileLocationProperty,
_additionalErrorLogValuesProperty), false);
final List<ConfiguredPropertyTaskPane> propertyTaskPanes = new ArrayList<>();
propertyTaskPanes.add(taskPane);
propertyTaskPanes.add(errorHandlingPane);
return propertyTaskPanes;
}
@Override
protected PropertyWidget<?> createPropertyWidget(final ComponentBuilder componentBuilder,
final ConfiguredPropertyDescriptor propertyDescriptor) {
if (_overriddenPropertyWidgets.containsKey(propertyDescriptor)) {
return _overriddenPropertyWidgets.get(propertyDescriptor);
}
return super.createPropertyWidget(componentBuilder, propertyDescriptor);
}
}