Examples with TableEntryLocation org.talend.designer.mapper.model.tableentry.TableEntryLocation used on opensource projects

Example 11 with TableEntryLocation

use of org.talend.designer.mapper.model.tableentry.TableEntryLocation in project tdi-studio-se by Talend.

the class DataMapExpressionParserTest method testReplaceLocation_renamingTable_sameSuffix.

@Test
public void testReplaceLocation_renamingTable_sameSuffix() {
    String result = expressionParser.replaceLocation("YYY.columnA == XXXYYY.columnA", new TableEntryLocation("YYY", "columnA"), new TableEntryLocation("YYYZZZ", "columnA"));
    assertEquals("YYYZZZ.columnA == XXXYYY.columnA", result);
    // underline
    result = expressionParser.replaceLocation("YYY.columnA == XXX_YYY.columnA", new TableEntryLocation("YYY", "columnA"), new TableEntryLocation("YYYZZZ", "columnA"));
    assertEquals("YYYZZZ.columnA == XXX_YYY.columnA", result);
}

Example 12 with TableEntryLocation

use of org.talend.designer.mapper.model.tableentry.TableEntryLocation in project tdi-studio-se by Talend.

the class DataMapExpressionParserTest method testReplaceLocation_renamingTable_multiExpresions_diffColumns.

@Test
public void testReplaceLocation_renamingTable_multiExpresions_diffColumns() {
    String result = expressionParser.replaceLocation("YYY.columnA == XXXYYY.columnA && YYY.columnB == XXXYYY.columnB", new TableEntryLocation("YYY", "columnA"), new TableEntryLocation("YYYZZZ", "columnA"));
    assertEquals("YYYZZZ.columnA == XXXYYY.columnA && YYY.columnB == XXXYYY.columnB", result);
    // no space
    result = expressionParser.replaceLocation("YYY.columnA == XXXYYY.columnA &&YYY.columnB == XXXYYY.columnB", new TableEntryLocation("YYY", "columnA"), new TableEntryLocation("YYYZZZ", "columnA"));
    assertEquals("YYYZZZ.columnA == XXXYYY.columnA &&YYY.columnB == XXXYYY.columnB", result);
    result = expressionParser.replaceLocation("YYY.columnA == XXXYYY.columnA&&YYY.columnB == XXXYYY.columnB", new TableEntryLocation("YYY", "columnA"), new TableEntryLocation("YYYZZZ", "columnA"));
    assertEquals("YYYZZZ.columnA == XXXYYY.columnA&&YYY.columnB == XXXYYY.columnB", result);
    // replace again for renaming table
    result = expressionParser.replaceLocation(result, new TableEntryLocation("YYY", "columnB"), new TableEntryLocation("YYYZZZ", "columnB"));
    assertEquals("YYYZZZ.columnA == XXXYYY.columnA&&YYYZZZ.columnB == XXXYYY.columnB", result);
}

Example 13 with TableEntryLocation

use of org.talend.designer.mapper.model.tableentry.TableEntryLocation in project tdi-studio-se by Talend.

the class DataMapExpressionParserTest method testReplaceLocation_renamingTable_middle.

@Test
public void testReplaceLocation_renamingTable_middle() {
    String result = expressionParser.replaceLocation("YYY.columnA == XXXYYYZZZ.columnA", new TableEntryLocation("YYY", "columnA"), new TableEntryLocation("XXXYYY", "columnA"));
    assertEquals("XXXYYY.columnA == XXXYYYZZZ.columnA", result);
    result = expressionParser.replaceLocation("YYY.columnA == XXX_YYY_ZZZ.columnA", new TableEntryLocation("YYY", "columnA"), new TableEntryLocation("XXXYYY", "columnA"));
    assertEquals("XXXYYY.columnA == XXX_YYY_ZZZ.columnA", result);
    result = expressionParser.replaceLocation("YYY.columnA == XXXYYY_ZZZ.columnA", new TableEntryLocation("YYY", "columnA"), new TableEntryLocation("XXXYYY", "columnA"));
    assertEquals("XXXYYY.columnA == XXXYYY_ZZZ.columnA", result);
    result = expressionParser.replaceLocation("YYY.columnA == XXX_YYYZZZ.columnA", new TableEntryLocation("YYY", "columnA"), new TableEntryLocation("XXXYYY", "columnA"));
    assertEquals("XXXYYY.columnA == XXX_YYYZZZ.columnA", result);
}

Example 14 with TableEntryLocation

use of org.talend.designer.mapper.model.tableentry.TableEntryLocation in project tdi-studio-se by Talend.

the class DataMapExpressionParserTest method testReplaceLocation_renamingColumn_none.

@Test
public void testReplaceLocation_renamingColumn_none() {
    final String expression = "YYY.columnC == XXXYYY.mycolumnAB";
    String result = expressionParser.replaceLocation(expression, new TableEntryLocation("YYY", "columnA"), new TableEntryLocation("YYY", "columnB"));
    assertEquals(expression, result);
}

Example 15 with TableEntryLocation

use of org.talend.designer.mapper.model.tableentry.TableEntryLocation in project tdi-studio-se by Talend.

the class UIManager method selectDataMapTableView.

/**
     * Select a table view.
     * 
     * @param dataMapTableView
     * @param useNewCommand
     * @param selectAllEntries TODO
     */
public void selectDataMapTableView(final DataMapTableView dataMapTableView, boolean useNewCommand, boolean selectAllEntries) {
    // reject table readonly
    IDataMapTable dataMapTable = dataMapTableView.getDataMapTable();
    if (dataMapTable instanceof OutputTable && ((OutputTable) dataMapTable).isErrorRejectTable()) {
        OutputTable table = (OutputTable) dataMapTable;
        if (table.getMetadataTable() != null) {
            for (IMetadataColumn column : table.getMetadataTable().getListColumns()) {
                if (mapperManager.ERROR_REJECT_MESSAGE.equals(column.getLabel()) || mapperManager.ERROR_REJECT_STACK_TRACE.equals(column.getLabel())) {
                    column.setCustom(true);
                }
            }
        }
        CustomTableManager.addCustomManagementToTable(getOutputMetaEditorView(), true);
    }
    TabFolderEditors tabFolderEditors = mapperUI.getTabFolderEditors();
    // tabFolderEditors.setSelection(TabFolderEditors.INDEX_TAB_METADATA_EDITOR);
    MetadataTableEditorView metadataTableEditorView = null;
    MetadataTableEditorView otherMetadataTableEditorView = null;
    final Zone currentZone = dataMapTableView.getZone();
    List<? extends AbstractDataMapTable> tables = null;
    DataMapTableView previousSelectedTableView = null;
    if (currentZone == Zone.INPUTS) {
        metadataTableEditorView = tabFolderEditors.getInputMetaEditorView();
        otherMetadataTableEditorView = tabFolderEditors.getOutputMetaEditorView();
        tables = mapperManager.getInputTables();
        previousSelectedTableView = this.currentSelectedInputTableView;
        this.currentSelectedInputTableView = (InputDataMapTableView) dataMapTableView;
        metadataTableEditorView.setReadOnly(this.currentSelectedInputTableView.getInputTable().hasReadOnlyMetadataColumns() || mapperManager.componentIsReadOnly() || this.currentSelectedInputTableView.getInputTable().isReadOnly());
    } else if (currentZone == Zone.OUTPUTS) {
        metadataTableEditorView = tabFolderEditors.getOutputMetaEditorView();
        otherMetadataTableEditorView = tabFolderEditors.getInputMetaEditorView();
        tables = mapperManager.getOutputTables();
        previousSelectedTableView = this.currentSelectedOutputTableView;
        this.currentSelectedOutputTableView = (OutputDataMapTableView) dataMapTableView;
        metadataTableEditorView.setReadOnly(this.currentSelectedOutputTableView.getOutputTable().hasReadOnlyMetadataColumns() || mapperManager.componentIsReadOnly());
    } else {
        this.currentSelectedVarsTableView = (VarsDataMapTableView) dataMapTableView;
    }
    if (currentZone != Zone.VARS) {
        updateToolbarButtonsStates(currentZone);
        final AbstractInOutTable abstractDataMapTable = (AbstractInOutTable) mapperManager.retrieveAbstractDataMapTable(dataMapTableView);
        MetadataTableEditor currentMetadataTableEditor = metadataTableEditorView.getMetadataTableEditor();
        final TableViewerCreator dataMapTVCreator = dataMapTableView.getTableViewerCreatorForColumns();
        final TableViewer dataMapTableViewer = dataMapTableView.getTableViewerCreatorForColumns().getTableViewer();
        if (currentMetadataTableEditor == null || currentMetadataTableEditor != null && oldSelectedView != dataMapTableView) {
            oldSelectedView = dataMapTableView;
            if (useNewCommand) {
                DataMapTableViewSelectedCommand command = new DataMapTableViewSelectedCommand(this, previousSelectedTableView, dataMapTableView);
                mapperManager.executeCommand(command);
            }
            currentMetadataTableEditor = new MetadataTableEditor(abstractDataMapTable.getMetadataTable(), abstractDataMapTable.getName());
            currentMetadataTableEditor.setModifiedBeanListenable(metadataTableEditorView.getTableViewerCreator());
            final MetadataTableEditorView metadataTableEditorViewFinal = metadataTableEditorView;
            final TableViewerCreator metadataTVCreator = metadataTableEditorViewFinal.getTableViewerCreator();
            final MetadataTableEditor metadataTableEditor = currentMetadataTableEditor;
            modifySelectionChangedListener(currentZone, metadataTableEditorViewFinal, metadataTVCreator, metadataTableEditor, dataMapTableView, previousSelectedTableView);
            // init actions listeners for list which contains metadata
            metadataTableEditor.addAfterOperationListListener(new IListenableListListener() {

                /**
                     * DOC acer Comment method "handleEvent".
                     * 
                     * @param event
                     */
                public void handleEvent(ListenableListEvent event) {
                    DataMapTableView view = mapperManager.retrieveAbstractDataMapTableView(abstractDataMapTable);
                    List<DataMapTableView> relatedOutputsTableView = getRelatedOutputsTableView(dataMapTableView);
                    if (event.type == TYPE.ADDED) {
                        // metadataEditorTableViewer.refresh();
                        List<IMetadataColumn> metadataColumns = (List<IMetadataColumn>) event.addedObjects;
                        lastCreatedInOutColumnEntries.clear();
                        if (event.index != null) {
                            int index = event.index;
                            for (IMetadataColumn metadataColumn : metadataColumns) {
                                lastCreatedInOutColumnEntries.add(mapperManager.addNewColumnEntry(dataMapTableView, metadataColumn, index));
                                // handle related table view
                                for (DataMapTableView tableView : relatedOutputsTableView) {
                                    // changed for bug TDI-26551 in July 2,2013 by fwang, should use original
                                    // expression for related table.
                                    IMetadataColumn relatedMetadata = metadataColumn;
                                    if (!oldMappingMap.isEmpty()) {
                                        IDataMapTable retrieveAbstractDataMapTable = mapperManager.retrieveAbstractDataMapTable(tableView);
                                        relatedMetadata = metadataColumn.clone();
                                        String label = relatedMetadata.getLabel();
                                        String expression = oldMappingMap.get(retrieveAbstractDataMapTable.getName() + "_" + label);
                                        relatedMetadata.setExpression(expression == null ? "" : expression);
                                    }
                                    mapperManager.addNewColumnEntry(tableView, relatedMetadata, index);
                                }
                                index = index + 1;
                            }
                        } else if (event.indicesTarget != null) {
                            List<Integer> indicesTarget = event.indicesTarget;
                            int lstSize = indicesTarget.size();
                            for (int i = 0; i < lstSize; i++) {
                                Integer indice = indicesTarget.get(i);
                                IMetadataColumn metadataColumn = metadataColumns.get(i);
                                lastCreatedInOutColumnEntries.add(mapperManager.addNewColumnEntry(dataMapTableView, metadataColumn, indice));
                                // handle related table view
                                for (DataMapTableView tableView : relatedOutputsTableView) {
                                    mapperManager.addNewColumnEntry(tableView, metadataColumn, indice);
                                }
                            }
                        } else {
                            //$NON-NLS-1$
                            throw new IllegalStateException(Messages.getString("UIManager.1"));
                        }
                        refreshBackground(false, false);
                        if (event.index != null) {
                            dataMapTableViewer.refresh();
                            dataMapTVCreator.getSelectionHelper().setSelection(event.index);
                            if (dataMapTableView.canBeResizedAtPreferedSize()) {
                                dataMapTableView.changeSize(view.getPreferredSize(true, false, false), true, true);
                            }
                            // resize ralated table
                            for (DataMapTableView tableView : relatedOutputsTableView) {
                                if (tableView.canBeResizedAtPreferedSize()) {
                                    tableView.changeSize(tableView.getPreferredSize(true, false, false), true, true);
                                }
                            }
                        } else if (event.indicesTarget != null) {
                            dataMapTableViewer.refresh();
                            dataMapTableView.changeSize(view.getPreferredSize(false, true, false), true, true);
                            int[] selection = ArrayUtils.toPrimitive((Integer[]) event.indicesTarget.toArray(new Integer[0]));
                            dataMapTVCreator.getSelectionHelper().setSelection(selection);
                            for (DataMapTableView tableView : relatedOutputsTableView) {
                                tableView.changeSize(tableView.getPreferredSize(false, true, false), true, true);
                            }
                        }
                    }
                    if (event.type == TYPE.REMOVED) {
                        // metadataEditorTableViewer.refresh();
                        List<IMetadataColumn> metadataColumns = (List<IMetadataColumn>) event.removedObjects;
                        for (IMetadataColumn metadataColumn : metadataColumns) {
                            ITableEntry metadataTableEntry = mapperManager.retrieveTableEntry(new TableEntryLocation(abstractDataMapTable.getName(), metadataColumn.getLabel()));
                            mapperManager.removeTableEntry(metadataTableEntry);
                            for (DataMapTableView tableView : relatedOutputsTableView) {
                                IDataMapTable retrieveAbstractDataMapTable = mapperManager.retrieveAbstractDataMapTable(tableView);
                                metadataTableEntry = mapperManager.retrieveTableEntry(new TableEntryLocation(retrieveAbstractDataMapTable.getName(), metadataColumn.getLabel()));
                                mapperManager.removeTableEntry(metadataTableEntry);
                                if (tableView.canBeResizedAtPreferedSize()) {
                                    tableView.resizeAtExpandedSize();
                                }
                            }
                        }
                        dataMapTableViewer.refresh();
                        if (dataMapTableView.canBeResizedAtPreferedSize()) {
                            dataMapTableView.resizeAtExpandedSize();
                        }
                        resizeTablesZoneViewAtComputedSize(dataMapTableView.getZone());
                        moveScrollBarZoneAtSelectedTable(dataMapTableView.getZone());
                        refreshBackground(true, false);
                    }
                    if (event.type == TYPE.SWAPED) {
                        List<Integer> listIndexTarget = event.indicesTarget;
                        abstractDataMapTable.swapColumnElements(event.indicesOrigin, listIndexTarget);
                        // handle related table view
                        for (DataMapTableView tableView : relatedOutputsTableView) {
                            AbstractDataMapTable relatedTable = (AbstractDataMapTable) tableView.getDataMapTable();
                            relatedTable.swapColumnElements(event.indicesOrigin, listIndexTarget);
                        }
                        // dataMapTableViewer.refresh();
                        refreshBackground(true, false);
                    }
                }
            });
            metadataTableEditorView.getTableViewerCreator().getSelectionHelper().setActiveFireSelectionChanged(false);
            metadataTableEditorView.setMetadataTableEditor(metadataTableEditor);
            metadataTableEditorView.getTableViewerCreator().getSelectionHelper().setActiveFireSelectionChanged(true);
            metadataTableEditorView.getExtendedToolbar().updateEnabledStateOfButtons();
            dataMapTVCreator.getSelectionHelper().setActiveFireSelectionChanged(false);
            metadataTableEditorView.getTableViewerCreator().getSelectionHelper().setSelection(dataMapTableViewer.getTable().getSelectionIndices());
            dataMapTVCreator.getSelectionHelper().setActiveFireSelectionChanged(true);
            // disable highlight for other DataMapTableView and highlight selected DataMapTableView
            for (IDataMapTable table : tables) {
                DataMapTableView otherDataMapTableView = mapperManager.retrieveAbstractDataMapTableView(table);
                otherDataMapTableView.setBackground(dataMapTableView.getDisplay().getSystemColor(SWT.COLOR_WIDGET_LIGHT_SHADOW));
            }
            dataMapTableView.setBackground(dataMapTableView.getDisplay().getSystemColor(SWT.COLOR_YELLOW));
        }
        if (selectAllEntries) {
            dataMapTVCreator.getTable().selectAll();
            selectAllLinks(dataMapTableView);
            if (currentZone != Zone.VARS) {
                metadataTableEditorView.getTableViewerCreator().getTable().selectAll();
                metadataTableEditorView.getToolBar().updateEnabledStateOfButtons();
            }
            if (currentZone == Zone.OUTPUTS) {
                dataMapTableView.getTableViewerCreatorForFilters().getTable().selectAll();
            }
        }
        boolean isMainSchemaRepository = false;
        if (abstractDataMapTable instanceof OutputTable) {
            OutputTable outputTable = (OutputTable) abstractDataMapTable;
            if (outputTable.getIsJoinTableOf() != null || !"".equals(outputTable.getIsJoinTableOf())) {
                final OutputTable outputTableByName = mapperManager.getOutputTableByName(outputTable.getIsJoinTableOf());
                if (outputTableByName != null && outputTableByName.getId() != null) {
                    isMainSchemaRepository = true;
                }
            }
        }
        dataMapTableView.enableDiaplayViewer(abstractDataMapTable.isRepository() || isMainSchemaRepository);
    }
    if (selectAllEntries && currentZone == Zone.VARS) {
        selectAllLinks(dataMapTableView);
        mapperManager.getUiManager().getVarsTablesView().get(0).getTableViewerCreatorForColumns().getTable().selectAll();
    }
    if (otherMetadataTableEditorView != null) {
        otherMetadataTableEditorView.getExtendedToolbar().updateEnabledStateOfButtons();
    }
}