| /******************************************************************************* |
| * 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.Connection; |
| 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.JpaUiMappingsMessages; |
| 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; |
| 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( Connection connection) { |
| // not interested to this event. |
| } |
| |
| public void closed( Connection connection) { |
| getCombo().getDisplay().asyncExec( new Runnable() { |
| public void run() { |
| if ( getControl().isDisposed()) { |
| return; |
| } |
| SchemaCombo.this.populateShemaCombo(); |
| } |
| }); |
| } |
| |
| public void modified( Connection connection) { |
| getCombo().getDisplay().asyncExec( new Runnable() { |
| public void run() { |
| if ( getControl().isDisposed()) { |
| return; |
| } |
| SchemaCombo.this.populateShemaCombo(); |
| } |
| }); |
| } |
| |
| public boolean okToClose( Connection connection) { |
| // not interested to this event. |
| return true; |
| } |
| |
| public void opened( Connection connection) { |
| getCombo().getDisplay().asyncExec( new Runnable() { |
| public void run() { |
| if ( getControl().isDisposed()) { |
| return; |
| } |
| SchemaCombo.this.populateShemaCombo(); |
| } |
| }); |
| } |
| |
| public void databaseChanged( Connection connection, 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( Connection connection, 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(Connection connection, final Table table) { |
| // not interested to this event. |
| } |
| }; |
| } |
| |
| @Override |
| protected void buildWidget( Composite parent) { |
| this.combo = getWidgetFactory().createCCombo( parent, SWT.FLAT); |
| this.combo.add( JpaUiMappingsMessages.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; |
| this.populateShemaCombo(); |
| } |
| |
| public void doPopulate() { |
| this.populateShemaCombo(); |
| } |
| |
| protected Database getDatabase() { |
| return this.getConnectionProfile().getDatabase(); |
| } |
| |
| private ConnectionProfile getConnectionProfile() { |
| return ( this.table != null) ? this.table.getJpaProject().connectionProfile() : null; |
| } |
| |
| 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 schemata = database.schemaNames(); |
| for ( Iterator stream = CollectionTools.sort( schemata); stream.hasNext(); ) { |
| this.combo.add(( String) 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( JpaUiMappingsMessages.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( JpaUiMappingsMessages.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); |
| } |
| |
| } |