Examples with MetadataDialog org.talend.core.ui.metadata.dialog.MetadataDialog used on opensource projects

Example 6 with MetadataDialog

use of org.talend.core.ui.metadata.dialog.MetadataDialog in project tdi-studio-se by Talend.

the class MultiSchemasUI method addButtonListeners.

protected void addButtonListeners() {
    // Event PreviewButton
    previewBtn.addSelectionListener(new SelectionAdapter() {

        @Override
        public void widgetSelected(final SelectionEvent e) {
            refreshPreview();
        }
    });
    fetchBtn.addSelectionListener(new SelectionAdapter() {

        @Override
        public void widgetSelected(final SelectionEvent e) {
            fetchCodes();
        }
    });
    leftBtn.addSelectionListener(new SelectionAdapter() {

        @Override
        public void widgetSelected(final SelectionEvent e) {
            getUIManager().moveRecord(schemaTreeViewer, true);
            getUIManager().packSchemaTreeFirstColumn(schemaTreeViewer);
        }
    });
    rightBtn.addSelectionListener(new SelectionAdapter() {

        @Override
        public void widgetSelected(final SelectionEvent e) {
            getUIManager().moveRecord(schemaTreeViewer, false);
            getUIManager().packSchemaTreeFirstColumn(schemaTreeViewer);
        }
    });
    addRow.addSelectionListener(new // hywang for 10263
    SelectionAdapter() {

        @Override
        public void widgetSelected(SelectionEvent e) {
            SchemasKeyData root = (SchemasKeyData) schemaTreeViewer.getInput();
            AddRowDialog dialog = new AddRowDialog(MultiSchemasUI.this.getShell(), root);
            if (Window.OK == dialog.open()) {
                Object input = schemaTreeViewer.getInput();
                if (input instanceof SchemasKeyData) {
                    SchemasKeyData data = (SchemasKeyData) input;
                    List<SchemasKeyData> all = data.getChildren();
                    SchemasKeyData newData = new SchemasKeyData(dialog.getRecordValue());
                    newData.setSeparator(dialog.getSepValue());
                    newData.setUniqueRecord(dialog.getKeyValue());
                    final IMetadataTable metadataTable = MetadataToolHelper.getMetadataTableFromNode(getMultiSchemasComponent(), dialog.getKeyValue());
                    if (metadataTable != null) {
                        multiSchemaManager.createMultiSchemasColumns(newData, metadataTable.clone(true));
                    } else {
                        List<MultiMetadataColumn> colums = multiSchemaManager.createPropertiesColumns(newData);
                        newData.setMetadataColumns(colums);
                    }
                    all.add(newData);
                    data.addChild(newData);
                    newData.setParent(data);
                    schemaTreeViewer.refresh();
                    int len = schemaTreeViewer.getTree().getItems().length;
                    schemaTreeViewer.getTree().select(schemaTreeViewer.getTree().getItems()[len - 1]);
                }
                getUIManager().refreshSchemasDetailView(schemaTreeViewer, schemaDetailsViewer, getSchemaDetailModel());
            }
        }
    });
    removeRow.addSelectionListener(new // hywang for 10263
    SelectionAdapter() {

        @Override
        public void widgetSelected(SelectionEvent e) {
            boolean needRefresh = false;
            if (schemaTreeViewer == null) {
                return;
            }
            SchemasKeyData removeData = null;
            ISelection selection = schemaTreeViewer.getSelection();
            Object input = schemaTreeViewer.getInput();
            if (selection instanceof IStructuredSelection) {
                Object element = ((IStructuredSelection) selection).getFirstElement();
                if (element instanceof SchemasKeyData) {
                    removeData = (SchemasKeyData) element;
                }
            }
            if (input instanceof SchemasKeyData) {
                SchemasKeyData data = (SchemasKeyData) input;
                List<SchemasKeyData> all = data.getChildren();
                if (all.contains(removeData)) {
                    all.remove(removeData);
                    schemaTreeViewer.setInput(data);
                    needRefresh = true;
                }
                if (needRefresh) {
                    schemaTreeViewer.refresh();
                    int len = schemaTreeViewer.getTree().getItems().length;
                    if (len > 0) {
                        schemaTreeViewer.getTree().select(schemaTreeViewer.getTree().getItems()[len - 1]);
                    }
                    removeRow.setEnabled(!all.isEmpty());
                    editSchema.setEnabled(!all.isEmpty());
                    getUIManager().refreshSchemasDetailView(schemaTreeViewer, schemaDetailsViewer, getSchemaDetailModel());
                }
            }
        }
    });
    editSchema.addSelectionListener(new SelectionAdapter() {

        @Override
        public void widgetSelected(SelectionEvent e) {
            ISelection selection = schemaTreeViewer.getSelection();
            SchemasKeyData selectedData = null;
            if (selection instanceof IStructuredSelection) {
                Object element = ((IStructuredSelection) selection).getFirstElement();
                if (element instanceof SchemasKeyData) {
                    selectedData = (SchemasKeyData) element;
                    IMetadataTable metadataTable = MetadataToolHelper.getMetadataTableFromNode(getMultiSchemasComponent(), selectedData.getUniqueRecord());
                    if (metadataTable == null) {
                        metadataTable = new org.talend.core.model.metadata.MetadataTable();
                    }
                    metadataTable.getListColumns().clear();
                    SchemasKeyData keydata = (SchemasKeyData) schemaTreeViewer.getInput();
                    for (int i = 0; i < keydata.getChildren().size(); i++) {
                        if (selectedData.getUniqueRecord().equals(keydata.getChildren().get(i).getUniqueRecord())) {
                            metadataTable.getListColumns().addAll(keydata.getChildren().get(i).getMetadataColumns());
                            break;
                        }
                    }
                    MetadataDialog dialog = new MetadataDialog(MultiSchemasUI.this.getShell(), metadataTable, getMultiSchemasComponent(), new CommandStackForComposite(MultiSchemasUI.this.getShell()));
                    dialog.setText("Schema of " + selectedData.getUniqueRecord());
                    if (Window.OK == dialog.open()) {
                        metadataTable = dialog.getOutputMetaData();
                        if (!selectedData.getMetadataColumns().isEmpty()) {
                            selectedData.getMetadataColumns().clear();
                        }
                        multiSchemaManager.createMultiSchemasColumns(selectedData, metadataTable);
                        getUIManager().refreshSchemasDetailView(schemaTreeViewer, schemaDetailsViewer, getSchemaDetailModel());
                    }
                }
            }
        }
    });
}

Example 7 with MetadataDialog

use of org.talend.core.ui.metadata.dialog.MetadataDialog in project tdi-studio-se by Talend.

the class GuessSchemaController method runShadowProcess.

private void runShadowProcess(final Property property, final Node inputNode, final IContext selectContext, final IElementParameter switchParam) {
    DatabaseConnection connt = TracesConnectionUtils.createConnection(connParameters);
    String dbmsId = connt.getDbmsId();
    if (dbmsId == null) {
        Shell shell = Display.getCurrent().getActiveShell();
        MessageDialog.openError(shell, "No info about DB found !", "Please choose the correct mapping file.\n Note: This is normal when using JDBC component");
        MappingFileSelectDialog dialog = new MappingFileSelectDialog(shell);
        dialog.open();
        dbmsId = dialog.getSelectId();
    }
    GuessSchemaProcess gsp = new GuessSchemaProcess(property, inputNode, selectContext, memoSQL, info, part.getProcess());
    try {
        List<Integer> indexsForSameNamedColumn = new ArrayList<Integer>();
        CsvArray array = gsp.run();
        List<String[]> schemaContent = array.getRows();
        List<String> columnLabels = new ArrayList<String>();
        if (columns != null) {
            columns.clear();
        }
        if (!schemaContent.isEmpty()) {
            int numbOfColumn = schemaContent.get(0).length;
            for (int i = 1; i <= numbOfColumn; i++) {
                indexsForSameNamedColumn.clear();
                Boolean b = false;
                IMetadataColumn oneColum = new MetadataColumn();
                // get the column name from the temp file genenrated by GuessSchemaProcess.java
                String labelName = (schemaContent.get(0))[i - 1];
                if (info != null && info.isHive()) {
                    if (labelName != null && labelName.indexOf(TalendTextUtils.JAVA_END_STRING) != -1) {
                        labelName = labelName.substring(labelName.lastIndexOf(TalendTextUtils.JAVA_END_STRING) + 1, labelName.length());
                    }
                }
                String name = labelName;
                String sub = "";
                String sub2 = "";
                if (labelName != null && labelName.length() > 0 && labelName.startsWith("_")) {
                    //$NON-NLS-1$
                    sub = labelName.substring(1);
                    if (sub != null && sub.length() > 0) {
                        sub2 = sub.substring(1);
                    }
                }
                if (KeywordsValidator.isKeyword(labelName) || KeywordsValidator.isKeyword(sub) || KeywordsValidator.isKeyword(sub2)) {
                    labelName = "_" + labelName;
                    b = true;
                }
                // String label = labelName;
                // findSameNamedColumnAndReplaceTheIndex(indexsForSameNamedColumn, i, oneColum, labelName);
                oneColum.setLabel(MetadataToolHelper.validateColumnName(labelName, i, columnLabels));
                //                    if (b && label != null && label.length() > 0 && label.startsWith("_")) { //$NON-NLS-1$
                // String substring = label.substring(1);
                // if (label.startsWith("_")
                // && (KeywordsValidator.isKeyword(substring) || KeywordsValidator.isKeyword(sub) ||
                // KeywordsValidator
                // .isKeyword(sub2))) {
                // label = substring;
                // }
                // }
                oneColum.setOriginalDbColumnName(name);
                if (schemaContent.size() > 5) {
                    oneColum.setPrecision(Integer.parseInt(schemaContent.get(2)[i - 1]));
                    oneColum.setLength(Integer.parseInt(schemaContent.get(3)[i - 1]));
                }
                try {
                    String talendType = null;
                    // to see if the language is java or perl
                    if (LanguageManager.getCurrentLanguage() == ECodeLanguage.JAVA) {
                        if (schemaContent.size() >= 5) {
                            talendType = MetadataTalendType.getMappingTypeRetriever(dbmsId).getDefaultSelectedTalendType(schemaContent.get(4)[i - 1]);
                        } else {
                            talendType = JavaTypesManager.STRING.getId();
                        }
                    } else {
                        if (schemaContent.size() >= 5) {
                            talendType = PerlDataTypeHelper.getNewTalendTypeOfValue(schemaContent.get(4)[i - 1]);
                        } else {
                            talendType = PerlTypesManager.STRING;
                        }
                    }
                    oneColum.setTalendType(talendType);
                    if (dbmsId != null) {
                        if (!TypesManager.checkDBType(dbmsId, oneColum.getTalendType(), oneColum.getType())) {
                            oneColum.setType(TypesManager.getDBTypeFromTalendType(dbmsId, oneColum.getTalendType()));
                        }
                    }
                // oneColum.setTalendType(JavaTypesManager.STRING.getId());
                } catch (Exception e) {
                    /*
                         * the table have no data at all ,to do nothing
                         */
                    ExceptionHandler.process(e);
                }
                // get if a column is nullable from the temp file genenrated by GuessSchemaProcess.java
                oneColum.setNullable((schemaContent.get(1))[i - 1].equals(Boolean.TRUE.toString()) ? true : false);
                columns.add(oneColum);
                columnLabels.add(oneColum.getLabel());
            }
            if (columns.size() > 0) {
                IElementParameter dqRule = elem.getElementParameter("DQRULES_LIST");
                if (dqRule != null) {
                    ITDQRuleService ruleService = null;
                    try {
                        ruleService = (ITDQRuleService) GlobalServiceRegister.getDefault().getService(ITDQRuleService.class);
                    } catch (RuntimeException e) {
                    // nothing to do
                    }
                    IElementParameter queryParam = elem.getElementParameter("QUERY");
                    if (ruleService != null && queryParam != null) {
                        ruleService.updateOriginalColumnNames(columns, queryParam);
                    }
                }
            }
            IMetadataTable tempMetatable = new MetadataTable();
            /* for bug 20973 */
            if (tempMetatable.getTableName() == null) {
                tempMetatable.setTableName(inputNode.getUniqueName());
            }
            IMetadataTable outputMetaCopy, originaleOutputTable;
            String propertyName = "";
            if (!btn.isDisposed()) {
                propertyName = (String) btn.getData(PARAMETER_NAME);
            }
            IElementParameter param = inputNode.getElementParameter(propertyName);
            for (IElementParameter eParam : elem.getElementParameters()) {
                if (eParam.getContext() != null) {
                    param = eParam;
                }
            }
            originaleOutputTable = inputNode.getMetadataFromConnector(param.getContext());
            if (originaleOutputTable != null) {
                outputMetaCopy = originaleOutputTable.clone();
            }
            tempMetatable.setListColumns(columns);
            tempMetatable.setDbms(dbmsId);
            MetadataDialog metaDialog = new MetadataDialog(composite.getShell(), tempMetatable, inputNode, getCommandStack());
            if (metaDialog != null) {
                //$NON-NLS-1$
                metaDialog.setText(Messages.getString("AbstractSchemaController.schema.title", inputNode.getLabel()));
            }
            // ok pressed
            if (metaDialog.open() == MetadataDialog.OK) {
                outputMetaCopy = metaDialog.getOutputMetaData();
                boolean modified = false;
                if (!outputMetaCopy.sameMetadataAs(originaleOutputTable, IMetadataColumn.OPTIONS_NONE)) {
                    modified = true;
                }
                if (modified) {
                    if (switchParam != null) {
                        switchParam.setValue(Boolean.FALSE);
                    }
                    changeMetadataCommand = new ChangeMetadataCommand(inputNode, param, originaleOutputTable, outputMetaCopy);
                    changeMetadataCommand.execute();
                }
            }
        }
    } catch (ProcessorException e) {
        ExtractMetaDataUtils.getInstance().closeConnection();
        final String strExcepton = e.getMessage();
        Display.getDefault().asyncExec(new Runnable() {

            @Override
            public void run() {
                MessageDialog.openWarning(composite.getShell(), Messages.getString("GuessSchemaController.connectionError"), //$NON-NLS-1$
                strExcepton);
            }
        });
        ExceptionHandler.process(e);
    }
}