// Preview the data
private void preview() {
GetTableNamesMeta oneMeta = new GetTableNamesMeta();
getInfo(oneMeta);
if (oneMeta.getDatabase() == null) {
MessageBox mb = new MessageBox(shell, SWT.OK | SWT.ICON_ERROR);
mb.setMessage(
BaseMessages.getString(PKG, "GetTableNamesDialog.InvalidConnection.DialogMessage"));
mb.setText(BaseMessages.getString(PKG, "GetTableNamesDialog.InvalidConnection.DialogTitle"));
mb.open();
return;
}
if (!checkUserInput(oneMeta)) return;
TransMeta previewMeta =
TransPreviewFactory.generatePreviewTransformation(transMeta, oneMeta, wStepname.getText());
EnterNumberDialog numberDialog =
new EnterNumberDialog(
shell,
props.getDefaultPreviewSize(),
BaseMessages.getString(PKG, "GetTableNamesDialog.PreviewSize.DialogTitle"),
BaseMessages.getString(PKG, "GetTableNamesDialog.PreviewSize.DialogMessage"));
int previewSize = numberDialog.open();
if (previewSize > 0) {
TransPreviewProgressDialog progressDialog =
new TransPreviewProgressDialog(
shell, previewMeta, new String[] {wStepname.getText()}, new int[] {previewSize});
progressDialog.open();
if (!progressDialog.isCancelled()) {
Trans trans = progressDialog.getTrans();
String loggingText = progressDialog.getLoggingText();
if (trans.getResult() != null && trans.getResult().getNrErrors() > 0) {
EnterTextDialog etd =
new EnterTextDialog(
shell,
BaseMessages.getString(PKG, "System.Dialog.Error.Title"),
BaseMessages.getString(PKG, "GetTableNamesDialog.ErrorInPreview.DialogMessage"),
loggingText,
true);
etd.setReadOnly();
etd.open();
}
PreviewRowsDialog prd =
new PreviewRowsDialog(
shell,
transMeta,
SWT.NONE,
wStepname.getText(),
progressDialog.getPreviewRowsMeta(wStepname.getText()),
progressDialog.getPreviewRows(wStepname.getText()),
loggingText);
prd.open();
}
}
}
private void ok() {
if (Const.isEmpty(wStepname.getText())) return;
stepname = wStepname.getText(); // return value
getInfo(input);
if (input.getDatabase() == null) {
MessageBox mb = new MessageBox(shell, SWT.OK | SWT.ICON_ERROR);
mb.setMessage(
BaseMessages.getString(PKG, "GetTableNamesDialog.InvalidConnection.DialogMessage"));
mb.setText(BaseMessages.getString(PKG, "GetTableNamesDialog.InvalidConnection.DialogTitle"));
mb.open();
return;
}
dispose();
}
private boolean checkUserInput(GetTableNamesMeta meta) {
if (Utils.isEmpty(meta.getTablenameFieldName())) {
MessageBox mb = new MessageBox(shell, SWT.OK | SWT.ICON_ERROR);
mb.setMessage(
BaseMessages.getString(
PKG, "GetTableNamesDialog.Error.TablenameFieldNameMissingMessage"));
mb.setText(
BaseMessages.getString(PKG, "GetTableNamesDialog.Error.TablenameFieldNameMissingTitle"));
mb.open();
return false;
}
return true;
}
private void getInfo(GetTableNamesMeta info) {
info.setDatabase(transMeta.findDatabase(wConnection.getText()));
info.setSchemaName(wschemaname.getText());
info.setTablenameFieldName(wTablenameField.getText());
info.setSQLCreationFieldName(wSQLCreationField.getText());
info.setObjectTypeFieldName(wObjectTypeField.getText());
info.setIsSystemObjectFieldName(wisSystemObjectField.getText());
info.setIncludeCatalog(wincludeCatalog.getSelection());
info.setIncludeSchema(wincludeSchema.getSelection());
info.setIncludeTable(wincludeTable.getSelection());
info.setIncludeView(wincludeView.getSelection());
info.setIncludeProcedure(wincludeProcedure.getSelection());
info.setIncludeSynonym(wincludeSynonym.getSelection());
info.setAddSchemaInOut(waddSchemaInOutput.getSelection());
info.setDynamicSchema(wdynamicSchema.getSelection());
info.setSchemaFieldName(wSchemaField.getText());
}
private void cancel() {
stepname = null;
input.setChanged(changed);
dispose();
}
/** Copy information from the meta-data input to the dialog fields. */
public void getData() {
if (isDebug()) {
logDebug(toString(), BaseMessages.getString(PKG, "GetTableNamesDialog.Log.GettingKeyInfo"));
}
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.getTablenameFieldName() != null) {
wTablenameField.setText(input.getTablenameFieldName());
}
if (input.getObjectTypeFieldName() != null) {
wObjectTypeField.setText(input.getObjectTypeFieldName());
}
if (input.isSystemObjectFieldName() != null) {
wisSystemObjectField.setText(input.isSystemObjectFieldName());
}
if (input.getSQLCreationFieldName() != null) {
wSQLCreationField.setText(input.getSQLCreationFieldName());
}
wincludeCatalog.setSelection(input.isIncludeCatalog());
wincludeSchema.setSelection(input.isIncludeSchema());
wincludeTable.setSelection(input.isIncludeTable());
wincludeView.setSelection(input.isIncludeView());
wincludeProcedure.setSelection(input.isIncludeProcedure());
wincludeSynonym.setSelection(input.isIncludeSynonym());
waddSchemaInOutput.setSelection(input.isAddSchemaInOut());
wdynamicSchema.setSelection(input.isDynamicSchema());
if (input.getSchemaFieldName() != null) {
wSchemaField.setText(input.getSchemaFieldName());
}
wStepname.selectAll();
wStepname.setFocus();
}
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, "GetTableNamesDialog.Shell.Title"));
int middle = props.getMiddlePct();
int margin = Const.MARGIN;
// Stepname line
wlStepname = new Label(shell, SWT.RIGHT);
wlStepname.setText(BaseMessages.getString(PKG, "GetTableNamesDialog.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.getDatabase() == null && transMeta.nrDatabases() == 1) {
wConnection.select(0);
}
wConnection.addModifyListener(lsMod);
// schemaname fieldname ...
wlschemaname = new Label(shell, SWT.RIGHT);
wlschemaname.setText(BaseMessages.getString(PKG, "GetTableNamesDialog.schemanameName.Label"));
props.setLook(wlschemaname);
fdlschemaname = new FormData();
fdlschemaname.left = new FormAttachment(0, 0);
fdlschemaname.right = new FormAttachment(middle, -margin);
fdlschemaname.top = new FormAttachment(wConnection, 2 * margin);
wlschemaname.setLayoutData(fdlschemaname);
wschemaname = new TextVar(transMeta, shell, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
wschemaname.setToolTipText(
BaseMessages.getString(PKG, "GetTableNamesDialog.schemanameName.Tooltip"));
props.setLook(wschemaname);
fdschemaname = new FormData();
fdschemaname.left = new FormAttachment(middle, 0);
fdschemaname.top = new FormAttachment(wConnection, 2 * margin);
fdschemaname.right = new FormAttachment(100, 0);
wschemaname.setLayoutData(fdschemaname);
ModifyListener lsModSchema =
new ModifyListener() {
public void modifyText(ModifyEvent e) {
input.setChanged();
refreshIncludeCatalog();
}
};
wschemaname.addModifyListener(lsModSchema);
// Is schema name defined in a Field
wldynamicSchema = new Label(shell, SWT.RIGHT);
wldynamicSchema.setText(
BaseMessages.getString(PKG, "GetTableNamesDialog.wldynamicSchema.Label"));
props.setLook(wldynamicSchema);
fdldynamicSchema = new FormData();
fdldynamicSchema.left = new FormAttachment(0, -margin);
fdldynamicSchema.top = new FormAttachment(wschemaname, margin);
fdldynamicSchema.right = new FormAttachment(middle, -margin);
wldynamicSchema.setLayoutData(fdldynamicSchema);
wdynamicSchema = new Button(shell, SWT.CHECK);
props.setLook(wdynamicSchema);
wdynamicSchema.setToolTipText(
BaseMessages.getString(PKG, "GetTableNamesDialog.wdynamicSchema.Tooltip"));
fddynamicSchema = new FormData();
fddynamicSchema.left = new FormAttachment(middle, 0);
fddynamicSchema.top = new FormAttachment(wschemaname, margin);
wdynamicSchema.setLayoutData(fddynamicSchema);
SelectionAdapter lsxmlstream =
new SelectionAdapter() {
public void widgetSelected(SelectionEvent arg0) {
ActivedynamicSchema();
input.setChanged();
}
};
wdynamicSchema.addSelectionListener(lsxmlstream);
// If schema string defined in a Field
wlSchemaField = new Label(shell, SWT.RIGHT);
wlSchemaField.setText(BaseMessages.getString(PKG, "GetTableNamesDialog.wlSchemaField.Label"));
props.setLook(wlSchemaField);
fdlSchemaField = new FormData();
fdlSchemaField.left = new FormAttachment(0, -margin);
fdlSchemaField.top = new FormAttachment(wdynamicSchema, margin);
fdlSchemaField.right = new FormAttachment(middle, -margin);
wlSchemaField.setLayoutData(fdlSchemaField);
wSchemaField = new CCombo(shell, SWT.BORDER | SWT.READ_ONLY);
wSchemaField.setEditable(true);
props.setLook(wSchemaField);
wSchemaField.addModifyListener(lsMod);
fdSchemaField = new FormData();
fdSchemaField.left = new FormAttachment(middle, 0);
fdSchemaField.top = new FormAttachment(wdynamicSchema, margin);
fdSchemaField.right = new FormAttachment(100, -margin);
wSchemaField.setLayoutData(fdSchemaField);
wSchemaField.addFocusListener(
new FocusListener() {
public void focusLost(org.eclipse.swt.events.FocusEvent e) {}
public void focusGained(org.eclipse.swt.events.FocusEvent e) {
setSchemaField();
shell.setCursor(null);
}
});
// ///////////////////////////////
// START OF SETTINGS GROUP //
// ///////////////////////////////
wSettings = new Group(shell, SWT.SHADOW_NONE);
props.setLook(wSettings);
wSettings.setText(BaseMessages.getString(PKG, "GetTableNamesDialog.wSettings.Label"));
FormLayout SettingsgroupLayout = new FormLayout();
SettingsgroupLayout.marginWidth = 10;
SettingsgroupLayout.marginHeight = 10;
wSettings.setLayout(SettingsgroupLayout);
// Include Catalogs
wlincludeCatalog = new Label(wSettings, SWT.RIGHT);
wlincludeCatalog.setText(
BaseMessages.getString(PKG, "GetCatalogNamesDialog.includeCatalog.Label"));
props.setLook(wlincludeCatalog);
fdlincludeCatalog = new FormData();
fdlincludeCatalog.left = new FormAttachment(0, -margin);
fdlincludeCatalog.top = new FormAttachment(wSchemaField, margin);
fdlincludeCatalog.right = new FormAttachment(middle, -2 * margin);
wlincludeCatalog.setLayoutData(fdlincludeCatalog);
wincludeCatalog = new Button(wSettings, SWT.CHECK);
props.setLook(wincludeCatalog);
wincludeCatalog.setToolTipText(
BaseMessages.getString(PKG, "GetCatalogNamesDialog.includeCatalog.Tooltip"));
fdincludeCatalog = new FormData();
fdincludeCatalog.left = new FormAttachment(middle, -margin);
fdincludeCatalog.top = new FormAttachment(wSchemaField, margin);
wincludeCatalog.setLayoutData(fdincludeCatalog);
SelectionAdapter lincludeCatalog =
new SelectionAdapter() {
public void widgetSelected(SelectionEvent arg0) {
input.setChanged();
}
};
wincludeCatalog.addSelectionListener(lincludeCatalog);
// Include Schemas
wlincludeSchema = new Label(wSettings, SWT.RIGHT);
wlincludeSchema.setText(
BaseMessages.getString(PKG, "GetSchemaNamesDialog.includeSchema.Label"));
props.setLook(wlincludeSchema);
fdlincludeSchema = new FormData();
fdlincludeSchema.left = new FormAttachment(0, -margin);
fdlincludeSchema.top = new FormAttachment(wincludeCatalog, margin);
fdlincludeSchema.right = new FormAttachment(middle, -2 * margin);
wlincludeSchema.setLayoutData(fdlincludeSchema);
wincludeSchema = new Button(wSettings, SWT.CHECK);
props.setLook(wincludeSchema);
wincludeSchema.setToolTipText(
BaseMessages.getString(PKG, "GetSchemaNamesDialog.includeSchema.Tooltip"));
fdincludeSchema = new FormData();
fdincludeSchema.left = new FormAttachment(middle, -margin);
fdincludeSchema.top = new FormAttachment(wincludeCatalog, margin);
wincludeSchema.setLayoutData(fdincludeSchema);
SelectionAdapter lincludeSchema =
new SelectionAdapter() {
public void widgetSelected(SelectionEvent arg0) {
input.setChanged();
}
};
wincludeSchema.addSelectionListener(lincludeSchema);
// Include tables
wlincludeTable = new Label(wSettings, SWT.RIGHT);
wlincludeTable.setText(BaseMessages.getString(PKG, "GetTableNamesDialog.includeTable.Label"));
props.setLook(wlincludeTable);
fdlincludeTable = new FormData();
fdlincludeTable.left = new FormAttachment(0, -margin);
fdlincludeTable.top = new FormAttachment(wincludeSchema, margin);
fdlincludeTable.right = new FormAttachment(middle, -2 * margin);
wlincludeTable.setLayoutData(fdlincludeTable);
wincludeTable = new Button(wSettings, SWT.CHECK);
props.setLook(wincludeTable);
wincludeTable.setToolTipText(
BaseMessages.getString(PKG, "GetTableNamesDialog.includeTable.Tooltip"));
fdincludeTable = new FormData();
fdincludeTable.left = new FormAttachment(middle, -margin);
fdincludeTable.top = new FormAttachment(wincludeSchema, margin);
wincludeTable.setLayoutData(fdincludeTable);
SelectionAdapter lincludeTable =
new SelectionAdapter() {
public void widgetSelected(SelectionEvent arg0) {
input.setChanged();
}
};
wincludeTable.addSelectionListener(lincludeTable);
// Include views
wlincludeView = new Label(wSettings, SWT.RIGHT);
wlincludeView.setText(BaseMessages.getString(PKG, "GetTableNamesDialog.includeView.Label"));
props.setLook(wlincludeView);
fdlincludeView = new FormData();
fdlincludeView.left = new FormAttachment(0, -margin);
fdlincludeView.top = new FormAttachment(wincludeTable, margin);
fdlincludeView.right = new FormAttachment(middle, -2 * margin);
wlincludeView.setLayoutData(fdlincludeView);
wincludeView = new Button(wSettings, SWT.CHECK);
props.setLook(wincludeView);
wincludeView.setToolTipText(
BaseMessages.getString(PKG, "GetTableNamesDialog.includeView.Tooltip"));
fdincludeView = new FormData();
fdincludeView.left = new FormAttachment(middle, -margin);
fdincludeView.top = new FormAttachment(wincludeTable, margin);
wincludeView.setLayoutData(fdincludeView);
SelectionAdapter lincludeView =
new SelectionAdapter() {
public void widgetSelected(SelectionEvent arg0) {
input.setChanged();
}
};
wincludeView.addSelectionListener(lincludeView);
// Include procedures
wlincludeProcedure = new Label(wSettings, SWT.RIGHT);
wlincludeProcedure.setText(
BaseMessages.getString(PKG, "GetTableNamesDialog.includeProcedure.Label"));
props.setLook(wlincludeProcedure);
fdlincludeProcedure = new FormData();
fdlincludeProcedure.left = new FormAttachment(0, -margin);
fdlincludeProcedure.top = new FormAttachment(wincludeView, margin);
fdlincludeProcedure.right = new FormAttachment(middle, -2 * margin);
wlincludeProcedure.setLayoutData(fdlincludeProcedure);
wincludeProcedure = new Button(wSettings, SWT.CHECK);
props.setLook(wincludeProcedure);
wincludeProcedure.setToolTipText(
BaseMessages.getString(PKG, "GetTableNamesDialog.includeProcedure.Tooltip"));
fdincludeProcedure = new FormData();
fdincludeProcedure.left = new FormAttachment(middle, -margin);
fdincludeProcedure.top = new FormAttachment(wincludeView, margin);
wincludeProcedure.setLayoutData(fdincludeProcedure);
SelectionAdapter lincludeProcedure =
new SelectionAdapter() {
public void widgetSelected(SelectionEvent arg0) {
input.setChanged();
}
};
wincludeProcedure.addSelectionListener(lincludeProcedure);
// Include Synonyms
wlincludeSynonym = new Label(wSettings, SWT.RIGHT);
wlincludeSynonym.setText(
BaseMessages.getString(PKG, "GetTableNamesDialog.includeSynonym.Label"));
props.setLook(wlincludeSynonym);
fdlincludeSynonym = new FormData();
fdlincludeSynonym.left = new FormAttachment(0, -margin);
fdlincludeSynonym.top = new FormAttachment(wincludeProcedure, margin);
fdlincludeSynonym.right = new FormAttachment(middle, -2 * margin);
wlincludeSynonym.setLayoutData(fdlincludeSynonym);
wincludeSynonym = new Button(wSettings, SWT.CHECK);
props.setLook(wincludeSynonym);
wincludeSynonym.setToolTipText(
BaseMessages.getString(PKG, "GetTableNamesDialog.includeSynonym.Tooltip"));
fdincludeSynonym = new FormData();
fdincludeSynonym.left = new FormAttachment(middle, -margin);
fdincludeSynonym.top = new FormAttachment(wincludeProcedure, margin);
wincludeSynonym.setLayoutData(fdincludeSynonym);
SelectionAdapter lincludeSynonym =
new SelectionAdapter() {
public void widgetSelected(SelectionEvent arg0) {
input.setChanged();
}
};
wincludeSynonym.addSelectionListener(lincludeSynonym);
// Add schema in output
wladdSchemaInOutput = new Label(wSettings, SWT.RIGHT);
wladdSchemaInOutput.setText(
BaseMessages.getString(PKG, "GetTableNamesDialog.addSchemaInOutput.Label"));
props.setLook(wladdSchemaInOutput);
fdladdSchemaInOutput = new FormData();
fdladdSchemaInOutput.left = new FormAttachment(0, -margin);
fdladdSchemaInOutput.top = new FormAttachment(wincludeSynonym, 2 * margin);
fdladdSchemaInOutput.right = new FormAttachment(middle, -2 * margin);
wladdSchemaInOutput.setLayoutData(fdladdSchemaInOutput);
waddSchemaInOutput = new Button(wSettings, SWT.CHECK);
props.setLook(waddSchemaInOutput);
waddSchemaInOutput.setToolTipText(
BaseMessages.getString(PKG, "GetTableNamesDialog.addSchemaInOutput.Tooltip"));
fdaddSchemaInOutput = new FormData();
fdaddSchemaInOutput.left = new FormAttachment(middle, -margin);
fdaddSchemaInOutput.top = new FormAttachment(wincludeSynonym, 2 * margin);
waddSchemaInOutput.setLayoutData(fdaddSchemaInOutput);
SelectionAdapter laddSchemaInOutput =
new SelectionAdapter() {
public void widgetSelected(SelectionEvent arg0) {
input.setChanged();
}
};
waddSchemaInOutput.addSelectionListener(laddSchemaInOutput);
FormData fdSettings = new FormData();
fdSettings.left = new FormAttachment(0, margin);
fdSettings.top = new FormAttachment(wSchemaField, 2 * margin);
fdSettings.right = new FormAttachment(100, -margin);
wSettings.setLayoutData(fdSettings);
// ///////////////////////////////////////////////////////////
// / END OF SETTINGS GROUP
// ///////////////////////////////////////////////////////////
// ///////////////////////////////
// START OF OutputFields GROUP //
// ///////////////////////////////
wOutputFields = new Group(shell, SWT.SHADOW_NONE);
props.setLook(wOutputFields);
wOutputFields.setText(BaseMessages.getString(PKG, "GetTableNamesDialog.wOutputFields.Label"));
FormLayout OutputFieldsgroupLayout = new FormLayout();
OutputFieldsgroupLayout.marginWidth = 10;
OutputFieldsgroupLayout.marginHeight = 10;
wOutputFields.setLayout(OutputFieldsgroupLayout);
// TablenameField fieldname ...
wlTablenameField = new Label(wOutputFields, SWT.RIGHT);
wlTablenameField.setText(
BaseMessages.getString(PKG, "GetTableNamesDialog.TablenameFieldName.Label"));
props.setLook(wlTablenameField);
fdlTablenameField = new FormData();
fdlTablenameField.left = new FormAttachment(0, 0);
fdlTablenameField.right = new FormAttachment(middle, -margin);
fdlTablenameField.top = new FormAttachment(wSettings, margin * 2);
wlTablenameField.setLayoutData(fdlTablenameField);
wTablenameField = new Text(wOutputFields, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
wTablenameField.setToolTipText(
BaseMessages.getString(PKG, "GetTableNamesDialog.TablenameFieldName.Tooltip"));
props.setLook(wTablenameField);
wTablenameField.addModifyListener(lsMod);
fdTablenameField = new FormData();
fdTablenameField.left = new FormAttachment(middle, 0);
fdTablenameField.top = new FormAttachment(wSettings, margin * 2);
fdTablenameField.right = new FormAttachment(100, 0);
wTablenameField.setLayoutData(fdTablenameField);
// ObjectTypeField fieldname ...
wlObjectTypeField = new Label(wOutputFields, SWT.RIGHT);
wlObjectTypeField.setText(
BaseMessages.getString(PKG, "GetTableNamesDialog.ObjectTypeFieldName.Label"));
props.setLook(wlObjectTypeField);
fdlObjectTypeField = new FormData();
fdlObjectTypeField.left = new FormAttachment(0, 0);
fdlObjectTypeField.right = new FormAttachment(middle, -margin);
fdlObjectTypeField.top = new FormAttachment(wTablenameField, margin);
wlObjectTypeField.setLayoutData(fdlObjectTypeField);
wObjectTypeField = new Text(wOutputFields, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
wObjectTypeField.setToolTipText(
BaseMessages.getString(PKG, "GetTableNamesDialog.ObjectTypeFieldName.Tooltip"));
props.setLook(wObjectTypeField);
wObjectTypeField.addModifyListener(lsMod);
fdObjectTypeField = new FormData();
fdObjectTypeField.left = new FormAttachment(middle, 0);
fdObjectTypeField.top = new FormAttachment(wTablenameField, margin);
fdObjectTypeField.right = new FormAttachment(100, 0);
wObjectTypeField.setLayoutData(fdObjectTypeField);
// isSystemObjectField fieldname ...
wlisSystemObjectField = new Label(wOutputFields, SWT.RIGHT);
wlisSystemObjectField.setText(
BaseMessages.getString(PKG, "GetTableNamesDialog.isSystemObjectFieldName.Label"));
props.setLook(wlisSystemObjectField);
fdlisSystemObjectField = new FormData();
fdlisSystemObjectField.left = new FormAttachment(0, 0);
fdlisSystemObjectField.right = new FormAttachment(middle, -margin);
fdlisSystemObjectField.top = new FormAttachment(wObjectTypeField, margin);
wlisSystemObjectField.setLayoutData(fdlisSystemObjectField);
wisSystemObjectField = new Text(wOutputFields, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
wisSystemObjectField.setToolTipText(
BaseMessages.getString(PKG, "GetTableNamesDialog.isSystemObjectFieldName.Tooltip"));
props.setLook(wisSystemObjectField);
wisSystemObjectField.addModifyListener(lsMod);
fdisSystemObjectField = new FormData();
fdisSystemObjectField.left = new FormAttachment(middle, 0);
fdisSystemObjectField.top = new FormAttachment(wObjectTypeField, margin);
fdisSystemObjectField.right = new FormAttachment(100, 0);
wisSystemObjectField.setLayoutData(fdisSystemObjectField);
// CreationSQL fieldname ...
wlSQLCreationField = new Label(wOutputFields, SWT.RIGHT);
wlSQLCreationField.setText(
BaseMessages.getString(PKG, "GetTableNamesDialog.CreationSQLName.Label"));
props.setLook(wlSQLCreationField);
fdlSQLCreationField = new FormData();
fdlSQLCreationField.left = new FormAttachment(0, 0);
fdlSQLCreationField.right = new FormAttachment(middle, -margin);
fdlSQLCreationField.top = new FormAttachment(wisSystemObjectField, margin);
wlSQLCreationField.setLayoutData(fdlSQLCreationField);
wSQLCreationField = new Text(wOutputFields, SWT.SINGLE | SWT.LEFT | SWT.BORDER);
wSQLCreationField.setToolTipText(
BaseMessages.getString(PKG, "GetTableNamesDialog.CreationSQLName.Tooltip"));
props.setLook(wSQLCreationField);
wSQLCreationField.addModifyListener(lsMod);
fdSQLCreationField = new FormData();
fdSQLCreationField.left = new FormAttachment(middle, 0);
fdSQLCreationField.top = new FormAttachment(wisSystemObjectField, margin);
fdSQLCreationField.right = new FormAttachment(100, 0);
wSQLCreationField.setLayoutData(fdSQLCreationField);
FormData fdOutputFields = new FormData();
fdOutputFields.left = new FormAttachment(0, margin);
fdOutputFields.top = new FormAttachment(wSettings, 2 * margin);
fdOutputFields.right = new FormAttachment(100, -margin);
wOutputFields.setLayoutData(fdOutputFields);
// ///////////////////////////////////////////////////////////
// / END OF OutputFields GROUP
// ///////////////////////////////////////////////////////////
// THE BUTTONS
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, "GetTableNamesDialog.Preview.Button"));
wCancel = new Button(shell, SWT.PUSH);
wCancel.setText(BaseMessages.getString(PKG, "System.Button.Cancel"));
setButtonPositions(new Button[] {wOK, wPreview, wCancel}, margin, wOutputFields);
// Add listeners
lsOK =
new Listener() {
public void handleEvent(Event e) {
ok();
}
};
lsCancel =
new Listener() {
public void handleEvent(Event e) {
cancel();
}
};
lsPreview =
new Listener() {
public void handleEvent(Event e) {
preview();
}
};
wOK.addListener(SWT.Selection, lsOK);
wPreview.addListener(SWT.Selection, lsPreview);
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();
ActivedynamicSchema();
refreshIncludeCatalog();
input.setChanged(changed);
shell.open();
while (!shell.isDisposed()) {
if (!display.readAndDispatch()) {
display.sleep();
}
}
return stepname;
}