| /******************************************************************************* |
| * Copyright (c) 2007 Oracle. All rights reserved. |
| * This program and the accompanying materials are made available under the |
| * terms of the Eclipse Public License v1.0, which accompanies this distribution |
| * and is available at http://www.eclipse.org/legal/epl-v10.html. |
| * |
| * Contributors: |
| * Oracle - initial API and implementation |
| *******************************************************************************/ |
| package org.eclipse.jpt.ui.internal.mappings.details; |
| |
| import java.util.Iterator; |
| |
| import org.eclipse.emf.common.command.CommandStack; |
| import org.eclipse.emf.common.notify.Adapter; |
| import org.eclipse.emf.common.notify.Notification; |
| import org.eclipse.emf.common.notify.impl.AdapterImpl; |
| import org.eclipse.emf.ecore.EObject; |
| import org.eclipse.jpt.core.internal.mappings.ITable; |
| import org.eclipse.jpt.core.internal.mappings.JpaCoreMappingsPackage; |
| import org.eclipse.jpt.db.internal.ConnectionListener; |
| import org.eclipse.jpt.db.internal.ConnectionProfile; |
| import org.eclipse.jpt.db.internal.Database; |
| import org.eclipse.jpt.db.internal.Schema; |
| import org.eclipse.jpt.db.internal.Table; |
| import org.eclipse.jpt.ui.internal.details.BaseJpaController; |
| import org.eclipse.jpt.ui.internal.mappings.JptUiMappingsMessages; |
| import org.eclipse.jpt.utility.internal.CollectionTools; |
| import org.eclipse.jpt.utility.internal.StringTools; |
| import org.eclipse.osgi.util.NLS; |
| import org.eclipse.swt.SWT; |
| import org.eclipse.swt.custom.CCombo; |
| import org.eclipse.swt.events.ModifyEvent; |
| import org.eclipse.swt.events.ModifyListener; |
| import org.eclipse.swt.widgets.Composite; |
| import org.eclipse.swt.widgets.Control; |
| import org.eclipse.swt.widgets.Display; |
| import org.eclipse.ui.views.properties.tabbed.TabbedPropertySheetWidgetFactory; |
| |
| public class SchemaCombo extends BaseJpaController |
| { |
| private ITable table; |
| |
| private Adapter listener; |
| |
| /** |
| * Caching the connectionProfile so we can remove the listener. If the |
| * cached table object has been removed from the model then we no longer |
| * have access to the parent and cannot find the connectionProfile |
| */ |
| private ConnectionProfile connectionProfile; |
| |
| private ConnectionListener connectionListener; |
| |
| private CCombo combo; |
| |
| public SchemaCombo(Composite parent, CommandStack theCommandStack, TabbedPropertySheetWidgetFactory widgetFactory) { |
| super(parent, theCommandStack, widgetFactory); |
| this.listener = this.buildTableListener(); |
| this.connectionListener = this.buildConnectionListener(); |
| } |
| |
| private Adapter buildTableListener() { |
| return new AdapterImpl() { |
| public void notifyChanged(Notification notification) { |
| SchemaCombo.this.schemaChanged(notification); |
| } |
| }; |
| } |
| |
| private ConnectionListener buildConnectionListener() { |
| return new ConnectionListener() { |
| public void aboutToClose(ConnectionProfile profile) { |
| // not interested to this event. |
| } |
| |
| public void closed(ConnectionProfile profile) { |
| getCombo().getDisplay().asyncExec(new Runnable() { |
| public void run() { |
| if (getControl().isDisposed()) { |
| return; |
| } |
| SchemaCombo.this.populateShemaCombo(); |
| } |
| }); |
| } |
| |
| public void modified(ConnectionProfile profile) { |
| getCombo().getDisplay().asyncExec(new Runnable() { |
| public void run() { |
| if (getControl().isDisposed()) { |
| return; |
| } |
| SchemaCombo.this.populateShemaCombo(); |
| } |
| }); |
| } |
| |
| public boolean okToClose(ConnectionProfile profile) { |
| // not interested to this event. |
| return true; |
| } |
| |
| public void opened(ConnectionProfile profile) { |
| getCombo().getDisplay().asyncExec(new Runnable() { |
| public void run() { |
| if (getControl().isDisposed()) { |
| return; |
| } |
| SchemaCombo.this.populateShemaCombo(); |
| } |
| }); |
| } |
| |
| public void databaseChanged(ConnectionProfile profile, final Database database) { |
| getControl().getDisplay().asyncExec(new Runnable() { |
| public void run() { |
| if (database == SchemaCombo.this.getDatabase()) { |
| if (!getControl().isDisposed()) { |
| SchemaCombo.this.populateShemaCombo(); |
| } |
| } |
| } |
| }); |
| } |
| |
| public void schemaChanged(ConnectionProfile profile, final Schema schema) { |
| getControl().getDisplay().asyncExec(new Runnable() { |
| public void run() { |
| if (schema == SchemaCombo.this.getTableSchema()) { |
| if (!getControl().isDisposed()) { |
| SchemaCombo.this.populateShemaCombo(); |
| } |
| } |
| } |
| }); |
| } |
| |
| public void tableChanged(ConnectionProfile profile, final Table table) { |
| // not interested to this event. |
| } |
| }; |
| } |
| |
| @Override |
| protected void buildWidget(Composite parent) { |
| this.combo = getWidgetFactory().createCCombo(parent, SWT.FLAT); |
| this.combo.add(JptUiMappingsMessages.TableComposite_defaultEmpty); |
| this.combo.addModifyListener(new ModifyListener() { |
| public void modifyText(ModifyEvent e) { |
| if (isPopulating()) { |
| return; |
| } |
| String schemaText = ((CCombo) e.getSource()).getText(); |
| if (schemaText.equals("")) { //$NON-NLS-1$ |
| schemaText = null; |
| if (SchemaCombo.this.table.getSpecifiedSchema() == null || SchemaCombo.this.table.getSpecifiedSchema().equals("")) { //$NON-NLS-1$ |
| return; |
| } |
| } |
| if (schemaText != null && combo.getItemCount() > 0 && schemaText.equals(combo.getItem(0))) { |
| schemaText = null; |
| } |
| if (SchemaCombo.this.table.getSpecifiedSchema() == null && schemaText != null) { |
| SchemaCombo.this.table.setSpecifiedSchema(schemaText); |
| } |
| if (SchemaCombo.this.table.getSpecifiedSchema() != null && !SchemaCombo.this.table.getSpecifiedSchema().equals(schemaText)) { |
| SchemaCombo.this.table.setSpecifiedSchema(schemaText); |
| } |
| } |
| }); |
| } |
| |
| protected void schemaChanged(Notification notification) { |
| if (notification.getFeatureID(ITable.class) == JpaCoreMappingsPackage.ITABLE__SPECIFIED_SCHEMA) { |
| Display.getDefault().asyncExec(new Runnable() { |
| public void run() { |
| if (getControl().isDisposed()) { |
| return; |
| } |
| SchemaCombo.this.populateSchemaName(); |
| } |
| }); |
| } |
| else if (notification.getFeatureID(ITable.class) == JpaCoreMappingsPackage.ITABLE__DEFAULT_SCHEMA) { |
| Display.getDefault().asyncExec(new Runnable() { |
| public void run() { |
| if (getControl().isDisposed()) { |
| return; |
| } |
| SchemaCombo.this.populateDefaultSchemaName(); |
| } |
| }); |
| } |
| else if (notification.getFeatureID(ITable.class) == JpaCoreMappingsPackage.ITABLE__DEFAULT_CATALOG) { |
| Display.getDefault().asyncExec(new Runnable() { |
| public void run() { |
| if (getControl().isDisposed()) { |
| return; |
| } |
| SchemaCombo.this.populateShemaCombo(); |
| } |
| }); |
| } |
| else if (notification.getFeatureID(ITable.class) == JpaCoreMappingsPackage.ITABLE__SPECIFIED_CATALOG) { |
| Display.getDefault().asyncExec(new Runnable() { |
| public void run() { |
| if (getControl().isDisposed()) { |
| return; |
| } |
| SchemaCombo.this.populateShemaCombo(); |
| } |
| }); |
| } |
| } |
| |
| public void doPopulate(EObject obj) { |
| this.table = (ITable) obj; |
| if (this.table != null) { |
| this.populateShemaCombo(); |
| } |
| else { |
| this.connectionProfile = null; |
| } |
| } |
| |
| public void doPopulate() { |
| this.populateShemaCombo(); |
| } |
| |
| protected Database getDatabase() { |
| return this.getConnectionProfile().getDatabase(); |
| } |
| |
| private ConnectionProfile getConnectionProfile() { |
| if (this.connectionProfile == null) { |
| this.connectionProfile = this.table.getJpaProject().connectionProfile(); |
| } |
| return this.connectionProfile; |
| } |
| |
| private void populateShemaCombo() { |
| if (this.table == null) { |
| return; |
| } |
| this.populateDefaultSchemaName(); |
| if (this.getConnectionProfile().isConnected()) { |
| this.combo.remove(1, this.combo.getItemCount() - 1); |
| Database database = this.getDatabase(); |
| if (database != null) { |
| Iterator<String> schemata = database.schemaNames(); |
| for (Iterator<String> stream = CollectionTools.sort(schemata); stream.hasNext();) { |
| this.combo.add(stream.next()); |
| } |
| } |
| } |
| else { |
| this.combo.remove(1, this.combo.getItemCount() - 1); |
| } |
| this.populateSchemaName(); |
| } |
| |
| protected void populateDefaultSchemaName() { |
| String defaultSchemaName = this.table.getDefaultSchema(); |
| int selectionIndex = combo.getSelectionIndex(); |
| combo.setItem(0, NLS.bind(JptUiMappingsMessages.TableComposite_defaultWithOneParam, defaultSchemaName)); |
| if (selectionIndex == 0) { |
| combo.clearSelection(); |
| combo.select(0); |
| } |
| } |
| |
| protected void populateSchemaName() { |
| if (this.table == null) { |
| return; |
| } |
| String schemaName = this.table.getSpecifiedSchema(); |
| String defaultSchemaName = this.table.getDefaultSchema(); |
| if (!StringTools.stringIsEmpty(schemaName)) { |
| if (!this.combo.getText().equals(schemaName)) { |
| this.combo.setText(schemaName); |
| } |
| } |
| else { |
| if (!this.combo.getText().equals(NLS.bind(JptUiMappingsMessages.TableComposite_defaultWithOneParam, defaultSchemaName))) { |
| this.combo.select(0); |
| } |
| } |
| } |
| |
| public CCombo getCombo() { |
| return this.combo; |
| } |
| |
| @Override |
| public Control getControl() { |
| return getCombo(); |
| } |
| |
| protected Schema getTableSchema() { |
| return this.getConnectionProfile().getDatabase().schemaNamed(table.getSchema()); |
| } |
| |
| @Override |
| protected void disengageListeners() { |
| if (this.table != null) { |
| this.removeConnectionListener(); |
| this.table.eAdapters().remove(this.listener); |
| } |
| } |
| |
| @Override |
| protected void engageListeners() { |
| if (this.table != null) { |
| this.table.eAdapters().add(this.listener); |
| this.addConnectionListener(); |
| } |
| } |
| |
| private void addConnectionListener() { |
| this.getConnectionProfile().addConnectionListener(this.connectionListener); |
| } |
| |
| private void removeConnectionListener() { |
| this.getConnectionProfile().removeConnectionListener(this.connectionListener); |
| } |
| } |