Example 36 with TableView
use of org.pentaho.di.ui.core.widget.TableView in project pentaho-kettle by pentaho.
the class DeleteDialog method open.
public String open() {
Shell parent = getParent();
Display display = parent.getDisplay();
shell = new Shell(parent, SWT.DIALOG_TRIM | SWT.RESIZE | SWT.MAX | SWT.MIN);
props.setLook(shell);
setShellImage(shell, input);
ModifyListener lsMod = new ModifyListener() {
public void modifyText(ModifyEvent e) {
input.setChanged();
}
};
ModifyListener lsTableMod = new ModifyListener() {
public void modifyText(ModifyEvent arg0) {
input.setChanged();
setTableFieldCombo();
}
};
SelectionListener lsSelection = new SelectionAdapter() {
public void widgetSelected(SelectionEvent e) {
input.setChanged();
setTableFieldCombo();
}
};
changed = input.hasChanged();
FormLayout formLayout = new FormLayout();
formLayout.marginWidth = Const.FORM_MARGIN;
formLayout.marginHeight = Const.FORM_MARGIN;
shell.setLayout(formLayout);
shell.setText(BaseMessages.getString(PKG, "DeleteDialog.Shell.Title"));
int middle = props.getMiddlePct();
int margin = Const.MARGIN;
// Stepname line
wlStepname = new Label(shell, SWT.RIGHT);
wlStepname.setText(BaseMessages.getString(PKG, "DeleteDialog.Stepname.Label"));
props.setLook(wlStepname);
fdlStepname = new FormData();
fdlStepname.left = new FormAttachment(0, 0);
fdlStepname.right = new FormAttachment(middle, -margin);
fdlStepname.top = new FormAttachment(0, margin);
wlStepname.setLayoutData(fdlStepname);
wStepname = new Text(shell, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
wStepname.setText(stepname);
props.setLook(wStepname);
wStepname.addModifyListener(lsMod);
fdStepname = new FormData();
fdStepname.left = new FormAttachment(middle, 0);
fdStepname.top = new FormAttachment(0, margin);
fdStepname.right = new FormAttachment(100, 0);
wStepname.setLayoutData(fdStepname);
// Connection line
wConnection = addConnectionLine(shell, wStepname, middle, margin);
if (input.getDatabaseMeta() == null && transMeta.nrDatabases() == 1) {
wConnection.select(0);
}
wConnection.addModifyListener(lsMod);
wConnection.addSelectionListener(lsSelection);
// Schema line...
wlSchema = new Label(shell, SWT.RIGHT);
wlSchema.setText(BaseMessages.getString(PKG, "DeleteDialog.TargetSchema.Label"));
props.setLook(wlSchema);
fdlSchema = new FormData();
fdlSchema.left = new FormAttachment(0, 0);
fdlSchema.right = new FormAttachment(middle, -margin);
fdlSchema.top = new FormAttachment(wConnection, margin * 2);
wlSchema.setLayoutData(fdlSchema);
wbSchema = new Button(shell, SWT.PUSH | SWT.CENTER);
props.setLook(wbSchema);
wbSchema.setText(BaseMessages.getString(PKG, "System.Button.Browse"));
fdbSchema = new FormData();
fdbSchema.top = new FormAttachment(wConnection, 2 * margin);
fdbSchema.right = new FormAttachment(100, 0);
wbSchema.setLayoutData(fdbSchema);
wSchema = new TextVar(transMeta, shell, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
props.setLook(wSchema);
wSchema.addModifyListener(lsTableMod);
fdSchema = new FormData();
fdSchema.left = new FormAttachment(middle, 0);
fdSchema.top = new FormAttachment(wConnection, margin * 2);
fdSchema.right = new FormAttachment(wbSchema, -margin);
wSchema.setLayoutData(fdSchema);
// Table line...
wlTable = new Label(shell, SWT.RIGHT);
wlTable.setText(BaseMessages.getString(PKG, "DeleteDialog.TargetTable.Label"));
props.setLook(wlTable);
fdlTable = new FormData();
fdlTable.left = new FormAttachment(0, 0);
fdlTable.right = new FormAttachment(middle, -margin);
fdlTable.top = new FormAttachment(wbSchema, margin);
wlTable.setLayoutData(fdlTable);
wbTable = new Button(shell, SWT.PUSH | SWT.CENTER);
props.setLook(wbTable);
wbTable.setText(BaseMessages.getString(PKG, "DeleteDialog.Browse.Button"));
fdbTable = new FormData();
fdbTable.right = new FormAttachment(100, 0);
fdbTable.top = new FormAttachment(wbSchema, margin);
wbTable.setLayoutData(fdbTable);
wTable = new TextVar(transMeta, shell, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
props.setLook(wTable);
wTable.addModifyListener(lsTableMod);
fdTable = new FormData();
fdTable.left = new FormAttachment(middle, 0);
fdTable.top = new FormAttachment(wbSchema, margin);
fdTable.right = new FormAttachment(wbTable, -margin);
wTable.setLayoutData(fdTable);
// Commit line
wlCommit = new Label(shell, SWT.RIGHT);
wlCommit.setText(BaseMessages.getString(PKG, "DeleteDialog.Commit.Label"));
props.setLook(wlCommit);
fdlCommit = new FormData();
fdlCommit.left = new FormAttachment(0, 0);
fdlCommit.top = new FormAttachment(wTable, margin);
fdlCommit.right = new FormAttachment(middle, -margin);
wlCommit.setLayoutData(fdlCommit);
wCommit = new TextVar(transMeta, shell, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
props.setLook(wCommit);
wCommit.addModifyListener(lsMod);
fdCommit = new FormData();
fdCommit.left = new FormAttachment(middle, 0);
fdCommit.top = new FormAttachment(wTable, margin);
fdCommit.right = new FormAttachment(100, 0);
wCommit.setLayoutData(fdCommit);
wlKey = new Label(shell, SWT.NONE);
wlKey.setText(BaseMessages.getString(PKG, "DeleteDialog.Key.Label"));
props.setLook(wlKey);
fdlKey = new FormData();
fdlKey.left = new FormAttachment(0, 0);
fdlKey.top = new FormAttachment(wCommit, margin);
wlKey.setLayoutData(fdlKey);
int nrKeyCols = 4;
int nrKeyRows = (input.getKeyStream() != null ? input.getKeyStream().length : 1);
ciKey = new ColumnInfo[nrKeyCols];
ciKey[0] = new ColumnInfo(BaseMessages.getString(PKG, "DeleteDialog.ColumnInfo.TableField"), ColumnInfo.COLUMN_TYPE_CCOMBO, new String[] { "" }, false);
ciKey[1] = new ColumnInfo(BaseMessages.getString(PKG, "DeleteDialog.ColumnInfo.Comparator"), ColumnInfo.COLUMN_TYPE_CCOMBO, new String[] { "=", "<>", "<", "<=", ">", ">=", "LIKE", "BETWEEN", "IS NULL", "IS NOT NULL" });
ciKey[2] = new ColumnInfo(BaseMessages.getString(PKG, "DeleteDialog.ColumnInfo.StreamField1"), ColumnInfo.COLUMN_TYPE_CCOMBO, new String[] { "" }, false);
ciKey[3] = new ColumnInfo(BaseMessages.getString(PKG, "DeleteDialog.ColumnInfo.StreamField2"), ColumnInfo.COLUMN_TYPE_CCOMBO, new String[] { "" }, false);
tableFieldColumns.add(ciKey[0]);
wKey = new TableView(transMeta, shell, SWT.BORDER | SWT.FULL_SELECTION | SWT.MULTI | SWT.V_SCROLL | SWT.H_SCROLL, ciKey, nrKeyRows, lsMod, props);
wGet = new Button(shell, SWT.PUSH);
wGet.setText(BaseMessages.getString(PKG, "DeleteDialog.GetFields.Button"));
fdGet = new FormData();
fdGet.right = new FormAttachment(100, 0);
fdGet.top = new FormAttachment(wlKey, margin);
wGet.setLayoutData(fdGet);
fdKey = new FormData();
fdKey.left = new FormAttachment(0, 0);
fdKey.top = new FormAttachment(wlKey, margin);
fdKey.right = new FormAttachment(wGet, -margin);
fdKey.bottom = new FormAttachment(100, -30);
wKey.setLayoutData(fdKey);
//
// Search the fields in the background
//
final Runnable runnable = new Runnable() {
public void run() {
StepMeta stepMeta = transMeta.findStep(stepname);
if (stepMeta != null) {
try {
RowMetaInterface row = transMeta.getPrevStepFields(stepMeta);
// Remember these fields...
for (int i = 0; i < row.size(); i++) {
inputFields.put(row.getValueMeta(i).getName(), i);
}
setComboBoxes();
} catch (KettleException e) {
logError(BaseMessages.getString(PKG, "System.Dialog.GetFieldsFailed.Message"));
}
}
}
};
new Thread(runnable).start();
// THE BUTTONS
wOK = new Button(shell, SWT.PUSH);
wOK.setText(BaseMessages.getString(PKG, "System.Button.OK"));
wCancel = new Button(shell, SWT.PUSH);
wCancel.setText(BaseMessages.getString(PKG, "System.Button.Cancel"));
setButtonPositions(new Button[] { wOK, wCancel }, margin, null);
// Add listeners
lsOK = new Listener() {
public void handleEvent(Event e) {
ok();
}
};
lsGet = new Listener() {
public void handleEvent(Event e) {
get();
}
};
lsCancel = new Listener() {
public void handleEvent(Event e) {
cancel();
}
};
wOK.addListener(SWT.Selection, lsOK);
wGet.addListener(SWT.Selection, lsGet);
wCancel.addListener(SWT.Selection, lsCancel);
lsDef = new SelectionAdapter() {
public void widgetDefaultSelected(SelectionEvent e) {
ok();
}
};
wStepname.addSelectionListener(lsDef);
wSchema.addSelectionListener(lsDef);
wTable.addSelectionListener(lsDef);
// Detect X or ALT-F4 or something that kills this window...
shell.addShellListener(new ShellAdapter() {
public void shellClosed(ShellEvent e) {
cancel();
}
});
wbSchema.addSelectionListener(new SelectionAdapter() {
public void widgetSelected(SelectionEvent e) {
getSchemaNames();
}
});
wbTable.addSelectionListener(new SelectionAdapter() {
public void widgetSelected(SelectionEvent e) {
getTableName();
}
});
// Set the shell size, based upon previous time...
setSize();
getData();
setTableFieldCombo();
input.setChanged(changed);
shell.open();
while (!shell.isDisposed()) {
if (!display.readAndDispatch()) {
display.sleep();
}
}
return stepname;
}
Also used :
KettleException(org.pentaho.di.core.exception.KettleException)
TableItemInsertListener(org.pentaho.di.ui.trans.step.TableItemInsertListener)
Listener(org.eclipse.swt.widgets.Listener)
ModifyListener(org.eclipse.swt.events.ModifyListener)
SelectionListener(org.eclipse.swt.events.SelectionListener)
ModifyListener(org.eclipse.swt.events.ModifyListener)
Label(org.eclipse.swt.widgets.Label)
ColumnInfo(org.pentaho.di.ui.core.widget.ColumnInfo)
ShellEvent(org.eclipse.swt.events.ShellEvent)
RowMetaInterface(org.pentaho.di.core.row.RowMetaInterface)
Shell(org.eclipse.swt.widgets.Shell)
ModifyEvent(org.eclipse.swt.events.ModifyEvent)
Button(org.eclipse.swt.widgets.Button)
SelectionEvent(org.eclipse.swt.events.SelectionEvent)
FormAttachment(org.eclipse.swt.layout.FormAttachment)
TableView(org.pentaho.di.ui.core.widget.TableView)
FormLayout(org.eclipse.swt.layout.FormLayout)
FormData(org.eclipse.swt.layout.FormData)
ShellAdapter(org.eclipse.swt.events.ShellAdapter)
SelectionAdapter(org.eclipse.swt.events.SelectionAdapter)
Text(org.eclipse.swt.widgets.Text)
StepMeta(org.pentaho.di.trans.step.StepMeta)
BaseStepMeta(org.pentaho.di.trans.step.BaseStepMeta)
TextVar(org.pentaho.di.ui.core.widget.TextVar)
Event(org.eclipse.swt.widgets.Event)
ModifyEvent(org.eclipse.swt.events.ModifyEvent)
ShellEvent(org.eclipse.swt.events.ShellEvent)
SelectionEvent(org.eclipse.swt.events.SelectionEvent)
Display(org.eclipse.swt.widgets.Display)
SelectionListener(org.eclipse.swt.events.SelectionListener)
Example 37 with TableView
use of org.pentaho.di.ui.core.widget.TableView in project pentaho-kettle by pentaho.
the class DimensionLookupDialog method open.
public String open() {
Shell parent = getParent();
Display display = parent.getDisplay();
shell = new Shell(parent, SWT.DIALOG_TRIM | SWT.RESIZE | SWT.MAX | SWT.MIN);
props.setLook(shell);
ModifyListener lsMod = new ModifyListener() {
public void modifyText(ModifyEvent e) {
input.setChanged();
}
};
FocusListener lsConnectionFocus = new FocusAdapter() {
public void focusLost(FocusEvent event) {
input.setChanged();
setTableFieldCombo();
}
};
ModifyListener lsTableMod = new ModifyListener() {
public void modifyText(ModifyEvent arg0) {
input.setChanged();
setTableFieldCombo();
}
};
backupChanged = input.hasChanged();
backupUpdate = input.isUpdate();
backupAutoInc = input.isAutoIncrement();
ci = input.getDatabaseMeta();
GridLayout shellLayout = new GridLayout();
shellLayout.numColumns = 1;
shell.setLayout(shellLayout);
shell.setText(BaseMessages.getString(PKG, "DimensionLookupDialog.Shell.Title"));
int middle = props.getMiddlePct();
int margin = Const.MARGIN;
Composite sCompParent = new Composite(shell, SWT.NONE);
sCompParent.setLayout(new FillLayout(SWT.VERTICAL));
GridData sCompGridData = new GridData(GridData.FILL_BOTH);
sCompGridData.grabExcessHorizontalSpace = true;
sCompGridData.grabExcessVerticalSpace = true;
sCompParent.setLayoutData(sCompGridData);
sComp = new ScrolledComposite(sCompParent, SWT.V_SCROLL | SWT.H_SCROLL);
sComp.setLayout(new FormLayout());
sComp.setExpandHorizontal(true);
sComp.setExpandVertical(true);
helpComp = new Composite(shell, SWT.NONE);
helpComp.setLayout(new FormLayout());
GridData helpCompData = new GridData();
helpCompData.grabExcessHorizontalSpace = true;
helpCompData.grabExcessVerticalSpace = false;
helpComp.setLayoutData(helpCompData);
setShellImage(shell, input);
comp = new Composite(sComp, SWT.NONE);
props.setLook(comp);
FormLayout fileLayout = new FormLayout();
fileLayout.marginWidth = 3;
fileLayout.marginHeight = 3;
comp.setLayout(fileLayout);
// Stepname line
wlStepname = new Label(comp, SWT.RIGHT);
wlStepname.setText(BaseMessages.getString(PKG, "DimensionLookupDialog.Stepname.Label"));
props.setLook(wlStepname);
fdlStepname = new FormData();
fdlStepname.left = new FormAttachment(0, 0);
fdlStepname.right = new FormAttachment(middle, -margin);
fdlStepname.top = new FormAttachment(0, margin);
wlStepname.setLayoutData(fdlStepname);
wStepname = new Text(comp, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
wStepname.setText(stepname);
props.setLook(wStepname);
wStepname.addModifyListener(lsMod);
fdStepname = new FormData();
fdStepname.left = new FormAttachment(middle, 0);
fdStepname.top = new FormAttachment(0, margin);
fdStepname.right = new FormAttachment(100, 0);
wStepname.setLayoutData(fdStepname);
// Update the dimension?
wlUpdate = new Label(comp, SWT.RIGHT);
wlUpdate.setText(BaseMessages.getString(PKG, "DimensionLookupDialog.Update.Label"));
props.setLook(wlUpdate);
FormData fdlUpdate = new FormData();
fdlUpdate.left = new FormAttachment(0, 0);
fdlUpdate.right = new FormAttachment(middle, -margin);
fdlUpdate.top = new FormAttachment(wStepname, margin);
wlUpdate.setLayoutData(fdlUpdate);
wUpdate = new Button(comp, SWT.CHECK);
props.setLook(wUpdate);
FormData fdUpdate = new FormData();
fdUpdate.left = new FormAttachment(middle, 0);
fdUpdate.top = new FormAttachment(wStepname, margin);
fdUpdate.right = new FormAttachment(100, 0);
wUpdate.setLayoutData(fdUpdate);
// Clicking on update changes the options in the update combo boxes!
wUpdate.addSelectionListener(new SelectionAdapter() {
public void widgetSelected(SelectionEvent e) {
input.setUpdate(!input.isUpdate());
input.setChanged();
setFlags();
}
});
// Connection line
wConnection = addConnectionLine(comp, wUpdate, middle, margin);
if (input.getDatabaseMeta() == null && transMeta.nrDatabases() == 1) {
wConnection.select(0);
}
// wConnection.addModifyListener(lsConnectionMod);
// wConnection.addSelectionListener(lsSelection);
wConnection.addFocusListener(lsConnectionFocus);
wConnection.addModifyListener(new ModifyListener() {
public void modifyText(ModifyEvent e) {
// We have new content: change ci connection:
ci = transMeta.findDatabase(wConnection.getText());
setFlags();
}
});
// Schema line...
wlSchema = new Label(comp, SWT.RIGHT);
wlSchema.setText(BaseMessages.getString(PKG, "DimensionLookupDialog.TargetSchema.Label"));
props.setLook(wlSchema);
FormData fdlSchema = new FormData();
fdlSchema.left = new FormAttachment(0, 0);
fdlSchema.right = new FormAttachment(middle, -margin);
fdlSchema.top = new FormAttachment(wConnection, margin);
wlSchema.setLayoutData(fdlSchema);
wbSchema = new Button(comp, SWT.PUSH | SWT.CENTER);
props.setLook(wbSchema);
wbSchema.setText(BaseMessages.getString(PKG, "System.Button.Browse"));
fdbSchema = new FormData();
fdbSchema.top = new FormAttachment(wConnection, margin);
fdbSchema.right = new FormAttachment(100, 0);
wbSchema.setLayoutData(fdbSchema);
wSchema = new TextVar(transMeta, comp, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
props.setLook(wSchema);
wSchema.addModifyListener(lsTableMod);
FormData fdSchema = new FormData();
fdSchema.left = new FormAttachment(middle, 0);
fdSchema.top = new FormAttachment(wConnection, margin);
fdSchema.right = new FormAttachment(wbSchema, -margin);
wSchema.setLayoutData(fdSchema);
// Table line...
wlTable = new Label(comp, SWT.RIGHT);
wlTable.setText(BaseMessages.getString(PKG, "DimensionLookupDialog.TargeTable.Label"));
props.setLook(wlTable);
FormData fdlTable = new FormData();
fdlTable.left = new FormAttachment(0, 0);
fdlTable.right = new FormAttachment(middle, -margin);
fdlTable.top = new FormAttachment(wbSchema, margin);
wlTable.setLayoutData(fdlTable);
wbTable = new Button(comp, SWT.PUSH | SWT.CENTER);
props.setLook(wbTable);
wbTable.setText(BaseMessages.getString(PKG, "DimensionLookupDialog.Browse.Button"));
FormData fdbTable = new FormData();
fdbTable.right = new FormAttachment(100, 0);
fdbTable.top = new FormAttachment(wbSchema, margin);
wbTable.setLayoutData(fdbTable);
wTable = new TextVar(transMeta, comp, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
props.setLook(wTable);
wTable.addModifyListener(lsTableMod);
FormData fdTable = new FormData();
fdTable.left = new FormAttachment(middle, 0);
fdTable.top = new FormAttachment(wbSchema, margin);
fdTable.right = new FormAttachment(wbTable, 0);
wTable.setLayoutData(fdTable);
// Commit size ...
wlCommit = new Label(comp, SWT.RIGHT);
wlCommit.setText(BaseMessages.getString(PKG, "DimensionLookupDialog.Commit.Label"));
props.setLook(wlCommit);
FormData fdlCommit = new FormData();
fdlCommit.left = new FormAttachment(0, 0);
fdlCommit.right = new FormAttachment(middle, -margin);
fdlCommit.top = new FormAttachment(wTable, margin);
wlCommit.setLayoutData(fdlCommit);
wCommit = new Text(comp, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
props.setLook(wCommit);
wCommit.addModifyListener(lsMod);
FormData fdCommit = new FormData();
fdCommit.left = new FormAttachment(middle, 0);
fdCommit.top = new FormAttachment(wTable, margin);
fdCommit.right = new FormAttachment(100, 0);
wCommit.setLayoutData(fdCommit);
// Use Cache?
wlUseCache = new Label(comp, SWT.RIGHT);
wlUseCache.setText(BaseMessages.getString(PKG, "DimensionLookupDialog.UseCache.Label"));
props.setLook(wlUseCache);
FormData fdlUseCache = new FormData();
fdlUseCache.left = new FormAttachment(0, 0);
fdlUseCache.right = new FormAttachment(middle, -margin);
fdlUseCache.top = new FormAttachment(wCommit, margin);
wlUseCache.setLayoutData(fdlUseCache);
wUseCache = new Button(comp, SWT.CHECK);
props.setLook(wUseCache);
wUseCache.addSelectionListener(new SelectionAdapter() {
public void widgetSelected(SelectionEvent arg0) {
setFlags();
input.setChanged();
}
});
FormData fdUseCache = new FormData();
fdUseCache.left = new FormAttachment(middle, 0);
fdUseCache.top = new FormAttachment(wCommit, margin);
fdUseCache.right = new FormAttachment(100, 0);
wUseCache.setLayoutData(fdUseCache);
// Preload cache?
wlPreloadCache = new Label(comp, SWT.RIGHT);
wlPreloadCache.setText(BaseMessages.getString(PKG, "DimensionLookupDialog.PreloadCache.Label"));
props.setLook(wlPreloadCache);
FormData fdlPreloadCache = new FormData();
fdlPreloadCache.left = new FormAttachment(0, 0);
fdlPreloadCache.right = new FormAttachment(middle, -margin);
fdlPreloadCache.top = new FormAttachment(wUseCache, margin);
wlPreloadCache.setLayoutData(fdlPreloadCache);
wPreloadCache = new Button(comp, SWT.CHECK);
props.setLook(wPreloadCache);
wPreloadCache.addSelectionListener(new SelectionAdapter() {
public void widgetSelected(SelectionEvent arg0) {
setFlags();
input.setChanged();
}
});
FormData fdPreloadCache = new FormData();
fdPreloadCache.left = new FormAttachment(middle, 0);
fdPreloadCache.top = new FormAttachment(wUseCache, margin);
fdPreloadCache.right = new FormAttachment(100, 0);
wPreloadCache.setLayoutData(fdPreloadCache);
// Cache size ...
wlCacheSize = new Label(comp, SWT.RIGHT);
wlCacheSize.setText(BaseMessages.getString(PKG, "DimensionLookupDialog.CacheSize.Label"));
props.setLook(wlCacheSize);
FormData fdlCacheSize = new FormData();
fdlCacheSize.left = new FormAttachment(0, 0);
fdlCacheSize.right = new FormAttachment(middle, -margin);
fdlCacheSize.top = new FormAttachment(wPreloadCache, margin);
wlCacheSize.setLayoutData(fdlCacheSize);
wCacheSize = new Text(comp, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
props.setLook(wCacheSize);
wCacheSize.addModifyListener(lsMod);
FormData fdCacheSize = new FormData();
fdCacheSize.left = new FormAttachment(middle, 0);
fdCacheSize.top = new FormAttachment(wPreloadCache, margin);
fdCacheSize.right = new FormAttachment(100, 0);
wCacheSize.setLayoutData(fdCacheSize);
wlTkRename = new Label(comp, SWT.RIGHT);
wTabFolder = new CTabFolder(comp, SWT.BORDER);
props.setLook(wTabFolder, Props.WIDGET_STYLE_TAB);
// ////////////////////////
// START OF KEY TAB ///
// /
wKeyTab = new CTabItem(wTabFolder, SWT.NONE);
wKeyTab.setText(BaseMessages.getString(PKG, "DimensionLookupDialog.KeyTab.CTabItem"));
FormLayout keyLayout = new FormLayout();
keyLayout.marginWidth = 3;
keyLayout.marginHeight = 3;
Composite wKeyComp = new Composite(wTabFolder, SWT.NONE);
props.setLook(wKeyComp);
wKeyComp.setLayout(keyLayout);
//
// The Lookup fields: usually the key
//
wlKey = new Label(wKeyComp, SWT.NONE);
wlKey.setText(BaseMessages.getString(PKG, "DimensionLookupDialog.KeyFields.Label"));
props.setLook(wlKey);
FormData fdlKey = new FormData();
fdlKey.left = new FormAttachment(0, 0);
fdlKey.top = new FormAttachment(0, margin);
fdlKey.right = new FormAttachment(100, 0);
wlKey.setLayoutData(fdlKey);
int nrKeyCols = 2;
int nrKeyRows = (input.getKeyStream() != null ? input.getKeyStream().length : 1);
ciKey = new ColumnInfo[nrKeyCols];
ciKey[0] = new ColumnInfo(BaseMessages.getString(PKG, "DimensionLookupDialog.ColumnInfo.DimensionField"), ColumnInfo.COLUMN_TYPE_CCOMBO, new String[] { "" }, false);
ciKey[1] = new ColumnInfo(BaseMessages.getString(PKG, "DimensionLookupDialog.ColumnInfo.FieldInStream"), ColumnInfo.COLUMN_TYPE_CCOMBO, new String[] { "" }, false);
tableFieldColumns.add(ciKey[0]);
wKey = new TableView(transMeta, wKeyComp, SWT.BORDER | SWT.FULL_SELECTION | SWT.MULTI | SWT.V_SCROLL | SWT.H_SCROLL, ciKey, nrKeyRows, lsMod, props);
FormData fdKey = new FormData();
fdKey.left = new FormAttachment(0, 0);
fdKey.top = new FormAttachment(wlKey, margin);
fdKey.right = new FormAttachment(100, 0);
fdKey.bottom = new FormAttachment(100, 0);
wKey.setLayoutData(fdKey);
fdKeyComp = new FormData();
fdKeyComp.left = new FormAttachment(0, 0);
fdKeyComp.top = new FormAttachment(0, 0);
fdKeyComp.right = new FormAttachment(100, 0);
fdKeyComp.bottom = new FormAttachment(100, 0);
wKeyComp.setLayoutData(fdKeyComp);
wKeyComp.layout();
wKeyTab.setControl(wKeyComp);
// ///////////////////////////////////////////////////////////
// / END OF KEY TAB
// ///////////////////////////////////////////////////////////
// Fields tab...
//
wFieldsTab = new CTabItem(wTabFolder, SWT.NONE);
wFieldsTab.setText(BaseMessages.getString(PKG, "DimensionLookupDialog.FieldsTab.CTabItem.Title"));
Composite wFieldsComp = new Composite(wTabFolder, SWT.NONE);
props.setLook(wFieldsComp);
FormLayout fieldsCompLayout = new FormLayout();
fieldsCompLayout.marginWidth = Const.FORM_MARGIN;
fieldsCompLayout.marginHeight = Const.FORM_MARGIN;
wFieldsComp.setLayout(fieldsCompLayout);
// THE UPDATE/INSERT TABLE
wlUpIns = new Label(wFieldsComp, SWT.NONE);
wlUpIns.setText(BaseMessages.getString(PKG, "DimensionLookupDialog.UpdateOrInsertFields.Label"));
props.setLook(wlUpIns);
FormData fdlUpIns = new FormData();
fdlUpIns.left = new FormAttachment(0, 0);
fdlUpIns.top = new FormAttachment(0, margin);
wlUpIns.setLayoutData(fdlUpIns);
int UpInsCols = 3;
int UpInsRows = (input.getFieldStream() != null ? input.getFieldStream().length : 1);
ciUpIns = new ColumnInfo[UpInsCols];
ciUpIns[0] = new ColumnInfo(BaseMessages.getString(PKG, "DimensionLookupDialog.ColumnInfo.DimensionField"), ColumnInfo.COLUMN_TYPE_CCOMBO, new String[] { "" }, false);
ciUpIns[1] = new ColumnInfo(BaseMessages.getString(PKG, "DimensionLookupDialog.ColumnInfo.StreamField"), ColumnInfo.COLUMN_TYPE_CCOMBO, new String[] { "" }, false);
ciUpIns[2] = new ColumnInfo(BaseMessages.getString(PKG, "DimensionLookupDialog.ColumnInfo.TypeOfDimensionUpdate"), ColumnInfo.COLUMN_TYPE_CCOMBO, input.isUpdate() ? DimensionLookupMeta.typeDesc : DimensionLookupMeta.typeDescLookup);
tableFieldColumns.add(ciUpIns[0]);
wUpIns = new TableView(transMeta, wFieldsComp, SWT.BORDER | SWT.FULL_SELECTION | SWT.MULTI | SWT.V_SCROLL | SWT.H_SCROLL, ciUpIns, UpInsRows, lsMod, props);
FormData fdUpIns = new FormData();
fdUpIns.left = new FormAttachment(0, 0);
fdUpIns.top = new FormAttachment(wlUpIns, margin);
fdUpIns.right = new FormAttachment(100, 0);
fdUpIns.bottom = new FormAttachment(100, 0);
wUpIns.setLayoutData(fdUpIns);
//
// Search the fields in the background
//
final Runnable runnable = new Runnable() {
public void run() {
StepMeta stepMeta = transMeta.findStep(stepname);
if (stepMeta != null) {
try {
RowMetaInterface row = transMeta.getPrevStepFields(stepMeta);
// Remember these fields...
for (int i = 0; i < row.size(); i++) {
inputFields.put(row.getValueMeta(i).getName(), i);
}
setComboBoxes();
} catch (KettleException e) {
logError(BaseMessages.getString(PKG, "System.Dialog.GetFieldsFailed.Message"));
}
}
}
};
new Thread(runnable).start();
fdFieldsComp = new FormData();
fdFieldsComp.left = new FormAttachment(0, 0);
fdFieldsComp.top = new FormAttachment(0, 0);
fdFieldsComp.right = new FormAttachment(100, 0);
fdFieldsComp.bottom = new FormAttachment(100, 0);
wFieldsComp.setLayoutData(fdFieldsComp);
wFieldsComp.layout();
wFieldsTab.setControl(wFieldsComp);
fdTabFolder = new FormData();
fdTabFolder.left = new FormAttachment(0, 0);
fdTabFolder.top = new FormAttachment(wCacheSize, margin);
fdTabFolder.right = new FormAttachment(100, 0);
fdTabFolder.height = 200;
wTabFolder.setLayoutData(fdTabFolder);
// Technical key field:
wlTk = new Label(comp, SWT.RIGHT);
wlTk.setText(BaseMessages.getString(PKG, "DimensionLookupDialog.TechnicalKeyField.Label"));
props.setLook(wlTk);
FormData fdlTk = new FormData();
fdlTk.left = new FormAttachment(0, 0);
fdlTk.right = new FormAttachment(middle, -margin);
fdlTk.top = new FormAttachment(wTabFolder, 2 * margin);
wlTk.setLayoutData(fdlTk);
wTk = new CCombo(comp, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
props.setLook(wTk);
wTk.addModifyListener(lsMod);
FormData fdTk = new FormData();
fdTk.left = new FormAttachment(middle, 0);
fdTk.top = new FormAttachment(wTabFolder, 2 * margin);
fdTk.right = new FormAttachment(50 + middle / 2, 0);
wTk.setLayoutData(fdTk);
wTk.addFocusListener(new FocusListener() {
public void focusLost(org.eclipse.swt.events.FocusEvent e) {
}
public void focusGained(org.eclipse.swt.events.FocusEvent e) {
Cursor busy = new Cursor(shell.getDisplay(), SWT.CURSOR_WAIT);
shell.setCursor(busy);
getFieldsFromTable();
shell.setCursor(null);
busy.dispose();
}
});
wlTkRename.setText(BaseMessages.getString(PKG, "DimensionLookupDialog.NewName.Label"));
props.setLook(wlTkRename);
FormData fdlTkRename = new FormData();
fdlTkRename.left = new FormAttachment(50 + middle / 2, margin);
fdlTkRename.top = new FormAttachment(wTabFolder, 2 * margin);
wlTkRename.setLayoutData(fdlTkRename);
wTkRename = new Text(comp, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
props.setLook(wTkRename);
wTkRename.addModifyListener(lsMod);
FormData fdTkRename = new FormData();
fdTkRename.left = new FormAttachment(wlTkRename, margin);
fdTkRename.top = new FormAttachment(wTabFolder, 2 * margin);
fdTkRename.right = new FormAttachment(100, 0);
wTkRename.setLayoutData(fdTkRename);
// //////////////////////////////////////////////////
// The key creation box
// //////////////////////////////////////////////////
gTechGroup = new Group(comp, SWT.SHADOW_ETCHED_IN);
gTechGroup.setText(BaseMessages.getString(PKG, "DimensionLookupDialog.TechGroup.Label"));
GridLayout gridLayout = new GridLayout(3, false);
gTechGroup.setLayout(gridLayout);
FormData fdTechGroup = new FormData();
fdTechGroup.left = new FormAttachment(middle, 0);
fdTechGroup.top = new FormAttachment(wTkRename, 2 * margin);
fdTechGroup.right = new FormAttachment(100, 0);
// the default looks ugly
gTechGroup.setBackground(shell.getBackground());
gTechGroup.setLayoutData(fdTechGroup);
// Use maximum of table + 1
wTableMax = new Button(gTechGroup, SWT.RADIO);
props.setLook(wTableMax);
wTableMax.setSelection(false);
GridData gdTableMax = new GridData();
wTableMax.setLayoutData(gdTableMax);
wTableMax.setToolTipText(BaseMessages.getString(PKG, "DimensionLookupDialog.TableMaximum.Tooltip", Const.CR));
wlTableMax = new Label(gTechGroup, SWT.LEFT);
wlTableMax.setText(BaseMessages.getString(PKG, "DimensionLookupDialog.TableMaximum.Label"));
props.setLook(wlTableMax);
GridData gdlTableMax = new GridData(GridData.FILL_BOTH);
gdlTableMax.horizontalSpan = 2;
gdlTableMax.verticalSpan = 1;
wlTableMax.setLayoutData(gdlTableMax);
// Sequence Check Button
wSeqButton = new Button(gTechGroup, SWT.RADIO);
props.setLook(wSeqButton);
wSeqButton.setSelection(false);
GridData gdSeqButton = new GridData();
wSeqButton.setLayoutData(gdSeqButton);
wSeqButton.setToolTipText(BaseMessages.getString(PKG, "DimensionLookupDialog.Sequence.Tooltip", Const.CR));
wlSeqButton = new Label(gTechGroup, SWT.LEFT);
wlSeqButton.setText(BaseMessages.getString(PKG, "DimensionLookupDialog.Sequence.Label"));
props.setLook(wlSeqButton);
GridData gdlSeqButton = new GridData();
wlSeqButton.setLayoutData(gdlSeqButton);
wSeq = new Text(gTechGroup, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
props.setLook(wSeq);
wSeq.addModifyListener(lsMod);
GridData gdSeq = new GridData(GridData.FILL_HORIZONTAL);
wSeq.setLayoutData(gdSeq);
wSeq.addFocusListener(new FocusListener() {
public void focusGained(FocusEvent arg0) {
input.setTechKeyCreation(DimensionLookupMeta.CREATION_METHOD_SEQUENCE);
wSeqButton.setSelection(true);
wAutoinc.setSelection(false);
wTableMax.setSelection(false);
}
public void focusLost(FocusEvent arg0) {
}
});
// Use an autoincrement field?
wAutoinc = new Button(gTechGroup, SWT.RADIO);
props.setLook(wAutoinc);
wAutoinc.setSelection(false);
GridData gdAutoinc = new GridData();
wAutoinc.setLayoutData(gdAutoinc);
wAutoinc.setToolTipText(BaseMessages.getString(PKG, "DimensionLookupDialog.AutoincButton.Tooltip", Const.CR));
wlAutoinc = new Label(gTechGroup, SWT.LEFT);
wlAutoinc.setText(BaseMessages.getString(PKG, "DimensionLookupDialog.Autoincrement.Label"));
props.setLook(wlAutoinc);
GridData gdlAutoinc = new GridData();
wlAutoinc.setLayoutData(gdlAutoinc);
// //////////////////////////////////////////////////
// The key creation box END
// //////////////////////////////////////////////////
// Version key field:
wlVersion = new Label(comp, SWT.RIGHT);
wlVersion.setText(BaseMessages.getString(PKG, "DimensionLookupDialog.Version.Label"));
props.setLook(wlVersion);
FormData fdlVersion = new FormData();
fdlVersion.left = new FormAttachment(0, 0);
fdlVersion.right = new FormAttachment(middle, -margin);
fdlVersion.top = new FormAttachment(gTechGroup, 2 * margin);
wlVersion.setLayoutData(fdlVersion);
wVersion = new CCombo(comp, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
props.setLook(wVersion);
wVersion.addModifyListener(lsMod);
FormData fdVersion = new FormData();
fdVersion.left = new FormAttachment(middle, 0);
fdVersion.top = new FormAttachment(gTechGroup, 2 * margin);
fdVersion.right = new FormAttachment(100, 0);
wVersion.setLayoutData(fdVersion);
wVersion.addFocusListener(new FocusListener() {
public void focusLost(org.eclipse.swt.events.FocusEvent e) {
}
public void focusGained(org.eclipse.swt.events.FocusEvent e) {
Cursor busy = new Cursor(shell.getDisplay(), SWT.CURSOR_WAIT);
shell.setCursor(busy);
getFieldsFromTable();
shell.setCursor(null);
busy.dispose();
}
});
// Datefield line
wlDatefield = new Label(comp, SWT.RIGHT);
wlDatefield.setText(BaseMessages.getString(PKG, "DimensionLookupDialog.Datefield.Label"));
props.setLook(wlDatefield);
FormData fdlDatefield = new FormData();
fdlDatefield.left = new FormAttachment(0, 0);
fdlDatefield.right = new FormAttachment(middle, -margin);
fdlDatefield.top = new FormAttachment(wVersion, 2 * margin);
wlDatefield.setLayoutData(fdlDatefield);
wDatefield = new CCombo(comp, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
props.setLook(wDatefield);
wDatefield.addModifyListener(lsMod);
FormData fdDatefield = new FormData();
fdDatefield.left = new FormAttachment(middle, 0);
fdDatefield.top = new FormAttachment(wVersion, 2 * margin);
fdDatefield.right = new FormAttachment(100, 0);
wDatefield.setLayoutData(fdDatefield);
wDatefield.addFocusListener(new FocusListener() {
public void focusLost(org.eclipse.swt.events.FocusEvent e) {
}
public void focusGained(org.eclipse.swt.events.FocusEvent e) {
Cursor busy = new Cursor(shell.getDisplay(), SWT.CURSOR_WAIT);
shell.setCursor(busy);
getFields();
shell.setCursor(null);
busy.dispose();
}
});
// Fromdate line
//
// 0 [wlFromdate] middle [wFromdate] (100-middle)/3 [wlMinyear]
// 2*(100-middle)/3 [wMinyear] 100%
//
wlFromdate = new Label(comp, SWT.RIGHT);
wlFromdate.setText(BaseMessages.getString(PKG, "DimensionLookupDialog.Fromdate.Label"));
props.setLook(wlFromdate);
FormData fdlFromdate = new FormData();
fdlFromdate.left = new FormAttachment(0, 0);
fdlFromdate.right = new FormAttachment(middle, -margin);
fdlFromdate.top = new FormAttachment(wDatefield, 2 * margin);
wlFromdate.setLayoutData(fdlFromdate);
wFromdate = new CCombo(comp, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
props.setLook(wFromdate);
wFromdate.addModifyListener(lsMod);
FormData fdFromdate = new FormData();
fdFromdate.left = new FormAttachment(middle, 0);
fdFromdate.right = new FormAttachment(middle + (100 - middle) / 3, -margin);
fdFromdate.top = new FormAttachment(wDatefield, 2 * margin);
wFromdate.setLayoutData(fdFromdate);
wFromdate.addFocusListener(new FocusListener() {
public void focusLost(org.eclipse.swt.events.FocusEvent e) {
}
public void focusGained(org.eclipse.swt.events.FocusEvent e) {
Cursor busy = new Cursor(shell.getDisplay(), SWT.CURSOR_WAIT);
shell.setCursor(busy);
getFieldsFromTable();
shell.setCursor(null);
busy.dispose();
}
});
// Minyear line
wlMinyear = new Label(comp, SWT.RIGHT);
wlMinyear.setText(BaseMessages.getString(PKG, "DimensionLookupDialog.Minyear.Label"));
props.setLook(wlMinyear);
FormData fdlMinyear = new FormData();
fdlMinyear.left = new FormAttachment(wFromdate, margin);
fdlMinyear.right = new FormAttachment(middle + 2 * (100 - middle) / 3, -margin);
fdlMinyear.top = new FormAttachment(wDatefield, 2 * margin);
wlMinyear.setLayoutData(fdlMinyear);
wMinyear = new Text(comp, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
props.setLook(wMinyear);
wMinyear.addModifyListener(lsMod);
FormData fdMinyear = new FormData();
fdMinyear.left = new FormAttachment(wlMinyear, margin);
fdMinyear.right = new FormAttachment(100, 0);
fdMinyear.top = new FormAttachment(wDatefield, 2 * margin);
wMinyear.setLayoutData(fdMinyear);
wMinyear.setToolTipText(BaseMessages.getString(PKG, "DimensionLookupDialog.Minyear.ToolTip"));
// Add a line with an option to specify an alternative start date...
//
wlUseAltStartDate = new Label(comp, SWT.RIGHT);
wlUseAltStartDate.setText(BaseMessages.getString(PKG, "DimensionLookupDialog.UseAlternativeStartDate.Label"));
props.setLook(wlUseAltStartDate);
FormData fdlUseAltStartDate = new FormData();
fdlUseAltStartDate.left = new FormAttachment(0, 0);
fdlUseAltStartDate.right = new FormAttachment(middle, -margin);
fdlUseAltStartDate.top = new FormAttachment(wFromdate, margin);
wlUseAltStartDate.setLayoutData(fdlUseAltStartDate);
wUseAltStartDate = new Button(comp, SWT.CHECK);
props.setLook(wUseAltStartDate);
wUseAltStartDate.setToolTipText(BaseMessages.getString(PKG, "DimensionLookupDialog.UseAlternativeStartDate.Tooltip", Const.CR));
FormData fdUseAltStartDate = new FormData();
fdUseAltStartDate.left = new FormAttachment(middle, 0);
fdUseAltStartDate.top = new FormAttachment(wFromdate, margin);
wUseAltStartDate.setLayoutData(fdUseAltStartDate);
wUseAltStartDate.addSelectionListener(new SelectionAdapter() {
public void widgetSelected(SelectionEvent e) {
setFlags();
input.setChanged();
}
});
// The choice...
//
wAltStartDate = new CCombo(comp, SWT.BORDER);
props.setLook(wAltStartDate);
// All options except for "No alternative"...
wAltStartDate.removeAll();
for (int i = 1; i < DimensionLookupMeta.getStartDateAlternativeDescriptions().length; i++) {
wAltStartDate.add(DimensionLookupMeta.getStartDateAlternativeDescriptions()[i]);
}
wAltStartDate.setText(BaseMessages.getString(PKG, "DimensionLookupDialog.AlternativeStartDate.SelectItemDefault"));
wAltStartDate.setToolTipText(BaseMessages.getString(PKG, "DimensionLookupDialog.AlternativeStartDate.Tooltip", Const.CR));
FormData fdAltStartDate = new FormData();
fdAltStartDate.left = new FormAttachment(wUseAltStartDate, 2 * margin);
fdAltStartDate.right = new FormAttachment(wUseAltStartDate, 200);
fdAltStartDate.top = new FormAttachment(wFromdate, margin);
wAltStartDate.setLayoutData(fdAltStartDate);
wAltStartDate.addModifyListener(new ModifyListener() {
public void modifyText(ModifyEvent arg0) {
setFlags();
input.setChanged();
}
});
wAltStartDateField = new CCombo(comp, SWT.SINGLE | SWT.BORDER);
props.setLook(wAltStartDateField);
wAltStartDateField.setToolTipText(BaseMessages.getString(PKG, "DimensionLookupDialog.AlternativeStartDateField.Tooltip", Const.CR));
FormData fdAltStartDateField = new FormData();
fdAltStartDateField.left = new FormAttachment(wAltStartDate, 2 * margin);
fdAltStartDateField.right = new FormAttachment(100, 0);
fdAltStartDateField.top = new FormAttachment(wFromdate, margin);
wAltStartDateField.setLayoutData(fdAltStartDateField);
wAltStartDateField.addFocusListener(new FocusListener() {
public void focusLost(org.eclipse.swt.events.FocusEvent e) {
}
public void focusGained(org.eclipse.swt.events.FocusEvent e) {
Cursor busy = new Cursor(shell.getDisplay(), SWT.CURSOR_WAIT);
shell.setCursor(busy);
getFieldsFromTable();
shell.setCursor(null);
busy.dispose();
}
});
// Todate line
wlTodate = new Label(comp, SWT.RIGHT);
wlTodate.setText(BaseMessages.getString(PKG, "DimensionLookupDialog.Todate.Label"));
props.setLook(wlTodate);
FormData fdlTodate = new FormData();
fdlTodate.left = new FormAttachment(0, 0);
fdlTodate.right = new FormAttachment(middle, -margin);
fdlTodate.top = new FormAttachment(wAltStartDate, margin);
wlTodate.setLayoutData(fdlTodate);
wTodate = new CCombo(comp, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
props.setLook(wTodate);
wTodate.addModifyListener(lsMod);
FormData fdTodate = new FormData();
fdTodate.left = new FormAttachment(middle, 0);
fdTodate.right = new FormAttachment(middle + (100 - middle) / 3, -margin);
fdTodate.top = new FormAttachment(wAltStartDate, margin);
wTodate.setLayoutData(fdTodate);
wTodate.addFocusListener(new FocusListener() {
public void focusLost(org.eclipse.swt.events.FocusEvent e) {
}
public void focusGained(org.eclipse.swt.events.FocusEvent e) {
Cursor busy = new Cursor(shell.getDisplay(), SWT.CURSOR_WAIT);
shell.setCursor(busy);
getFieldsFromTable();
shell.setCursor(null);
busy.dispose();
}
});
// Maxyear line
wlMaxyear = new Label(comp, SWT.RIGHT);
wlMaxyear.setText(BaseMessages.getString(PKG, "DimensionLookupDialog.Maxyear.Label"));
props.setLook(wlMaxyear);
FormData fdlMaxyear = new FormData();
fdlMaxyear.left = new FormAttachment(wTodate, margin);
fdlMaxyear.right = new FormAttachment(middle + 2 * (100 - middle) / 3, -margin);
fdlMaxyear.top = new FormAttachment(wAltStartDate, margin);
wlMaxyear.setLayoutData(fdlMaxyear);
wMaxyear = new Text(comp, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
props.setLook(wMaxyear);
wMaxyear.addModifyListener(lsMod);
FormData fdMaxyear = new FormData();
fdMaxyear.left = new FormAttachment(wlMaxyear, margin);
fdMaxyear.right = new FormAttachment(100, 0);
fdMaxyear.top = new FormAttachment(wAltStartDate, margin);
wMaxyear.setLayoutData(fdMaxyear);
wMaxyear.setToolTipText(BaseMessages.getString(PKG, "DimensionLookupDialog.Maxyear.ToolTip"));
// THE BOTTOM BUTTONS
wOK = new Button(comp, SWT.PUSH);
wOK.setText(BaseMessages.getString(PKG, "System.Button.OK"));
wGet = new Button(comp, SWT.PUSH);
wGet.setText(BaseMessages.getString(PKG, "DimensionLookupDialog.GetFields.Button"));
wCreate = new Button(comp, SWT.PUSH);
wCreate.setText(BaseMessages.getString(PKG, "DimensionLookupDialog.SQL.Button"));
wCancel = new Button(comp, SWT.PUSH);
wCancel.setText(BaseMessages.getString(PKG, "System.Button.Cancel"));
setButtonPositions(new Button[] { wOK, wCancel, wGet, wCreate }, margin, wMaxyear);
FormData fdComp = new FormData();
fdComp.left = new FormAttachment(0, 0);
fdComp.top = new FormAttachment(0, 0);
fdComp.right = new FormAttachment(100, 0);
fdComp.bottom = new FormAttachment(100, 0);
comp.setLayoutData(fdComp);
comp.pack();
Rectangle bounds = comp.getBounds();
sComp.setContent(comp);
sComp.setExpandHorizontal(true);
sComp.setExpandVertical(true);
sComp.setMinWidth(bounds.width);
sComp.setMinHeight(bounds.height);
// Add listeners
lsOK = new Listener() {
public void handleEvent(Event e) {
ok();
}
};
lsGet = new Listener() {
public void handleEvent(Event e) {
get();
}
};
lsCreate = new Listener() {
public void handleEvent(Event e) {
create();
}
};
lsCancel = new Listener() {
public void handleEvent(Event e) {
cancel();
}
};
wOK.addListener(SWT.Selection, lsOK);
wGet.addListener(SWT.Selection, lsGet);
wCreate.addListener(SWT.Selection, lsCreate);
wCancel.addListener(SWT.Selection, lsCancel);
setTableMax();
setSequence();
setAutoincUse();
lsDef = new SelectionAdapter() {
public void widgetDefaultSelected(SelectionEvent e) {
ok();
}
};
wStepname.addSelectionListener(lsDef);
wSchema.addSelectionListener(lsDef);
wTable.addSelectionListener(lsDef);
wCommit.addSelectionListener(lsDef);
wCacheSize.addSelectionListener(lsDef);
wTk.addSelectionListener(lsDef);
wTkRename.addSelectionListener(lsDef);
wSeq.addSelectionListener(lsDef);
wVersion.addSelectionListener(lsDef);
wDatefield.addSelectionListener(lsDef);
wFromdate.addSelectionListener(lsDef);
wMinyear.addSelectionListener(lsDef);
wTodate.addSelectionListener(lsDef);
wMaxyear.addSelectionListener(lsDef);
// Detect X or ALT-F4 or something that kills this window...
shell.addShellListener(new ShellAdapter() {
public void shellClosed(ShellEvent e) {
cancel();
}
});
wbSchema.addSelectionListener(new SelectionAdapter() {
public void widgetSelected(SelectionEvent e) {
getSchemaNames();
}
});
wbTable.addSelectionListener(new SelectionAdapter() {
public void widgetSelected(SelectionEvent e) {
getTableName();
}
});
wTabFolder.setSelection(0);
// Set the shell size, based upon previous time...
setSize();
getData();
setTableFieldCombo();
input.setChanged(backupChanged);
shell.open();
while (!shell.isDisposed()) {
if (!display.readAndDispatch()) {
display.sleep();
}
}
return stepname;
}
Also used :
FocusAdapter(org.eclipse.swt.events.FocusAdapter)
KettleException(org.pentaho.di.core.exception.KettleException)
Group(org.eclipse.swt.widgets.Group)
CTabFolder(org.eclipse.swt.custom.CTabFolder)
TableItemInsertListener(org.pentaho.di.ui.trans.step.TableItemInsertListener)
FocusListener(org.eclipse.swt.events.FocusListener)
Listener(org.eclipse.swt.widgets.Listener)
ModifyListener(org.eclipse.swt.events.ModifyListener)
ModifyListener(org.eclipse.swt.events.ModifyListener)
Label(org.eclipse.swt.widgets.Label)
Rectangle(org.eclipse.swt.graphics.Rectangle)
ColumnInfo(org.pentaho.di.ui.core.widget.ColumnInfo)
ShellEvent(org.eclipse.swt.events.ShellEvent)
RowMetaInterface(org.pentaho.di.core.row.RowMetaInterface)
FocusEvent(org.eclipse.swt.events.FocusEvent)
Cursor(org.eclipse.swt.graphics.Cursor)
FocusEvent(org.eclipse.swt.events.FocusEvent)
CTabItem(org.eclipse.swt.custom.CTabItem)
Shell(org.eclipse.swt.widgets.Shell)
ModifyEvent(org.eclipse.swt.events.ModifyEvent)
GridLayout(org.eclipse.swt.layout.GridLayout)
Button(org.eclipse.swt.widgets.Button)
SelectionEvent(org.eclipse.swt.events.SelectionEvent)
ScrolledComposite(org.eclipse.swt.custom.ScrolledComposite)
FormAttachment(org.eclipse.swt.layout.FormAttachment)
TableView(org.pentaho.di.ui.core.widget.TableView)
FormLayout(org.eclipse.swt.layout.FormLayout)
FormData(org.eclipse.swt.layout.FormData)
ShellAdapter(org.eclipse.swt.events.ShellAdapter)
Composite(org.eclipse.swt.widgets.Composite)
ScrolledComposite(org.eclipse.swt.custom.ScrolledComposite)
SelectionAdapter(org.eclipse.swt.events.SelectionAdapter)
Text(org.eclipse.swt.widgets.Text)
FillLayout(org.eclipse.swt.layout.FillLayout)
StepMeta(org.pentaho.di.trans.step.StepMeta)
BaseStepMeta(org.pentaho.di.trans.step.BaseStepMeta)
TextVar(org.pentaho.di.ui.core.widget.TextVar)
CCombo(org.eclipse.swt.custom.CCombo)
GridData(org.eclipse.swt.layout.GridData)
FocusEvent(org.eclipse.swt.events.FocusEvent)
ModifyEvent(org.eclipse.swt.events.ModifyEvent)
Event(org.eclipse.swt.widgets.Event)
ShellEvent(org.eclipse.swt.events.ShellEvent)
SelectionEvent(org.eclipse.swt.events.SelectionEvent)
FocusListener(org.eclipse.swt.events.FocusListener)
Display(org.eclipse.swt.widgets.Display)
Example 38 with TableView
use of org.pentaho.di.ui.core.widget.TableView in project pentaho-kettle by pentaho.
the class FormulaDialog method open.
@Override
public String open() {
Shell parent = getParent();
Display display = parent.getDisplay();
shell = new Shell(parent, SWT.DIALOG_TRIM | SWT.RESIZE | SWT.MIN | SWT.MAX);
props.setLook(shell);
setShellImage(shell, currentMeta);
ModifyListener lsMod = new ModifyListener() {
@Override
public void modifyText(ModifyEvent e) {
currentMeta.setChanged();
}
};
changed = currentMeta.hasChanged();
FormLayout formLayout = new FormLayout();
formLayout.marginWidth = Const.FORM_MARGIN;
formLayout.marginHeight = Const.FORM_MARGIN;
shell.setLayout(formLayout);
shell.setText(BaseMessages.getString(PKG, "FormulaDialog.DialogTitle"));
int middle = props.getMiddlePct();
int margin = Const.MARGIN;
// Stepname line
wlStepname = new Label(shell, SWT.RIGHT);
wlStepname.setText(BaseMessages.getString(PKG, "System.Label.StepName"));
props.setLook(wlStepname);
fdlStepname = new FormData();
fdlStepname.left = new FormAttachment(0, 0);
fdlStepname.right = new FormAttachment(middle, -margin);
fdlStepname.top = new FormAttachment(0, margin);
wlStepname.setLayoutData(fdlStepname);
wStepname = new Text(shell, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
wStepname.setText(stepname);
props.setLook(wStepname);
wStepname.addModifyListener(lsMod);
fdStepname = new FormData();
fdStepname.left = new FormAttachment(middle, 0);
fdStepname.top = new FormAttachment(0, margin);
fdStepname.right = new FormAttachment(100, 0);
wStepname.setLayoutData(fdStepname);
wlFields = new Label(shell, SWT.NONE);
wlFields.setText(BaseMessages.getString(PKG, "FormulaDialog.Fields.Label"));
props.setLook(wlFields);
fdlFields = new FormData();
fdlFields.left = new FormAttachment(0, 0);
fdlFields.top = new FormAttachment(wStepname, margin);
wlFields.setLayoutData(fdlFields);
final int FieldsRows = currentMeta.getFormula() != null ? currentMeta.getFormula().length : 1;
colinf = new ColumnInfo[] { new ColumnInfo(BaseMessages.getString(PKG, "FormulaDialog.NewField.Column"), ColumnInfo.COLUMN_TYPE_TEXT, false), new ColumnInfo(BaseMessages.getString(PKG, "FormulaDialog.Formula.Column"), ColumnInfo.COLUMN_TYPE_TEXT, false), new ColumnInfo(BaseMessages.getString(PKG, "FormulaDialog.ValueType.Column"), ColumnInfo.COLUMN_TYPE_CCOMBO, ValueMetaFactory.getValueMetaNames()), new ColumnInfo(BaseMessages.getString(PKG, "FormulaDialog.Length.Column"), ColumnInfo.COLUMN_TYPE_TEXT, false), new ColumnInfo(BaseMessages.getString(PKG, "FormulaDialog.Precision.Column"), ColumnInfo.COLUMN_TYPE_TEXT, false), new ColumnInfo(BaseMessages.getString(PKG, "FormulaDialog.Replace.Column"), ColumnInfo.COLUMN_TYPE_CCOMBO, new String[] {}) };
wFields = new TableView(transMeta, shell, SWT.BORDER | SWT.FULL_SELECTION | SWT.MULTI, colinf, FieldsRows, lsMod, props);
fdFields = new FormData();
fdFields.left = new FormAttachment(0, 0);
fdFields.top = new FormAttachment(wlFields, margin);
fdFields.right = new FormAttachment(100, 0);
fdFields.bottom = new FormAttachment(100, -50);
wFields.setLayoutData(fdFields);
//
// Search the fields in the background
//
final Runnable runnable = new Runnable() {
@Override
public void run() {
StepMeta stepMeta = transMeta.findStep(stepname);
if (stepMeta != null) {
try {
RowMetaInterface row = transMeta.getPrevStepFields(stepMeta);
// Remember these fields...
for (int i = 0; i < row.size(); i++) {
inputFields.put(row.getValueMeta(i).getName(), new Integer(i));
}
setComboBoxes();
} catch (KettleException e) {
logError(BaseMessages.getString(PKG, "FormulaDialog.Log.UnableToFindInput"));
}
}
}
};
new Thread(runnable).start();
colinf[1].setSelectionAdapter(new SelectionAdapter() {
@Override
public void widgetSelected(SelectionEvent e) {
if (fieldNames == null) {
return;
}
TableView tv = (TableView) e.widget;
TableItem item = tv.table.getItem(e.y);
String formula = item.getText(e.x);
try {
if (!shell.isDisposed()) {
LibFormulaEditor libFormulaEditor = new LibFormulaEditor(shell, SWT.APPLICATION_MODAL | SWT.SHEET, Const.NVL(formula, ""), fieldNames);
formula = libFormulaEditor.open();
if (formula != null && !tv.isDisposed()) {
tv.setText(formula, e.x, e.y);
}
}
} catch (Exception ex) {
new ErrorDialog(shell, "Error", "There was an unexpected error in the formula editor", ex);
}
}
});
wFields.addModifyListener(new ModifyListener() {
@Override
public void modifyText(ModifyEvent arg0) {
// Now set the combo's
shell.getDisplay().asyncExec(new Runnable() {
@Override
public void run() {
setComboBoxes();
}
});
}
});
// Some buttons
wOK = new Button(shell, SWT.PUSH);
wOK.setText(BaseMessages.getString(PKG, "System.Button.OK"));
wCancel = new Button(shell, SWT.PUSH);
wCancel.setText(BaseMessages.getString(PKG, "System.Button.Cancel"));
setButtonPositions(new Button[] { wOK, wCancel }, margin, null);
// Add listeners
lsCancel = new Listener() {
@Override
public void handleEvent(Event e) {
cancel();
}
};
lsOK = new Listener() {
@Override
public void handleEvent(Event e) {
ok();
}
};
wCancel.addListener(SWT.Selection, lsCancel);
wOK.addListener(SWT.Selection, lsOK);
lsDef = new SelectionAdapter() {
@Override
public void widgetDefaultSelected(SelectionEvent e) {
ok();
}
};
wStepname.addSelectionListener(lsDef);
// Detect X or ALT-F4 or something that kills this window...
shell.addShellListener(new ShellAdapter() {
@Override
public void shellClosed(ShellEvent e) {
cancel();
}
});
// Set the shell size, based upon previous time...
setSize();
getData();
currentMeta.setChanged(changed);
shell.open();
while (!shell.isDisposed()) {
if (!display.readAndDispatch()) {
display.sleep();
}
}
return stepname;
}
Also used :
KettleException(org.pentaho.di.core.exception.KettleException)
Listener(org.eclipse.swt.widgets.Listener)
ModifyListener(org.eclipse.swt.events.ModifyListener)
ModifyListener(org.eclipse.swt.events.ModifyListener)
TableItem(org.eclipse.swt.widgets.TableItem)
Label(org.eclipse.swt.widgets.Label)
ColumnInfo(org.pentaho.di.ui.core.widget.ColumnInfo)
ShellEvent(org.eclipse.swt.events.ShellEvent)
RowMetaInterface(org.pentaho.di.core.row.RowMetaInterface)
LibFormulaEditor(org.pentaho.libformula.ui.editor.LibFormulaEditor)
Shell(org.eclipse.swt.widgets.Shell)
ModifyEvent(org.eclipse.swt.events.ModifyEvent)
Button(org.eclipse.swt.widgets.Button)
SelectionEvent(org.eclipse.swt.events.SelectionEvent)
FormAttachment(org.eclipse.swt.layout.FormAttachment)
TableView(org.pentaho.di.ui.core.widget.TableView)
FormLayout(org.eclipse.swt.layout.FormLayout)
FormData(org.eclipse.swt.layout.FormData)
ShellAdapter(org.eclipse.swt.events.ShellAdapter)
SelectionAdapter(org.eclipse.swt.events.SelectionAdapter)
ErrorDialog(org.pentaho.di.ui.core.dialog.ErrorDialog)
Text(org.eclipse.swt.widgets.Text)
StepMeta(org.pentaho.di.trans.step.StepMeta)
BaseStepMeta(org.pentaho.di.trans.step.BaseStepMeta)
KettleException(org.pentaho.di.core.exception.KettleException)
Event(org.eclipse.swt.widgets.Event)
ModifyEvent(org.eclipse.swt.events.ModifyEvent)
ShellEvent(org.eclipse.swt.events.ShellEvent)
SelectionEvent(org.eclipse.swt.events.SelectionEvent)
Display(org.eclipse.swt.widgets.Display)
Example 39 with TableView
use of org.pentaho.di.ui.core.widget.TableView in project pentaho-kettle by pentaho.
the class GetXMLDataDialog method open.
public String open() {
Shell parent = getParent();
Display display = parent.getDisplay();
shell = new Shell(parent, SWT.DIALOG_TRIM | SWT.RESIZE | SWT.MAX | SWT.MIN);
props.setLook(shell);
setShellImage(shell, input);
lsMod = new ModifyListener() {
public void modifyText(ModifyEvent e) {
input.setChanged();
}
};
changed = input.hasChanged();
FormLayout formLayout = new FormLayout();
formLayout.marginWidth = Const.FORM_MARGIN;
formLayout.marginHeight = Const.FORM_MARGIN;
shell.setLayout(formLayout);
shell.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.DialogTitle"));
middle = props.getMiddlePct();
margin = Const.MARGIN;
// Stepname line
wlStepname = new Label(shell, SWT.RIGHT);
wlStepname.setText(BaseMessages.getString(PKG, "System.Label.StepName"));
props.setLook(wlStepname);
fdlStepname = new FormData();
fdlStepname.left = new FormAttachment(0, 0);
fdlStepname.top = new FormAttachment(0, margin);
fdlStepname.right = new FormAttachment(middle, -margin);
wlStepname.setLayoutData(fdlStepname);
wStepname = new Text(shell, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
wStepname.setText(stepname);
props.setLook(wStepname);
wStepname.addModifyListener(lsMod);
fdStepname = new FormData();
fdStepname.left = new FormAttachment(middle, 0);
fdStepname.top = new FormAttachment(0, margin);
fdStepname.right = new FormAttachment(100, 0);
wStepname.setLayoutData(fdStepname);
wTabFolder = new CTabFolder(shell, SWT.BORDER);
props.setLook(wTabFolder, Props.WIDGET_STYLE_TAB);
// ////////////////////////
// START OF FILE TAB ///
// ////////////////////////
wFileTab = new CTabItem(wTabFolder, SWT.NONE);
wFileTab.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.File.Tab"));
wFileComp = new Composite(wTabFolder, SWT.NONE);
props.setLook(wFileComp);
FormLayout fileLayout = new FormLayout();
fileLayout.marginWidth = 3;
fileLayout.marginHeight = 3;
wFileComp.setLayout(fileLayout);
// ///////////////////////////////
// START OF Output Field GROUP //
// ///////////////////////////////
wOutputField = new Group(wFileComp, SWT.SHADOW_NONE);
props.setLook(wOutputField);
wOutputField.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.wOutputField.Label"));
FormLayout outputfieldgroupLayout = new FormLayout();
outputfieldgroupLayout.marginWidth = 10;
outputfieldgroupLayout.marginHeight = 10;
wOutputField.setLayout(outputfieldgroupLayout);
// Is XML string defined in a Field
wlXmlStreamField = new Label(wOutputField, SWT.RIGHT);
wlXmlStreamField.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.wlXmlStreamField.Label"));
props.setLook(wlXmlStreamField);
fdlXMLStreamField = new FormData();
fdlXMLStreamField.left = new FormAttachment(0, -margin);
fdlXMLStreamField.top = new FormAttachment(0, margin);
fdlXMLStreamField.right = new FormAttachment(middle, -2 * margin);
wlXmlStreamField.setLayoutData(fdlXMLStreamField);
wXMLStreamField = new Button(wOutputField, SWT.CHECK);
props.setLook(wXMLStreamField);
wXMLStreamField.setToolTipText(BaseMessages.getString(PKG, "GetXMLDataDialog.wXmlStreamField.Tooltip"));
fdXSDFileField = new FormData();
fdXSDFileField.left = new FormAttachment(middle, -margin);
fdXSDFileField.top = new FormAttachment(0, margin);
wXMLStreamField.setLayoutData(fdXSDFileField);
SelectionAdapter lsxmlstream = new SelectionAdapter() {
public void widgetSelected(SelectionEvent arg0) {
XMLSource = null;
ActiveXmlStreamField();
input.setChanged();
}
};
wXMLStreamField.addSelectionListener(lsxmlstream);
// Is XML source is a file?
wlXMLIsAFile = new Label(wOutputField, SWT.RIGHT);
wlXMLIsAFile.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.XMLIsAFile.Label"));
props.setLook(wlXMLIsAFile);
fdlXMLIsAFile = new FormData();
fdlXMLIsAFile.left = new FormAttachment(0, -margin);
fdlXMLIsAFile.top = new FormAttachment(wXMLStreamField, margin);
fdlXMLIsAFile.right = new FormAttachment(middle, -2 * margin);
wlXMLIsAFile.setLayoutData(fdlXMLIsAFile);
wXMLIsAFile = new Button(wOutputField, SWT.CHECK);
props.setLook(wXMLIsAFile);
wXMLIsAFile.setToolTipText(BaseMessages.getString(PKG, "GetXMLDataDialog.XMLIsAFile.Tooltip"));
fdXMLIsAFile = new FormData();
fdXMLIsAFile.left = new FormAttachment(middle, -margin);
fdXMLIsAFile.top = new FormAttachment(wXMLStreamField, margin);
wXMLIsAFile.setLayoutData(fdXMLIsAFile);
SelectionAdapter lsxmlisafile = new SelectionAdapter() {
public void widgetSelected(SelectionEvent arg0) {
XMLSource = null;
if (wXMLIsAFile.getSelection()) {
wreadUrl.setSelection(false);
}
input.setChanged();
}
};
wXMLIsAFile.addSelectionListener(lsxmlisafile);
// read url as source ?
wlreadUrl = new Label(wOutputField, SWT.RIGHT);
wlreadUrl.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.readUrl.Label"));
props.setLook(wlreadUrl);
fdlreadUrl = new FormData();
fdlreadUrl.left = new FormAttachment(0, -margin);
fdlreadUrl.top = new FormAttachment(wXMLIsAFile, margin);
fdlreadUrl.right = new FormAttachment(middle, -2 * margin);
wlreadUrl.setLayoutData(fdlreadUrl);
wreadUrl = new Button(wOutputField, SWT.CHECK);
props.setLook(wreadUrl);
wreadUrl.setToolTipText(BaseMessages.getString(PKG, "GetXMLDataDialog.readUrl.Tooltip"));
fdreadUrl = new FormData();
fdreadUrl.left = new FormAttachment(middle, -margin);
fdreadUrl.top = new FormAttachment(wXMLIsAFile, margin);
wreadUrl.setLayoutData(fdreadUrl);
SelectionAdapter lsreadurl = new SelectionAdapter() {
public void widgetSelected(SelectionEvent arg0) {
XMLSource = null;
if (wreadUrl.getSelection()) {
wXMLIsAFile.setSelection(false);
}
input.setChanged();
}
};
wreadUrl.addSelectionListener(lsreadurl);
// If XML string defined in a Field
wlXMLField = new Label(wOutputField, SWT.RIGHT);
wlXMLField.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.wlXMLField.Label"));
props.setLook(wlXMLField);
fdlXMLField = new FormData();
fdlXMLField.left = new FormAttachment(0, -margin);
fdlXMLField.top = new FormAttachment(wreadUrl, margin);
fdlXMLField.right = new FormAttachment(middle, -2 * margin);
wlXMLField.setLayoutData(fdlXMLField);
wXMLField = new CCombo(wOutputField, SWT.BORDER | SWT.READ_ONLY);
wXMLField.setEditable(true);
props.setLook(wXMLField);
wXMLField.addModifyListener(lsMod);
fdXMLField = new FormData();
fdXMLField.left = new FormAttachment(middle, -margin);
fdXMLField.top = new FormAttachment(wreadUrl, margin);
fdXMLField.right = new FormAttachment(100, -margin);
wXMLField.setLayoutData(fdXMLField);
wXMLField.addFocusListener(new FocusListener() {
public void focusLost(org.eclipse.swt.events.FocusEvent e) {
}
public void focusGained(org.eclipse.swt.events.FocusEvent e) {
Cursor busy = new Cursor(shell.getDisplay(), SWT.CURSOR_WAIT);
shell.setCursor(busy);
setXMLStreamField();
shell.setCursor(null);
busy.dispose();
}
});
fdOutputField = new FormData();
fdOutputField.left = new FormAttachment(0, margin);
fdOutputField.top = new FormAttachment(wFilenameList, margin);
fdOutputField.right = new FormAttachment(100, -margin);
wOutputField.setLayoutData(fdOutputField);
// ///////////////////////////////////////////////////////////
// / END OF Output Field GROUP
// ///////////////////////////////////////////////////////////
// Filename line
wlFilename = new Label(wFileComp, SWT.RIGHT);
wlFilename.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.Filename.Label"));
props.setLook(wlFilename);
fdlFilename = new FormData();
fdlFilename.left = new FormAttachment(0, 0);
fdlFilename.top = new FormAttachment(wOutputField, margin);
fdlFilename.right = new FormAttachment(middle, -margin);
wlFilename.setLayoutData(fdlFilename);
wbbFilename = new Button(wFileComp, SWT.PUSH | SWT.CENTER);
props.setLook(wbbFilename);
wbbFilename.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.FilenameBrowse.Button"));
wbbFilename.setToolTipText(BaseMessages.getString(PKG, "System.Tooltip.BrowseForFileOrDirAndAdd"));
fdbFilename = new FormData();
fdbFilename.right = new FormAttachment(100, 0);
fdbFilename.top = new FormAttachment(wOutputField, margin);
wbbFilename.setLayoutData(fdbFilename);
wbaFilename = new Button(wFileComp, SWT.PUSH | SWT.CENTER);
props.setLook(wbaFilename);
wbaFilename.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.FilenameAdd.Button"));
wbaFilename.setToolTipText(BaseMessages.getString(PKG, "GetXMLDataDialog.FilenameAdd.Tooltip"));
fdbaFilename = new FormData();
fdbaFilename.right = new FormAttachment(wbbFilename, -margin);
fdbaFilename.top = new FormAttachment(wOutputField, margin);
wbaFilename.setLayoutData(fdbaFilename);
wFilename = new TextVar(transMeta, wFileComp, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
props.setLook(wFilename);
wFilename.addModifyListener(lsMod);
fdFilename = new FormData();
fdFilename.left = new FormAttachment(middle, 0);
fdFilename.right = new FormAttachment(wbaFilename, -margin);
fdFilename.top = new FormAttachment(wOutputField, margin);
wFilename.setLayoutData(fdFilename);
wlFilemask = new Label(wFileComp, SWT.RIGHT);
wlFilemask.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.RegExp.Label"));
props.setLook(wlFilemask);
fdlFilemask = new FormData();
fdlFilemask.left = new FormAttachment(0, 0);
fdlFilemask.top = new FormAttachment(wFilename, margin);
fdlFilemask.right = new FormAttachment(middle, -margin);
wlFilemask.setLayoutData(fdlFilemask);
wFilemask = new TextVar(transMeta, wFileComp, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
props.setLook(wFilemask);
wFilemask.addModifyListener(lsMod);
fdFilemask = new FormData();
fdFilemask.left = new FormAttachment(middle, 0);
fdFilemask.top = new FormAttachment(wFilename, margin);
fdFilemask.right = new FormAttachment(100, 0);
wFilemask.setLayoutData(fdFilemask);
wlExcludeFilemask = new Label(wFileComp, SWT.RIGHT);
wlExcludeFilemask.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.ExcludeFilemask.Label"));
props.setLook(wlExcludeFilemask);
fdlExcludeFilemask = new FormData();
fdlExcludeFilemask.left = new FormAttachment(0, 0);
fdlExcludeFilemask.top = new FormAttachment(wFilemask, margin);
fdlExcludeFilemask.right = new FormAttachment(middle, -margin);
wlExcludeFilemask.setLayoutData(fdlExcludeFilemask);
wExcludeFilemask = new TextVar(transMeta, wFileComp, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
props.setLook(wExcludeFilemask);
wExcludeFilemask.addModifyListener(lsMod);
fdExcludeFilemask = new FormData();
fdExcludeFilemask.left = new FormAttachment(middle, 0);
fdExcludeFilemask.top = new FormAttachment(wFilemask, margin);
fdExcludeFilemask.right = new FormAttachment(wFilename, 0, SWT.RIGHT);
wExcludeFilemask.setLayoutData(fdExcludeFilemask);
// Filename list line
wlFilenameList = new Label(wFileComp, SWT.RIGHT);
wlFilenameList.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.FilenameList.Label"));
props.setLook(wlFilenameList);
fdlFilenameList = new FormData();
fdlFilenameList.left = new FormAttachment(0, 0);
fdlFilenameList.top = new FormAttachment(wExcludeFilemask, margin);
fdlFilenameList.right = new FormAttachment(middle, -margin);
wlFilenameList.setLayoutData(fdlFilenameList);
// Buttons to the right of the screen...
wbdFilename = new Button(wFileComp, SWT.PUSH | SWT.CENTER);
props.setLook(wbdFilename);
wbdFilename.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.FilenameRemove.Button"));
wbdFilename.setToolTipText(BaseMessages.getString(PKG, "GetXMLDataDialog.FilenameRemove.Tooltip"));
fdbdFilename = new FormData();
fdbdFilename.right = new FormAttachment(100, 0);
fdbdFilename.top = new FormAttachment(wExcludeFilemask, 40);
wbdFilename.setLayoutData(fdbdFilename);
wbeFilename = new Button(wFileComp, SWT.PUSH | SWT.CENTER);
props.setLook(wbeFilename);
wbeFilename.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.FilenameEdit.Button"));
wbeFilename.setToolTipText(BaseMessages.getString(PKG, "GetXMLDataDialog.FilenameEdit.Tooltip"));
fdbeFilename = new FormData();
fdbeFilename.right = new FormAttachment(100, 0);
fdbeFilename.left = new FormAttachment(wbdFilename, 0, SWT.LEFT);
fdbeFilename.top = new FormAttachment(wbdFilename, margin);
wbeFilename.setLayoutData(fdbeFilename);
wbShowFiles = new Button(wFileComp, SWT.PUSH | SWT.CENTER);
props.setLook(wbShowFiles);
wbShowFiles.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.ShowFiles.Button"));
fdbShowFiles = new FormData();
fdbShowFiles.left = new FormAttachment(middle, 0);
fdbShowFiles.bottom = new FormAttachment(100, 0);
wbShowFiles.setLayoutData(fdbShowFiles);
ColumnInfo[] colinfo = new ColumnInfo[5];
colinfo[0] = new ColumnInfo(BaseMessages.getString(PKG, "GetXMLDataDialog.Files.Filename.Column"), ColumnInfo.COLUMN_TYPE_TEXT, false);
colinfo[1] = new ColumnInfo(BaseMessages.getString(PKG, "GetXMLDataDialog.Files.Wildcard.Column"), ColumnInfo.COLUMN_TYPE_TEXT, false);
colinfo[2] = new ColumnInfo(BaseMessages.getString(PKG, "GetXMLDataDialog.Files.ExcludeWildcard.Column"), ColumnInfo.COLUMN_TYPE_TEXT, false);
colinfo[0].setUsingVariables(true);
colinfo[1].setUsingVariables(true);
colinfo[1].setToolTip(BaseMessages.getString(PKG, "GetXMLDataDialog.Files.Wildcard.Tooltip"));
colinfo[2].setUsingVariables(true);
colinfo[2].setToolTip(BaseMessages.getString(PKG, "GetXMLDataDialog.Files.ExcludeWildcard.Tooltip"));
colinfo[3] = new ColumnInfo(BaseMessages.getString(PKG, "GetXMLDataDialog.Required.Column"), ColumnInfo.COLUMN_TYPE_CCOMBO, GetXMLDataMeta.RequiredFilesDesc);
colinfo[3].setToolTip(BaseMessages.getString(PKG, "GetXMLDataDialog.Required.Tooltip"));
colinfo[4] = new ColumnInfo(BaseMessages.getString(PKG, "GetXMLDataDialog.IncludeSubDirs.Column"), ColumnInfo.COLUMN_TYPE_CCOMBO, GetXMLDataMeta.RequiredFilesDesc);
colinfo[4].setToolTip(BaseMessages.getString(PKG, "GetXMLDataDialog.IncludeSubDirs.Tooltip"));
wFilenameList = new TableView(transMeta, wFileComp, SWT.FULL_SELECTION | SWT.SINGLE | SWT.BORDER, colinfo, 2, lsMod, props);
props.setLook(wFilenameList);
fdFilenameList = new FormData();
fdFilenameList.left = new FormAttachment(middle, 0);
fdFilenameList.right = new FormAttachment(wbdFilename, -margin);
fdFilenameList.top = new FormAttachment(wExcludeFilemask, margin);
fdFilenameList.bottom = new FormAttachment(wbShowFiles, -margin);
wFilenameList.setLayoutData(fdFilenameList);
fdFileComp = new FormData();
fdFileComp.left = new FormAttachment(0, 0);
fdFileComp.top = new FormAttachment(0, 0);
fdFileComp.right = new FormAttachment(100, 0);
fdFileComp.bottom = new FormAttachment(100, 0);
wFileComp.setLayoutData(fdFileComp);
wFileComp.layout();
wFileTab.setControl(wFileComp);
// ///////////////////////////////////////////////////////////
// / END OF FILE TAB
// ///////////////////////////////////////////////////////////
// ////////////////////////
// START OF CONTENT TAB///
// /
wContentTab = new CTabItem(wTabFolder, SWT.NONE);
wContentTab.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.Content.Tab"));
FormLayout contentLayout = new FormLayout();
contentLayout.marginWidth = 3;
contentLayout.marginHeight = 3;
wContentComp = new Composite(wTabFolder, SWT.NONE);
props.setLook(wContentComp);
wContentComp.setLayout(contentLayout);
// ///////////////////////////////
// START OF XmlConf Field GROUP //
// ///////////////////////////////
wXmlConf = new Group(wContentComp, SWT.SHADOW_NONE);
props.setLook(wXmlConf);
wXmlConf.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.wXmlConf.Label"));
FormLayout XmlConfgroupLayout = new FormLayout();
XmlConfgroupLayout.marginWidth = 10;
XmlConfgroupLayout.marginHeight = 10;
wXmlConf.setLayout(XmlConfgroupLayout);
wbbLoopPathList = new Button(wXmlConf, SWT.PUSH | SWT.CENTER);
props.setLook(wbbLoopPathList);
wbbLoopPathList.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.LoopPathList.Button"));
wbbLoopPathList.setToolTipText(BaseMessages.getString(PKG, "System.Tooltip.BrowseForFileOrDirAndAdd"));
fdbLoopPathList = new FormData();
fdbLoopPathList.right = new FormAttachment(100, 0);
fdbLoopPathList.top = new FormAttachment(0, 0);
wbbLoopPathList.setLayoutData(fdbLoopPathList);
wbbLoopPathList.addSelectionListener(new SelectionAdapter() {
public void widgetSelected(SelectionEvent e) {
getLoopPathList();
}
});
wlLoopXPath = new Label(wXmlConf, SWT.RIGHT);
wlLoopXPath.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.LoopXPath.Label"));
props.setLook(wlLoopXPath);
fdlLoopXPath = new FormData();
fdlLoopXPath.left = new FormAttachment(0, 0);
fdlLoopXPath.top = new FormAttachment(0, margin);
fdlLoopXPath.right = new FormAttachment(middle, -margin);
wlLoopXPath.setLayoutData(fdlLoopXPath);
wLoopXPath = new TextVar(transMeta, wXmlConf, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
wLoopXPath.setToolTipText(BaseMessages.getString(PKG, "GetXMLDataDialog.LoopXPath.Tooltip"));
props.setLook(wLoopXPath);
wLoopXPath.addModifyListener(lsMod);
fdLoopXPath = new FormData();
fdLoopXPath.left = new FormAttachment(middle, 0);
fdLoopXPath.top = new FormAttachment(0, margin);
fdLoopXPath.right = new FormAttachment(wbbLoopPathList, -margin);
wLoopXPath.setLayoutData(fdLoopXPath);
wlEncoding = new Label(wXmlConf, SWT.RIGHT);
wlEncoding.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.Encoding.Label"));
props.setLook(wlEncoding);
fdlEncoding = new FormData();
fdlEncoding.left = new FormAttachment(0, 0);
fdlEncoding.top = new FormAttachment(wLoopXPath, margin);
fdlEncoding.right = new FormAttachment(middle, -margin);
wlEncoding.setLayoutData(fdlEncoding);
wEncoding = new CCombo(wXmlConf, SWT.BORDER | SWT.READ_ONLY);
wEncoding.setEditable(true);
props.setLook(wEncoding);
wEncoding.addModifyListener(lsMod);
fdEncoding = new FormData();
fdEncoding.left = new FormAttachment(middle, 0);
fdEncoding.top = new FormAttachment(wLoopXPath, margin);
fdEncoding.right = new FormAttachment(100, 0);
wEncoding.setLayoutData(fdEncoding);
wEncoding.addFocusListener(new FocusListener() {
public void focusLost(org.eclipse.swt.events.FocusEvent e) {
}
public void focusGained(org.eclipse.swt.events.FocusEvent e) {
Cursor busy = new Cursor(shell.getDisplay(), SWT.CURSOR_WAIT);
shell.setCursor(busy);
setEncodings();
shell.setCursor(null);
busy.dispose();
}
});
// Set Namespace aware ?
wlNameSpaceAware = new Label(wXmlConf, SWT.RIGHT);
wlNameSpaceAware.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.NameSpaceAware.Label"));
props.setLook(wlNameSpaceAware);
fdlNameSpaceAware = new FormData();
fdlNameSpaceAware.left = new FormAttachment(0, 0);
fdlNameSpaceAware.top = new FormAttachment(wEncoding, margin);
fdlNameSpaceAware.right = new FormAttachment(middle, -margin);
wlNameSpaceAware.setLayoutData(fdlNameSpaceAware);
wNameSpaceAware = new Button(wXmlConf, SWT.CHECK);
props.setLook(wNameSpaceAware);
wNameSpaceAware.setToolTipText(BaseMessages.getString(PKG, "GetXMLDataDialog.NameSpaceAware.Tooltip"));
fdNameSpaceAware = new FormData();
fdNameSpaceAware.left = new FormAttachment(middle, 0);
fdNameSpaceAware.top = new FormAttachment(wEncoding, margin);
wNameSpaceAware.setLayoutData(fdNameSpaceAware);
// Ignore comments ?
wlIgnoreComment = new Label(wXmlConf, SWT.RIGHT);
wlIgnoreComment.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.IgnoreComment.Label"));
props.setLook(wlIgnoreComment);
fdlIgnoreComment = new FormData();
fdlIgnoreComment.left = new FormAttachment(0, 0);
fdlIgnoreComment.top = new FormAttachment(wNameSpaceAware, margin);
fdlIgnoreComment.right = new FormAttachment(middle, -margin);
wlIgnoreComment.setLayoutData(fdlIgnoreComment);
wIgnoreComment = new Button(wXmlConf, SWT.CHECK);
props.setLook(wIgnoreComment);
wIgnoreComment.setToolTipText(BaseMessages.getString(PKG, "GetXMLDataDialog.IgnoreComment.Tooltip"));
fdIgnoreComment = new FormData();
fdIgnoreComment.left = new FormAttachment(middle, 0);
fdIgnoreComment.top = new FormAttachment(wNameSpaceAware, margin);
wIgnoreComment.setLayoutData(fdIgnoreComment);
// Validate XML?
wlValidating = new Label(wXmlConf, SWT.RIGHT);
wlValidating.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.Validating.Label"));
props.setLook(wlValidating);
fdlValidating = new FormData();
fdlValidating.left = new FormAttachment(0, 0);
fdlValidating.top = new FormAttachment(wIgnoreComment, margin);
fdlValidating.right = new FormAttachment(middle, -margin);
wlValidating.setLayoutData(fdlValidating);
wValidating = new Button(wXmlConf, SWT.CHECK);
props.setLook(wValidating);
wValidating.setToolTipText(BaseMessages.getString(PKG, "GetXMLDataDialog.Validating.Tooltip"));
fdValidating = new FormData();
fdValidating.left = new FormAttachment(middle, 0);
fdValidating.top = new FormAttachment(wIgnoreComment, margin);
wValidating.setLayoutData(fdValidating);
// use Token ?
wluseToken = new Label(wXmlConf, SWT.RIGHT);
wluseToken.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.useToken.Label"));
props.setLook(wluseToken);
fdluseToken = new FormData();
fdluseToken.left = new FormAttachment(0, 0);
fdluseToken.top = new FormAttachment(wValidating, margin);
fdluseToken.right = new FormAttachment(middle, -margin);
wluseToken.setLayoutData(fdluseToken);
wuseToken = new Button(wXmlConf, SWT.CHECK);
props.setLook(wuseToken);
wuseToken.setToolTipText(BaseMessages.getString(PKG, "GetXMLDataDialog.useToken.Tooltip"));
fduseToken = new FormData();
fduseToken.left = new FormAttachment(middle, 0);
fduseToken.top = new FormAttachment(wValidating, margin);
wuseToken.setLayoutData(fduseToken);
// Ignore Empty File
wlIgnoreEmptyFile = new Label(wXmlConf, SWT.RIGHT);
wlIgnoreEmptyFile.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.IgnoreEmptyFile.Label"));
props.setLook(wlIgnoreEmptyFile);
fdlIgnoreEmptyFile = new FormData();
fdlIgnoreEmptyFile.left = new FormAttachment(0, 0);
fdlIgnoreEmptyFile.top = new FormAttachment(wuseToken, margin);
fdlIgnoreEmptyFile.right = new FormAttachment(middle, -margin);
wlIgnoreEmptyFile.setLayoutData(fdlIgnoreEmptyFile);
wIgnoreEmptyFile = new Button(wXmlConf, SWT.CHECK);
props.setLook(wIgnoreEmptyFile);
wIgnoreEmptyFile.setToolTipText(BaseMessages.getString(PKG, "GetXMLDataDialog.IgnoreEmptyFile.Tooltip"));
fdIgnoreEmptyFile = new FormData();
fdIgnoreEmptyFile.left = new FormAttachment(middle, 0);
fdIgnoreEmptyFile.top = new FormAttachment(wuseToken, margin);
wIgnoreEmptyFile.setLayoutData(fdIgnoreEmptyFile);
// do not fail if no files?
wldoNotFailIfNoFile = new Label(wXmlConf, SWT.RIGHT);
wldoNotFailIfNoFile.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.doNotFailIfNoFile.Label"));
props.setLook(wldoNotFailIfNoFile);
fdldoNotFailIfNoFile = new FormData();
fdldoNotFailIfNoFile.left = new FormAttachment(0, 0);
fdldoNotFailIfNoFile.top = new FormAttachment(wIgnoreEmptyFile, margin);
fdldoNotFailIfNoFile.right = new FormAttachment(middle, -margin);
wldoNotFailIfNoFile.setLayoutData(fdldoNotFailIfNoFile);
wdoNotFailIfNoFile = new Button(wXmlConf, SWT.CHECK);
props.setLook(wdoNotFailIfNoFile);
wdoNotFailIfNoFile.setToolTipText(BaseMessages.getString(PKG, "GetXMLDataDialog.doNotFailIfNoFile.Tooltip"));
fddoNotFailIfNoFile = new FormData();
fddoNotFailIfNoFile.left = new FormAttachment(middle, 0);
fddoNotFailIfNoFile.top = new FormAttachment(wIgnoreEmptyFile, margin);
wdoNotFailIfNoFile.setLayoutData(fddoNotFailIfNoFile);
wlLimit = new Label(wXmlConf, SWT.RIGHT);
wlLimit.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.Limit.Label"));
props.setLook(wlLimit);
fdlLimit = new FormData();
fdlLimit.left = new FormAttachment(0, 0);
fdlLimit.top = new FormAttachment(wdoNotFailIfNoFile, margin);
fdlLimit.right = new FormAttachment(middle, -margin);
wlLimit.setLayoutData(fdlLimit);
wLimit = new Text(wXmlConf, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
props.setLook(wLimit);
wLimit.addModifyListener(lsMod);
fdLimit = new FormData();
fdLimit.left = new FormAttachment(middle, 0);
fdLimit.top = new FormAttachment(wdoNotFailIfNoFile, margin);
fdLimit.right = new FormAttachment(100, 0);
wLimit.setLayoutData(fdLimit);
// Prune path to handle large files (streaming mode)
wlPrunePath = new Label(wXmlConf, SWT.RIGHT);
wlPrunePath.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.StreamingMode.Label"));
props.setLook(wlPrunePath);
fdlPrunePath = new FormData();
fdlPrunePath.left = new FormAttachment(0, 0);
fdlPrunePath.top = new FormAttachment(wLimit, margin);
fdlPrunePath.right = new FormAttachment(middle, -margin);
wlPrunePath.setLayoutData(fdlPrunePath);
wPrunePath = new TextVar(transMeta, wXmlConf, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
wPrunePath.setToolTipText(BaseMessages.getString(PKG, "GetXMLDataDialog.StreamingMode.Tooltip"));
props.setLook(wPrunePath);
wPrunePath.addModifyListener(lsMod);
fdPrunePath = new FormData();
fdPrunePath.left = new FormAttachment(middle, 0);
fdPrunePath.top = new FormAttachment(wLimit, margin);
fdPrunePath.right = new FormAttachment(100, 0);
wPrunePath.setLayoutData(fdPrunePath);
fdXmlConf = new FormData();
fdXmlConf.left = new FormAttachment(0, margin);
fdXmlConf.top = new FormAttachment(0, margin);
fdXmlConf.right = new FormAttachment(100, -margin);
wXmlConf.setLayoutData(fdXmlConf);
// ///////////////////////////////////////////////////////////
// / END OF XmlConf Field GROUP
// ///////////////////////////////////////////////////////////
// ///////////////////////////////
// START OF Additional Fields GROUP //
// ///////////////////////////////
wAdditionalFields = new Group(wContentComp, SWT.SHADOW_NONE);
props.setLook(wAdditionalFields);
wAdditionalFields.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.wAdditionalFields.Label"));
FormLayout AdditionalFieldsgroupLayout = new FormLayout();
AdditionalFieldsgroupLayout.marginWidth = 10;
AdditionalFieldsgroupLayout.marginHeight = 10;
wAdditionalFields.setLayout(AdditionalFieldsgroupLayout);
wlInclFilename = new Label(wAdditionalFields, SWT.RIGHT);
wlInclFilename.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.InclFilename.Label"));
props.setLook(wlInclFilename);
fdlInclFilename = new FormData();
fdlInclFilename.left = new FormAttachment(0, 0);
fdlInclFilename.top = new FormAttachment(wXmlConf, 4 * margin);
fdlInclFilename.right = new FormAttachment(middle, -margin);
wlInclFilename.setLayoutData(fdlInclFilename);
wInclFilename = new Button(wAdditionalFields, SWT.CHECK);
props.setLook(wInclFilename);
wInclFilename.setToolTipText(BaseMessages.getString(PKG, "GetXMLDataDialog.InclFilename.Tooltip"));
fdInclFilename = new FormData();
fdInclFilename.left = new FormAttachment(middle, 0);
fdInclFilename.top = new FormAttachment(wXmlConf, 4 * margin);
wInclFilename.setLayoutData(fdInclFilename);
wlInclFilenameField = new Label(wAdditionalFields, SWT.LEFT);
wlInclFilenameField.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.InclFilenameField.Label"));
props.setLook(wlInclFilenameField);
fdlInclFilenameField = new FormData();
fdlInclFilenameField.left = new FormAttachment(wInclFilename, margin);
fdlInclFilenameField.top = new FormAttachment(wLimit, 4 * margin);
wlInclFilenameField.setLayoutData(fdlInclFilenameField);
wInclFilenameField = new TextVar(transMeta, wAdditionalFields, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
props.setLook(wInclFilenameField);
wInclFilenameField.addModifyListener(lsMod);
fdInclFilenameField = new FormData();
fdInclFilenameField.left = new FormAttachment(wlInclFilenameField, margin);
fdInclFilenameField.top = new FormAttachment(wLimit, 4 * margin);
fdInclFilenameField.right = new FormAttachment(100, 0);
wInclFilenameField.setLayoutData(fdInclFilenameField);
wlInclRownum = new Label(wAdditionalFields, SWT.RIGHT);
wlInclRownum.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.InclRownum.Label"));
props.setLook(wlInclRownum);
fdlInclRownum = new FormData();
fdlInclRownum.left = new FormAttachment(0, 0);
fdlInclRownum.top = new FormAttachment(wInclFilenameField, margin);
fdlInclRownum.right = new FormAttachment(middle, -margin);
wlInclRownum.setLayoutData(fdlInclRownum);
wInclRownum = new Button(wAdditionalFields, SWT.CHECK);
props.setLook(wInclRownum);
wInclRownum.setToolTipText(BaseMessages.getString(PKG, "GetXMLDataDialog.InclRownum.Tooltip"));
fdRownum = new FormData();
fdRownum.left = new FormAttachment(middle, 0);
fdRownum.top = new FormAttachment(wInclFilenameField, margin);
wInclRownum.setLayoutData(fdRownum);
wlInclRownumField = new Label(wAdditionalFields, SWT.RIGHT);
wlInclRownumField.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.InclRownumField.Label"));
props.setLook(wlInclRownumField);
fdlInclRownumField = new FormData();
fdlInclRownumField.left = new FormAttachment(wInclRownum, margin);
fdlInclRownumField.top = new FormAttachment(wInclFilenameField, margin);
wlInclRownumField.setLayoutData(fdlInclRownumField);
wInclRownumField = new TextVar(transMeta, wAdditionalFields, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
props.setLook(wInclRownumField);
wInclRownumField.addModifyListener(lsMod);
fdInclRownumField = new FormData();
fdInclRownumField.left = new FormAttachment(wlInclRownumField, margin);
fdInclRownumField.top = new FormAttachment(wInclFilenameField, margin);
fdInclRownumField.right = new FormAttachment(100, 0);
wInclRownumField.setLayoutData(fdInclRownumField);
fdAdditionalFields = new FormData();
fdAdditionalFields.left = new FormAttachment(0, margin);
fdAdditionalFields.top = new FormAttachment(wXmlConf, margin);
fdAdditionalFields.right = new FormAttachment(100, -margin);
wAdditionalFields.setLayoutData(fdAdditionalFields);
// ///////////////////////////////////////////////////////////
// / END OF Additional Fields GROUP
// ///////////////////////////////////////////////////////////
// ///////////////////////////////
// START OF AddFileResult GROUP //
// ///////////////////////////////
wAddFileResult = new Group(wContentComp, SWT.SHADOW_NONE);
props.setLook(wAddFileResult);
wAddFileResult.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.wAddFileResult.Label"));
FormLayout AddFileResultgroupLayout = new FormLayout();
AddFileResultgroupLayout.marginWidth = 10;
AddFileResultgroupLayout.marginHeight = 10;
wAddFileResult.setLayout(AddFileResultgroupLayout);
wlAddResult = new Label(wAddFileResult, SWT.RIGHT);
wlAddResult.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.AddResult.Label"));
props.setLook(wlAddResult);
fdlAddResult = new FormData();
fdlAddResult.left = new FormAttachment(0, 0);
fdlAddResult.top = new FormAttachment(wAdditionalFields, margin);
fdlAddResult.right = new FormAttachment(middle, -margin);
wlAddResult.setLayoutData(fdlAddResult);
wAddResult = new Button(wAddFileResult, SWT.CHECK);
props.setLook(wAddResult);
wAddResult.setToolTipText(BaseMessages.getString(PKG, "GetXMLDataDialog.AddResult.Tooltip"));
fdAddResult = new FormData();
fdAddResult.left = new FormAttachment(middle, 0);
fdAddResult.top = new FormAttachment(wAdditionalFields, margin);
wAddResult.setLayoutData(fdAddResult);
fdAddFileResult = new FormData();
fdAddFileResult.left = new FormAttachment(0, margin);
fdAddFileResult.top = new FormAttachment(wAdditionalFields, margin);
fdAddFileResult.right = new FormAttachment(100, -margin);
wAddFileResult.setLayoutData(fdAddFileResult);
// ///////////////////////////////////////////////////////////
// / END OF AddFileResult GROUP
// ///////////////////////////////////////////////////////////
fdContentComp = new FormData();
fdContentComp.left = new FormAttachment(0, 0);
fdContentComp.top = new FormAttachment(0, 0);
fdContentComp.right = new FormAttachment(100, 0);
fdContentComp.bottom = new FormAttachment(100, 0);
wContentComp.setLayoutData(fdContentComp);
wContentComp.layout();
wContentTab.setControl(wContentComp);
// ///////////////////////////////////////////////////////////
// / END OF CONTENT TAB
// ///////////////////////////////////////////////////////////
// Fields tab...
//
wFieldsTab = new CTabItem(wTabFolder, SWT.NONE);
wFieldsTab.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.Fields.Tab"));
FormLayout fieldsLayout = new FormLayout();
fieldsLayout.marginWidth = Const.FORM_MARGIN;
fieldsLayout.marginHeight = Const.FORM_MARGIN;
wFieldsComp = new Composite(wTabFolder, SWT.NONE);
wFieldsComp.setLayout(fieldsLayout);
props.setLook(wFieldsComp);
wGet = new Button(wFieldsComp, SWT.PUSH);
wGet.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.GetFields.Button"));
fdGet = new FormData();
fdGet.left = new FormAttachment(50, 0);
fdGet.bottom = new FormAttachment(100, 0);
wGet.setLayoutData(fdGet);
final int FieldsRows = input.getInputFields().length;
ColumnInfo[] colinf = new ColumnInfo[] { new ColumnInfo(BaseMessages.getString(PKG, "GetXMLDataDialog.FieldsTable.Name.Column"), ColumnInfo.COLUMN_TYPE_TEXT, false), new ColumnInfo(BaseMessages.getString(PKG, "GetXMLDataDialog.FieldsTable.XPath.Column"), ColumnInfo.COLUMN_TYPE_TEXT, false), new ColumnInfo(BaseMessages.getString(PKG, "GetXMLDataDialog.FieldsTable.Element.Column"), ColumnInfo.COLUMN_TYPE_CCOMBO, GetXMLDataField.ElementTypeDesc, true), new ColumnInfo(BaseMessages.getString(PKG, "GetXMLDataDialog.FieldsTable.ResultType.Column"), ColumnInfo.COLUMN_TYPE_CCOMBO, GetXMLDataField.ResultTypeDesc, true), new ColumnInfo(BaseMessages.getString(PKG, "GetXMLDataDialog.FieldsTable.Type.Column"), ColumnInfo.COLUMN_TYPE_CCOMBO, ValueMeta.getTypes(), true), new ColumnInfo(BaseMessages.getString(PKG, "GetXMLDataDialog.FieldsTable.Format.Column"), ColumnInfo.COLUMN_TYPE_FORMAT, 4), new ColumnInfo(BaseMessages.getString(PKG, "GetXMLDataDialog.FieldsTable.Length.Column"), ColumnInfo.COLUMN_TYPE_TEXT, false), new ColumnInfo(BaseMessages.getString(PKG, "GetXMLDataDialog.FieldsTable.Precision.Column"), ColumnInfo.COLUMN_TYPE_TEXT, false), new ColumnInfo(BaseMessages.getString(PKG, "GetXMLDataDialog.FieldsTable.Currency.Column"), ColumnInfo.COLUMN_TYPE_TEXT, false), new ColumnInfo(BaseMessages.getString(PKG, "GetXMLDataDialog.FieldsTable.Decimal.Column"), ColumnInfo.COLUMN_TYPE_TEXT, false), new ColumnInfo(BaseMessages.getString(PKG, "GetXMLDataDialog.FieldsTable.Group.Column"), ColumnInfo.COLUMN_TYPE_TEXT, false), new ColumnInfo(BaseMessages.getString(PKG, "GetXMLDataDialog.FieldsTable.TrimType.Column"), ColumnInfo.COLUMN_TYPE_CCOMBO, GetXMLDataField.trimTypeDesc, true), new ColumnInfo(BaseMessages.getString(PKG, "GetXMLDataDialog.FieldsTable.Repeat.Column"), ColumnInfo.COLUMN_TYPE_CCOMBO, new String[] { BaseMessages.getString(PKG, "System.Combo.Yes"), BaseMessages.getString(PKG, "System.Combo.No") }, true) };
colinf[0].setUsingVariables(true);
colinf[0].setToolTip(BaseMessages.getString(PKG, "GetXMLDataDialog.FieldsTable.Name.Column.Tooltip"));
colinf[1].setUsingVariables(true);
colinf[1].setToolTip(BaseMessages.getString(PKG, "GetXMLDataDialog.FieldsTable.XPath.Column.Tooltip"));
wFields = new TableView(transMeta, wFieldsComp, SWT.FULL_SELECTION | SWT.MULTI, colinf, FieldsRows, lsMod, props);
fdFields = new FormData();
fdFields.left = new FormAttachment(0, 0);
fdFields.top = new FormAttachment(0, 0);
fdFields.right = new FormAttachment(100, 0);
fdFields.bottom = new FormAttachment(wGet, -margin);
wFields.setLayoutData(fdFields);
fdFieldsComp = new FormData();
fdFieldsComp.left = new FormAttachment(0, 0);
fdFieldsComp.top = new FormAttachment(0, 0);
fdFieldsComp.right = new FormAttachment(100, 0);
fdFieldsComp.bottom = new FormAttachment(100, 0);
wFieldsComp.setLayoutData(fdFieldsComp);
wFieldsComp.layout();
wFieldsTab.setControl(wFieldsComp);
addAdditionalFieldsTab();
fdTabFolder = new FormData();
fdTabFolder.left = new FormAttachment(0, 0);
fdTabFolder.top = new FormAttachment(wStepname, margin);
fdTabFolder.right = new FormAttachment(100, 0);
fdTabFolder.bottom = new FormAttachment(100, -50);
wTabFolder.setLayoutData(fdTabFolder);
wOK = new Button(shell, SWT.PUSH);
wOK.setText(BaseMessages.getString(PKG, "System.Button.OK"));
wPreview = new Button(shell, SWT.PUSH);
wPreview.setText(BaseMessages.getString(PKG, "GetXMLDataDialog.Button.PreviewRows"));
wCancel = new Button(shell, SWT.PUSH);
wCancel.setText(BaseMessages.getString(PKG, "System.Button.Cancel"));
setButtonPositions(new Button[] { wOK, wPreview, wCancel }, margin, wTabFolder);
// Add listeners
lsOK = new Listener() {
public void handleEvent(Event e) {
ok();
}
};
lsGet = new Listener() {
public void handleEvent(Event e) {
get();
}
};
lsPreview = new Listener() {
public void handleEvent(Event e) {
preview();
}
};
lsCancel = new Listener() {
public void handleEvent(Event e) {
cancel();
}
};
wOK.addListener(SWT.Selection, lsOK);
wGet.addListener(SWT.Selection, lsGet);
wPreview.addListener(SWT.Selection, lsPreview);
wCancel.addListener(SWT.Selection, lsCancel);
lsDef = new SelectionAdapter() {
public void widgetDefaultSelected(SelectionEvent e) {
ok();
}
};
wStepname.addSelectionListener(lsDef);
wLimit.addSelectionListener(lsDef);
wInclRownumField.addSelectionListener(lsDef);
wInclFilenameField.addSelectionListener(lsDef);
// Add the file to the list of files...
SelectionAdapter selA = new SelectionAdapter() {
public void widgetSelected(SelectionEvent arg0) {
wFilenameList.add(new String[] { wFilename.getText(), wFilemask.getText(), wExcludeFilemask.getText(), GetXMLDataMeta.RequiredFilesCode[0], GetXMLDataMeta.RequiredFilesCode[0] });
wFilename.setText("");
wFilemask.setText("");
wExcludeFilemask.setText("");
wFilenameList.removeEmptyRows();
wFilenameList.setRowNums();
wFilenameList.optWidth(true);
}
};
wbaFilename.addSelectionListener(selA);
wFilename.addSelectionListener(selA);
// Delete files from the list of files...
wbdFilename.addSelectionListener(new SelectionAdapter() {
public void widgetSelected(SelectionEvent arg0) {
int[] idx = wFilenameList.getSelectionIndices();
wFilenameList.remove(idx);
wFilenameList.removeEmptyRows();
wFilenameList.setRowNums();
}
});
// Edit the selected file & remove from the list...
wbeFilename.addSelectionListener(new SelectionAdapter() {
public void widgetSelected(SelectionEvent arg0) {
int idx = wFilenameList.getSelectionIndex();
if (idx >= 0) {
String[] string = wFilenameList.getItem(idx);
wFilename.setText(string[0]);
wFilemask.setText(string[1]);
wExcludeFilemask.setText(string[2]);
wFilenameList.remove(idx);
}
wFilenameList.removeEmptyRows();
wFilenameList.setRowNums();
}
});
// Show the files that are selected at this time...
wbShowFiles.addSelectionListener(new SelectionAdapter() {
public void widgetSelected(SelectionEvent e) {
try {
GetXMLDataMeta tfii = new GetXMLDataMeta();
getInfo(tfii);
FileInputList fileInputList = tfii.getFiles(transMeta);
String[] files = fileInputList.getFileStrings();
if (files != null && files.length > 0) {
EnterSelectionDialog esd = new EnterSelectionDialog(shell, files, BaseMessages.getString(PKG, "GetXMLDataDialog.FilesReadSelection.DialogTitle"), BaseMessages.getString(PKG, "GetXMLDataDialog.FilesReadSelection.DialogMessage"));
esd.setViewOnly();
esd.open();
} else {
MessageBox mb = new MessageBox(shell, SWT.OK | SWT.ICON_ERROR);
mb.setMessage(BaseMessages.getString(PKG, "GetXMLDataDialog.NoFileFound.DialogMessage"));
mb.setText(BaseMessages.getString(PKG, "System.Dialog.Error.Title"));
mb.open();
}
} catch (KettleException ex) {
new ErrorDialog(shell, BaseMessages.getString(PKG, "GetXMLDataDialog.ErrorParsingData.DialogTitle"), BaseMessages.getString(PKG, "GetXMLDataDialog.ErrorParsingData.DialogMessage"), ex);
}
}
});
// Enable/disable the right fields to allow a filename to be added to each row...
wInclFilename.addSelectionListener(new SelectionAdapter() {
public void widgetSelected(SelectionEvent e) {
setIncludeFilename();
}
});
// Enable/disable the right fields to allow a row number to be added to each row...
wInclRownum.addSelectionListener(new SelectionAdapter() {
public void widgetSelected(SelectionEvent e) {
setIncludeRownum();
}
});
// Whenever something changes, set the tooltip to the expanded version of the filename:
wFilename.addModifyListener(new ModifyListener() {
public void modifyText(ModifyEvent e) {
wFilename.setToolTipText(wFilename.getText());
}
});
wbbFilename.addSelectionListener(new SelectionAdapterFileDialogTextVar(log, wFilename, transMeta, new SelectionAdapterOptions(SelectionOperation.FILE_OR_FOLDER, new FilterType[] { FilterType.ALL, FilterType.XML }, FilterType.XML)));
// Detect X or ALT-F4 or something that kills this window...
shell.addShellListener(new ShellAdapter() {
public void shellClosed(ShellEvent e) {
cancel();
}
});
wTabFolder.setSelection(0);
// Set the shell size, based upon previous time...
setSize();
getData(input);
ActiveXmlStreamField();
setIncludeFilename();
setIncludeRownum();
input.setChanged(changed);
wFields.optWidth(true);
shell.open();
while (!shell.isDisposed()) {
if (!display.readAndDispatch()) {
display.sleep();
}
}
return stepname;
}
Also used :
Group(org.eclipse.swt.widgets.Group)
KettleException(org.pentaho.di.core.exception.KettleException)
GetXMLDataMeta(org.pentaho.di.trans.steps.getxmldata.GetXMLDataMeta)
CTabFolder(org.eclipse.swt.custom.CTabFolder)
FocusListener(org.eclipse.swt.events.FocusListener)
Listener(org.eclipse.swt.widgets.Listener)
ModifyListener(org.eclipse.swt.events.ModifyListener)
ModifyListener(org.eclipse.swt.events.ModifyListener)
Label(org.eclipse.swt.widgets.Label)
ColumnInfo(org.pentaho.di.ui.core.widget.ColumnInfo)
SelectionAdapterOptions(org.pentaho.di.ui.core.events.dialog.SelectionAdapterOptions)
ShellEvent(org.eclipse.swt.events.ShellEvent)
Cursor(org.eclipse.swt.graphics.Cursor)
CTabItem(org.eclipse.swt.custom.CTabItem)
Shell(org.eclipse.swt.widgets.Shell)
ModifyEvent(org.eclipse.swt.events.ModifyEvent)
Button(org.eclipse.swt.widgets.Button)
SelectionEvent(org.eclipse.swt.events.SelectionEvent)
SelectionAdapterFileDialogTextVar(org.pentaho.di.ui.core.events.dialog.SelectionAdapterFileDialogTextVar)
FormAttachment(org.eclipse.swt.layout.FormAttachment)
FileInputList(org.pentaho.di.core.fileinput.FileInputList)
EnterSelectionDialog(org.pentaho.di.ui.core.dialog.EnterSelectionDialog)
TableView(org.pentaho.di.ui.core.widget.TableView)
FormLayout(org.eclipse.swt.layout.FormLayout)
FormData(org.eclipse.swt.layout.FormData)
ShellAdapter(org.eclipse.swt.events.ShellAdapter)
Composite(org.eclipse.swt.widgets.Composite)
SelectionAdapter(org.eclipse.swt.events.SelectionAdapter)
ErrorDialog(org.pentaho.di.ui.core.dialog.ErrorDialog)
Text(org.eclipse.swt.widgets.Text)
TextVar(org.pentaho.di.ui.core.widget.TextVar)
SelectionAdapterFileDialogTextVar(org.pentaho.di.ui.core.events.dialog.SelectionAdapterFileDialogTextVar)
MessageBox(org.eclipse.swt.widgets.MessageBox)
CCombo(org.eclipse.swt.custom.CCombo)
ModifyEvent(org.eclipse.swt.events.ModifyEvent)
Event(org.eclipse.swt.widgets.Event)
ShellEvent(org.eclipse.swt.events.ShellEvent)
SelectionEvent(org.eclipse.swt.events.SelectionEvent)
FocusListener(org.eclipse.swt.events.FocusListener)
Display(org.eclipse.swt.widgets.Display)
Example 40 with TableView
use of org.pentaho.di.ui.core.widget.TableView in project pentaho-kettle by pentaho.
the class PreviewSelectDialog method open.
public void open() {
Shell parent = getParent();
Display display = parent.getDisplay();
shell = new Shell(parent, SWT.DIALOG_TRIM | SWT.RESIZE | SWT.MAX | SWT.MIN);
props.setLook(shell);
shell.setImage(GUIResource.getInstance().getImageSpoon());
FormLayout formLayout = new FormLayout();
formLayout.marginWidth = Const.FORM_MARGIN;
formLayout.marginHeight = Const.FORM_MARGIN;
shell.setLayout(formLayout);
// Preview
shell.setText(BaseMessages.getString(PKG, "PreviewSelectDialog.Dialog.PreviewSelection.Title"));
// selection
// screen
shell.setImage(GUIResource.getInstance().getImageLogoSmall());
int margin = Const.MARGIN;
wlFields = new Label(shell, SWT.NONE);
// Steps:
wlFields.setText(BaseMessages.getString(PKG, "PreviewSelectDialog.Label.Steps"));
props.setLook(wlFields);
fdlFields = new FormData();
fdlFields.left = new FormAttachment(0, 0);
fdlFields.top = new FormAttachment(0, margin);
wlFields.setLayoutData(fdlFields);
List<StepMeta> usedSteps = transMeta.getUsedSteps();
final int FieldsRows = usedSteps.size();
ColumnInfo[] colinf = { new ColumnInfo(BaseMessages.getString(PKG, "PreviewSelectDialog.Column.Stepname"), ColumnInfo.COLUMN_TYPE_TEXT, false, // Stepname
true), new ColumnInfo(BaseMessages.getString(PKG, "PreviewSelectDialog.Column.PreviewSize"), ColumnInfo.COLUMN_TYPE_TEXT, false, // Preview size
false) };
wFields = new TableView(transMeta, shell, SWT.BORDER | SWT.FULL_SELECTION | SWT.MULTI, colinf, FieldsRows, // read-only
true, null, props);
fdFields = new FormData();
fdFields.left = new FormAttachment(0, 0);
fdFields.top = new FormAttachment(wlFields, margin);
fdFields.right = new FormAttachment(100, 0);
fdFields.bottom = new FormAttachment(100, -50);
wFields.setLayoutData(fdFields);
wPreview = new Button(shell, SWT.PUSH);
wPreview.setText(BaseMessages.getString(PKG, "System.Button.Show"));
wCancel = new Button(shell, SWT.PUSH);
wCancel.setText(BaseMessages.getString(PKG, "System.Button.Close"));
BaseStepDialog.positionBottomButtons(shell, new Button[] { wPreview, wCancel }, margin, null);
// Add listeners
lsCancel = new Listener() {
public void handleEvent(Event e) {
cancel();
}
};
lsPreview = new Listener() {
public void handleEvent(Event e) {
preview();
}
};
wCancel.addListener(SWT.Selection, lsCancel);
wPreview.addListener(SWT.Selection, lsPreview);
// Detect X or ALT-F4 or something that kills this window...
shell.addShellListener(new ShellAdapter() {
public void shellClosed(ShellEvent e) {
cancel();
}
});
BaseStepDialog.setSize(shell);
getData();
shell.open();
while (!shell.isDisposed()) {
if (!display.readAndDispatch()) {
display.sleep();
}
}
}
Also used :
FormLayout(org.eclipse.swt.layout.FormLayout)
FormData(org.eclipse.swt.layout.FormData)
ShellAdapter(org.eclipse.swt.events.ShellAdapter)
Listener(org.eclipse.swt.widgets.Listener)
Label(org.eclipse.swt.widgets.Label)
ColumnInfo(org.pentaho.di.ui.core.widget.ColumnInfo)
ShellEvent(org.eclipse.swt.events.ShellEvent)
StepMeta(org.pentaho.di.trans.step.StepMeta)
Shell(org.eclipse.swt.widgets.Shell)
Button(org.eclipse.swt.widgets.Button)
Event(org.eclipse.swt.widgets.Event)
ShellEvent(org.eclipse.swt.events.ShellEvent)
FormAttachment(org.eclipse.swt.layout.FormAttachment)
Display(org.eclipse.swt.widgets.Display)
TableView(org.pentaho.di.ui.core.widget.TableView)
Aggregations
TableView (org.pentaho.di.ui.core.widget.TableView)229
ColumnInfo (org.pentaho.di.ui.core.widget.ColumnInfo)220
FormAttachment (org.eclipse.swt.layout.FormAttachment)218
FormData (org.eclipse.swt.layout.FormData)218
FormLayout (org.eclipse.swt.layout.FormLayout)200
Label (org.eclipse.swt.widgets.Label)186
Button (org.eclipse.swt.widgets.Button)185
SelectionEvent (org.eclipse.swt.events.SelectionEvent)172
SelectionAdapter (org.eclipse.swt.events.SelectionAdapter)168
Shell (org.eclipse.swt.widgets.Shell)157
ShellEvent (org.eclipse.swt.events.ShellEvent)154
Event (org.eclipse.swt.widgets.Event)153
Listener (org.eclipse.swt.widgets.Listener)152
Text (org.eclipse.swt.widgets.Text)151
Display (org.eclipse.swt.widgets.Display)150
ModifyEvent (org.eclipse.swt.events.ModifyEvent)149
ModifyListener (org.eclipse.swt.events.ModifyListener)149
ShellAdapter (org.eclipse.swt.events.ShellAdapter)149
Composite (org.eclipse.swt.widgets.Composite)105
CTabItem (org.eclipse.swt.custom.CTabItem)100
