use of org.talend.metadata.managment.ui.dialog.MappingFileSelectDialog 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);
}
}
Aggregations