protected void getParamsData() {
wParams.clearAll(false);
ArrayList<String> paramNames = new ArrayList<String>(configuration.getParams().keySet());
Collections.sort(paramNames);
for (int i = 0; i < paramNames.size(); i++) {
String paramName = paramNames.get(i);
String paramValue = configuration.getParams().get(paramName);
String defaultValue;
try {
defaultValue = abstractMeta.getParameterDefault(paramName);
} catch (UnknownParamException e) {
defaultValue = "";
}
String description;
try {
description = abstractMeta.getParameterDescription(paramName);
} catch (UnknownParamException e) {
description = "";
}
TableItem tableItem = new TableItem(wParams.table, SWT.NONE);
tableItem.setText(1, paramName);
tableItem.setText(2, Const.NVL(defaultValue, ""));
tableItem.setText(3, Const.NVL(paramValue, ""));
tableItem.setText(4, Const.NVL(description, ""));
}
wParams.removeEmptyRows();
wParams.setRowNums();
wParams.optWidth(true);
}
public void loadXML(
Node entrynode,
List<DatabaseMeta> databases,
List<SlaveServer> slaveServers,
Repository rep,
IMetaStore metaStore)
throws KettleXMLException {
try {
super.loadXML(entrynode, databases, slaveServers);
String dbname = XMLHandler.getTagValue(entrynode, "connection");
connection = DatabaseMeta.findDatabase(databases, dbname);
schemaname = XMLHandler.getTagValue(entrynode, "schemaname");
tablename = XMLHandler.getTagValue(entrynode, "tablename");
successCondition =
getSucessConditionByCode(
Const.NVL(XMLHandler.getTagValue(entrynode, "success_condition"), ""));
limit = Const.NVL(XMLHandler.getTagValue(entrynode, "limit"), "0");
iscustomSQL = "Y".equalsIgnoreCase(XMLHandler.getTagValue(entrynode, "is_custom_sql"));
isUseVars = "Y".equalsIgnoreCase(XMLHandler.getTagValue(entrynode, "is_usevars"));
customSQL = XMLHandler.getTagValue(entrynode, "custom_sql");
isAddRowsResult = "Y".equalsIgnoreCase(XMLHandler.getTagValue(entrynode, "add_rows_result"));
isClearResultList =
"Y".equalsIgnoreCase(XMLHandler.getTagValue(entrynode, "clear_result_rows"));
} catch (KettleException e) {
throw new KettleXMLException(
BaseMessages.getString(PKG, "JobEntryEvalTableContent.UnableLoadXML"), e);
}
}
/** Copy information from the meta-data input to the dialog fields. */
public void getData() {
List<StreamInterface> infoStreams = input.getStepIOMeta().getInfoStreams();
wReference.setText(Const.NVL(infoStreams.get(0).getStepname(), ""));
wCompare.setText(Const.NVL(infoStreams.get(1).getStepname(), ""));
if (input.getFlagField() != null) {
wFlagfield.setText(input.getFlagField());
}
for (int i = 0; i < input.getKeyFields().length; i++) {
TableItem item = wKeys.table.getItem(i);
if (input.getKeyFields()[i] != null) {
item.setText(1, input.getKeyFields()[i]);
}
}
for (int i = 0; i < input.getValueFields().length; i++) {
TableItem item = wValues.table.getItem(i);
if (input.getValueFields()[i] != null) {
item.setText(1, input.getValueFields()[i]);
}
}
wStepname.selectAll();
wStepname.setFocus();
}
private void getTableName() {
DatabaseMeta inf = null;
// New class: SelectTableDialog
int connr = wConnection.getSelectionIndex();
if (connr >= 0) inf = transMeta.getDatabase(connr);
if (inf != null) {
logDebug(
BaseMessages.getString(PKG, "LucidDBBulkLoaderDialog.Log.LookingAtConnection")
+ inf.toString()); // $NON-NLS-1$
DatabaseExplorerDialog std =
new DatabaseExplorerDialog(shell, SWT.NONE, inf, transMeta.getDatabases());
std.setSelectedSchemaAndTable(wSchema.getText(), wTable.getText());
if (std.open()) {
wSchema.setText(Const.NVL(std.getSchemaName(), ""));
wTable.setText(Const.NVL(std.getTableName(), ""));
}
} else {
MessageBox mb = new MessageBox(shell, SWT.OK | SWT.ICON_ERROR);
mb.setMessage(
BaseMessages.getString(
PKG, "LucidDBBulkLoaderDialog.InvalidConnection.DialogMessage")); // $NON-NLS-1$
mb.setText(
BaseMessages.getString(
PKG, "LucidDBBulkLoaderDialog.InvalidConnection.DialogTitle")); // $NON-NLS-1$
mb.open();
}
}
private void getInfo(IngresVectorwiseLoaderMeta input) {
input.setDatabaseMeta(transMeta.findDatabase(serverConnection.getText()));
input.setTablename(wTable.getText());
input.setFifoFileName(wFifoFile.getText());
input.setSqlPath(wSqlPath.getText());
input.setUseSSV(wUseSSV.getSelection());
input.setEscapingSpecialCharacters(wEscapeSpecialChars.getSelection());
input.setUsingVwload(wUseVwload.getSelection());
input.setUseAuthentication(wUseAuthentication.getSelection());
input.setTruncatingTable(wTruncateTable.getSelection());
input.setDelimiter(wDelimiter.getText());
input.setEncoding(wCharSet.getText());
input.setBufferSize(wBufferSize.getText());
input.setUseStandardConversion(wUseStandardConversion.getSelection());
input.setContinueOnError(wContinueOnError.getSelection());
input.setErrorFileName(wErrorFile.getText());
input.setUseDynamicVNode(wUseDynamicVNode.getSelection());
input.setMaxNrErrors(wMaxErrors.getText());
int nrRows = wFields.nrNonEmpty();
input.allocate(nrRows);
// CHECKSTYLE:Indentation:OFF
for (int i = 0; i < nrRows; i++) {
TableItem item = wFields.getNonEmpty(i);
input.getFieldDatabase()[i] = Const.NVL(item.getText(1), "");
input.getFieldStream()[i] = Const.NVL(item.getText(2), "");
}
}
/** Copy information from the meta-data input to the dialog fields. */
public void getData() {
if (jobEntry.getName() != null) wName.setText(jobEntry.getName());
wName.selectAll();
if (jobEntry.getHostname() != null) wHostname.setText(jobEntry.getHostname());
wPort.setText(Const.NVL(jobEntry.getPort(), String.valueOf(JobEntryTelnet.DEFAULT_PORT)));
wTimeOut.setText(
Const.NVL(jobEntry.getTimeOut(), String.valueOf(JobEntryTelnet.DEFAULT_TIME_OUT)));
}
/** Copy information from the meta-data input to the dialog fields. */
public void getData() {
if (jobEntry.getName() != null) wName.setText(jobEntry.getName());
wName.selectAll();
wFilename.setText(Const.NVL(jobEntry.getFilename(), ""));
wMaximumTimeout.setText(Const.NVL(jobEntry.getMaximumTimeout(), ""));
wCheckCycleTime.setText(Const.NVL(jobEntry.getCheckCycleTime(), ""));
wSuccesOnTimeout.setSelection(jobEntry.isSuccessOnTimeout());
wFileSizeCheck.setSelection(jobEntry.isFileSizeCheck());
wAddFilenameResult.setSelection(jobEntry.isAddFilenameToResult());
}
/** Copy information from the meta-data input to the dialog fields. */
public void getData() {
wName.setText(Const.NVL(jobEntry.getName(), ""));
wMailAddress.setText(Const.NVL(jobEntry.getEmailAddress(), ""));
wTimeOut.setText(Const.NVL(jobEntry.getTimeOut(), "0"));
wSMTPCheck.setSelection(jobEntry.isSMTPCheck());
wDefaultSMTP.setText(Const.NVL(jobEntry.getDefaultSMTP(), ""));
weMailSender.setText(Const.NVL(jobEntry.geteMailSender(), ""));
wName.selectAll();
wName.setFocus();
}
/** Copy information from the meta-data input to the dialog fields. */
public void getData() {
int i;
if (isDebug())
logDebug(BaseMessages.getString(PKG, "RestDialog.Log.GettingKeyInfo")); // $NON-NLS-1$
if (input.getHeaderName() != null) {
for (i = 0; i < input.getHeaderName().length; i++) {
TableItem item = wFields.table.getItem(i);
if (input.getHeaderField()[i] != null) item.setText(1, input.getHeaderField()[i]);
if (input.getHeaderName()[i] != null) item.setText(2, input.getHeaderName()[i]);
}
}
if (input.getParameterField() != null) {
for (i = 0; i < input.getParameterField().length; i++) {
TableItem item = wParameters.table.getItem(i);
if (input.getParameterField()[i] != null) item.setText(1, input.getParameterField()[i]);
if (input.getParameterName()[i] != null) item.setText(2, input.getParameterName()[i]);
}
}
wMethod.setText(Const.NVL(input.getMethod(), RestMeta.HTTP_METHOD_GET));
wMethodInField.setSelection(input.isDynamicMethod());
if (input.getBodyField() != null) wBody.setText(input.getBodyField());
if (input.getMethodFieldName() != null) wMethodField.setText(input.getMethodFieldName());
if (input.getUrl() != null) wUrl.setText(input.getUrl());
wUrlInField.setSelection(input.isUrlInField());
if (input.getUrlField() != null) wUrlField.setText(input.getUrlField());
if (input.getFieldName() != null) wResult.setText(input.getFieldName());
if (input.getResultCodeFieldName() != null) wResultCode.setText(input.getResultCodeFieldName());
if (input.getResponseTimeFieldName() != null)
wResponseTime.setText(input.getResponseTimeFieldName());
if (input.getHttpLogin() != null) wHttpLogin.setText(input.getHttpLogin());
if (input.getHttpPassword() != null) wHttpPassword.setText(input.getHttpPassword());
if (input.getProxyHost() != null) wProxyHost.setText(input.getProxyHost());
if (input.getProxyPort() != null) wProxyPort.setText(input.getProxyPort());
wPreemptive.setSelection(input.isPreemptive());
if (input.getTrustStoreFile() != null) wTrustStoreFile.setText(input.getTrustStoreFile());
if (input.getTrustStorePassword() != null)
wTrustStorePassword.setText(input.getTrustStorePassword());
wApplicationType.setText(Const.NVL(input.getApplicationType(), ""));
wFields.setRowNums();
wFields.optWidth(true);
wStepname.selectAll();
}
@Override
protected void getInfo(SalesforceStepMeta in) throws KettleException {
SalesforceDeleteMeta meta = (SalesforceDeleteMeta) in;
stepname = wStepname.getText(); // return value
// copy info to SalesforceDeleteMeta class (input)
meta.setTargetURL(Const.NVL(wURL.getText(), SalesforceConnectionUtils.TARGET_DEFAULT_URL));
meta.setUsername(wUserName.getText());
meta.setPassword(wPassword.getText());
meta.setModule(wModule.getText());
meta.setDeleteField(wDeleteField.getText());
meta.setBatchSize(wBatchSize.getText());
meta.setCompression(wUseCompression.getSelection());
meta.setTimeout(Const.NVL(wTimeOut.getText(), "0"));
meta.setRollbackAllChangesOnError(wRollbackAllChangesOnError.getSelection());
}
private void readData(Node stepnode, List<? extends SharedObjectInterface> databases)
throws KettleXMLException {
try {
String csize;
String con = XMLHandler.getTagValue(stepnode, "connection");
databaseMeta = DatabaseMeta.findDatabase(databases, con);
csize = XMLHandler.getTagValue(stepnode, "commit");
commitSize = Const.toInt(csize, 0);
sqlField = XMLHandler.getTagValue(stepnode, "sql_field");
insertField = XMLHandler.getTagValue(stepnode, "insert_field");
updateField = XMLHandler.getTagValue(stepnode, "update_field");
deleteField = XMLHandler.getTagValue(stepnode, "delete_field");
readField = XMLHandler.getTagValue(stepnode, "read_field");
sqlFromfile = "Y".equalsIgnoreCase(XMLHandler.getTagValue(stepnode, "sqlFromfile"));
sendOneStatement =
"Y"
.equalsIgnoreCase(
Const.NVL(XMLHandler.getTagValue(stepnode, "sendOneStatement"), "Y"));
} catch (Exception e) {
throw new KettleXMLException(
BaseMessages.getString(PKG, "ExecSQLRowMeta.Exception.UnableToLoadStepInfoFromXML"), e);
}
}
public void loadRep(
Repository rep,
IMetaStore metaStore,
ObjectId id_jobentry,
List<DatabaseMeta> databases,
List<SlaveServer> slaveServers)
throws KettleException {
try {
connection =
rep.loadDatabaseMetaFromJobEntryAttribute(
id_jobentry, "connection", "id_database", databases);
schemaname = rep.getJobEntryAttributeString(id_jobentry, "schemaname");
tablename = rep.getJobEntryAttributeString(id_jobentry, "tablename");
successCondition =
getSuccessConditionByCode(
Const.NVL(rep.getJobEntryAttributeString(id_jobentry, "success_condition"), ""));
limit = rep.getJobEntryAttributeString(id_jobentry, "limit");
iscustomSQL = rep.getJobEntryAttributeBoolean(id_jobentry, "is_custom_sql");
isUseVars = rep.getJobEntryAttributeBoolean(id_jobentry, "is_usevars");
isAddRowsResult = rep.getJobEntryAttributeBoolean(id_jobentry, "add_rows_result");
isClearResultList = rep.getJobEntryAttributeBoolean(id_jobentry, "clear_result_rows");
customSQL = rep.getJobEntryAttributeString(id_jobentry, "custom_sql");
} catch (KettleDatabaseException dbe) {
throw new KettleException(
BaseMessages.getString(PKG, "JobEntryEvalTableContent.UnableLoadRep", "" + id_jobentry),
dbe);
}
}
@Override
public void loadRep(
Repository rep,
IMetaStore metaStore,
ObjectId id_jobentry,
List<DatabaseMeta> databases,
List<SlaveServer> slaveServers)
throws KettleException {
try {
connection =
rep.loadDatabaseMetaFromJobEntryAttribute(
id_jobentry, "connection", "id_database", databases);
schemaname = rep.getJobEntryAttributeString(id_jobentry, "schemaname");
tablename = rep.getJobEntryAttributeString(id_jobentry, "tablename");
successCondition =
getSuccessConditionByCode(
Const.NVL(rep.getJobEntryAttributeString(id_jobentry, "success_condition"), ""));
rowsCountValue = rep.getJobEntryAttributeString(id_jobentry, "rows_count_value");
iscustomSQL = rep.getJobEntryAttributeBoolean(id_jobentry, "is_custom_sql");
isUseVars = rep.getJobEntryAttributeBoolean(id_jobentry, "is_usevars");
isAddRowsResult = rep.getJobEntryAttributeBoolean(id_jobentry, "add_rows_result");
customSQL = rep.getJobEntryAttributeString(id_jobentry, "custom_sql");
maximumTimeout = rep.getJobEntryAttributeString(id_jobentry, "maximum_timeout");
checkCycleTime = rep.getJobEntryAttributeString(id_jobentry, "check_cycle_time");
successOnTimeout = rep.getJobEntryAttributeBoolean(id_jobentry, "success_on_timeout");
isClearResultList = rep.getJobEntryAttributeBoolean(id_jobentry, "clear_result_rows");
} catch (KettleDatabaseException dbe) {
throw new KettleException(
BaseMessages.getString(PKG, "JobEntryWaitForSQL.UnableLoadRep", "" + id_jobentry), dbe);
}
}
/** Load the Database Info */
public DatabaseMeta loadDatabaseMeta(ObjectId id_database) throws KettleException {
DatabaseMeta databaseMeta = new DatabaseMeta();
try {
RowMetaAndData r = getDatabase(id_database);
if (r != null) {
ObjectId id_database_type =
new LongObjectId(
r.getInteger(
KettleDatabaseRepository.FIELD_DATABASE_ID_DATABASE_TYPE, 0)); // con_type
String dbTypeDesc = getDatabaseTypeCode(id_database_type);
if (dbTypeDesc != null) {
databaseMeta.setDatabaseInterface(DatabaseMeta.getDatabaseInterface(dbTypeDesc));
databaseMeta.setAttributes(new Properties()); // new attributes
}
databaseMeta.setObjectId(id_database);
databaseMeta.setName(r.getString(KettleDatabaseRepository.FIELD_DATABASE_NAME, ""));
ObjectId id_database_contype =
new LongObjectId(
r.getInteger(
KettleDatabaseRepository.FIELD_DATABASE_ID_DATABASE_CONTYPE, 0)); // con_access
databaseMeta.setAccessType(
DatabaseMeta.getAccessType(getDatabaseConTypeCode(id_database_contype)));
databaseMeta.setHostname(
r.getString(KettleDatabaseRepository.FIELD_DATABASE_HOST_NAME, ""));
databaseMeta.setDBName(
r.getString(KettleDatabaseRepository.FIELD_DATABASE_DATABASE_NAME, ""));
databaseMeta.setDBPort(r.getString(KettleDatabaseRepository.FIELD_DATABASE_PORT, ""));
databaseMeta.setUsername(r.getString(KettleDatabaseRepository.FIELD_DATABASE_USERNAME, ""));
databaseMeta.setPassword(
Encr.decryptPasswordOptionallyEncrypted(
r.getString(KettleDatabaseRepository.FIELD_DATABASE_PASSWORD, "")));
databaseMeta.setServername(
r.getString(KettleDatabaseRepository.FIELD_DATABASE_SERVERNAME, ""));
databaseMeta.setDataTablespace(
r.getString(KettleDatabaseRepository.FIELD_DATABASE_DATA_TBS, ""));
databaseMeta.setIndexTablespace(
r.getString(KettleDatabaseRepository.FIELD_DATABASE_INDEX_TBS, ""));
// Also, load all the properties we can find...
final Collection<RowMetaAndData> attrs =
repository.connectionDelegate.getDatabaseAttributes(id_database);
for (RowMetaAndData row : attrs) {
String code = row.getString(KettleDatabaseRepository.FIELD_DATABASE_ATTRIBUTE_CODE, "");
String attribute =
row.getString(KettleDatabaseRepository.FIELD_DATABASE_ATTRIBUTE_VALUE_STR, "");
databaseMeta.getAttributes().put(code, Const.NVL(attribute, ""));
}
}
return databaseMeta;
} catch (KettleDatabaseException dbe) {
throw new KettleException(
"Error loading database connection from repository (id_database=" + id_database + ")",
dbe);
}
}
private String resolvePath(String rootPath, String entryPath) {
String extraPath = Const.NVL(entryPath, "/");
if (needToCheckPathForVariables()) {
if (containsVariables(entryPath)) {
return extraPath;
}
}
String newPath = Const.NVL(rootPath, "/");
if (newPath.endsWith("/") && extraPath.startsWith("/")) {
newPath = newPath.substring(0, newPath.length() - 1);
} else if (!newPath.endsWith("/") && !extraPath.startsWith("/")) {
newPath += "/";
} else if (extraPath.equals("/")) {
extraPath = "";
}
return newPath + extraPath;
}
/**
* Read the data from the TextFileInputMeta object and show it in this dialog.
*
* @param in The SalesforceDeleteMeta object to obtain the data from.
*/
public void getData(SalesforceDeleteMeta in) {
wURL.setText(Const.NVL(in.getTargetURL(), ""));
wUserName.setText(Const.NVL(in.getUsername(), ""));
wPassword.setText(Const.NVL(in.getPassword(), ""));
wBatchSize.setText(in.getBatchSize());
wModule.setText(Const.NVL(in.getModule(), "Account"));
if (in.getDeleteField() != null) {
wDeleteField.setText(in.getDeleteField());
}
wBatchSize.setText("" + in.getBatchSize());
wTimeOut.setText(Const.NVL(in.getTimeout(), SalesforceConnectionUtils.DEFAULT_TIMEOUT));
wUseCompression.setSelection(in.isCompression());
wRollbackAllChangesOnError.setSelection(in.isRollbackAllChangesOnError());
wStepname.selectAll();
wStepname.setFocus();
}
/** Copy information from the meta-data input to the dialog fields. */
public void getData() {
wAccField.setText(Const.NVL(input.getAcceptingField(), ""));
for (int i = 0; i < input.getOutputFields().size(); i++) {
SasInputField field = input.getOutputFields().get(i);
TableItem item = new TableItem(wFields.table, SWT.NONE);
int colnr = 1;
item.setText(colnr++, Const.NVL(field.getName(), ""));
item.setText(colnr++, Const.NVL(field.getRename(), ""));
item.setText(colnr++, ValueMeta.getTypeDesc(field.getType()));
item.setText(colnr++, Const.NVL(field.getConversionMask(), ""));
item.setText(colnr++, field.getLength() >= 0 ? Integer.toString(field.getLength()) : "");
item.setText(
colnr++, field.getPrecision() >= 0 ? Integer.toString(field.getPrecision()) : "");
item.setText(colnr++, Const.NVL(field.getDecimalSymbol(), ""));
item.setText(colnr++, Const.NVL(field.getGroupingSymbol(), ""));
item.setText(colnr++, Const.NVL(field.getTrimTypeDesc(), ""));
}
wFields.removeEmptyRows();
wFields.setRowNums();
wFields.optWidth(true);
wStepname.selectAll();
wStepname.setFocus();
}
private void getArgumentsData() {
wArguments.clearAll(false);
List<String> argumentNames = new ArrayList<String>(configuration.getArguments().keySet());
Collections.sort(argumentNames);
for (int i = 0; i < argumentNames.size(); i++) {
String argumentName = argumentNames.get(i);
String argumentValue = configuration.getArguments().get(argumentName);
TableItem tableItem = new TableItem(wArguments.table, SWT.NONE);
tableItem.setText(1, Const.NVL(argumentName, ""));
tableItem.setText(2, Const.NVL(argumentValue, ""));
}
wArguments.removeEmptyRows();
wArguments.setRowNums();
wArguments.optWidth(true);
}
/** Copy information from the meta-data input to the dialog fields. */
public void getData() {
if (input.getXslFilename() != null) {
wXSLFilename.setText(input.getXslFilename());
}
if (input.getResultfieldname() != null) {
wResultField.setText(input.getResultfieldname());
}
if (input.getFieldname() != null) {
wField.setText(input.getFieldname());
}
if (input.getXSLFileField() != null) {
wXSLField.setText(input.getXSLFileField());
}
wXSLFileField.setSelection(input.useXSLField());
wXSLFieldIsAFile.setSelection(input.isXSLFieldIsAFile());
if (input.getXSLFactory() != null) {
wXSLTFactory.setText(input.getXSLFactory());
} else {
wXSLTFactory.setText("JAXP");
}
if (input.getParameterName() != null) {
for (int i = 0; i < input.getParameterName().length; i++) {
TableItem item = wFields.table.getItem(i);
item.setText(1, Const.NVL(input.getParameterField()[i], ""));
item.setText(2, Const.NVL(input.getParameterName()[i], ""));
}
}
if (input.getOutputPropertyName() != null) {
for (int i = 0; i < input.getOutputPropertyName().length; i++) {
TableItem item = wOutputProperties.table.getItem(i);
item.setText(1, Const.NVL(input.getOutputPropertyName()[i], ""));
item.setText(2, Const.NVL(input.getOutputPropertyValue()[i], ""));
}
}
wStepname.selectAll();
wStepname.setFocus();
}
/* (non-Javadoc)
* @see org.pentaho.di.repository.RepositoryMeta#loadXML(org.w3c.dom.Node, java.util.List)
*/
public void loadXML(Node repnode, List<DatabaseMeta> databases) throws KettleException {
try {
// Fix for PDI-2508: migrating from 3.2 to 4.0 causes NPE on startup.
id = Const.NVL(XMLHandler.getTagValue(repnode, "id"), id);
name = XMLHandler.getTagValue(repnode, "name");
description = XMLHandler.getTagValue(repnode, "description");
} catch (Exception e) {
throw new KettleException("Unable to load repository meta object", e);
}
}
private void getByReferenceData(ObjectId transObjectId) {
try {
RepositoryObject transInf =
rep.getObjectInformation(transObjectId, RepositoryObjectType.TRANSFORMATION);
String fullPath =
Const.NVL(transInf.getRepositoryDirectory().getPath(), "")
+ "/"
+ Const.NVL(transInf.getName(), "");
wPath.setText(fullPath);
} catch (KettleException e) {
new ErrorDialog(
shell,
BaseMessages.getString(
PKG, "JobEntryTransDialog.Exception.UnableToReferenceObjectId.Title"),
BaseMessages.getString(
PKG, "JobEntryTransDialog.Exception.UnableToReferenceObjectId.Message"),
e);
}
}
private void getTableName() {
// New class: SelectTableDialog
int connr = wConnection.getSelectionIndex();
if (connr >= 0) {
DatabaseMeta inf = transMeta.getDatabase(connr);
DatabaseExplorerDialog std =
new DatabaseExplorerDialog(shell, SWT.NONE, inf, transMeta.getDatabases());
std.setSelectedSchemaAndTable(wSchemaname.getText(), wTablenameText.getText());
if (std.open()) {
wSchemaname.setText(Const.NVL(std.getSchemaName(), ""));
wTablenameText.setText(Const.NVL(std.getTableName(), ""));
}
} else {
MessageBox mb = new MessageBox(shell, SWT.OK | SWT.ICON_ERROR);
mb.setMessage(
BaseMessages.getString(PKG, "ColumnExistsDialog.ConnectionError2.DialogMessage"));
mb.setText(BaseMessages.getString(PKG, "System.Dialog.Error.Title"));
mb.open();
}
}
/** Copy information from the meta-data input to the dialog fields. */
public void getData() {
if (isDebug()) {
logDebug(BaseMessages.getString(PKG, "FuzzyMatchDialog.Log.GettingKeyInfo"));
}
wAlgorithm.setText(FuzzyMatchMeta.getAlgorithmTypeDesc(input.getAlgorithmType()));
if (input.getMainStreamField() != null) {
wMainStreamField.setText(input.getMainStreamField());
}
if (input.getLookupField() != null) {
wLookupField.setText(input.getLookupField());
}
wcaseSensitive.setSelection(input.isCaseSensitive());
wgetCloserValue.setSelection(input.isGetCloserValue());
if (input.getMinimalValue() != null) {
wminValue.setText(input.getMinimalValue());
}
if (input.getMaximalValue() != null) {
wmaxValue.setText(input.getMaximalValue());
}
if (input.getOutputMatchField() != null) {
wmatchField.setText(input.getOutputMatchField());
}
if (input.getOutputValueField() != null) {
wvalueField.setText(input.getOutputValueField());
}
if (input.getSeparator() != null) {
wseparator.setText(input.getSeparator());
}
if (input.getValue() != null) {
for (int i = 0; i < input.getValue().length; i++) {
TableItem item = wReturn.table.getItem(i);
if (input.getValue()[i] != null) {
item.setText(1, input.getValue()[i]);
}
if (input.getValueName()[i] != null
&& !input.getValueName()[i].equals(input.getValue()[i])) {
item.setText(2, input.getValueName()[i]);
}
}
}
StreamInterface infoStream = input.getStepIOMeta().getInfoStreams().get(0);
wStep.setText(Const.NVL(infoStream.getStepname(), ""));
wReturn.setRowNums();
wReturn.optWidth(true);
wStepname.selectAll();
wStepname.setFocus();
}
public void getData() {
wName.setText(Const.NVL(slaveServer.getName(), ""));
wHostname.setText(Const.NVL(slaveServer.getHostname(), ""));
wPort.setText(Const.NVL(slaveServer.getPort(), ""));
wWebAppName.setText(Const.NVL(slaveServer.getWebAppName(), ""));
wUsername.setText(Const.NVL(slaveServer.getUsername(), ""));
wPassword.setText(Const.NVL(slaveServer.getPassword(), ""));
wProxyHost.setText(Const.NVL(slaveServer.getProxyHostname(), ""));
wProxyPort.setText(Const.NVL(slaveServer.getProxyPort(), ""));
wNonProxyHosts.setText(Const.NVL(slaveServer.getNonProxyHosts(), ""));
wMaster.setSelection(slaveServer.isMaster());
wSSL.setSelection(slaveServer.isSslMode());
wName.setFocus();
}
public void readRep(
Repository rep, ObjectId id_step, List<DatabaseMeta> databases, Map<String, Counter> counters)
throws KettleException {
try {
int nrkeys = rep.countNrStepAttributes(id_step, "in_stream_name"); // $NON-NLS-1$
allocate(nrkeys);
for (int i = 0; i < nrkeys; i++) {
fieldInStream[i] =
Const.NVL(rep.getStepAttributeString(id_step, i, "in_stream_name"), ""); // $NON-NLS-1$
fieldOutStream[i] =
Const.NVL(rep.getStepAttributeString(id_step, i, "out_stream_name"), "");
cutFrom[i] =
Const.NVL(rep.getStepAttributeString(id_step, i, "cut_from"), ""); // $NON-NLS-1$
cutTo[i] = Const.NVL(rep.getStepAttributeString(id_step, i, "cut_to"), ""); // $NON-NLS-1$
}
} catch (Exception e) {
throw new KettleException(
BaseMessages.getString(PKG, "StringCutMeta.Exception.UnexpectedErrorInReadingStepInfo"),
e); //$NON-NLS-1$
}
}
public void readRep(
Repository rep, IMetaStore metaStore, ObjectId id_step, List<DatabaseMeta> databases)
throws KettleException {
try {
databaseMeta = rep.loadDatabaseMetaFromStepAttribute(id_step, "id_connection", databases);
tablename = rep.getStepAttributeString(id_step, "table");
fifoFileName = rep.getStepAttributeString(id_step, "fifo_file_name");
sqlPath = rep.getStepAttributeString(id_step, "sql_path");
encoding = rep.getStepAttributeString(id_step, "encoding");
delimiter = rep.getStepAttributeString(id_step, "delimiter");
continueOnError = rep.getStepAttributeBoolean(id_step, "continue_on_error");
errorFileName = rep.getStepAttributeString(id_step, "error_file_name");
useStandardConversion = rep.getStepAttributeBoolean(id_step, "use_standard_conversion");
useAuthentication = rep.getStepAttributeBoolean(id_step, "use_authentication");
useDynamicVNode = rep.getStepAttributeBoolean(id_step, "use_dynamic_vnode");
useSSV = rep.getStepAttributeBoolean(id_step, "use_SSV_delimiter");
escapingSpecialCharacters =
rep.getStepAttributeBoolean(id_step, 0, "escape_special_characters", true);
usingVwload = rep.getStepAttributeBoolean(id_step, "use_vwload");
maxNrErrors = rep.getStepAttributeString(id_step, "max_errors");
truncatingTable = rep.getStepAttributeBoolean(id_step, "truncate_table");
bufferSize = rep.getStepAttributeString(id_step, "buffer_size");
int nrCols = rep.countNrStepAttributes(id_step, "column_name");
int nrStreams = rep.countNrStepAttributes(id_step, "stream_name");
int nrRows = (nrCols < nrStreams ? nrStreams : nrCols);
allocate(nrRows);
for (int idx = 0; idx < nrRows; idx++) {
fieldDatabase[idx] = Const.NVL(rep.getStepAttributeString(id_step, idx, "column_name"), "");
fieldStream[idx] = Const.NVL(rep.getStepAttributeString(id_step, idx, "stream_name"), "");
}
} catch (Exception e) {
throw new KettleException("Unexpected error reading step information from the repository", e);
}
}
private void readData(Node stepnode) throws KettleXMLException {
try {
int nrkeys;
Node lookup = XMLHandler.getSubNode(stepnode, "fields"); // $NON-NLS-1$
nrkeys = XMLHandler.countNodes(lookup, "field"); // $NON-NLS-1$
allocate(nrkeys);
for (int i = 0; i < nrkeys; i++) {
Node fnode = XMLHandler.getSubNodeByNr(lookup, "field", i); // $NON-NLS-1$
fieldInStream[i] =
Const.NVL(XMLHandler.getTagValue(fnode, "in_stream_name"), ""); // $NON-NLS-1$
fieldOutStream[i] =
Const.NVL(XMLHandler.getTagValue(fnode, "out_stream_name"), ""); // $NON-NLS-1$
cutFrom[i] = Const.NVL(XMLHandler.getTagValue(fnode, "cut_from"), ""); // $NON-NLS-1$
cutTo[i] = Const.NVL(XMLHandler.getTagValue(fnode, "cut_to"), ""); // $NON-NLS-1$
}
} catch (Exception e) {
throw new KettleXMLException(
BaseMessages.getString(PKG, "StringCutMeta.Exception.UnableToReadStepInfoFromXML"),
e); //$NON-NLS-1$
}
}
/** Copy information from the meta-data input to the dialog fields. */
public void getData() {
String[] inputStepNames = joinMeta.getInputSteps();
if (inputStepNames != null) {
String inputStepName;
String[] keyFields = joinMeta.getKeyFields();
String keyField;
for (int i = 0; i < inputStepNames.length; i++) {
inputStepName = Const.NVL(inputStepNames[i], "");
wInputStepArray[i].setText(inputStepName);
keyField = Const.NVL(keyFields[i], "");
keyValTextBox[i].setText(keyField);
}
String joinType = joinMeta.getJoinType();
if (joinType != null && joinType.length() > 0) {
joinTypeCombo.setText(joinType);
} else {
joinTypeCombo.setText(MultiMergeJoinMeta.join_types[0]);
}
}
wStepname.selectAll();
wStepname.setFocus();
}
/** Copy information from the meta-data input to the dialog fields. */
public void getData() {
wStepname.setText(stepname);
wFilename.setText(Const.NVL(inputMeta.getFilename(), ""));
wLineWidth.setText(Const.NVL(inputMeta.getLineWidth(), ""));
wLineFeedPresent.setSelection(inputMeta.isLineFeedPresent());
wBufferSize.setText(Const.NVL(inputMeta.getBufferSize(), ""));
wLazyConversion.setSelection(inputMeta.isLazyConversionActive());
wHeaderPresent.setSelection(inputMeta.isHeaderPresent());
wRunningInParallel.setSelection(inputMeta.isRunningInParallel());
wFileType.setText(inputMeta.getFileTypeDesc());
wEncoding.setText(Const.NVL(inputMeta.getEncoding(), ""));
wAddResult.setSelection(inputMeta.isAddResultFile());
for (int i = 0; i < inputMeta.getFieldDefinition().length; i++) {
TableItem item = new TableItem(wFields.table, SWT.NONE);
int colnr = 1;
FixedFileInputField field = inputMeta.getFieldDefinition()[i];
item.setText(colnr++, Const.NVL(field.getName(), ""));
item.setText(colnr++, ValueMetaFactory.getValueMetaName(field.getType()));
item.setText(colnr++, Const.NVL(field.getFormat(), ""));
item.setText(colnr++, field.getWidth() >= 0 ? Integer.toString(field.getWidth()) : "");
item.setText(colnr++, field.getLength() >= 0 ? Integer.toString(field.getLength()) : "");
item.setText(
colnr++, field.getPrecision() >= 0 ? Integer.toString(field.getPrecision()) : "");
item.setText(colnr++, Const.NVL(field.getCurrency(), ""));
item.setText(colnr++, Const.NVL(field.getDecimal(), ""));
item.setText(colnr++, Const.NVL(field.getGrouping(), ""));
item.setText(colnr++, ValueMetaString.getTrimTypeCode(field.getTrimType()));
}
wFields.removeEmptyRows();
wFields.setRowNums();
wFields.optWidth(true);
enableFields();
wStepname.selectAll();
wStepname.setFocus();
}
/** Get the parameters from the dialog. */
protected void getInfoParameters() {
Map<String, String> map = new HashMap<String, String>();
int nrNonEmptyVariables = wParams.nrNonEmpty();
for (int i = 0; i < nrNonEmptyVariables; i++) {
TableItem tableItem = wParams.getNonEmpty(i);
String paramName = tableItem.getText(1);
String defaultValue = tableItem.getText(2);
String paramValue = tableItem.getText(3);
if (Const.isEmpty(paramValue)) {
paramValue = Const.NVL(defaultValue, "");
}
map.put(paramName, paramValue);
}
configuration.setParams(map);
}
