Java tutorial
/********************************************************************** ** ** ** This code belongs to the KETTLE project. ** ** ** ** Kettle, from version 2.2 on, is released into the public domain ** ** under the Lesser GNU Public License (LGPL). ** ** ** ** For more details, please read the document LICENSE.txt, included ** ** in this project ** ** ** ** http://www.kettle.be ** ** info@kettle.be ** ** ** **********************************************************************/ /* * Created on 18-mei-2003 * */ package be.ibridge.kettle.trans.step.uniquerows; import org.eclipse.jface.dialogs.MessageDialog; import org.eclipse.jface.dialogs.MessageDialogWithToggle; import org.eclipse.swt.SWT; import org.eclipse.swt.events.ModifyEvent; import org.eclipse.swt.events.ModifyListener; import org.eclipse.swt.events.SelectionAdapter; import org.eclipse.swt.events.SelectionEvent; import org.eclipse.swt.events.ShellAdapter; import org.eclipse.swt.events.ShellEvent; import org.eclipse.swt.layout.FormAttachment; import org.eclipse.swt.layout.FormData; import org.eclipse.swt.layout.FormLayout; import org.eclipse.swt.widgets.Button; import org.eclipse.swt.widgets.Display; import org.eclipse.swt.widgets.Event; import org.eclipse.swt.widgets.Label; import org.eclipse.swt.widgets.Listener; import org.eclipse.swt.widgets.Shell; import org.eclipse.swt.widgets.TableItem; import org.eclipse.swt.widgets.Text; import be.ibridge.kettle.core.ColumnInfo; import be.ibridge.kettle.core.Const; import be.ibridge.kettle.core.Row; import be.ibridge.kettle.core.dialog.ErrorDialog; import be.ibridge.kettle.core.exception.KettleException; import be.ibridge.kettle.core.widget.TableView; import be.ibridge.kettle.trans.TransMeta; import be.ibridge.kettle.trans.step.BaseStepDialog; import be.ibridge.kettle.trans.step.BaseStepMeta; import be.ibridge.kettle.trans.step.StepDialogInterface; public class UniqueRowsDialog extends BaseStepDialog implements StepDialogInterface { public static final String STRING_SORT_WARNING_PARAMETER = "UniqueSortWarning"; //$NON-NLS-1$ private UniqueRowsMeta input; private Label wlCount; private Button wCount; private FormData fdlCount, fdCount; private Label wlCountField; private Text wCountField; private FormData fdlCountField, fdCountField; private Label wlFields; private TableView wFields; private FormData fdlFields, fdFields; public UniqueRowsDialog(Shell parent, Object in, TransMeta transMeta, String sname) { super(parent, (BaseStepMeta) in, transMeta, sname); input = (UniqueRowsMeta) in; } 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, input); ModifyListener 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(Messages.getString("UniqueRowsDialog.Shell.Title")); //$NON-NLS-1$ int middle = props.getMiddlePct(); int margin = Const.MARGIN; // Stepname line wlStepname = new Label(shell, SWT.RIGHT); wlStepname.setText(Messages.getString("UniqueRowsDialog.Stepname.Label")); //$NON-NLS-1$ 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); wlCount = new Label(shell, SWT.RIGHT); wlCount.setText(Messages.getString("UniqueRowsDialog.Count.Label")); //$NON-NLS-1$ props.setLook(wlCount); fdlCount = new FormData(); fdlCount.left = new FormAttachment(0, 0); fdlCount.top = new FormAttachment(wStepname, margin); fdlCount.right = new FormAttachment(middle, -margin); wlCount.setLayoutData(fdlCount); wCount = new Button(shell, SWT.CHECK); props.setLook(wCount); wCount.setToolTipText(Messages.getString("UniqueRowsDialog.Count.ToolTip", Const.CR)); //$NON-NLS-1$ //$NON-NLS-2$ fdCount = new FormData(); fdCount.left = new FormAttachment(middle, 0); fdCount.top = new FormAttachment(wStepname, margin); wCount.setLayoutData(fdCount); wCount.addSelectionListener(new SelectionAdapter() { public void widgetSelected(SelectionEvent e) { input.setChanged(); setFlags(); } }); wlCountField = new Label(shell, SWT.LEFT); wlCountField.setText(Messages.getString("UniqueRowsDialog.CounterField.Label")); //$NON-NLS-1$ props.setLook(wlCountField); fdlCountField = new FormData(); fdlCountField.left = new FormAttachment(wCount, margin); fdlCountField.top = new FormAttachment(wStepname, margin); wlCountField.setLayoutData(fdlCountField); wCountField = new Text(shell, SWT.SINGLE | SWT.LEFT | SWT.BORDER); props.setLook(wCountField); wCountField.addModifyListener(lsMod); fdCountField = new FormData(); fdCountField.left = new FormAttachment(wlCountField, margin); fdCountField.top = new FormAttachment(wStepname, margin); fdCountField.right = new FormAttachment(100, 0); wCountField.setLayoutData(fdCountField); // Some buttons wOK = new Button(shell, SWT.PUSH); wOK.setText(Messages.getString("System.Button.OK")); //$NON-NLS-1$ wGet = new Button(shell, SWT.PUSH); wGet.setText(Messages.getString("UniqueRowsDialog.Get.Button")); //$NON-NLS-1$ wCancel = new Button(shell, SWT.PUSH); wCancel.setText(Messages.getString("System.Button.Cancel")); //$NON-NLS-1$ fdOK = new FormData(); setButtonPositions(new Button[] { wOK, wGet, wCancel }, margin, null); wlFields = new Label(shell, SWT.NONE); wlFields.setText(Messages.getString("UniqueRowsDialog.Fields.Label")); //$NON-NLS-1$ props.setLook(wlFields); fdlFields = new FormData(); fdlFields.left = new FormAttachment(0, 0); fdlFields.top = new FormAttachment(wCountField, margin); wlFields.setLayoutData(fdlFields); final int FieldsRows = input.getCompareFields() == null ? 0 : input.getCompareFields().length; ColumnInfo[] colinf = new ColumnInfo[] { new ColumnInfo(Messages.getString("UniqueRowsDialog.ColumnInfo.Fieldname"), //$NON-NLS-1$ ColumnInfo.COLUMN_TYPE_TEXT, false), new ColumnInfo(Messages.getString("UniqueRowsDialog.ColumnInfo.IgnoreCase"), //$NON-NLS-1$ ColumnInfo.COLUMN_TYPE_CCOMBO, new String[] { "Y", "N" }, true) //$NON-NLS-1$ //$NON-NLS-2$ }; wFields = new TableView(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(wOK, -2 * margin); wFields.setLayoutData(fdFields); // Add listeners lsCancel = new Listener() { public void handleEvent(Event e) { cancel(); } }; lsGet = new Listener() { public void handleEvent(Event e) { get(); } }; lsOK = new Listener() { public void handleEvent(Event e) { ok(); } }; wCancel.addListener(SWT.Selection, lsCancel); wGet.addListener(SWT.Selection, lsGet); wOK.addListener(SWT.Selection, lsOK); lsDef = new SelectionAdapter() { public void widgetDefaultSelected(SelectionEvent e) { ok(); } }; wStepname.addSelectionListener(lsDef); wCountField.addSelectionListener(lsDef); // Detect X or ALT-F4 or something that kills this window... shell.addShellListener(new ShellAdapter() { public void shellClosed(ShellEvent e) { cancel(); } }); // Set the shell size, based upon previous time... setSize(); getData(); input.setChanged(changed); shell.open(); while (!shell.isDisposed()) { if (!display.readAndDispatch()) display.sleep(); } return stepname; } public void setFlags() { wlCountField.setEnabled(wCount.getSelection()); wCountField.setEnabled(wCount.getSelection()); } /** * Copy information from the meta-data input to the dialog fields. */ public void getData() { wCount.setSelection(input.isCountRows()); if (input.getCountField() != null) wCountField.setText(input.getCountField()); setFlags(); for (int i = 0; i < input.getCompareFields().length; i++) { TableItem item = wFields.table.getItem(i); if (input.getCompareFields()[i] != null) item.setText(1, input.getCompareFields()[i]); item.setText(2, input.getCaseInsensitive()[i] ? "Y" : "N"); //$NON-NLS-1$ //$NON-NLS-2$ } wFields.setRowNums(); wFields.optWidth(true); wStepname.selectAll(); } private void cancel() { stepname = null; input.setChanged(changed); dispose(); } private void ok() { int nrfields = wFields.nrNonEmpty(); input.allocate(nrfields); for (int i = 0; i < nrfields; i++) { TableItem item = wFields.getNonEmpty(i); input.getCompareFields()[i] = item.getText(1); input.getCaseInsensitive()[i] = "Y".equalsIgnoreCase(item.getText(2)); //$NON-NLS-1$ } input.setCountField(wCountField.getText()); input.setCountRows(wCount.getSelection()); stepname = wStepname.getText(); // return value if ("Y".equalsIgnoreCase(props.getCustomParameter(STRING_SORT_WARNING_PARAMETER, "Y"))) //$NON-NLS-1$ //$NON-NLS-2$ { MessageDialogWithToggle md = new MessageDialogWithToggle(shell, Messages.getString("UniqueRowsDialog.InputNeedSort.DialogTitle"), //$NON-NLS-1$ null, Messages.getString("UniqueRowsDialog.InputNeedSort.DialogMessage", Const.CR) + Const.CR, //$NON-NLS-1$ //$NON-NLS-2$ MessageDialog.WARNING, new String[] { Messages.getString("UniqueRowsDialog.InputNeedSort.Option1") }, //$NON-NLS-1$ 0, Messages.getString("UniqueRowsDialog.InputNeedSort.Option2"), //$NON-NLS-1$ "N".equalsIgnoreCase(props.getCustomParameter(STRING_SORT_WARNING_PARAMETER, "Y")) //$NON-NLS-1$ //$NON-NLS-2$ ); md.open(); props.setCustomParameter(STRING_SORT_WARNING_PARAMETER, md.getToggleState() ? "N" : "Y"); //$NON-NLS-1$ //$NON-NLS-2$ props.saveProps(); } dispose(); } private void get() { try { Row r = transMeta.getPrevStepFields(stepname); if (r != null) { BaseStepDialog.getFieldsFromPrevious(r, wFields, 1, new int[] { 1 }, new int[] {}, -1, -1, null); } } catch (KettleException ke) { new ErrorDialog(shell, Messages.getString("UniqueRowsDialog.FailedToGetFields.DialogTitle"), //$NON-NLS-1$ Messages.getString("UniqueRowsDialog.FailedToGetFields.DialogMessage"), ke); //$NON-NLS-1$ } } }