private void getInfo(LucidDBBulkLoaderMeta inf) { int nrfields = wReturn.nrNonEmpty(); inf.allocate(nrfields); inf.setMaxErrors(Const.toInt(wMaxErrors.getText(), 0)); logDebug( BaseMessages.getString( PKG, "LucidDBBulkLoaderDialog.Log.FoundFields", "" + nrfields)); // $NON-NLS-1$ //$NON-NLS-2$ for (int i = 0; i < nrfields; i++) { TableItem item = wReturn.getNonEmpty(i); inf.getFieldTable()[i] = item.getText(1); inf.getFieldStream()[i] = item.getText(2); inf.getFieldFormatOk()[i] = "Y".equalsIgnoreCase(item.getText(3)); } inf.setSchemaName(wSchema.getText()); inf.setTableName(wTable.getText()); inf.setDatabaseMeta(transMeta.findDatabase(wConnection.getText())); inf.setFifoDirectory(wFifoPath.getText()); inf.setFifoServerName(wFifoServer.getText()); stepname = wStepname.getText(); // return value }
/** Copy information from the meta-data input to the dialog fields. */ public void getData() { int i; logDebug( BaseMessages.getString(PKG, "LucidDBBulkLoaderDialog.Log.GettingKeyInfo")); // $NON-NLS-1$ wMaxErrors.setText("" + input.getMaxErrors()); // $NON-NLS-1$ if (input.getFieldTable() != null) { for (i = 0; i < input.getFieldTable().length; i++) { TableItem item = wReturn.table.getItem(i); if (input.getFieldTable()[i] != null) item.setText(1, input.getFieldTable()[i]); if (input.getFieldStream()[i] != null) item.setText(2, input.getFieldStream()[i]); item.setText(3, input.getFieldFormatOk()[i] ? "Y" : "N"); } } if (input.getDatabaseMeta() != null) wConnection.setText(input.getDatabaseMeta().getName()); else { if (transMeta.nrDatabases() == 1) { wConnection.setText(transMeta.getDatabase(0).getName()); } } if (input.getSchemaName() != null) wSchema.setText(input.getSchemaName()); if (input.getTableName() != null) wTable.setText(input.getTableName()); if (input.getFifoDirectory() != null) wFifoPath.setText(input.getFifoDirectory()); if (input.getFifoServerName() != null) wFifoServer.setText(input.getFifoServerName()); wStepname.selectAll(); wReturn.setRowNums(); wReturn.optWidth(true); }
private void fillStoredData() { if (stepname != null) textStepName.setText(stepname); int index = addConnectionLine.indexOf( meta.getDatabaseMeta() != null ? meta.getDatabaseMeta().getName() : ""); if (index >= 0) addConnectionLine.select(index); if (meta.getDimension() != null) { comboDimension.add(meta.getDimension()); comboDimension.select(0); } buttonBaseElementsOnly.setSelection(meta.getBaseElementsOnly()); tableViewFields.table.removeAll(); if (meta.getLevels().size() > 0) { for (PaloDimensionLevel level : meta.getLevels()) { tableViewFields.add( level.getLevelName(), String.valueOf(level.getLevelNumber()), level.getFieldName(), level.getFieldType()); } tableViewFields.setRowNums(); tableViewFields.optWidth(true); } }
public void getInfo(SasInputMeta meta) throws KettleStepException { // copy info to Meta class (input) meta.setAcceptingField(wAccField.getText()); int nrNonEmptyFields = wFields.nrNonEmpty(); meta.getOutputFields().clear(); for (int i = 0; i < nrNonEmptyFields; i++) { TableItem item = wFields.getNonEmpty(i); int colnr = 1; SasInputField field = new SasInputField(); field.setName(item.getText(colnr++)); field.setRename(item.getText(colnr++)); if (Const.isEmpty(field.getRename())) { field.setRename(field.getName()); } field.setType(ValueMeta.getType(item.getText(colnr++))); field.setConversionMask(item.getText(colnr++)); field.setLength(Const.toInt(item.getText(colnr++), -1)); field.setPrecision(Const.toInt(item.getText(colnr++), -1)); field.setDecimalSymbol(item.getText(colnr++)); field.setGroupingSymbol(item.getText(colnr++)); field.setTrimType(ValueMeta.getTrimTypeByDesc(item.getText(colnr++))); meta.getOutputFields().add(field); } wFields.removeEmptyRows(); wFields.setRowNums(); wFields.optWidth(true); }
private void ok() { if (Const.isEmpty(wStepname.getText())) { return; } stepname = wStepname.getText(); // return value if (transMeta.findDatabase(wConnection.getText()) == null) { int answer = showDatabaseWarning(true); if (answer == SWT.CANCEL) { return; } } // check tablecount Set<String> tables = new HashSet<String>(); int nrParameters = wOutput.nrNonEmpty(); for (int i = 0; i < nrParameters; i++) { TableItem item = wOutput.getNonEmpty(i); String tableName = item.getText(3); tables.add(tableName); } if (tables.size() > 1) { int answer = showMultipleOutputTablesWarning(true); if (answer == SWT.CANCEL) { return; } } getInfo(input); dispose(); }
public void dispose() { props.setScreen(new WindowProperty(shell)); bounds = shell.getBounds(); hscroll = wFields.getHorizontalBar().getSelection(); vscroll = wFields.getVerticalBar().getSelection(); shell.dispose(); }
/** Copy information from the meta-data input to the dialog fields. */ public void getData() { int i; logDebug(BaseMessages.getString(PKG, "DBProcDialog.Log.GettingKeyInfo")); // $NON-NLS-1$ if (input.getArgument() != null) for (i = 0; i < input.getArgument().length; i++) { TableItem item = wFields.table.getItem(i); if (input.getArgument()[i] != null) item.setText(1, input.getArgument()[i]); if (input.getArgumentDirection()[i] != null) item.setText(2, input.getArgumentDirection()[i]); item.setText(3, ValueMeta.getTypeDesc(input.getArgumentType()[i])); } if (input.getDatabase() != null) wConnection.setText(input.getDatabase().getName()); else if (transMeta.nrDatabases() == 1) { wConnection.setText(transMeta.getDatabase(0).getName()); } if (input.getProcedure() != null) wProcName.setText(input.getProcedure()); if (input.getResultName() != null) wResult.setText(input.getResultName()); wResultType.setText(ValueMeta.getTypeDesc(input.getResultType())); wAutoCommit.setSelection(input.isAutoCommit()); wFields.setRowNums(); wFields.optWidth(true); wStepname.selectAll(); }
private void ok() { stepname = wStepname.getText(); String formatKey = getFormatKey(wInputFormat.getText()); input.setInputFormat(formatKey); List<GisInputFormatParameter> inputFormatParameters = new ArrayList<GisInputFormatParameter>(); for (int i = 0; i < wParams.nrNonEmpty(); i++) { TableItem tableItem = wParams.getNonEmpty(i); String paramKey = getParamKey(formatKey, tableItem.getText(1)); if (tableItem.getText(3) != null && !tableItem.getText(3).isEmpty()) { String value = getParamValueKey(formatKey, paramKey, tableItem.getText(3)); inputFormatParameters.add(new GisInputFormatParameter(paramKey, value)); } else { inputFormatParameters.add(new GisInputFormatParameter(paramKey, "")); } } input.setInputFormatParameters(inputFormatParameters); input.setInputFileName(wFileName.getText()); input.setGeometryFieldName(wGeometryField.getText()); input.setEncoding(wEncoding.getText()); input.setRowLimit(Long.valueOf(wRowLimit.getText())); dispose(); }
private void populateTableWithTupleTemplate() { Table table = m_fieldsView.table; Set<String> existingRowAliases = new HashSet<String>(); for (int i = 0; i < table.getItemCount(); i++) { TableItem tableItem = table.getItem(i); String alias = tableItem.getText(1); if (!Const.isEmpty(alias)) { existingRowAliases.add(alias); } } int choice = 0; if (existingRowAliases.size() > 0) { // Ask what we should do with existing mapping data MessageDialog md = new MessageDialog( m_shell, Messages.getString("MappingDialog.GetFieldsChoice.Title"), null, Messages.getString( "MappingDialog.GetFieldsChoice.Message", "" + existingRowAliases.size(), "" + 5), MessageDialog.WARNING, new String[] { Messages.getString("MappingOutputDialog.ClearAndAdd"), Messages.getString("MappingOutputDialog.Cancel"), }, 0); MessageDialog.setDefaultImage(GUIResource.getInstance().getImageSpoon()); int idx = md.open(); choice = idx & 0xFF; } if (choice == 1 || choice == 255 /* 255 = escape pressed */) { return; // Cancel } m_fieldsView.clearAll(); TableItem item = new TableItem(table, SWT.NONE); item.setText(1, "KEY"); item.setText(2, "Y"); item = new TableItem(table, SWT.NONE); item.setText(1, "Family"); item.setText(2, "N"); item.setText(5, "String"); item = new TableItem(table, SWT.NONE); item.setText(1, "Column"); item.setText(2, "N"); item = new TableItem(table, SWT.NONE); item.setText(1, "Value"); item.setText(2, "N"); item = new TableItem(table, SWT.NONE); item.setText(1, "Timestamp"); item.setText(2, "N"); item.setText(5, "Long"); m_fieldsView.removeEmptyRows(); m_fieldsView.setRowNums(); m_fieldsView.optWidth(true); }
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), ""); } }
private void ok() { if (Const.isEmpty(wName.getText())) { MessageBox mb = new MessageBox(shell, SWT.OK | SWT.ICON_ERROR); mb.setText(BaseMessages.getString(PKG, "System.StepJobEntryNameMissing.Title")); mb.setMessage(BaseMessages.getString(PKG, "System.JobEntryNameMissing.Msg")); mb.open(); return; } jobEntry.setName(wName.getText()); int nritems = wFields.nrNonEmpty(); jobEntry.connections = new DatabaseMeta[nritems]; jobEntry.waitfors = new String[nritems]; jobEntry.waittimes = new int[nritems]; for (int i = 0; i < nritems; i++) { String arg = wFields.getNonEmpty(i).getText(1); DatabaseMeta dbMeta = jobMeta.findDatabase(arg); if (dbMeta != null) { jobEntry.connections[i] = dbMeta; jobEntry.waitfors[i] = "" + Const.toInt(wFields.getNonEmpty(i).getText(2), 0); jobEntry.waittimes[i] = JobEntryCheckDbConnections.getWaitTimeByDesc(wFields.getNonEmpty(i).getText(3)); } } dispose(); }
private void ok() { if (Const.isEmpty(wStepname.getText())) return; stepname = wStepname.getText(); // return value // copy info to TextFileInputMeta class (input) input.setSql(wSQL.getText()); input.setDatabaseMeta(transMeta.findDatabase(wConnection.getText())); input.setExecutedEachInputRow(wEachRow.getSelection()); input.setSingleStatement(wSingleStatement.getSelection()); input.setVariableReplacementActive(wVariables.getSelection()); input.setQuoteString(wQuoteString.getSelection()); input.setParams(wSetParams.getSelection()); input.setInsertField(wInsertField.getText()); input.setUpdateField(wUpdateField.getText()); input.setDeleteField(wDeleteField.getText()); input.setReadField(wReadField.getText()); int nrargs = wFields.nrNonEmpty(); input.allocate(nrargs); if (log.isDebug()) logDebug(BaseMessages.getString(PKG, "ExecSQLDialog.Log.FoundArguments", +nrargs + "")); for (int i = 0; i < nrargs; i++) { TableItem item = wFields.getNonEmpty(i); input.getArguments()[i] = item.getText(1); } if (input.getDatabaseMeta() == null) { MessageBox mb = new MessageBox(shell, SWT.OK | SWT.ICON_ERROR); mb.setMessage(BaseMessages.getString(PKG, "ExecSQLDialog.InvalidConnection.DialogMessage")); mb.setText(BaseMessages.getString(PKG, "ExecSQLDialog.InvalidConnection.DialogTitle")); mb.open(); } dispose(); }
private void ok() { if (Const.isEmpty(wStepname.getText())) { return; } List<StreamInterface> infoStreams = input.getStepIOMeta().getInfoStreams(); infoStreams.get(0).setStepMeta(transMeta.findStep(wReference.getText())); infoStreams.get(1).setStepMeta(transMeta.findStep(wCompare.getText())); input.setFlagField(wFlagfield.getText()); int nrKeys = wKeys.nrNonEmpty(); int nrValues = wValues.nrNonEmpty(); input.allocate(nrKeys, nrValues); // CHECKSTYLE:Indentation:OFF for (int i = 0; i < nrKeys; i++) { TableItem item = wKeys.getNonEmpty(i); input.getKeyFields()[i] = item.getText(1); } // CHECKSTYLE:Indentation:OFF for (int i = 0; i < nrValues; i++) { TableItem item = wValues.getNonEmpty(i); input.getValueFields()[i] = item.getText(1); } stepname = wStepname.getText(); // return value dispose(); }
private void ok() { if (Const.isEmpty(wStepname.getText())) return; stepname = wStepname.getText(); // return value input.setReplaceAllByValue(wReplaceByValue.getText()); input.setReplaceAllMask(wMask.getText()); input.setSelectFields(wSelectFields.getSelection()); input.setSelectValuesType(wSelectValuesType.getSelection()); int nrtypes = wValueTypes.nrNonEmpty(); int nrfields = wFields.nrNonEmpty(); input.allocate(nrtypes, nrfields); for (int i = 0; i < nrtypes; i++) { TableItem ti = wValueTypes.getNonEmpty(i); input.getTypeName()[i] = ti.getText(1); input.getTypeReplaceValue()[i] = ti.getText(2); input.getTypeReplaceMask()[i] = ti.getText(3); } for (int i = 0; i < nrfields; i++) { TableItem ti = wFields.getNonEmpty(i); input.getFieldName()[i] = ti.getText(1); input.getReplaceValue()[i] = ti.getText(2); input.getReplaceMask()[i] = ti.getText(3); } dispose(); }
/** Copy information from the meta-data input to the dialog fields. */ public void getData() { wStepname.setText(stepname); for (int i = 0; i < input.getFieldCCType().length; i++) { TableItem item = wFields.table.getItem(i); String type = input.getFieldCCType()[i]; String len = input.getFieldCCLength()[i]; String size = input.getFieldCCSize()[i]; if (type != null) item.setText(1, type); if (len != null) item.setText(2, len); if (size != null) item.setText(3, size); } wFields.setRowNums(); wFields.optWidth(true); if (input.getCardNumberFieldName() != null) wCCNumberField.setText(input.getCardNumberFieldName()); if (input.getCardTypeFieldName() != null) wCCTypeField.setText(input.getCardTypeFieldName()); if (input.getCardLengthFieldName() != null) wCCLengthField.setText(input.getCardLengthFieldName()); wStepname.selectAll(); }
/** Copy information from the meta-data input to the dialog fields. */ public void getData() { super.getData(); hasOneTemporalField = ((LoadSatMeta) inputMeta).getFromDateColumn() != null; enableFields(); if (inputMeta.getFields() != null) { for (int i = 0; i < inputMeta.getFields().length; i++) { TableItem item = wKey.table.getItem(i); if (inputMeta.getCols()[i] != null) { item.setText(1, inputMeta.getCols()[i]); } if (inputMeta.getFields()[i] != null) { item.setText(2, inputMeta.getFields()[i]); } if (inputMeta.getTypes()[i] != null) { item.setText(3, inputMeta.getTypes()[i]); } } } if (((LoadSatMeta) inputMeta).getToDateColumn() != null) { wcbToDateCol.setText(((LoadSatMeta) inputMeta).getToDateColumn()); } if (((LoadSatMeta) inputMeta).getToDateMaxFlag() != null) { wToDateMax.setText(((LoadSatMeta) inputMeta).getToDateMaxFlag()); } wbIsIdempotentSat.setSelection(((LoadSatMeta) inputMeta).isIdempotent()); wKey.setRowNums(); wKey.optWidth(true); wStepname.selectAll(); wStepname.setFocus(); }
private void ok() { stepname = wStepname.getText(); // return value input.setXslFilename(wXSLFilename.getText()); input.setResultfieldname(wResultField.getText()); input.setFieldname(wField.getText()); input.setXSLFileField(wXSLField.getText()); input.setXSLFactory(wXSLTFactory.getText()); input.setXSLField(wXSLFileField.getSelection()); input.setXSLFieldIsAFile(wXSLFieldIsAFile.getSelection()); int nrparams = wFields.nrNonEmpty(); int nroutputprops = wOutputProperties.nrNonEmpty(); input.allocate(nrparams, nroutputprops); if (isDebug()) { logDebug( BaseMessages.getString(PKG, "HTTPDialog.Log.FoundArguments", String.valueOf(nrparams))); } // CHECKSTYLE:Indentation:OFF for (int i = 0; i < nrparams; i++) { TableItem item = wFields.getNonEmpty(i); input.getParameterField()[i] = item.getText(1); input.getParameterName()[i] = item.getText(2); } // CHECKSTYLE:Indentation:OFF for (int i = 0; i < nroutputprops; i++) { TableItem item = wOutputProperties.getNonEmpty(i); input.getOutputPropertyName()[i] = item.getText(1); input.getOutputPropertyValue()[i] = item.getText(2); } dispose(); }
private void ok() { if (Const.isEmpty(wStepname.getText())) { return; } int sizegroup = wGroup.nrNonEmpty(); int nrfields = wAgg.nrNonEmpty(); input.setAlwaysGivingBackOneRow(wAlwaysAddResult.getSelection()); input.allocate(sizegroup, nrfields); // CHECKSTYLE:Indentation:OFF for (int i = 0; i < sizegroup; i++) { TableItem item = wGroup.getNonEmpty(i); input.getGroupField()[i] = item.getText(1); } // CHECKSTYLE:Indentation:OFF for (int i = 0; i < nrfields; i++) { TableItem item = wAgg.getNonEmpty(i); input.getAggregateField()[i] = item.getText(1); input.getSubjectField()[i] = item.getText(2); input.getAggregateType()[i] = MemoryGroupByMeta.getType(item.getText(3)); input.getValueField()[i] = item.getText(4); } stepname = wStepname.getText(); dispose(); }
/** 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 getInfo(StepsMetricsMeta in) { stepname = wStepname.getText(); // return value int nrsteps = wFields.nrNonEmpty(); in.allocate(nrsteps); for (int i = 0; i < nrsteps; i++) { TableItem ti = wFields.getNonEmpty(i); StepMeta tm = transMeta.findStep(ti.getText(1)); // CHECKSTYLE:Indentation:OFF if (tm != null) { in.getStepName()[i] = tm.getName(); in.getStepCopyNr()[i] = "" + Const.toInt(ti.getText(2), 0); in.getStepRequired()[i] = in.getRequiredStepsCode(ti.getText(3)); } } in.setStepNameFieldName(wStepnameField.getText()); in.setStepIdFieldName(wStepidField.getText()); in.setStepLinesInputFieldName(wLinesinputField.getText()); in.setStepLinesOutputFieldName(wLinesoutputField.getText()); in.setStepLinesReadFieldName(wLinesreadField.getText()); in.setStepLinesWrittenFieldName(wLineswrittenField.getText()); in.setStepLinesUpdatedFieldName(wLinesupdatedField.getText()); in.setStepLinesErrorsFieldName(wLineserrorsField.getText()); in.setStepSecondsFieldName(wSecondsField.getText()); }
/** * This helper method puts the step configuration stored in the meta object and puts it into the * dialog controls. */ private void populateDialog() { wRemoveBlanks.setSelection(meta.isConsecutiveDelimsAsOne()); if (meta.getSourceFields() != null) { for (int i = 0; i < meta.getSourceFields().length; i++) { TableItem item = wGroup.table.getItem(i); if (meta.getSourceFields()[i] != null) { item.setText(1, meta.getSourceFields()[i]); } if (meta.getSourceDelims()[i] != null) { item.setText(2, meta.getSourceDelims()[i]); } if (meta.getOutputFields()[i] != null) { item.setText(3, meta.getOutputFields()[i]); } if (meta.getOutputDelims()[i] != null) { item.setText(4, meta.getOutputDelims()[i]); } } } wGroup.setRowNums(); wGroup.optWidth(true); wStepname.selectAll(); wStepname.setFocus(); }
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); }
private void ok() { if (Const.isEmpty(wStepname.getText())) { return; } stepname = wStepname.getText(); // return value input.setEmptyStringAll(wSetEmptyStringAll.getSelection()); if (wSetEmptyStringAll.getSelection()) { input.setReplaceAllByValue(""); input.setReplaceAllMask(""); } else { input.setReplaceAllByValue(wReplaceByValue.getText()); input.setReplaceAllMask(wMask.getText()); } input.setSelectFields(wSelectFields.getSelection()); input.setSelectValuesType(wSelectValuesType.getSelection()); int nrtypes = wValueTypes.nrNonEmpty(); int nrfields = wFields.nrNonEmpty(); input.allocate(nrtypes, nrfields); // CHECKSTYLE:Indentation:OFF for (int i = 0; i < nrtypes; i++) { TableItem ti = wValueTypes.getNonEmpty(i); input.getValueTypes()[i].setTypeName(ti.getText(1)); input.getValueTypes()[i].setTypeEmptyString( BaseMessages.getString(PKG, "System.Combo.Yes").equalsIgnoreCase(ti.getText(4))); if (input.getValueTypes()[i].isSetTypeEmptyString()) { input.getValueTypes()[i].setTypereplaceValue(""); input.getValueTypes()[i].setTypereplaceMask(""); } else { input.getValueTypes()[i].setTypereplaceValue(ti.getText(2)); input.getValueTypes()[i].setTypereplaceMask(ti.getText(3)); } } // CHECKSTYLE:Indentation:OFF for (int i = 0; i < nrfields; i++) { TableItem ti = wFields.getNonEmpty(i); input.getFields()[i].setFieldName(ti.getText(1)); input.getFields()[i].setEmptyString( BaseMessages.getString(PKG, "System.Combo.Yes").equalsIgnoreCase(ti.getText(4))); if (input.getFields()[i].isSetEmptyString()) { input.getFields()[i].setReplaceValue(""); input.getFields()[i].setReplaceMask(""); } else { input.getFields()[i].setReplaceValue(ti.getText(2)); input.getFields()[i].setReplaceMask(ti.getText(3)); } } dispose(); }
private void ok() { if (Utils.isEmpty(wStepname.getText())) { return; } input.setMainStreamField(wMainStreamField.getText()); input.setLookupField(wLookupField.getText()); input.setAlgorithmType(FuzzyMatchMeta.getAlgorithmTypeByDesc(wAlgorithm.getText())); input.setCaseSensitive(wcaseSensitive.getSelection()); input.setGetCloserValue(wgetCloserValue.getSelection()); input.setMaximalValue(wmaxValue.getText()); input.setMinimalValue(wminValue.getText()); input.setOutputMatchField(wmatchField.getText()); input.setOutputValueField(wvalueField.getText()); input.setSeparator(wseparator.getText()); int nrvalues = wReturn.nrNonEmpty(); input.allocate(nrvalues); if (isDebug()) { logDebug(BaseMessages.getString(PKG, "FuzzyMatchDialog.Log.FoundFields", nrvalues + "")); } // CHECKSTYLE:Indentation:OFF for (int i = 0; i < nrvalues; i++) { TableItem item = wReturn.getNonEmpty(i); input.getValue()[i] = item.getText(1); input.getValueName()[i] = item.getText(2); if (input.getValueName()[i] == null || input.getValueName()[i].length() == 0) { input.getValueName()[i] = input.getValue()[i]; } } StreamInterface infoStream = input.getStepIOMeta().getInfoStreams().get(0); infoStream.setStepMeta(transMeta.findStep(wStep.getText())); if (infoStream.getStepMeta() == null) { MessageBox mb = new MessageBox(shell, SWT.OK | SWT.ICON_ERROR); if (Utils.isEmpty(wStep.getText())) { mb.setMessage( BaseMessages.getString( PKG, "FuzzyMatchDialog.NotStepSpecified.DialogMessage", wStep.getText())); } else { mb.setMessage( BaseMessages.getString( PKG, "FuzzyMatchDialog.StepCanNotFound.DialogMessage", wStep.getText())); } mb.setText(BaseMessages.getString(PKG, "FuzzyMatchDialog.StepCanNotFound.DialogTitle")); mb.open(); } stepname = wStepname.getText(); // return value dispose(); }
private void activeFields() { wlFields.setEnabled(wSelectFields.getSelection()); wFields.setEnabled(wSelectFields.getSelection()); wGet.setEnabled(wSelectFields.getSelection()); wlValueTypes.setEnabled(wSelectValuesType.getSelection()); wValueTypes.setEnabled(wSelectValuesType.getSelection()); wlReplaceByValue.setEnabled(!wSelectFields.getSelection() && !wSelectValuesType.getSelection()); wReplaceByValue.setEnabled(!wSelectFields.getSelection() && !wSelectValuesType.getSelection()); wlMask.setEnabled(!wSelectFields.getSelection() && !wSelectValuesType.getSelection()); wMask.setEnabled(!wSelectFields.getSelection() && !wSelectValuesType.getSelection()); }
protected void ok() { setCheckboxFlag(); if (Const.isOSX()) { // OSX bug workaround. wVariables.applyOSXChanges(); wParams.applyOSXChanges(); } getInfo(); retval = true; dispose(); }
public void getDatabases() { wFields.removeAll(); for (int i = 0; i < jobMeta.nrDatabases(); i++) { DatabaseMeta ci = jobMeta.getDatabase(i); if (ci != null) { wFields.add(new String[] {ci.getName(), "0", JobEntryCheckDbConnections.unitTimeDesc[0]}); } } wFields.removeEmptyRows(); wFields.setRowNums(); wFields.optWidth(true); }
/** 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(); }
/** Copy information from the meta-data input to the dialog fields. */ public void getData() { wStoreValues.setSelection(input.getStoreValues()); for (int i = 0; i < input.getCompareFields().length; i++) { TableItem item = wFields.table.getItem(i); if (input.getCompareFields()[i] != null) item.setText(1, input.getCompareFields()[i]); } wFields.setRowNums(); wFields.optWidth(true); wStepname.selectAll(); }
public void setMapping(Mapping mapping) { if (mapping == null) { return; } m_fieldsView.clearAll(); // do the key first TableItem keyItem = new TableItem(m_fieldsView.table, SWT.NONE); keyItem.setText(1, mapping.getKeyName()); keyItem.setText(2, "Y"); keyItem.setText(5, mapping.getKeyType().toString()); if (mapping.isTupleMapping() && !Const.isEmpty(mapping.getTupleFamilies())) { keyItem.setText(3, mapping.getTupleFamilies()); } // the rest of the fields in the mapping Map<String, HBaseValueMeta> mappedFields = mapping.getMappedColumns(); for (String alias : mappedFields.keySet()) { HBaseValueMeta vm = mappedFields.get(alias); TableItem item = new TableItem(m_fieldsView.table, SWT.NONE); item.setText(1, alias); item.setText(2, "N"); item.setText(3, vm.getColumnFamily()); item.setText(4, vm.getColumnName()); if (vm.isInteger()) { if (vm.getIsLongOrDouble()) { item.setText(5, "Long"); } else { item.setText(5, "Integer"); } } else if (vm.isNumber()) { if (vm.getIsLongOrDouble()) { item.setText(5, "Double"); } else { item.setText(5, "Float"); } } else { item.setText(5, vm.getTypeDesc()); } if (vm.getStorageType() == ValueMetaInterface.STORAGE_TYPE_INDEXED) { item.setText(6, HBaseValueMeta.objectIndexValuesToString(vm.getIndex())); } } m_fieldsView.removeEmptyRows(); m_fieldsView.setRowNums(); m_fieldsView.optWidth(true); }