/**
     * {@inheritDoc}
     *
     * @see org.eclipse.jface.viewers.ColumnLabelProvider#getText(java.lang.Object)
     */
    @Override
    public String getText(Object element) {

      String result = PluginConstants.EMPTY_STRING;
      Binding binding = (Binding) element;
      switch (this.columnNumber) {
          // | status icon | Source SQL Symbol | <-- | Matched Datatype | ->  | Target Column
        case 0:
          break;
        case 1:
          result = binding.getSqlSymbolText(true);
          break;
        case 2:
          break;
        case 3:
          Object attr = binding.getAttribute();
          // Attribute Datatype Label
          EObject datatype = null;
          attr = binding.getAttribute();
          if (TransformationHelper.isSqlColumn(attr)) {
            datatype = bindingListInput.getTargetDatatype(binding);
          }
          result = getDatatypeText(datatype);
          break;
        case 4:
          break;
        case 5:
          result = binding.getAttributeText(true);
          break;

        default:
          break;
      }
      return result;
    }
    @Override
    protected void setElementValue(Object element, Object newValue) {
      if (element instanceof Binding && newValue instanceof Boolean) {
        Binding binding = (Binding) element;

        Object attr = binding.getAttribute();

        if (TransformationHelper.isSqlColumn(attr)) {
          Shell shell = UiPlugin.getDefault().getCurrentWorkbenchWindow().getShell();
          DatatypeSelectionDialog dialog =
              new DatatypeSelectionDialog(shell, (EObject) attr, "string"); // $NON-NLS-1$
          Object originalValue = bindingListInput.getTargetDatatype(binding);

          Object[] selection = new Object[] {originalValue};

          selection[0] = originalValue;
          dialog.setInitialSelections(selection);

          int status = dialog.open();
          EObject newDatatype = (EObject) originalValue;
          if (status == Window.OK) {
            Object[] result = dialog.getResult();
            if (result.length == 0) {
              // null out the value
              newDatatype = null;
            } else {
              // return the selected value
              newDatatype = (EObject) result[0];
            }
          }
          // If different datatype was chosen, set it on the binding
          if (newDatatype != null && !newDatatype.equals(originalValue)) {
            bindingListInput.setTargetDatatype(binding, newDatatype);
            updateAttributeConversionPanelButtons(binding);
          }
        }

        // chooserPanel.layout();
        bindingTableViewer.refresh(true);
        updateRowColors();
        updateMessageArea();
      }
    }
  /* (non-Javadoc)
   * @See org.teiid.designer.ui.actions.IModelObjectEditHelper#canDelete(java.lang.Object)
   */
  @Override
  public boolean canDelete(Object obj) {
    if (obj instanceof EObject) {

      // Defect 23466 - Need to put a hack in here to NOT allow deleting if the focused part is
      // Diagram Editor, the diagram is
      // a transformation & the transformation global actions manager says it can or not.
      // This is because the SQL Editor global actions may supercede the DiagramEditor's and there
      // is no framework to restore
      // these actions at the momement.

      // Let's Check out the selection's source. If it's
      IWorkbenchPart activePart =
          UiPlugin.getDefault().getCurrentWorkbenchWindow().getPartService().getActivePart();

      if (activePart instanceof ModelEditor) {
        IEditorPart activeSubEditorPart = ((ModelEditor) activePart).getActiveEditor();
        if (activeSubEditorPart instanceof DiagramEditor) {
          DiagramViewer viewer = ((DiagramEditor) activeSubEditorPart).getDiagramViewer();
          if (viewer.isValidViewer() && viewer.hasFocus()) {
            // Check for T-Diagram
            Diagram diagram = viewer.getEditor().getDiagram();
            if (diagram.getType().equals(PluginConstants.MAPPING_TRANSFORMATION_DIAGRAM_TYPE_ID)) {
              EObject vTable = diagram.getTarget();
              if (vTable != null) {
                EObject transform = TransformationHelper.getTransformationMappingRoot(vTable);
                if (transform != null) {
                  IStructuredSelection diagramSelection =
                      (IStructuredSelection) viewer.getSelection();
                  List selectedObjs = SelectionUtilities.getSelectedEObjects(diagramSelection);
                  if (selectedObjs.contains(obj)) {
                    return TransformationGlobalActionsManager.canDelete(transform, selectedObjs);
                  }
                }
              }
            }
          }
        }
      }
    }
    return true;
  }
  /** handler for Datatype chooser dialog */
  void showDatatypeDialogPressed() {
    Binding binding = getSelectedBinding();
    if (binding != null) {
      Object attr = binding.getAttribute();
      if (TransformationHelper.isSqlColumn(attr)) {
        Shell shell = UiPlugin.getDefault().getCurrentWorkbenchWindow().getShell();
        DatatypeSelectionDialog dialog =
            new DatatypeSelectionDialog(shell, (EObject) attr, "string"); // $NON-NLS-1$
        Object originalValue = this.chooserDatatype;
        Object[] selection = new Object[] {originalValue};
        selection[0] = originalValue;
        dialog.setInitialSelections(selection);

        int status = dialog.open();
        EObject newDatatype = (EObject) originalValue;
        if (status == Window.OK) {
          Object[] result = dialog.getResult();
          if (result.length == 0) {
            // null out the value
            newDatatype = null;
          } else {
            // return the selected value
            newDatatype = (EObject) result[0];
          }
        }
        // If different datatype was chosen, set it on the binding
        if (!newDatatype.equals(originalValue)) {
          setChooserDatatype(newDatatype);
          updateAttributeConversionPanelButtons(binding);
        }
      }
      attrGroup.layout();
      // chooserPanel.layout();
      tableViewer.refresh(true);
      updateRowColors();
      updateMessageArea();
    }
  }
예제 #5
0
  private Collection getTransforMationsForTable(
      final Object container,
      final String entityName,
      final char recordType,
      final boolean isPartialName) {
    AbstractNameFinder finder = null;
    switch (recordType) {
      case IndexConstants.RECORD_TYPE.SELECT_TRANSFORM:
      case IndexConstants.RECORD_TYPE.INSERT_TRANSFORM:
      case IndexConstants.RECORD_TYPE.UPDATE_TRANSFORM:
      case IndexConstants.RECORD_TYPE.DELETE_TRANSFORM:
      case IndexConstants.RECORD_TYPE.MAPPING_TRANSFORM:
        finder = new TableNameFinder(entityName, isPartialName);
        break;
      case IndexConstants.RECORD_TYPE.PROC_TRANSFORM:
        finder = new ProcedureNameFinder(entityName, isPartialName);
        break;
      default:
        throw new ModelerCoreRuntimeException(
            TransformationPlugin.Util.getString(
                "TransformationMetadata.No_known_index_file_type_associated_with_the_recordType_1",
                new Character(recordType))); // $NON-NLS-1$		
    }

    executeVisitor(container, finder, ModelVisitorProcessor.DEPTH_INFINITE);
    Collection matches = finder.getMatchingEObjects();
    Collection transforms = new ArrayList(matches.size());
    for (Iterator targetIter = matches.iterator(); targetIter.hasNext(); ) {
      EObject targetObj = (EObject) targetIter.next();
      if (org.teiid.designer.core.metamodel.aspect.sql.SqlAspectHelper.isValidTransformationTarget(
          targetObj)) {
        EObject mappinRoot = TransformationHelper.getMappingRoot(targetObj);
        transforms.add(mappinRoot);
      }
    }

    return transforms;
  }
  private void createResolveAttributePanel(Composite parent) {
    if (this.targetLocked) {
      attrGroup = WidgetFactory.createGroup(parent, RESOLVE_ATTR_GROUP_LOCKED_NAME);
    } else {
      attrGroup = WidgetFactory.createGroup(parent, RESOLVE_ATTR_GROUP_NAME);
    }
    GridLayout gridLayout = new GridLayout();
    attrGroup.setLayout(gridLayout);
    gridLayout.numColumns = 4;
    gridLayout.marginHeight = 0;
    gridLayout.marginWidth = 0;
    gridLayout.marginLeft = 5;
    gridLayout.marginBottom = 5;
    GridData gridData = new GridData(GridData.FILL_HORIZONTAL);
    attrGroup.setLayoutData(gridData);

    Binding binding = bindingList.get(0);
    Object attr = binding.getAttribute();
    // Attribute Datatype Label
    EObject datatype = null;
    attr = binding.getAttribute();
    if (TransformationHelper.isSqlColumn(attr)) {
      datatype = TransformationHelper.getSqlColumnDatatype((EObject) attr);
    }
    String datatypeText = getDatatypeText(datatype);
    Image datatypeImage = getDatatypeImage(datatype);

    attrGroup.setText(VIRTUAL_TARGET_ATTRIBUTE_TXT);

    // --------------------------------------
    // SQL Symbol Label
    // --------------------------------------
    attributeLabel =
        WidgetFactory.createLabel(attrGroup, "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"); // $NON-NLS-1$
    GridData attrGD =
        new GridData(
            GridData.HORIZONTAL_ALIGN_BEGINNING, GridData.VERTICAL_ALIGN_FILL, false, false, 4, 1);
    attributeLabel.setLayoutData(attrGD);
    attributeLabel.setForeground(getDisplay().getSystemColor(SWT.COLOR_BLUE));

    Label rtTypeLabel = WidgetFactory.createLabel(attrGroup, RUNTIME_TYPE_TXT);
    GridData gdRT =
        new GridData(
            GridData.HORIZONTAL_ALIGN_BEGINNING,
            GridData.VERTICAL_ALIGN_BEGINNING,
            false,
            false,
            2,
            1);
    rtTypeLabel.setLayoutData(gdRT);
    WidgetFactory.createLabel(attrGroup, CoreStringUtil.Constants.EMPTY_STRING);

    // --------------------------------------
    // Attribute RuntimeType Label
    // --------------------------------------
    attrRuntimeTypeLabel =
        WidgetFactory.createLabel(
            attrGroup,
            datatypeText,
            datatypeImage,
            GridData.HORIZONTAL_ALIGN_BEGINNING | GridData.GRAB_HORIZONTAL);

    // --------------------------------------
    // Attribute Type Chooser Panel
    // --------------------------------------
    // Create the changeSelectedAttribute Button
    this.convertSelectedAttrButton =
        WidgetFactory.createButton(
            attrGroup, CONVERT_SELECTED_ATTR_BUTTON, GridData.HORIZONTAL_ALIGN_BEGINNING);
    this.convertSelectedAttrButton.setEnabled(false);
    this.convertSelectedAttrButton.addSelectionListener(
        new SelectionAdapter() {
          @Override
          public void widgetSelected(final SelectionEvent event) {
            convertSelectedAttrPressed();
          }
        });

    // Create the changeAllAttributes Button
    this.convertAllAttrsButton =
        WidgetFactory.createButton(
            attrGroup, CONVERT_ALL_ATTR_BUTTON, GridData.HORIZONTAL_ALIGN_BEGINNING);
    this.convertAllAttrsButton.setEnabled(false);
    this.convertAllAttrsButton.addSelectionListener(
        new SelectionAdapter() {
          @Override
          public void widgetSelected(final SelectionEvent event) {
            convertAllAttrsPressed();
          }
        });

    // Create the showDatatypeDialog Button
    this.showDatatypeDialogButton =
        WidgetFactory.createButton(
            attrGroup, "Change", GridData.HORIZONTAL_ALIGN_END); // $NON-NLS-1$
    this.showDatatypeDialogButton.addSelectionListener(
        new SelectionAdapter() {
          @Override
          public void widgetSelected(final SelectionEvent event) {
            showDatatypeDialogPressed();
          }
        });

    attrDatatypeLabel =
        WidgetFactory.createLabel(
            attrGroup,
            "xxxxxxxxxxxxxxxxxxxxxxx",
            datatypeImage, //$NON-NLS-1$
            GridData.HORIZONTAL_ALIGN_BEGINNING | GridData.GRAB_HORIZONTAL);
    if (this.targetLocked) {
      this.showDatatypeDialogButton.setEnabled(false);
    } else {
      this.showDatatypeDialogButton.setEnabled(true);
    }
  }
  public String getSqlOutputString(ModelResource modelResource) throws ModelWorkspaceException {
    List transformations = modelResource.getModelTransformations().getTransformations();
    int nTransforms = transformations.size();
    int initBufferSize = nTransforms * 200;
    StringBuffer sb = new StringBuffer(initBufferSize);
    String relativeTablePath = null;
    boolean hasMissingSelects = false;
    boolean hasMissingInserts = false;
    boolean hasMissingUpdates = false;
    boolean hasMissingDeletes = false;

    for (Iterator iter = transformations.iterator(); iter.hasNext(); ) {
      Object obj = iter.next();
      String rowString = null;
      if (obj instanceof SqlTransformationMappingRoot) {
        EObject table = ((SqlTransformationMappingRoot) obj).getTarget();
        relativeTablePath = ModelerCore.getModelEditor().getModelRelativePath(table).toString();

        String userString = TransformationHelper.getSelectSqlString(obj);

        if (userString != null && relativeTablePath != null) {
          rowString = createRowForFile(QueryValidator.SELECT_TRNS, relativeTablePath, userString);
          if (rowString != null && rowString.length() > 0) {
            sb.append(rowString);
          }
        } else {
          hasMissingSelects = true;
        }

        // Now check if updates allowed
        boolean tableSupportsUpdates = TransformationHelper.tableSupportsUpdate(table);
        if (tableSupportsUpdates) {
          if (TransformationHelper.supportsInsert((EObject) obj, null)) {
            userString = TransformationHelper.getInsertSqlString(obj);

            if (userString != null && relativeTablePath != null) {
              rowString =
                  createRowForFile(QueryValidator.INSERT_TRNS, relativeTablePath, userString);
              if (rowString != null && rowString.length() > 0) {
                sb.append(rowString);
              }
            } else {
              hasMissingInserts = true;
            }
          }
          if (TransformationHelper.supportsUpdate((EObject) obj, null)) {
            userString = TransformationHelper.getUpdateSqlString(obj);

            if (userString != null && relativeTablePath != null) {
              rowString =
                  createRowForFile(QueryValidator.UPDATE_TRNS, relativeTablePath, userString);
              if (rowString != null && rowString.length() > 0) {
                sb.append(rowString);
              }
            } else {
              hasMissingUpdates = true;
            }
          }
          if (TransformationHelper.supportsDelete((EObject) obj, null)) {
            userString = TransformationHelper.getDeleteSqlString(obj);

            if (userString != null && relativeTablePath != null) {
              rowString =
                  createRowForFile(QueryValidator.DELETE_TRNS, relativeTablePath, userString);
              if (rowString != null && rowString.length() > 0) {
                sb.append(rowString);
              }
            } else {
              hasMissingDeletes = true;
            }
          }
        }
      }
    }

    // If operations are missing, specify in the error message
    if (hasMissingSelects || hasMissingInserts || hasMissingUpdates || hasMissingDeletes) {
      int count = 0;
      StringBuffer msgBuff =
          new StringBuffer(
              UiConstants.Util.getString(
                  "ExportTransformationSqlToTextAction.exportQueryProblem",
                  modelResource.getItemName())); // $NON-NLS-1$
      msgBuff.append(SPACE + LEFT_BRACKET);
      if (hasMissingSelects) {
        msgBuff.append(ISQLConstants.SQL_TYPE_SELECT_STRING);
        count++;
      }
      if (hasMissingInserts) {
        if (count > 0) msgBuff.append(SPACE + DELIMETER + SPACE);
        msgBuff.append(ISQLConstants.SQL_TYPE_INSERT_STRING);
        count++;
      }
      if (hasMissingUpdates) {
        if (count > 0) msgBuff.append(SPACE + DELIMETER + SPACE);
        msgBuff.append(ISQLConstants.SQL_TYPE_UPDATE_STRING);
        count++;
      }
      if (hasMissingDeletes) {
        if (count > 0) msgBuff.append(SPACE + DELIMETER + SPACE);
        msgBuff.append(ISQLConstants.SQL_TYPE_DELETE_STRING);
        count++;
      }
      msgBuff.append(RIGHT_BRACKET);
      UiConstants.Util.log(IStatus.ERROR, msgBuff.toString());
    }

    return sb.toString();
  }