Examples with SQLPattern org.talend.designer.business.model.business.SQLPattern used on opensource projects

Example 1 with SQLPattern

use of org.talend.designer.business.model.business.SQLPattern in project tdi-studio-se by Talend.

the class FindAssignmentAction method doRun.

/*
     * (non-Javadoc)
     * 
     * @see org.eclipse.jface.action.Action#run()
     */
@Override
protected void doRun() {
    RepositoryNode repositoryNode = (RepositoryNode) getFirstSelectedObject();
    IEditorPart activeEditor = getActiveEditor();
    // remove frames draw last time
    for (BusinessItemShapeFigure shapFigure : repaintedFigures) {
        shapFigure.setDrawFrame(false);
        shapFigure.revalidate();
        shapFigure.repaint();
    }
    if (activeEditor instanceof BusinessDiagramEditor) {
        BusinessDiagramEditor businessDiagramEditor = (BusinessDiagramEditor) activeEditor;
        Diagram diagram = (Diagram) businessDiagramEditor.getDiagramEditPart().getModel();
        BusinessProcess businessProcess = (BusinessProcess) diagram.getElement();
        // PTODO mhelleboid use OCL or using a visitor
        List list = new ArrayList();
        for (Iterator iter = businessProcess.getBusinessItems().iterator(); iter.hasNext(); ) {
            BusinessItem businessItem = (BusinessItem) iter.next();
            for (Iterator iterator = businessItem.getAssignments().iterator(); iterator.hasNext(); ) {
                BusinessAssignment businessAssignment = (BusinessAssignment) iterator.next();
                TalendItem talendItem = businessAssignment.getTalendItem();
                IRepositoryViewObject obj = repositoryNode.getObject();
                if (talendItem.getId().equals(repositoryNode.getId())) {
                    list.add(businessItem);
                } else if (talendItem instanceof SQLPattern || talendItem instanceof Routine || talendItem instanceof TableMetadata || talendItem instanceof Query || talendItem instanceof SapFunctionMetadata) {
                    if (talendItem.getLabel().equals(repositoryNode.getProperties(EProperties.LABEL))) {
                        list.add(businessItem);
                    }
                }
            }
        }
        IDiagramGraphicalViewer diagramGraphicalViewer = businessDiagramEditor.getDiagramGraphicalViewer();
        List editParts = new ArrayList();
        for (Iterator iter = list.iterator(); iter.hasNext(); ) {
            BusinessItem businessItem = (BusinessItem) iter.next();
            editParts.addAll(diagramGraphicalViewer.findEditPartsForElement(EMFCoreUtil.getProxyID(businessItem), BaseBusinessItemRelationShipEditPart.class));
            editParts.addAll(diagramGraphicalViewer.findEditPartsForElement(EMFCoreUtil.getProxyID(businessItem), BusinessItemShapeEditPart.class));
        }
        diagramGraphicalViewer.deselectAll();
        // add a frame when use findAassignment
        for (Iterator iter = editParts.iterator(); iter.hasNext(); ) {
            EditPart editPart = (EditPart) iter.next();
            if (editPart instanceof BusinessItemShapeEditPart) {
                BusinessItemShapeEditPart shapEditPart = (BusinessItemShapeEditPart) editPart;
                IFigure figure = shapEditPart.getFigure();
                for (Object child : figure.getChildren()) {
                    if (child instanceof BusinessItemShapeFigure) {
                        BusinessItemShapeFigure shapFigure = (BusinessItemShapeFigure) child;
                        shapFigure.setDrawFrame(true);
                        shapFigure.revalidate();
                        shapFigure.repaint();
                        repaintedFigures.add(shapFigure);
                    }
                }
            }
            diagramGraphicalViewer.getSelectionManager().appendSelection(editPart);
        }
        ZoomManager zoomManager = (ZoomManager) businessDiagramEditor.getAdapter(ZoomManager.class);
        zoomFitSelection(zoomManager, editParts, businessDiagramEditor.getDiagramEditPart(), true);
    }
}

Example 2 with SQLPattern

use of org.talend.designer.business.model.business.SQLPattern in project tdi-studio-se by Talend.

the class BusinessAssignmentComposite method createSelectionListener.

private void createSelectionListener() {
    tableViewer.addSelectionChangedListener(new ISelectionChangedListener() {

        @Override
        public void selectionChanged(SelectionChangedEvent event) {
            BusinessAssignment businessAssignment = getBusinessAssignment(event.getSelection());
            if (businessAssignment != null) {
                final IRepositoryView repositoryView = getRepositoryView();
                if (repositoryView != null) {
                    IProjectRepositoryNode rootRepositoryNode = repositoryView.getRoot();
                    TalendItem item = businessAssignment.getTalendItem();
                    //
                    if (item instanceof Routine && rootRepositoryNode instanceof ProjectRepositoryNode) {
                        RepositoryNodeUtilities.expandParentNode(getRepositoryView(), ((ProjectRepositoryNode) rootRepositoryNode).getRootRepositoryNode(ERepositoryObjectType.CODE));
                    }
                    selectChild(item, (IRepositoryNode) rootRepositoryNode);
                }
            }
        }

        private void selectChild(TalendItem item, IRepositoryNode rootRepositoryNode) {
            try {
                RepositoryNode curNode = null;
                JobSettingsView viewer = (JobSettingsView) PlatformUI.getWorkbench().getActiveWorkbenchWindow().getActivePage().findView(JobSettingsView.ID);
                IRepositoryViewObject lastVersion = ProxyRepositoryFactory.getInstance().getLastVersion(item.getId());
                if (lastVersion != null) {
                    curNode = RepositoryNodeUtilities.getRepositoryNode(lastVersion);
                    select(viewer, curNode);
                } else if (item instanceof TableMetadata) {
                    MetadataTable table = MetadataToolHelper.getMetadataTableFromRepository(item.getId());
                    if (table != null) {
                        //$NON-NLS-1$
                        String id = item.getId().split(" - ")[0];
                        RepositoryNode node = RepositoryNodeUtilities.getMetadataTableFromConnection(item.getId());
                        IRepositoryView view = getRepositoryView();
                        if (view != null) {
                            RepositoryNodeUtilities.expandParentNode(view, node);
                            select(viewer, node);
                        }
                    }
                } else if (item instanceof Query) {
                    org.talend.core.model.metadata.builder.connection.Query query = MetadataToolHelper.getQueryFromRepository(item.getId());
                    if (query != null) {
                        //$NON-NLS-1$
                        String id = item.getId().split(" - ")[0];
                        IRepositoryView view = getRepositoryView();
                        RepositoryNode node = RepositoryNodeUtilities.getQueryFromConnection(item.getId());
                        RepositoryNodeUtilities.expandParentNode(view, node);
                        select(viewer, node);
                    }
                } else if (item instanceof SAPFunction) {
                    SAPFunctionUnit function = MetadataToolHelper.getSAPFunctionFromRepository(item.getId());
                    if (function != null) {
                        IRepositoryView view = getRepositoryView();
                        RepositoryNode node = RepositoryNodeUtilities.getSAPFunctionFromConnection(item.getId());
                        RepositoryNodeUtilities.expandParentNode(view, node);
                        select(viewer, node);
                    }
                } else {
                    for (IRepositoryNode node : rootRepositoryNode.getChildren()) {
                        RepositoryNode rNode = (RepositoryNode) node;
                        if (item instanceof SQLPattern && rNode.getProperties(EProperties.CONTENT_TYPE) == ERepositoryObjectType.SQLPATTERNS) {
                            if (rNode.getType() == ENodeType.REPOSITORY_ELEMENT) {
                                SQLPatternItem sqlItem = (SQLPatternItem) rNode.getObject().getProperty().getItem();
                                if (sqlItem.isSystem() && item.getLabel().equals(rNode.getObject().getLabel())) {
                                    select(viewer, rNode);
                                }
                            } else {
                                selectChild(item, rNode);
                            }
                        } else if (item instanceof Routine && rNode.getProperties(EProperties.CONTENT_TYPE) == ERepositoryObjectType.ROUTINES) {
                            if (rNode.getType() == ENodeType.REPOSITORY_ELEMENT) {
                                RoutineItem sqlItem = (RoutineItem) rNode.getObject().getProperty().getItem();
                                if (sqlItem.isBuiltIn() && item.getLabel().equals(rNode.getObject().getLabel())) {
                                    select(viewer, rNode);
                                }
                            } else {
                                selectChild(item, rNode);
                            }
                        }
                    }
                }
            } catch (PersistenceException e) {
                // TODO Auto-generated catch block
                // e.printStackTrace();
                ExceptionHandler.process(e);
            }
        }

        private void select(JobSettingsView viewer, RepositoryNode repositoryNode) {
            if (viewer == null) {
                return;
            }
            if (repositoryNode == null) {
                return;
            }
            CorePlugin.getDefault().getRepositoryService().removeRepositoryTreeViewListener(viewer);
            final IRepositoryView repositoryView = getRepositoryView();
            if (repositoryView != null) {
                repositoryView.getViewer().setSelection(new StructuredSelection(repositoryNode));
            }
            CorePlugin.getDefault().getRepositoryService().addRepositoryTreeViewListener(viewer);
        }
    });
}

Example 3 with SQLPattern

use of org.talend.designer.business.model.business.SQLPattern in project tdi-studio-se by Talend.

the class BusinessAssignmentComposite method createRepositoryNode.

private RepositoryNode createRepositoryNode(BusinessAssignment businessAssignment) {
    IRepositoryViewObject lastVersion;
    try {
        TalendItem item = businessAssignment.getTalendItem();
        lastVersion = ProxyRepositoryFactory.getInstance().getLastVersion(item.getId());
        if (lastVersion != null) {
            ERepositoryObjectType itemType = ERepositoryObjectType.getItemType(lastVersion.getProperty().getItem());
            RepositoryNode repositoryNode = new RepositoryNode(lastVersion, RepositoryNodeUtilities.getParentRepositoryNodeFromSelection(lastVersion), ENodeType.REPOSITORY_ELEMENT);
            repositoryNode.setProperties(EProperties.CONTENT_TYPE, itemType);
            return repositoryNode;
        } else if (item instanceof SQLPattern) {
            IRepositoryViewObject object = getObjectFromSystem(item, ERepositoryObjectType.SQLPATTERNS);
            if (object != null) {
                RepositoryNode repositoryNode = new RepositoryNode(object, RepositoryNodeUtilities.getParentRepositoryNodeFromSelection(object), ENodeType.REPOSITORY_ELEMENT);
                repositoryNode.setProperties(EProperties.CONTENT_TYPE, ERepositoryObjectType.SQLPATTERNS);
                return repositoryNode;
            }
        } else if (item instanceof Routine) {
            IRepositoryViewObject object = getObjectFromSystem(item, ERepositoryObjectType.ROUTINES);
            if (object != null) {
                RepositoryNode repositoryNode = new RepositoryNode(object, RepositoryNodeUtilities.getParentRepositoryNodeFromSelection(object), ENodeType.REPOSITORY_ELEMENT);
                repositoryNode.setProperties(EProperties.CONTENT_TYPE, ERepositoryObjectType.ROUTINES);
                return repositoryNode;
            }
        } else if (item instanceof TableMetadata) {
            MetadataTable table = MetadataToolHelper.getMetadataTableFromRepository(item.getId());
            if (table != null) {
                return RepositoryNodeUtilities.getMetadataTableFromConnection(item.getId());
            }
        } else if (item instanceof Query) {
            org.talend.core.model.metadata.builder.connection.Query query = MetadataToolHelper.getQueryFromRepository(item.getId());
            if (query != null) {
                return RepositoryNodeUtilities.getQueryFromConnection(item.getId());
            }
        } else if (item instanceof SAPFunction) {
            SAPFunctionUnit function = MetadataToolHelper.getSAPFunctionFromRepository(item.getId());
            if (function != null) {
                return RepositoryNodeUtilities.getSAPFunctionFromConnection(item.getId());
            }
        }
    } catch (PersistenceException e) {
    }
    return null;
}

Example 4 with SQLPattern

use of org.talend.designer.business.model.business.SQLPattern in project tdi-studio-se by Talend.

the class RepositoryFactoryProxyLabelProvider method getColumnImage.

@Override
public Image getColumnImage(Object object, int columnIndex) {
    Image image = super.getColumnImage(object, columnIndex);
    BusinessAssignment assignment = (BusinessAssignment) object;
    try {
        if (columnIndex == 0) {
            IRepositoryViewObject lastVersion = getLastVersion(object);
            if (lastVersion == null) {
                MetadataTable table = MetadataToolHelper.getMetadataTableFromRepository(assignment.getTalendItem().getId());
                if (table != null) {
                    return image;
                }
                Query query = MetadataToolHelper.getQueryFromRepository(assignment.getTalendItem().getId());
                if (query != null) {
                    return image;
                }
                SAPFunctionUnit function = MetadataToolHelper.getSAPFunctionFromRepository(assignment.getTalendItem().getId());
                if (function != null) {
                    return image;
                }
                TalendItem item = assignment.getTalendItem();
                if (item instanceof SQLPattern) {
                    List<IRepositoryViewObject> list = ProxyRepositoryFactory.getInstance().getAll(ERepositoryObjectType.SQLPATTERNS);
                    for (IRepositoryViewObject obj : list) {
                        if (item.getLabel().equals(obj.getLabel())) {
                            return image;
                        }
                    }
                } else if (item instanceof Routine) {
                    List<IRepositoryViewObject> list = ProxyRepositoryFactory.getInstance().getAll(ERepositoryObjectType.ROUTINES);
                    for (IRepositoryViewObject obj : list) {
                        if (item.getLabel().equals(obj.getLabel())) {
                            return image;
                        }
                    }
                }
                return new OverlayImage(image, ImageProvider.getImageDesc(ECoreImage.DELETED_OVERLAY), EPosition.BOTTOM_RIGHT).createImage();
            } else if (isDeleted(lastVersion)) {
                return new OverlayImage(image, ImageProvider.getImageDesc(ECoreImage.RECYCLE_BIN_OVERLAY), EPosition.BOTTOM_RIGHT).createImage();
            }
        }
    } catch (PersistenceException e) {
        // e.printStackTrace();
        ExceptionHandler.process(e);
    }
    return image;
}

Example 5 with SQLPattern

use of org.talend.designer.business.model.business.SQLPattern in project tdi-studio-se by Talend.

the class RepositoryFactoryProxyLabelProvider method getColumnText.

@Override
public String getColumnText(Object object, int columnIndex) {
    String columnText = super.getColumnText(object, columnIndex);
    BusinessAssignment assignment = (BusinessAssignment) object;
    IRepositoryViewObject lastVersion = getLastVersion(object);
    try {
        if (columnIndex == 0) {
            if (lastVersion == null) {
                MetadataTable table = MetadataToolHelper.getMetadataTableFromRepository(assignment.getTalendItem().getId());
                if (table != null) {
                    if (SubItemHelper.isDeleted(table)) {
                        //$NON-NLS-1$
                        columnText += Messages.getString("RepositoryFactoryProxyLabelProvider.Deleted");
                    }
                    return columnText;
                }
                Query query = MetadataToolHelper.getQueryFromRepository(assignment.getTalendItem().getId());
                if (query != null) {
                    if (SubItemHelper.isDeleted(query)) {
                        //$NON-NLS-1$
                        columnText += Messages.getString("RepositoryFactoryProxyLabelProvider.Deleted");
                    }
                    return columnText;
                }
                SAPFunctionUnit function = MetadataToolHelper.getSAPFunctionFromRepository(assignment.getTalendItem().getId());
                if (function != null) {
                    if (SubItemHelper.isDeleted(function)) {
                        //$NON-NLS-1$
                        columnText += Messages.getString("RepositoryFactoryProxyLabelProvider.Deleted");
                    }
                    return columnText;
                }
                TalendItem item = assignment.getTalendItem();
                if (item instanceof SQLPattern) {
                    List<IRepositoryViewObject> list = ProxyRepositoryFactory.getInstance().getAll(ERepositoryObjectType.SQLPATTERNS);
                    for (IRepositoryViewObject obj : list) {
                        if (item.getLabel().equals(obj.getLabel())) {
                            return columnText;
                        }
                    }
                } else if (item instanceof Routine) {
                    List<IRepositoryViewObject> list = ProxyRepositoryFactory.getInstance().getAll(ERepositoryObjectType.ROUTINES);
                    for (IRepositoryViewObject obj : list) {
                        if (item.getLabel().equals(obj.getLabel())) {
                            return columnText;
                        }
                    }
                }
                //$NON-NLS-1$
                columnText += Messages.getString("RepositoryFactoryProxyLabelProvider.NotFound");
            } else if (isDeleted(lastVersion)) {
                //$NON-NLS-1$
                columnText += Messages.getString("RepositoryFactoryProxyLabelProvider.Deleted");
            }
        }
    } catch (PersistenceException e) {
        // e.printStackTrace();
        ExceptionHandler.process(e);
    }
    if (columnIndex == 1) {
        if (lastVersion != null) {
            String label = lastVersion.getProperty().getLabel();
            if (!label.equals(columnText)) {
                ChangeTalendItemLabelCommand command = new ChangeTalendItemLabelCommand(((BusinessAssignment) object).getTalendItem(), label);
                try {
                    command.execute(null, null);
                } catch (ExecutionException e) {
                }
                return label;
            }
        }
    }
    return columnText;
}