Пример #1
0
  private void getTableName() {
    DatabaseMeta inf = null;
    // New class: SelectTableDialog
    int connr = wConnection.getSelectionIndex();
    if (connr >= 0) inf = transMeta.getDatabase(connr);

    if (inf != null) {
      log.logDebug(
          toString(),
          Messages.getString("UpdateDialog.Log.LookingAtConnection")
              + inf.toString()); // $NON-NLS-1$

      DatabaseExplorerDialog std =
          new DatabaseExplorerDialog(shell, SWT.NONE, inf, transMeta.getDatabases());
      std.setSelectedSchema(wSchema.getText());
      std.setSelectedTable(wTable.getText());
      std.setSplitSchemaAndTable(true);
      if (std.open() != null) {
        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(
          Messages.getString("UpdateDialog.InvalidConnection.DialogMessage")); // $NON-NLS-1$
      mb.setText(Messages.getString("UpdateDialog.InvalidConnection.DialogTitle")); // $NON-NLS-1$
      mb.open();
    }
  }
 public FormulaMetaFunction(Node calcnode) {
   fieldName = XMLHandler.getTagValue(calcnode, "field_name");
   formula = XMLHandler.getTagValue(calcnode, "formula_string");
   valueType = Value.getType(XMLHandler.getTagValue(calcnode, "value_type"));
   valueLength = Const.toInt(XMLHandler.getTagValue(calcnode, "value_length"), -1);
   valuePrecision = Const.toInt(XMLHandler.getTagValue(calcnode, "value_precision"), -1);
   removedFromResult = "Y".equalsIgnoreCase(XMLHandler.getTagValue(calcnode, "remove"));
 }
  private void refreshMappings() {
    // Refresh the results...
    wResult.removeAll();
    for (int i = 0; i < mappings.size(); i++) {
      SourceToTargetMapping mapping = (SourceToTargetMapping) mappings.get(i);
      String mappingString =
          sourceList[mapping.getSourcePosition()]
              + " --> "
              + targetList[mapping.getTargetPosition()];
      wResult.add(mappingString);
    }

    wSource.removeAll();
    // Refresh the sources
    for (int a = 0; a < sourceList.length; a++) {
      boolean found = false;
      if (wSourceHide.getSelection()) {
        for (int b = 0; b < mappings.size() && !found; b++) {
          SourceToTargetMapping mapping = (SourceToTargetMapping) mappings.get(b);
          if (mapping.getSourcePosition() == Const.indexOfString(sourceList[a], sourceList)) {
            found = true;
          }
        }
      }

      if (!found) {
        wSource.add(sourceList[a]);
      }
    }

    wTarget.removeAll();
    // Refresh the targets
    for (int a = 0; a < targetList.length; a++) {
      boolean found = false;
      if (wTargetHide.getSelection()) {
        for (int b = 0; b < mappings.size() && !found; b++) {
          SourceToTargetMapping mapping = (SourceToTargetMapping) mappings.get(b);
          if (mapping.getTargetPosition() == Const.indexOfString(targetList[a], targetList)) {
            found = true;
          }
        }
      }

      if (!found) {
        wTarget.add(targetList[a]);
      }
    }
  }
  private void add() {
    if (wSource.getSelectionCount() == 1 && wTarget.getSelectionCount() == 1) {
      String sourceString = wSource.getSelection()[0];
      String targetString = wTarget.getSelection()[0];

      int srcIndex = Const.indexOfString(sourceString, sourceList);
      int tgtIndex = Const.indexOfString(targetString, targetList);

      if (srcIndex >= 0 && tgtIndex >= 0) {
        // New mapping: add it to the list...
        SourceToTargetMapping mapping = new SourceToTargetMapping(srcIndex, tgtIndex);
        mappings.add(mapping);

        refreshMappings();
      }
    }
  }
 private void guess() {
   // Guess the target for all the sources...
   for (int i = 0; i < sourceList.length; i++) {
     int idx = Const.indexOfString(sourceList[i], wSource.getItems());
     if (idx >= 0) {
       wSource.select(idx);
       if (findTarget()) {
         add();
       }
     }
   }
 }
Пример #6
0
  private void getInfo(UpdateMeta inf) {
    // Table ktable = wKey.table;
    int nrkeys = wKey.nrNonEmpty();
    int nrfields = wReturn.nrNonEmpty();

    inf.allocate(nrkeys, nrfields);

    inf.setCommitSize(Const.toInt(wCommit.getText(), 0));

    log.logDebug(
        toString(),
        Messages.getString("UpdateDialog.Log.FoundKeys", nrkeys + "")); // $NON-NLS-1$ //$NON-NLS-2$
    for (int i = 0; i < nrkeys; i++) {
      TableItem item = wKey.getNonEmpty(i);
      inf.getKeyLookup()[i] = item.getText(1);
      inf.getKeyCondition()[i] = item.getText(2);
      inf.getKeyStream()[i] = item.getText(3);
      inf.getKeyStream2()[i] = item.getText(4);
    }

    // Table ftable = wReturn.table;

    log.logDebug(
        toString(),
        Messages.getString(
            "UpdateDialog.Log.FoundFields", nrfields + "")); // $NON-NLS-1$ //$NON-NLS-2$
    for (int i = 0; i < nrfields; i++) {
      TableItem item = wReturn.getNonEmpty(i);
      inf.getUpdateLookup()[i] = item.getText(1);
      inf.getUpdateStream()[i] = item.getText(2);
    }

    inf.setSchemaName(wSchema.getText());
    inf.setTableName(wTable.getText());
    inf.setDatabaseMeta(transMeta.findDatabase(wConnection.getText()));

    inf.setErrorIgnored(wErrorIgnored.getSelection());
    inf.setIgnoreFlagField(wIgnoreFlagField.getText());

    stepname = wStepname.getText(); // return value
  }