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);
  }
  /** 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 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);
  }
  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);
  }
 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);
 }
  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);
  }
  /** Copy information from the meta-data input to the dialog fields. */
  public void getData() {
    Table table = wFields.table;
    if (input.getStepName().length > 0) {
      table.removeAll();
    }
    for (int i = 0; i < input.getStepName().length; i++) {
      TableItem ti = new TableItem(table, SWT.NONE);
      ti.setText(0, "" + (i + 1));
      if (input.getStepName()[i] != null) {
        ti.setText(1, input.getStepName()[i]);
        ti.setText(2, String.valueOf(Const.toInt(input.getStepCopyNr()[i], 0)));
        ti.setText(3, input.getRequiredStepsDesc(input.getStepRequired()[i]));
      }
    }

    wFields.removeEmptyRows();
    wFields.setRowNums();
    wFields.optWidth(true);

    if (input.getStepNameFieldName() != null) {
      wStepnameField.setText(input.getStepNameFieldName());
    }
    if (input.getStepIdFieldName() != null) {
      wStepidField.setText(input.getStepIdFieldName());
    }
    if (input.getStepLinesInputFieldName() != null) {
      wLinesinputField.setText(input.getStepLinesInputFieldName());
    }
    if (input.getStepLinesOutputFieldName() != null) {
      wLinesoutputField.setText(input.getStepLinesOutputFieldName());
    }
    if (input.getStepLinesReadFieldName() != null) {
      wLinesreadField.setText(input.getStepLinesReadFieldName());
    }
    if (input.getStepLinesWrittenFieldName() != null) {
      wLineswrittenField.setText(input.getStepLinesWrittenFieldName());
    }
    if (input.getStepLinesUpdatedFieldName() != null) {
      wLinesupdatedField.setText(input.getStepLinesUpdatedFieldName());
    }
    if (input.getStepLinesErrorsFieldName() != null) {
      wLineserrorsField.setText(input.getStepLinesErrorsFieldName());
    }
    if (input.getStepSecondsFieldName() != null) {
      wSecondsField.setText(input.getStepSecondsFieldName());
    }

    wStepname.selectAll();
    wStepname.setFocus();
  }
Esempio n. 8
0
  /** Copy information from the meta-data input to the dialog fields. */
  public void getData() {
    if (input.getReplaceAllByValue() != null) wReplaceByValue.setText(input.getReplaceAllByValue());
    if (input.getReplaceAllMask() != null) wMask.setText(input.getReplaceAllMask());

    wSelectFields.setSelection(input.isSelectFields());
    wSelectValuesType.setSelection(input.isSelectValuesType());

    Table table = wValueTypes.table;
    if (input.getTypeName().length > 0) table.removeAll();
    for (int i = 0; i < input.getTypeName().length; i++) {
      TableItem ti = new TableItem(table, SWT.NONE);
      ti.setText(0, "" + (i + 1));
      if (input.getTypeName()[i] != null) ti.setText(1, input.getTypeName()[i]);
      if (input.getTypeReplaceValue()[i] != null) ti.setText(2, input.getTypeReplaceValue()[i]);
      if (input.getTypeReplaceMask()[i] != null) ti.setText(3, input.getTypeReplaceMask()[i]);
    }

    wValueTypes.setRowNums();
    wValueTypes.removeEmptyRows();
    wValueTypes.optWidth(true);

    table = wFields.table;
    if (input.getFieldName().length > 0) table.removeAll();
    for (int i = 0; i < input.getFieldName().length; i++) {
      TableItem ti = new TableItem(table, SWT.NONE);
      ti.setText(0, "" + (i + 1));
      if (input.getFieldName()[i] != null) ti.setText(1, input.getFieldName()[i]);
      if (input.getReplaceValue()[i] != null) ti.setText(2, input.getReplaceValue()[i]);
      if (input.getReplaceMask()[i] != null) ti.setText(3, input.getReplaceMask()[i]);
    }

    wFields.setRowNums();
    wValueTypes.removeEmptyRows();
    wFields.optWidth(true);

    wStepname.selectAll();
  }
  private void doGetFields() {
    try {
      List<String> cubeDimensions = null;
      if (comboCube.getText() != null && comboCube.getText() != "") {
        if (addConnectionLine.getText() != null) {
          DatabaseMeta dbMeta = transMeta.findDatabase(addConnectionLine.getText());
          if (dbMeta != null) {
            PaloCellOutputData data = new PaloCellOutputData(dbMeta);
            data.helper.connect();
            cubeDimensions = data.helper.getCubeDimensions(comboCube.getText());
            data.helper.disconnect();
          }
        }
        tableViewFields.table.removeAll();

        for (int i = 0; i < cubeDimensions.size(); i++) {
          final TableItem item = new TableItem(tableViewFields.table, SWT.NONE);
          item.setText(1, cubeDimensions.get(i));
          // item.setText(3, "String");

        }
        final TableItem item = new TableItem(tableViewFields.table, SWT.NONE);
        item.setText(1, "Cube Measure");
        item.setForeground(Display.getCurrent().getSystemColor(SWT.COLOR_DARK_GREEN));

        tableViewFields.removeEmptyRows();
        tableViewFields.setRowNums();
        tableViewFields.optWidth(true);
        tableViewFields.setReadonly(true);

      } else {
        new ErrorDialog(
            shell,
            BaseMessages.getString(PKG, "System.Dialog.GetFieldsFailed.Title"),
            BaseMessages.getString(PKG, "System.Dialog.GetFieldsFailed.Message"),
            new Exception(
                BaseMessages.getString(PKG, "PaloCellOutputDialog.SelectCubeFirstError")));
      }

      this.fillPreviousFieldTableViewColumn();

    } catch (KettleException ke) {
      new ErrorDialog(
          shell,
          BaseMessages.getString(PKG, "System.Dialog.GetFieldsFailed.Title"),
          BaseMessages.getString(PKG, "System.Dialog.GetFieldsFailed.Message"),
          ke);
    }
  }
  private void get() {
    wFields.removeAll();
    Table table = wFields.table;

    for (int i = 0; i < previousSteps.length; i++) {
      TableItem ti = new TableItem(table, SWT.NONE);
      ti.setText(0, "" + (i + 1));
      ti.setText(1, previousSteps[i]);
      ti.setText(2, "0");
      ti.setText(3, BaseMessages.getString(PKG, "System.Combo.No"));
    }
    wFields.removeEmptyRows();
    wFields.setRowNums();
    wFields.optWidth(true);
  }
Esempio n. 11
0
  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);
  }
Esempio n. 12
0
  private void getInfo(FixedInputMeta fixedInputMeta) {

    fixedInputMeta.setFilename(wFilename.getText());
    fixedInputMeta.setLineWidth(wLineWidth.getText());
    fixedInputMeta.setBufferSize(wBufferSize.getText());
    fixedInputMeta.setLazyConversionActive(wLazyConversion.getSelection());
    fixedInputMeta.setHeaderPresent(wHeaderPresent.getSelection());
    fixedInputMeta.setLineFeedPresent(wLineFeedPresent.getSelection());
    fixedInputMeta.setRunningInParallel(wRunningInParallel.getSelection());
    fixedInputMeta.setFileType(FixedInputMeta.getFileType(wFileType.getText()));
    fixedInputMeta.setEncoding(wEncoding.getText());
    fixedInputMeta.setAddResultFile(wAddResult.getSelection());

    int nrNonEmptyFields = wFields.nrNonEmpty();
    fixedInputMeta.allocate(nrNonEmptyFields);

    for (int i = 0; i < nrNonEmptyFields; i++) {
      TableItem item = wFields.getNonEmpty(i);
      int colnr = 1;

      FixedFileInputField field = new FixedFileInputField();

      field.setName(item.getText(colnr++));
      field.setType(ValueMetaFactory.getIdForValueMeta(item.getText(colnr++)));
      field.setFormat(item.getText(colnr++));
      field.setWidth(Const.toInt(item.getText(colnr++), -1));
      field.setLength(Const.toInt(item.getText(colnr++), -1));
      field.setPrecision(Const.toInt(item.getText(colnr++), -1));
      field.setCurrency(item.getText(colnr++));
      field.setDecimal(item.getText(colnr++));
      field.setGrouping(item.getText(colnr++));
      field.setTrimType(ValueMetaString.getTrimTypeByDesc(item.getText(colnr++)));

      // CHECKSTYLE:Indentation:OFF
      fixedInputMeta.getFieldDefinition()[i] = field;
    }
    wFields.removeEmptyRows();
    wFields.setRowNums();
    wFields.optWidth(true);

    fixedInputMeta.setChanged();
  }
Esempio n. 13
0
  /** 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();
  }
  private void addMappingDefinitionTab(
      final MappingIODefinition definition,
      int index,
      final String tabTitle,
      final String tabTooltip,
      String inputStepLabel,
      String outputStepLabel,
      String descriptionLabel,
      String sourceColumnLabel,
      String targetColumnLabel,
      final boolean input) {

    final CTabItem wTab;
    if (index >= wTabFolder.getItemCount()) {
      wTab = new CTabItem(wTabFolder, SWT.CLOSE);
    } else {
      wTab = new CTabItem(wTabFolder, SWT.CLOSE, index);
    }
    setMappingDefinitionTabNameAndToolTip(wTab, tabTitle, tabTooltip, definition, input);

    Composite wInputComposite = new Composite(wTabFolder, SWT.NONE);
    props.setLook(wInputComposite);

    FormLayout tabLayout = new FormLayout();
    tabLayout.marginWidth = Const.FORM_MARGIN;
    tabLayout.marginHeight = Const.FORM_MARGIN;
    wInputComposite.setLayout(tabLayout);

    // What's the stepname to read from? (empty is OK too)
    //
    Button wbInputStep = new Button(wInputComposite, SWT.PUSH);
    props.setLook(wbInputStep);
    wbInputStep.setText(Messages.getString("MappingFieldRunnerDialog.button.SourceStepName"));
    FormData fdbInputStep = new FormData();
    fdbInputStep.top = new FormAttachment(0, 0);
    fdbInputStep.right = new FormAttachment(100, 0); // First one in the
    // left top corner
    wbInputStep.setLayoutData(fdbInputStep);

    Label wlInputStep = new Label(wInputComposite, SWT.RIGHT);
    props.setLook(wlInputStep);
    wlInputStep.setText(inputStepLabel); // $NON-NLS-1$
    FormData fdlInputStep = new FormData();
    fdlInputStep.top = new FormAttachment(wbInputStep, 0, SWT.CENTER);
    fdlInputStep.left = new FormAttachment(0, 0); // First one in the left
    // top corner
    fdlInputStep.right = new FormAttachment(middle, -margin);
    wlInputStep.setLayoutData(fdlInputStep);

    final Text wInputStep = new Text(wInputComposite, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
    props.setLook(wInputStep);
    wInputStep.setText(Const.NVL(definition.getInputStepname(), ""));
    wInputStep.addModifyListener(lsMod);
    FormData fdInputStep = new FormData();
    fdInputStep.top = new FormAttachment(wbInputStep, 0, SWT.CENTER);
    fdInputStep.left = new FormAttachment(middle, 0); // To the right of
    // the label
    fdInputStep.right = new FormAttachment(wbInputStep, -margin);
    wInputStep.setLayoutData(fdInputStep);
    wInputStep.addFocusListener(
        new FocusAdapter() {
          @Override
          public void focusLost(FocusEvent event) {
            definition.setInputStepname(wInputStep.getText());
            setMappingDefinitionTabNameAndToolTip(wTab, tabTitle, tabTooltip, definition, input);
          }
        });
    wbInputStep.addSelectionListener(
        new SelectionAdapter() {
          @Override
          public void widgetSelected(SelectionEvent event) {
            String stepName = selectTransformationStepname(input, input);
            if (stepName != null) {
              wInputStep.setText(stepName);
              definition.setInputStepname(stepName);
              setMappingDefinitionTabNameAndToolTip(wTab, tabTitle, tabTooltip, definition, input);
            }
          }
        });

    // What's the step name to read from? (empty is OK too)
    //
    Button wbOutputStep = new Button(wInputComposite, SWT.PUSH);
    props.setLook(wbOutputStep);
    wbOutputStep.setText(Messages.getString("MappingFieldRunnerDialog.button.SourceStepName"));
    FormData fdbOutputStep = new FormData();
    fdbOutputStep.top = new FormAttachment(wbInputStep, margin);
    fdbOutputStep.right = new FormAttachment(100, 0);
    wbOutputStep.setLayoutData(fdbOutputStep);

    Label wlOutputStep = new Label(wInputComposite, SWT.RIGHT);
    props.setLook(wlOutputStep);
    wlOutputStep.setText(outputStepLabel); // $NON-NLS-1$
    FormData fdlOutputStep = new FormData();
    fdlOutputStep.top = new FormAttachment(wbOutputStep, 0, SWT.CENTER);
    fdlOutputStep.left = new FormAttachment(0, 0);
    fdlOutputStep.right = new FormAttachment(middle, -margin);
    wlOutputStep.setLayoutData(fdlOutputStep);

    final Text wOutputStep = new Text(wInputComposite, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
    props.setLook(wOutputStep);
    wOutputStep.setText(Const.NVL(definition.getOutputStepname(), ""));
    wOutputStep.addModifyListener(lsMod);
    FormData fdOutputStep = new FormData();
    fdOutputStep.top = new FormAttachment(wbOutputStep, 0, SWT.CENTER);
    fdOutputStep.left = new FormAttachment(middle, 0); // To the right of
    // the label
    fdOutputStep.right = new FormAttachment(wbOutputStep, -margin);
    wOutputStep.setLayoutData(fdOutputStep);

    // Add a checkbox to indicate the main step to read from, the main data
    // path...
    //
    Label wlMainPath = new Label(wInputComposite, SWT.RIGHT);
    props.setLook(wlMainPath);
    wlMainPath.setText(
        Messages.getString("MappingFieldRunnerDialog.input.MainDataPath")); // $NON-NLS-1$
    FormData fdlMainPath = new FormData();
    fdlMainPath.top = new FormAttachment(wbOutputStep, margin);
    fdlMainPath.left = new FormAttachment(0, 0);
    fdlMainPath.right = new FormAttachment(middle, -margin);
    wlMainPath.setLayoutData(fdlMainPath);

    Button wMainPath = new Button(wInputComposite, SWT.CHECK);
    props.setLook(wMainPath);
    FormData fdMainPath = new FormData();
    fdMainPath.top = new FormAttachment(wbOutputStep, margin);
    fdMainPath.left = new FormAttachment(middle, 0);
    // fdMainPath.right = new FormAttachment(100, 0); // who cares, it's a
    // checkbox
    wMainPath.setLayoutData(fdMainPath);

    wMainPath.setSelection(definition.isMainDataPath());
    wMainPath.addSelectionListener(
        new SelectionAdapter() {

          @Override
          public void widgetSelected(SelectionEvent event) {
            definition.setMainDataPath(!definition.isMainDataPath()); // flip
            // the
            // switch
          }
        });

    // Add a checkbox to indicate that all output mappings need to rename
    // the values back...
    //
    Label wlRenameOutput = new Label(wInputComposite, SWT.RIGHT);
    props.setLook(wlRenameOutput);
    wlRenameOutput.setText(
        Messages.getString("MappingFieldRunnerDialog.input.RenamingOnOutput")); // $NON-NLS-1$
    FormData fdlRenameOutput = new FormData();
    fdlRenameOutput.top = new FormAttachment(wMainPath, margin);
    fdlRenameOutput.left = new FormAttachment(0, 0);
    fdlRenameOutput.right = new FormAttachment(middle, -margin);
    wlRenameOutput.setLayoutData(fdlRenameOutput);

    Button wRenameOutput = new Button(wInputComposite, SWT.CHECK);
    props.setLook(wRenameOutput);
    FormData fdRenameOutput = new FormData();
    fdRenameOutput.top = new FormAttachment(wMainPath, margin);
    fdRenameOutput.left = new FormAttachment(middle, 0);
    // fdRenameOutput.right = new FormAttachment(100, 0); // who cares, it's
    // a check box
    wRenameOutput.setLayoutData(fdRenameOutput);

    wRenameOutput.setSelection(definition.isRenamingOnOutput());
    wRenameOutput.addSelectionListener(
        new SelectionAdapter() {

          @Override
          public void widgetSelected(SelectionEvent event) {
            definition.setRenamingOnOutput(!definition.isRenamingOnOutput()); // flip
            // the
            // switch
          }
        });

    // Allow for a small description
    //
    Label wlDescription = new Label(wInputComposite, SWT.RIGHT);
    props.setLook(wlDescription);
    wlDescription.setText(descriptionLabel); // $NON-NLS-1$
    FormData fdlDescription = new FormData();
    fdlDescription.top = new FormAttachment(wRenameOutput, margin);
    fdlDescription.left = new FormAttachment(0, 0); // First one in the left
    // top corner
    fdlDescription.right = new FormAttachment(middle, -margin);
    wlDescription.setLayoutData(fdlDescription);

    final Text wDescription =
        new Text(wInputComposite, SWT.MULTI | SWT.LEFT | SWT.BORDER | SWT.V_SCROLL | SWT.H_SCROLL);
    props.setLook(wDescription);
    wDescription.setText(Const.NVL(definition.getDescription(), ""));
    wDescription.addModifyListener(lsMod);
    FormData fdDescription = new FormData();
    fdDescription.top = new FormAttachment(wRenameOutput, margin);
    fdDescription.bottom = new FormAttachment(wRenameOutput, 100 + margin);
    fdDescription.left = new FormAttachment(middle, 0); // To the right of
    // the label
    fdDescription.right = new FormAttachment(wbOutputStep, -margin);
    wDescription.setLayoutData(fdDescription);
    wDescription.addFocusListener(
        new FocusAdapter() {
          @Override
          public void focusLost(FocusEvent event) {
            definition.setDescription(wDescription.getText());
          }
        });

    // Now add a table view with the 2 columns to specify: input and output
    // fields for the source and target steps.
    //
    final Button wbEnterMapping = new Button(wInputComposite, SWT.PUSH);
    props.setLook(wbEnterMapping);
    wbEnterMapping.setText(Messages.getString("MappingFieldRunnerDialog.button.EnterMapping"));
    FormData fdbEnterMapping = new FormData();
    fdbEnterMapping.top = new FormAttachment(wDescription, margin * 2);
    fdbEnterMapping.right = new FormAttachment(100, 0); // First one in the
    // left top corner
    wbEnterMapping.setLayoutData(fdbEnterMapping);

    ColumnInfo[] colinfo =
        new ColumnInfo[] {
          new ColumnInfo(
              sourceColumnLabel, ColumnInfo.COLUMN_TYPE_TEXT, false, false), // $NON-NLS-1$
          new ColumnInfo(
              targetColumnLabel, ColumnInfo.COLUMN_TYPE_TEXT, false, false), // $NON-NLS-1$
        };
    final TableView wFieldMappings =
        new TableView(
            transMeta,
            wInputComposite,
            SWT.FULL_SELECTION | SWT.SINGLE | SWT.BORDER,
            colinfo,
            1,
            lsMod,
            props);
    props.setLook(wFieldMappings);
    FormData fdMappings = new FormData();
    fdMappings.left = new FormAttachment(0, 0);
    fdMappings.right = new FormAttachment(wbEnterMapping, -margin);
    fdMappings.top = new FormAttachment(wDescription, margin * 2);
    fdMappings.bottom = new FormAttachment(100, -20);
    wFieldMappings.setLayoutData(fdMappings);

    for (MappingValueRename valueRename : definition.getValueRenames()) {
      TableItem tableItem = new TableItem(wFieldMappings.table, SWT.NONE);
      tableItem.setText(1, valueRename.getSourceValueName());
      tableItem.setText(2, valueRename.getTargetValueName());
    }
    wFieldMappings.removeEmptyRows();
    wFieldMappings.setRowNums();
    wFieldMappings.optWidth(true);

    wbEnterMapping.addSelectionListener(
        new SelectionAdapter() {

          @Override
          public void widgetSelected(SelectionEvent arg0) {
            try {
              RowMetaInterface sourceRowMeta = getFieldsFromStep(wInputStep.getText(), true, input);
              RowMetaInterface targetRowMeta =
                  getFieldsFromStep(wOutputStep.getText(), false, input);
              String sourceFields[] = sourceRowMeta.getFieldNames();
              String targetFields[] = targetRowMeta.getFieldNames();

              EnterMappingDialog dialog = new EnterMappingDialog(shell, sourceFields, targetFields);
              List<SourceToTargetMapping> mappings = dialog.open();
              if (mappings != null) {
                // first clear the dialog...
                wFieldMappings.clearAll(false);

                //
                definition.getValueRenames().clear();

                // Now add the new values...
                for (int i = 0; i < mappings.size(); i++) {
                  SourceToTargetMapping mapping = mappings.get(i);
                  TableItem item = new TableItem(wFieldMappings.table, SWT.NONE);
                  item.setText(1, mapping.getSourceString(sourceFields));
                  item.setText(2, mapping.getTargetString(targetFields));

                  String source = input ? item.getText(1) : item.getText(2);
                  String target = input ? item.getText(2) : item.getText(1);
                  definition.getValueRenames().add(new MappingValueRename(source, target));
                }
                wFieldMappings.removeEmptyRows();
                wFieldMappings.setRowNums();
                wFieldMappings.optWidth(true);
              }
            } catch (KettleException e) {
              new ErrorDialog(
                  shell,
                  Messages.getString("System.Dialog.Error.Title"),
                  Messages.getString(
                      "MappingFieldRunnerDialog.Exception.ErrorGettingMappingSourceAndTargetFields",
                      e.toString()),
                  e);
            }
          }
        });

    wOutputStep.addFocusListener(
        new FocusAdapter() {
          @Override
          public void focusLost(FocusEvent event) {
            definition.setOutputStepname(wOutputStep.getText());
            try {
              enableMappingButton(
                  wbEnterMapping, input, wInputStep.getText(), wOutputStep.getText());
            } catch (KettleException e) {
              // Show the missing/wrong step name error
              //
              new ErrorDialog(shell, "Error", "Unexpected error", e);
            }
          }
        });
    wbOutputStep.addSelectionListener(
        new SelectionAdapter() {
          @Override
          public void widgetSelected(SelectionEvent event) {
            String stepName = selectTransformationStepname(!input, input);
            if (stepName != null) {
              wOutputStep.setText(stepName);
              definition.setOutputStepname(stepName);
              try {
                enableMappingButton(
                    wbEnterMapping, input, wInputStep.getText(), wOutputStep.getText());
              } catch (KettleException e) {
                // Show the missing/wrong stepname error
                new ErrorDialog(shell, "Error", "Unexpected error", e);
              }
            }
          }
        });

    FormData fdParametersComposite = new FormData();
    fdParametersComposite.left = new FormAttachment(0, 0);
    fdParametersComposite.top = new FormAttachment(0, 0);
    fdParametersComposite.right = new FormAttachment(100, 0);
    fdParametersComposite.bottom = new FormAttachment(100, 0);
    wInputComposite.setLayoutData(fdParametersComposite);

    wInputComposite.layout();
    wTab.setControl(wInputComposite);

    final ApplyChanges applyChanges =
        new MappingDefinitionTab(
            definition, wInputStep, wOutputStep, wMainPath, wDescription, wFieldMappings);
    changeList.add(applyChanges);

    // OK, suppose for some weird reason the user wants to remove an input
    // or output tab...
    wTabFolder.addCTabFolder2Listener(
        new CTabFolder2Adapter() {

          @Override
          public void close(CTabFolderEvent event) {
            if (event.item.equals(wTab)) {
              // The user has the audacity to try and close this mapping
              // definition tab.
              // We really should warn him that this is a bad idea...
              MessageBox box = new MessageBox(shell, SWT.YES | SWT.NO);
              box.setText(
                  Messages.getString(
                      "MappingFieldRunnerDialog.CloseDefinitionTabAreYouSure.Title"));
              box.setMessage(
                  Messages.getString(
                      "MappingFieldRunnerDialog.CloseDefinitionTabAreYouSure.Message"));
              int answer = box.open();
              if (answer != SWT.YES) {
                event.doit = false;
              } else {
                // Remove it from our list to make sure it's gone...
                if (input) inputMappings.remove(definition);
                else outputMappings.remove(definition);

                // remove it from the changeList too...
                // Otherwise the dialog leaks memory.
                //
                changeList.remove(applyChanges);
              }
            }
          }
        });

    wTabFolder.setSelection(wTab);
  }
Esempio n. 15
0
  private void populateTableWithIncomingFields() {
    if (m_incomingFieldsProducer != null) {
      RowMetaInterface incomingRowMeta = m_incomingFieldsProducer.getIncomingFields();

      Table table = m_fieldsView.table;
      if (incomingRowMeta != null) {
        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(),
                      "" + incomingRowMeta.size()),
                  MessageDialog.WARNING,
                  new String[] {
                    Messages.getString("MappingDialog.AddNew"),
                    Messages.getString("MappingOutputDialog.Add"),
                    Messages.getString("MappingOutputDialog.ClearAndAdd"),
                    Messages.getString("MappingOutputDialog.Cancel"),
                  },
                  0);
          MessageDialog.setDefaultImage(GUIResource.getInstance().getImageSpoon());
          int idx = md.open();
          choice = idx & 0xFF;
        }

        if (choice == 3 || choice == 255 /* 255 = escape pressed */) {
          return; // Cancel
        }

        if (choice == 2) {
          m_fieldsView.clearAll();
        }

        for (int i = 0; i < incomingRowMeta.size(); i++) {
          ValueMetaInterface vm = incomingRowMeta.getValueMeta(i);
          boolean addIt = true;

          if (choice == 0) {
            // only add if its not already in the table
            if (existingRowAliases.contains(vm.getName())) {
              addIt = false;
            }
          }

          if (addIt) {
            TableItem item = new TableItem(m_fieldsView.table, SWT.NONE);
            item.setText(1, vm.getName());
            item.setText(2, "N");

            if (m_familyCI.getComboValues()[0].length() > 0) {
              // use existing first column family name as the default
              item.setText(3, m_familyCI.getComboValues()[0]);
            } else {
              // default
              item.setText(3, DEFAULT_FAMILY);
            }

            item.setText(4, vm.getName());
            item.setText(5, vm.getTypeDesc());
            if (vm.getType() == ValueMetaInterface.TYPE_INTEGER) {
              item.setText(5, "Long");
            }
            if (vm.getType() == ValueMetaInterface.TYPE_NUMBER) {
              item.setText(5, "Double");
            }
            if (vm.getStorageType() == ValueMetaInterface.STORAGE_TYPE_INDEXED) {
              Object[] indexValus = vm.getIndex();
              String indexValsS = HBaseValueMeta.objectIndexValuesToString(indexValus);
              item.setText(6, indexValsS);
            }
          }
        }

        m_fieldsView.removeEmptyRows();
        m_fieldsView.setRowNums();
        m_fieldsView.optWidth(true);
      }
    }
  }
  /** Copy information from the meta-data input to the dialog fields. */
  public void getData() {
    if (input.getReplaceAllByValue() != null) {
      wReplaceByValue.setText(input.getReplaceAllByValue());
    }
    if (input.getReplaceAllMask() != null) {
      wMask.setText(input.getReplaceAllMask());
    }
    wSetEmptyStringAll.setSelection(input.isSetEmptyStringAll());

    wSelectFields.setSelection(input.isSelectFields());
    wSelectValuesType.setSelection(input.isSelectValuesType());

    Table table = wValueTypes.table;
    if (input.getValueTypes().length > 0) {
      table.removeAll();
    }
    for (int i = 0; i < input.getValueTypes().length; i++) {
      TableItem ti = new TableItem(table, SWT.NONE);
      ti.setText(0, "" + (i + 1));
      if (input.getValueTypes()[i].getTypeName() != null) {
        ti.setText(1, input.getValueTypes()[i].getTypeName());
      }
      if (input.getValueTypes()[i].getTypereplaceValue() != null) {
        ti.setText(2, input.getValueTypes()[i].getTypereplaceValue());
      }
      if (input.getValueTypes()[i].getTypereplaceMask() != null) {
        ti.setText(3, input.getValueTypes()[i].getTypereplaceMask());
      }
      ti.setText(
          4,
          input.getValueTypes()[i].isSetTypeEmptyString()
              ? BaseMessages.getString(PKG, "System.Combo.Yes")
              : BaseMessages.getString(PKG, "System.Combo.No"));
    }

    wValueTypes.setRowNums();
    wValueTypes.removeEmptyRows();
    wValueTypes.optWidth(true);

    table = wFields.table;
    if (input.getFields().length > 0) {
      table.removeAll();
    }
    for (int i = 0; i < input.getFields().length; i++) {
      TableItem ti = new TableItem(table, SWT.NONE);
      ti.setText(0, "" + (i + 1));
      if (input.getFields()[i].getFieldName() != null) {
        ti.setText(1, input.getFields()[i].getFieldName());
      }
      if (input.getFields()[i].getReplaceValue() != null) {
        ti.setText(2, input.getFields()[i].getReplaceValue());
      }
      if (input.getFields()[i].getReplaceMask() != null) {
        ti.setText(3, input.getFields()[i].getReplaceMask());
      }
      ti.setText(
          4,
          input.getFields()[i].isSetEmptyString()
              ? BaseMessages.getString(PKG, "System.Combo.Yes")
              : BaseMessages.getString(PKG, "System.Combo.No"));
    }

    wFields.setRowNums();
    wValueTypes.removeEmptyRows();
    wFields.optWidth(true);

    wStepname.selectAll();
    wStepname.setFocus();
  }
  /**
   * Read the data from the GetFilesRowsCountMeta object and show it in this dialog.
   *
   * @param in The GetFilesRowsCountMeta object to obtain the data from.
   */
  public void getData(GetFilesRowsCountMeta in) {
    if (in.getFileName() != null) {
      wFilenameList.removeAll();
      for (int i = 0; i < in.getFileName().length; i++) {
        wFilenameList.add(
            new String[] {
              in.getFileName()[i],
              in.getFileMask()[i],
              in.getExludeFileMask()[i],
              in.getRequiredFilesDesc(in.getFileRequired()[i]),
              in.getRequiredFilesDesc(in.getIncludeSubFolders()[i])
            });
      }
      wFilenameList.removeEmptyRows();
      wFilenameList.setRowNums();
      wFilenameList.optWidth(true);
    }
    wInclFilesCount.setSelection(in.includeCountFiles());

    if (in.getFilesCountFieldName() != null) {
      wInclFilesCountField.setText(in.getFilesCountFieldName());
    } else {
      wInclFilesCountField.setText("filescount");
    }

    if (in.getRowsCountFieldName() != null) {
      wRowsCountField.setText(in.getRowsCountFieldName());
    } else {
      wRowsCountField.setText(GetFilesRowsCountMeta.DEFAULT_ROWSCOUNT_FIELDNAME);
    }

    if (in.getRowSeparatorFormat() != null) {
      // Checking for 'CR' for backwards compatibility
      if (in.getRowSeparatorFormat().equals("CARRIAGERETURN")
          || in.getRowSeparatorFormat().equals("CR")) {
        wRowSeparatorFormat.select(0);
      } else if (in.getRowSeparatorFormat().equals("LINEFEED")
          || in.getRowSeparatorFormat().equals("LF")) {
        // Checking for 'LF' for backwards compatibility
        wRowSeparatorFormat.select(1);
      } else if (in.getRowSeparatorFormat().equals("CRLF")) {
        wRowSeparatorFormat.select(2);
      } else if (in.getRowSeparatorFormat().equals("TAB")) {
        wRowSeparatorFormat.select(3);
      } else {
        wRowSeparatorFormat.select(4);
      }
    } else {
      wRowSeparatorFormat.select(0);
    }

    if (in.getRowSeparator() != null) {
      wRowSeparator.setText(in.getRowSeparator());
    }

    wAddResult.setSelection(in.isAddResultFile());
    wFileField.setSelection(in.isFileField());
    if (in.setOutputFilenameField() != null) {
      wFilenameField.setText(in.setOutputFilenameField());
    }

    logDebug(BaseMessages.getString(PKG, "GetFilesRowsCountDialog.Log.GettingFieldsInfo"));

    setIncludeRownum();

    wStepname.selectAll();
    wStepname.setFocus();
  }