private void ok() {
if (Const.isEmpty(wStepname.getText())) return;
input.setDatabase(transMeta.findDatabase(wConnection.getText()));
input.setSchemaname(wSchemaname.getText());
input.setTablename(wTablenameText.getText());
input.setTablenameInField(wTablenameInField.getSelection());
input.setDynamicTablenameField(wTableName.getText());
input.setDynamicColumnnameField(wColumnName.getText());
input.setResultFieldName(wResult.getText());
stepname = wStepname.getText(); // return value
if (input.getDatabase() == null) {
MessageBox mb = new MessageBox(shell, SWT.OK | SWT.ICON_ERROR);
mb.setMessage(
BaseMessages.getString(
PKG, "ColumnExistsDialog.InvalidConnection.DialogMessage")); // $NON-NLS-1$
mb.setText(
BaseMessages.getString(
PKG, "ColumnExistsDialog.InvalidConnection.DialogTitle")); // $NON-NLS-1$
mb.open();
}
dispose();
}
/** Copy information from the meta-data input to the dialog fields. */
public void getData() {
if (log.isDebug())
logDebug(BaseMessages.getString(PKG, "ColumnExistsDialog.Log.GettingKeyInfo")); // $NON-NLS-1$
if (input.getDatabase() != null) wConnection.setText(input.getDatabase().getName());
else if (transMeta.nrDatabases() == 1) {
wConnection.setText(transMeta.getDatabase(0).getName());
}
if (input.getSchemaname() != null) wSchemaname.setText(input.getSchemaname());
if (input.getTablename() != null) wTablenameText.setText(input.getTablename());
wTablenameInField.setSelection(input.isTablenameInField());
if (input.getDynamicTablenameField() != null)
wTableName.setText(input.getDynamicTablenameField());
if (input.getDynamicColumnnameField() != null)
wColumnName.setText(input.getDynamicColumnnameField());
if (input.getResultFieldName() != null) wResult.setText(input.getResultFieldName());
wStepname.selectAll();
}
private void cancel() {
stepname = null;
input.setChanged(changed);
dispose();
}
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();
}
};
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, "ColumnExistsDialog.Shell.Title")); // $NON-NLS-1$
int middle = props.getMiddlePct();
int margin = Const.MARGIN;
// Stepname line
wlStepname = new Label(shell, SWT.RIGHT);
wlStepname.setText(
BaseMessages.getString(PKG, "ColumnExistsDialog.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);
// Connection line
wConnection = addConnectionLine(shell, wStepname, middle, margin);
if (input.getDatabase() == null && transMeta.nrDatabases() == 1) wConnection.select(0);
wConnection.addModifyListener(lsMod);
// Schema name line
wlSchemaname = new Label(shell, SWT.RIGHT);
wlSchemaname.setText(BaseMessages.getString(PKG, "ColumnExistsDialog.Schemaname.Label"));
props.setLook(wlSchemaname);
fdlSchemaname = new FormData();
fdlSchemaname.left = new FormAttachment(0, 0);
fdlSchemaname.right = new FormAttachment(middle, -margin);
fdlSchemaname.top = new FormAttachment(wConnection, margin * 2);
wlSchemaname.setLayoutData(fdlSchemaname);
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);
wbSchema.addSelectionListener(
new SelectionAdapter() {
public void widgetSelected(SelectionEvent e) {
getSchemaNames();
}
});
wSchemaname = new TextVar(transMeta, shell, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
props.setLook(wSchemaname);
wSchemaname.setToolTipText(
BaseMessages.getString(PKG, "ColumnExistsDialog.Schemaname.Tooltip"));
wSchemaname.addModifyListener(lsMod);
fdSchemaname = new FormData();
fdSchemaname.left = new FormAttachment(middle, 0);
fdSchemaname.top = new FormAttachment(wConnection, margin * 2);
fdSchemaname.right = new FormAttachment(wbSchema, -margin);
wSchemaname.setLayoutData(fdSchemaname);
// TablenameText fieldname ...
wlTablenameText = new Label(shell, SWT.RIGHT);
wlTablenameText.setText(
BaseMessages.getString(PKG, "ColumnExistsDialog.TablenameTextField.Label")); // $NON-NLS-1$
props.setLook(wlTablenameText);
fdlTablenameText = new FormData();
fdlTablenameText.left = new FormAttachment(0, 0);
fdlTablenameText.right = new FormAttachment(middle, -margin);
fdlTablenameText.top = new FormAttachment(wbSchema, margin);
wlTablenameText.setLayoutData(fdlTablenameText);
wbTable = new Button(shell, SWT.PUSH | SWT.CENTER);
props.setLook(wbTable);
wbTable.setText(BaseMessages.getString(PKG, "System.Button.Browse"));
FormData fdbTable = new FormData();
fdbTable.right = new FormAttachment(100, 0);
fdbTable.top = new FormAttachment(wbSchema, margin);
wbTable.setLayoutData(fdbTable);
wbTable.addSelectionListener(
new SelectionAdapter() {
public void widgetSelected(SelectionEvent e) {
getTableName();
}
});
wTablenameText = new TextVar(transMeta, shell, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
wTablenameText.setToolTipText(
BaseMessages.getString(PKG, "ColumnExistsDialog.TablenameTextField.Tooltip"));
props.setLook(wTablenameText);
wTablenameText.addModifyListener(lsMod);
fdTablenameText = new FormData();
fdTablenameText.left = new FormAttachment(middle, 0);
fdTablenameText.top = new FormAttachment(wbSchema, margin);
fdTablenameText.right = new FormAttachment(wbTable, -margin);
wTablenameText.setLayoutData(fdTablenameText);
// Is tablename is field?
wlTablenameInField = new Label(shell, SWT.RIGHT);
wlTablenameInField.setText(
BaseMessages.getString(PKG, "ColumnExistsDialog.TablenameInfield.Label"));
props.setLook(wlTablenameInField);
fdlTablenameInField = new FormData();
fdlTablenameInField.left = new FormAttachment(0, 0);
fdlTablenameInField.top = new FormAttachment(wTablenameText, margin);
fdlTablenameInField.right = new FormAttachment(middle, -margin);
wlTablenameInField.setLayoutData(fdlTablenameInField);
wTablenameInField = new Button(shell, SWT.CHECK);
wTablenameInField.setToolTipText(
BaseMessages.getString(PKG, "ColumnExistsDialog.TablenameInfield.Tooltip"));
props.setLook(wTablenameInField);
fdTablenameInField = new FormData();
fdTablenameInField.left = new FormAttachment(middle, 0);
fdTablenameInField.top = new FormAttachment(wTablenameText, margin);
fdTablenameInField.right = new FormAttachment(100, 0);
wTablenameInField.setLayoutData(fdTablenameInField);
SelectionAdapter lsSelR =
new SelectionAdapter() {
public void widgetSelected(SelectionEvent arg0) {
input.setChanged();
activeTablenameInField();
}
};
wTablenameInField.addSelectionListener(lsSelR);
// Dynamic tablename
wlTableName = new Label(shell, SWT.RIGHT);
wlTableName.setText(
BaseMessages.getString(PKG, "ColumnExistsDialog.TableName.Label")); // $NON-NLS-1$
props.setLook(wlTableName);
fdlTableName = new FormData();
fdlTableName.left = new FormAttachment(0, 0);
fdlTableName.right = new FormAttachment(middle, -margin);
fdlTableName.top = new FormAttachment(wTablenameInField, margin * 2);
wlTableName.setLayoutData(fdlTableName);
wTableName = new CCombo(shell, SWT.BORDER | SWT.READ_ONLY);
props.setLook(wTableName);
wTableName.addModifyListener(lsMod);
fdTableName = new FormData();
fdTableName.left = new FormAttachment(middle, 0);
fdTableName.top = new FormAttachment(wTablenameInField, margin * 2);
fdTableName.right = new FormAttachment(100, -margin);
wTableName.setLayoutData(fdTableName);
wTableName.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);
get();
shell.setCursor(null);
busy.dispose();
}
});
// Dynamic column name field
wlColumnName = new Label(shell, SWT.RIGHT);
wlColumnName.setText(
BaseMessages.getString(PKG, "ColumnExistsDialog.ColumnName.Label")); // $NON-NLS-1$
props.setLook(wlColumnName);
fdlColumnName = new FormData();
fdlColumnName.left = new FormAttachment(0, 0);
fdlColumnName.right = new FormAttachment(middle, -margin);
fdlColumnName.top = new FormAttachment(wTableName, margin);
wlColumnName.setLayoutData(fdlColumnName);
wColumnName = new CCombo(shell, SWT.BORDER | SWT.READ_ONLY);
props.setLook(wColumnName);
wColumnName.addModifyListener(lsMod);
fdColumnName = new FormData();
fdColumnName.left = new FormAttachment(middle, 0);
fdColumnName.top = new FormAttachment(wTableName, margin);
fdColumnName.right = new FormAttachment(100, -margin);
wColumnName.setLayoutData(fdColumnName);
wColumnName.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);
get();
shell.setCursor(null);
busy.dispose();
}
});
// Result fieldname ...
wlResult = new Label(shell, SWT.RIGHT);
wlResult.setText(
BaseMessages.getString(PKG, "ColumnExistsDialog.ResultField.Label")); // $NON-NLS-1$
props.setLook(wlResult);
fdlResult = new FormData();
fdlResult.left = new FormAttachment(0, 0);
fdlResult.right = new FormAttachment(middle, -margin);
fdlResult.top = new FormAttachment(wColumnName, margin * 2);
wlResult.setLayoutData(fdlResult);
wResult = new Text(shell, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
wResult.setToolTipText(BaseMessages.getString(PKG, "ColumnExistsDialog.ResultField.Tooltip"));
props.setLook(wResult);
wResult.addModifyListener(lsMod);
fdResult = new FormData();
fdResult.left = new FormAttachment(middle, 0);
fdResult.top = new FormAttachment(wColumnName, margin * 2);
fdResult.right = new FormAttachment(100, 0);
wResult.setLayoutData(fdResult);
// THE BUTTONS
wOK = new Button(shell, SWT.PUSH);
wOK.setText(BaseMessages.getString(PKG, "System.Button.OK")); // $NON-NLS-1$
wCancel = new Button(shell, SWT.PUSH);
wCancel.setText(BaseMessages.getString(PKG, "System.Button.Cancel")); // $NON-NLS-1$
setButtonPositions(new Button[] {wOK, wCancel}, margin, wResult);
// Add listeners
lsOK =
new Listener() {
public void handleEvent(Event e) {
ok();
}
};
lsCancel =
new Listener() {
public void handleEvent(Event e) {
cancel();
}
};
wOK.addListener(SWT.Selection, lsOK);
wCancel.addListener(SWT.Selection, lsCancel);
lsDef =
new SelectionAdapter() {
public void widgetDefaultSelected(SelectionEvent e) {
ok();
}
};
wStepname.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();
activeTablenameInField();
input.setChanged(changed);
shell.open();
while (!shell.isDisposed()) {
if (!display.readAndDispatch()) display.sleep();
}
return stepname;
}
