jpa/plugins/org.eclipse.jpt.ui/src/org/eclipse/jpt/ui/internal/mappings/details/ColumnComposite.java - dali/webtools.dali - Git at Google

 /*******************************************************************************
  * 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.emf.ecore.impl.EObjectImpl;
 import org.eclipse.jpt.core.internal.mappings.DefaultTrueBoolean;
 import org.eclipse.jpt.core.internal.mappings.IAbstractColumn;
 import org.eclipse.jpt.core.internal.mappings.IColumn;
 import org.eclipse.jpt.core.internal.mappings.INamedColumn;
 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.IJpaHelpContextIds;
 import org.eclipse.jpt.ui.internal.details.BaseJpaComposite;
 import org.eclipse.jpt.ui.internal.mappings.JptUiMappingsMessages;
 import org.eclipse.jpt.ui.internal.mappings.details.EnumComboViewer.EnumHolder;
 import org.eclipse.jpt.utility.internal.CollectionTools;
 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.layout.GridData;
 import org.eclipse.swt.layout.GridLayout;
 import org.eclipse.swt.widgets.Composite;
 import org.eclipse.swt.widgets.Display;
 import org.eclipse.swt.widgets.Group;
 import org.eclipse.ui.PlatformUI;
 import org.eclipse.ui.help.IWorkbenchHelpSystem;
 import org.eclipse.ui.views.properties.tabbed.TabbedPropertySheetWidgetFactory;

 //TODO repopulate this panel based on the Entity table changing
 public class ColumnComposite extends BaseJpaComposite
 {

 	private IColumn column;

 	private Adapter columnListener;
 	private ConnectionListener connectionListener;

 	protected CCombo columnCombo;
 	protected CCombo tableCombo;
 	protected EnumComboViewer insertableComboViewer;
 	protected EnumComboViewer updatableComboViewer;

 	private ConnectionProfile connectionProfile;

 	public ColumnComposite(Composite parent, CommandStack commandStack, TabbedPropertySheetWidgetFactory widgetFactory) {
 		super(parent, SWT.NULL, commandStack, widgetFactory);
 		this.columnListener = buildColumnListener();
 		this.connectionListener = buildConnectionListener();
 	}

 	private Adapter buildColumnListener() {
 		return new AdapterImpl() {
 			public void notifyChanged(Notification notification) {
 				columnChanged(notification);
 			}
 		};
 	}

     private ConnectionListener buildConnectionListener() {
 		return new ConnectionListener() {

 			public void aboutToClose(ConnectionProfile profile) {
 				// not interested to this event.
 			}

 			public void closed(ConnectionProfile profile) {
 				getControl().getDisplay().asyncExec( new Runnable() {
 					public void run() {
 						if (getControl().isDisposed()) {
 							return;
 						}
 						ColumnComposite.this.populateColumnCombo();
 					}
 				});
 			}

 			public void modified(ConnectionProfile profile) {
 				getControl().getDisplay().asyncExec( new Runnable() {
 					public void run() {
 						if (getControl().isDisposed()) {
 							return;
 						}
 						ColumnComposite.this.populateColumnCombo();
 					}
 				});
 			}

 			public boolean okToClose(ConnectionProfile profile) {
 				// not interested to this event.
 				return true;
 			}

 			public void opened(ConnectionProfile profile) {
 				getControl().getDisplay().asyncExec( new Runnable() {
 					public void run() {
 						if (getControl().isDisposed()) {
 							return;
 						}
 						ColumnComposite.this.populateColumnCombo();
 					}
 				});
 			}

 			public void databaseChanged(ConnectionProfile profile, final Database database) {
 				return;
 			}

 			public void schemaChanged(ConnectionProfile profile, final Schema schema) {
 				return;
 			}

 			public void tableChanged(ConnectionProfile profile, final Table table) {
 				getControl().getDisplay().asyncExec( new Runnable() {
 					public void run() {
 						if(table == getDbTable()) {
 							if (!getControl().isDisposed()) {
 								ColumnComposite.this.populateColumnCombo();
 							}
 						}
 					}
 				});
 			}
 		};
     }

 	@Override
 	protected void initializeLayout(Composite composite) {
 		IWorkbenchHelpSystem helpSystem = PlatformUI.getWorkbench().getHelpSystem();
 		GridLayout layout = new GridLayout();
 		layout.marginWidth = 0;
 		composite.setLayout(layout);

 		Group columnGroup = getWidgetFactory().createGroup(composite, JptUiMappingsMessages.ColumnComposite_columnSection);
 		layout = new GridLayout();
 		layout.marginHeight = 0;
 		columnGroup.setLayout(layout);
 		GridData gridData = new GridData();
 		gridData.horizontalAlignment = SWT.FILL;
 		gridData.verticalAlignment = SWT.FILL;
 		gridData.grabExcessHorizontalSpace = true;
 		gridData.grabExcessVerticalSpace= true;
 		columnGroup.setLayoutData(gridData);

 		//created this composite because combos as direct children of a Group do not have a border, no clue why
 		Composite intermediaryComposite = getWidgetFactory().createComposite(columnGroup);
 		layout = new GridLayout(2, false);
 		layout.marginWidth = 0;
 		intermediaryComposite.setLayout(layout);

 		gridData = new GridData();
 		gridData.horizontalAlignment = SWT.FILL;
 		gridData.verticalAlignment = SWT.FILL;
 		gridData.grabExcessHorizontalSpace = true;
 		gridData.grabExcessVerticalSpace= true;
 		intermediaryComposite.setLayoutData(gridData);


 		CommonWidgets.buildColumnLabel(intermediaryComposite, getWidgetFactory());

 		this.columnCombo = buildColumnCombo(intermediaryComposite);
 		gridData = new GridData();
 		gridData.horizontalAlignment = SWT.FILL;
 		gridData.verticalAlignment = SWT.BEGINNING;
 		gridData.grabExcessHorizontalSpace = true;
 		this.columnCombo.setLayoutData(gridData);
 		helpSystem.setHelp(columnCombo, IJpaHelpContextIds.MAPPING_COLUMN);


 		CommonWidgets.buildColumnTableLabel(intermediaryComposite, getWidgetFactory());

 		this.tableCombo = buildTableCombo(intermediaryComposite);
 		gridData = new GridData();
 		gridData.horizontalAlignment = SWT.FILL;
 		gridData.verticalAlignment = SWT.BEGINNING;
 		gridData.grabExcessHorizontalSpace = true;
 		this.tableCombo.setLayoutData(gridData);
 		helpSystem.setHelp(tableCombo, IJpaHelpContextIds.MAPPING_COLUMN_TABLE);

 		getWidgetFactory().createLabel(intermediaryComposite, JptUiMappingsMessages.ColumnComposite_insertable);

 		this.insertableComboViewer = new EnumComboViewer(intermediaryComposite, this.commandStack, getWidgetFactory());
 		this.insertableComboViewer.getControl().setLayoutData(new GridData(GridData.FILL_HORIZONTAL | GridData.GRAB_HORIZONTAL));
 		helpSystem.setHelp(this.insertableComboViewer.getControl(), IJpaHelpContextIds.MAPPING_COLUMN_INSERTABLE);

 		getWidgetFactory().createLabel(intermediaryComposite, JptUiMappingsMessages.ColumnComposite_updatable);

 		this.updatableComboViewer = new EnumComboViewer(intermediaryComposite, this.commandStack, getWidgetFactory());
 		this.updatableComboViewer.getControl().setLayoutData(new GridData(GridData.FILL_HORIZONTAL | GridData.GRAB_HORIZONTAL));
 		helpSystem.setHelp(this.updatableComboViewer.getControl(), IJpaHelpContextIds.MAPPING_COLUMN_UPDATABLE);
 	}


 	private CCombo buildColumnCombo(Composite parent) {
 		final CCombo combo = getWidgetFactory().createCCombo(parent, SWT.FLAT);
   		combo.add(JptUiMappingsMessages.ColumnComposite_defaultEmpty);
 		combo.addModifyListener(new ModifyListener() {
 			public void modifyText(ModifyEvent e) {
 				if (isPopulating()) {
 					return;
 				}
 				String columnText = ((CCombo) e.getSource()).getText();
 				if (columnText.equals("")) { //$NON-NLS-1$
 					columnText = null;
 					if (column.getSpecifiedName() == null || column.getSpecifiedName().equals("")) { //$NON-NLS-1$
 						return;
 					}
 				}

 				if (columnText != null && combo.getItemCount() > 0 && columnText.equals(combo.getItem(0))) {
 					columnText = null;
 				}

 				if (column.getSpecifiedName() == null && columnText != null) {
 					column.setSpecifiedName(columnText);
 				}
 				if (column.getSpecifiedName() != null && !column.getSpecifiedName().equals(columnText)) {
 					column.setSpecifiedName(columnText);
 				}
 			}
 		});
 		return combo;
 	}

 	private CCombo buildTableCombo(Composite parent) {
 		final CCombo combo = getWidgetFactory().createCCombo(parent, SWT.FLAT);
   		combo.add(JptUiMappingsMessages.ColumnComposite_defaultEmpty);
 		combo.addModifyListener(new ModifyListener() {
 			public void modifyText(ModifyEvent e) {
 				if (isPopulating()) {
 					return;
 				}
 				String tableText = ((CCombo) e.getSource()).getText();
 				if (tableText.equals("")) { //$NON-NLS-1$
 					tableText = null;
 					if (column.getSpecifiedTable() == null || column.getSpecifiedTable().equals("")) { //$NON-NLS-1$
 						return;
 					}
 				}

 				if (tableText != null && combo.getItemCount() > 0 && tableText.equals(combo.getItem(0))) {
 					tableText = null;
 				}

 				if (column.getSpecifiedTable() == null && tableText != null) {
 					column.setSpecifiedTable(tableText);
 				}
 				if (column.getSpecifiedTable() != null && !column.getSpecifiedTable().equals(tableText)) {
 					column.setSpecifiedTable(tableText);
 				}
 			}
 		});
 		return combo;

 	}

 	protected void columnChanged(Notification notification) {
 		if (notification.getFeatureID(INamedColumn.class) == JpaCoreMappingsPackage.INAMED_COLUMN__SPECIFIED_NAME) {
 			Display.getDefault().asyncExec(new Runnable() {
 				public void run() {
 					if (getControl().isDisposed() || isPopulating()) {
 						return;
 					}
 					populateColumnName();
 				}
 			});
 		}
 		else if (notification.getFeatureID(INamedColumn.class) == JpaCoreMappingsPackage.INAMED_COLUMN__DEFAULT_NAME) {
 			Display.getDefault().asyncExec(new Runnable() {
 				public void run() {
 					if (getControl().isDisposed()) {
 						return;
 					}
 					populateDefaultColumnName();
 				}
 			});
 		}
 		else if (notification.getFeatureID(IAbstractColumn.class) == JpaCoreMappingsPackage.IABSTRACT_COLUMN__DEFAULT_TABLE) {
 			Display.getDefault().asyncExec(new Runnable() {
 				public void run() {
 					if (getControl().isDisposed()) {
 						return;
 					}
 					populateDefaultColumnTable();
 					populateColumnCombo();
 				}
 			});
 		}
 		else if (notification.getFeatureID(IAbstractColumn.class) == JpaCoreMappingsPackage.IABSTRACT_COLUMN__SPECIFIED_TABLE) {
 			Display.getDefault().asyncExec(new Runnable() {
 				public void run() {
 					if (getControl().isDisposed()) {
 						return;
 					}
 					populateColumnTable();
 					populateColumnCombo();
 				}
 			});
 		}
 	}

 	@Override
 	protected void engageListeners() {
 		if (this.column != null) {
 			this.column.eAdapters().add(this.columnListener);
 			this.addConnectionListener();
 		}
 	}

 	@Override
 	protected void disengageListeners() {
 		if (this.column != null) {
 			this.removeConnectionListener();
 			this.column.eAdapters().remove(this.columnListener);
 		}
 	}

 	private ConnectionProfile getConnectionProfile() {
 		if (this.connectionProfile == null) {
 			this.connectionProfile = this.column.getJpaProject().connectionProfile();
 		}
 		return this.connectionProfile;
 	}

 	private void addConnectionListener() {
 		this.getConnectionProfile().addConnectionListener(this.connectionListener);
 	}

 	private void removeConnectionListener() {
 		this.getConnectionProfile().removeConnectionListener(this.connectionListener);
 	}

 	private Table getDbTable() {
 		return this.column.dbTable();
 	}

 	private void populateColumnCombo() {
 		//TODO don't do instanceof check here - check on Table, or isRoot check on Entity
 		//this.tableCombo.setEnabled(!(this.table instanceof SingleTableInheritanceChildTableImpl));
 		populateDefaultColumnName();

 		if (this.getConnectionProfile().isConnected()) {
 			this.columnCombo.remove(1, this.columnCombo.getItemCount()-1);
 			Table table = getDbTable();
 			if (table != null) {
 				for (Iterator i = CollectionTools.sort(CollectionTools.list(table.columnNames())).iterator(); i.hasNext();) {
 					this.columnCombo.add((String) i.next());
 				}
 			}
 		}
 		else {
 			this.columnCombo.remove(1, this.columnCombo.getItemCount()-1);
 		}
 		populateColumnName();
 	}

 	protected void populateDefaultColumnName() {
 		String defaultTableName = column.getDefaultName();
 		int selectionIndex = columnCombo.getSelectionIndex();
 		columnCombo.setItem(0, NLS.bind(JptUiMappingsMessages.ColumnComposite_defaultWithOneParam, defaultTableName));
 		if (selectionIndex == 0) {
 			//combo text does not update when switching between 2 mappings of the same type
 			//that both have a default column name.  clear the selection and then set it again
 			columnCombo.clearSelection();
 			columnCombo.select(0);
 		}
 	}

 	protected void populateColumnName() {
 		String specifiedColumnName = this.column.getSpecifiedName();
 		if (specifiedColumnName != null) {
 			if (!this.columnCombo.getText().equals(specifiedColumnName)) {
 				this.columnCombo.setText(specifiedColumnName);
 			}
 		}
 		else {
 			String defaultColumnName = this.column.getDefaultName();
 			if (!this.columnCombo.getText().equals(NLS.bind(JptUiMappingsMessages.ColumnComposite_defaultWithOneParam, defaultColumnName))) {
 				this.columnCombo.select(0);
 			}
 		}
 	}

 	private void populateTableCombo() {
 		//TODO don't do instanceof check here - check on Table, or isRoot check on Entity
 		//this.tableCombo.setEnabled(!(this.table instanceof SingleTableInheritanceChildTableImpl));
 		populateDefaultColumnTable();
 		this.tableCombo.remove(1, this.tableCombo.getItemCount()-1);

 		if (this.column != null) {
 			for (Iterator i = this.column.getOwner().getTypeMapping().associatedTableNamesIncludingInherited(); i.hasNext(); ) {
 				this.tableCombo.add((String) i.next());
 			}
 		}
 		populateColumnTable();
 	}

 	protected void populateDefaultColumnTable() {
 		String defaultTableName = column.getDefaultTable();
 		int selectionIndex = tableCombo.getSelectionIndex();
 		tableCombo.setItem(0, NLS.bind(JptUiMappingsMessages.ColumnComposite_defaultWithOneParam, defaultTableName));
 		if (selectionIndex == 0) {
 			//combo text does not update when switching between 2 mappings of the same type
 			//that both have a default column name.  clear the selection and then set it again
 			tableCombo.clearSelection();
 			tableCombo.select(0);
 		}
 	}

 	protected void populateColumnTable() {
 		String tableName = this.column.getSpecifiedTable();
 		String defaultTableName = this.column.getDefaultTable();
 		if (tableName != null) {
 			if (!this.tableCombo.getText().equals(tableName)) {
 				this.tableCombo.setText(tableName);
 			}
 		}
 		else {
 			if (!this.tableCombo.getText().equals(NLS.bind(JptUiMappingsMessages.ColumnComposite_defaultWithOneParam, defaultTableName))) {
 				this.tableCombo.select(0);
 			}
 		}
 	}

 	public void doPopulate(EObject obj) {
 		this.column = (IColumn) obj;
 		if (this.column != null) {
 			populateColumnCombo();
 			populateTableCombo();
 		}
 		this.insertableComboViewer.populate(new InsertableHolder(this.column));
 		this.updatableComboViewer.populate(new UpdatableHolder(this.column));
 	}

 	public void doPopulate() {
 		if (this.column != null) {
 			populateColumnCombo();
 			populateTableCombo();
 		}
 		else {
 			this.connectionProfile = null;
 		}
 		this.insertableComboViewer.populate();
 		this.updatableComboViewer.populate();
 	}

 	protected void enableWidgets(boolean enabled) {
 		this.columnCombo.setEnabled(enabled);
 		this.tableCombo.setEnabled(enabled);
 		this.insertableComboViewer.getControl().setEnabled(enabled);
 		this.updatableComboViewer.getControl().setEnabled(enabled);
 	}

 	@Override
 	public void dispose() {
 		this.insertableComboViewer.dispose();
 		this.updatableComboViewer.dispose();
 		super.dispose();
 	}

 	private class InsertableHolder extends EObjectImpl implements EnumHolder {

 		private IAbstractColumn column;

 		InsertableHolder(IAbstractColumn column) {
 			super();
 			this.column = column;
 		}

 		public Object get() {
 			return this.column.getInsertable();
 		}

 		public void set(Object enumSetting) {
 			this.column.setInsertable((DefaultTrueBoolean) enumSetting);

 		}

 		public Class featureClass() {
 			return IAbstractColumn.class;
 		}

 		public int featureId() {
 			return JpaCoreMappingsPackage.IABSTRACT_COLUMN__INSERTABLE;
 		}

 		public EObject wrappedObject() {
 			return this.column;
 		}

 		public Object[] enumValues() {
 			return DefaultTrueBoolean.VALUES.toArray();
 		}

 		public Object defaultValue() {
 			return DefaultTrueBoolean.DEFAULT;
 		}

 		public String defaultString() {
 			//TODO move this out of the UI into the model
 			return "True";
 		}
 	}

 	private class UpdatableHolder extends EObjectImpl implements EnumHolder {

 		private IAbstractColumn column;

 		UpdatableHolder(IAbstractColumn column) {
 			super();
 			this.column = column;
 		}

 		public Object get() {
 			return this.column.getUpdatable();
 		}

 		public void set(Object enumSetting) {
 			this.column.setUpdatable((DefaultTrueBoolean) enumSetting);

 		}

 		public Class featureClass() {
 			return IAbstractColumn.class;
 		}

 		public int featureId() {
 			return JpaCoreMappingsPackage.IABSTRACT_COLUMN__UPDATABLE;
 		}

 		public EObject wrappedObject() {
 			return this.column;
 		}

 		public Object[] enumValues() {
 			return DefaultTrueBoolean.VALUES.toArray();
 		}

 		public Object defaultValue() {
 			return DefaultTrueBoolean.DEFAULT;
 		}

 		public String defaultString() {
 			//TODO move this out of the UI into the model
 			return "True";
 		}
 	}
 }
	/*******************************************************************************
	* 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.emf.ecore.impl.EObjectImpl;
	import org.eclipse.jpt.core.internal.mappings.DefaultTrueBoolean;
	import org.eclipse.jpt.core.internal.mappings.IAbstractColumn;
	import org.eclipse.jpt.core.internal.mappings.IColumn;
	import org.eclipse.jpt.core.internal.mappings.INamedColumn;
	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.IJpaHelpContextIds;
	import org.eclipse.jpt.ui.internal.details.BaseJpaComposite;
	import org.eclipse.jpt.ui.internal.mappings.JptUiMappingsMessages;
	import org.eclipse.jpt.ui.internal.mappings.details.EnumComboViewer.EnumHolder;
	import org.eclipse.jpt.utility.internal.CollectionTools;
	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.layout.GridData;
	import org.eclipse.swt.layout.GridLayout;
	import org.eclipse.swt.widgets.Composite;
	import org.eclipse.swt.widgets.Display;
	import org.eclipse.swt.widgets.Group;
	import org.eclipse.ui.PlatformUI;
	import org.eclipse.ui.help.IWorkbenchHelpSystem;
	import org.eclipse.ui.views.properties.tabbed.TabbedPropertySheetWidgetFactory;

	//TODO repopulate this panel based on the Entity table changing
	public class ColumnComposite extends BaseJpaComposite
	{

	private IColumn column;

	private Adapter columnListener;
	private ConnectionListener connectionListener;

	protected CCombo columnCombo;
	protected CCombo tableCombo;
	protected EnumComboViewer insertableComboViewer;
	protected EnumComboViewer updatableComboViewer;

	private ConnectionProfile connectionProfile;

	public ColumnComposite(Composite parent, CommandStack commandStack, TabbedPropertySheetWidgetFactory widgetFactory) {
	super(parent, SWT.NULL, commandStack, widgetFactory);
	this.columnListener = buildColumnListener();
	this.connectionListener = buildConnectionListener();
	}

	private Adapter buildColumnListener() {
	return new AdapterImpl() {
	public void notifyChanged(Notification notification) {
	columnChanged(notification);
	}
	};
	}

	private ConnectionListener buildConnectionListener() {
	return new ConnectionListener() {

	public void aboutToClose(ConnectionProfile profile) {
	// not interested to this event.
	}

	public void closed(ConnectionProfile profile) {
	getControl().getDisplay().asyncExec( new Runnable() {
	public void run() {
	if (getControl().isDisposed()) {
	return;
	}
	ColumnComposite.this.populateColumnCombo();
	}
	});
	}

	public void modified(ConnectionProfile profile) {
	getControl().getDisplay().asyncExec( new Runnable() {
	public void run() {
	if (getControl().isDisposed()) {
	return;
	}
	ColumnComposite.this.populateColumnCombo();
	}
	});
	}

	public boolean okToClose(ConnectionProfile profile) {
	// not interested to this event.
	return true;
	}

	public void opened(ConnectionProfile profile) {
	getControl().getDisplay().asyncExec( new Runnable() {
	public void run() {
	if (getControl().isDisposed()) {
	return;
	}
	ColumnComposite.this.populateColumnCombo();
	}
	});
	}

	public void databaseChanged(ConnectionProfile profile, final Database database) {
	return;
	}

	public void schemaChanged(ConnectionProfile profile, final Schema schema) {
	return;
	}

	public void tableChanged(ConnectionProfile profile, final Table table) {
	getControl().getDisplay().asyncExec( new Runnable() {
	public void run() {
	if(table == getDbTable()) {
	if (!getControl().isDisposed()) {
	ColumnComposite.this.populateColumnCombo();
	}
	}
	}
	});
	}
	};
	}

	@Override
	protected void initializeLayout(Composite composite) {
	IWorkbenchHelpSystem helpSystem = PlatformUI.getWorkbench().getHelpSystem();
	GridLayout layout = new GridLayout();
	layout.marginWidth = 0;
	composite.setLayout(layout);

	Group columnGroup = getWidgetFactory().createGroup(composite, JptUiMappingsMessages.ColumnComposite_columnSection);
	layout = new GridLayout();
	layout.marginHeight = 0;
	columnGroup.setLayout(layout);
	GridData gridData = new GridData();
	gridData.horizontalAlignment = SWT.FILL;
	gridData.verticalAlignment = SWT.FILL;
	gridData.grabExcessHorizontalSpace = true;
	gridData.grabExcessVerticalSpace= true;
	columnGroup.setLayoutData(gridData);

	//created this composite because combos as direct children of a Group do not have a border, no clue why
	Composite intermediaryComposite = getWidgetFactory().createComposite(columnGroup);
	layout = new GridLayout(2, false);
	layout.marginWidth = 0;
	intermediaryComposite.setLayout(layout);

	gridData = new GridData();
	gridData.horizontalAlignment = SWT.FILL;
	gridData.verticalAlignment = SWT.FILL;
	gridData.grabExcessHorizontalSpace = true;
	gridData.grabExcessVerticalSpace= true;
	intermediaryComposite.setLayoutData(gridData);


	CommonWidgets.buildColumnLabel(intermediaryComposite, getWidgetFactory());

	this.columnCombo = buildColumnCombo(intermediaryComposite);
	gridData = new GridData();
	gridData.horizontalAlignment = SWT.FILL;
	gridData.verticalAlignment = SWT.BEGINNING;
	gridData.grabExcessHorizontalSpace = true;
	this.columnCombo.setLayoutData(gridData);
	helpSystem.setHelp(columnCombo, IJpaHelpContextIds.MAPPING_COLUMN);


	CommonWidgets.buildColumnTableLabel(intermediaryComposite, getWidgetFactory());

	this.tableCombo = buildTableCombo(intermediaryComposite);
	gridData = new GridData();
	gridData.horizontalAlignment = SWT.FILL;
	gridData.verticalAlignment = SWT.BEGINNING;
	gridData.grabExcessHorizontalSpace = true;
	this.tableCombo.setLayoutData(gridData);
	helpSystem.setHelp(tableCombo, IJpaHelpContextIds.MAPPING_COLUMN_TABLE);

	getWidgetFactory().createLabel(intermediaryComposite, JptUiMappingsMessages.ColumnComposite_insertable);

	this.insertableComboViewer = new EnumComboViewer(intermediaryComposite, this.commandStack, getWidgetFactory());
	this.insertableComboViewer.getControl().setLayoutData(new GridData(GridData.FILL_HORIZONTAL \| GridData.GRAB_HORIZONTAL));
	helpSystem.setHelp(this.insertableComboViewer.getControl(), IJpaHelpContextIds.MAPPING_COLUMN_INSERTABLE);

	getWidgetFactory().createLabel(intermediaryComposite, JptUiMappingsMessages.ColumnComposite_updatable);

	this.updatableComboViewer = new EnumComboViewer(intermediaryComposite, this.commandStack, getWidgetFactory());
	this.updatableComboViewer.getControl().setLayoutData(new GridData(GridData.FILL_HORIZONTAL \| GridData.GRAB_HORIZONTAL));
	helpSystem.setHelp(this.updatableComboViewer.getControl(), IJpaHelpContextIds.MAPPING_COLUMN_UPDATABLE);
	}


	private CCombo buildColumnCombo(Composite parent) {
	final CCombo combo = getWidgetFactory().createCCombo(parent, SWT.FLAT);
	combo.add(JptUiMappingsMessages.ColumnComposite_defaultEmpty);
	combo.addModifyListener(new ModifyListener() {
	public void modifyText(ModifyEvent e) {
	if (isPopulating()) {
	return;
	}
	String columnText = ((CCombo) e.getSource()).getText();
	if (columnText.equals("")) { //$NON-NLS-1$
	columnText = null;
	if (column.getSpecifiedName() == null \|\| column.getSpecifiedName().equals("")) { //$NON-NLS-1$
	return;
	}
	}

	if (columnText != null && combo.getItemCount() > 0 && columnText.equals(combo.getItem(0))) {
	columnText = null;
	}

	if (column.getSpecifiedName() == null && columnText != null) {
	column.setSpecifiedName(columnText);
	}
	if (column.getSpecifiedName() != null && !column.getSpecifiedName().equals(columnText)) {
	column.setSpecifiedName(columnText);
	}
	}
	});
	return combo;
	}

	private CCombo buildTableCombo(Composite parent) {
	final CCombo combo = getWidgetFactory().createCCombo(parent, SWT.FLAT);
	combo.add(JptUiMappingsMessages.ColumnComposite_defaultEmpty);
	combo.addModifyListener(new ModifyListener() {
	public void modifyText(ModifyEvent e) {
	if (isPopulating()) {
	return;
	}
	String tableText = ((CCombo) e.getSource()).getText();
	if (tableText.equals("")) { //$NON-NLS-1$
	tableText = null;
	if (column.getSpecifiedTable() == null \|\| column.getSpecifiedTable().equals("")) { //$NON-NLS-1$
	return;
	}
	}

	if (tableText != null && combo.getItemCount() > 0 && tableText.equals(combo.getItem(0))) {
	tableText = null;
	}

	if (column.getSpecifiedTable() == null && tableText != null) {
	column.setSpecifiedTable(tableText);
	}
	if (column.getSpecifiedTable() != null && !column.getSpecifiedTable().equals(tableText)) {
	column.setSpecifiedTable(tableText);
	}
	}
	});
	return combo;

	}

	protected void columnChanged(Notification notification) {
	if (notification.getFeatureID(INamedColumn.class) == JpaCoreMappingsPackage.INAMED_COLUMN__SPECIFIED_NAME) {
	Display.getDefault().asyncExec(new Runnable() {
	public void run() {
	if (getControl().isDisposed() \|\| isPopulating()) {
	return;
	}
	populateColumnName();
	}
	});
	}
	else if (notification.getFeatureID(INamedColumn.class) == JpaCoreMappingsPackage.INAMED_COLUMN__DEFAULT_NAME) {
	Display.getDefault().asyncExec(new Runnable() {
	public void run() {
	if (getControl().isDisposed()) {
	return;
	}
	populateDefaultColumnName();
	}
	});
	}
	else if (notification.getFeatureID(IAbstractColumn.class) == JpaCoreMappingsPackage.IABSTRACT_COLUMN__DEFAULT_TABLE) {
	Display.getDefault().asyncExec(new Runnable() {
	public void run() {
	if (getControl().isDisposed()) {
	return;
	}
	populateDefaultColumnTable();
	populateColumnCombo();
	}
	});
	}
	else if (notification.getFeatureID(IAbstractColumn.class) == JpaCoreMappingsPackage.IABSTRACT_COLUMN__SPECIFIED_TABLE) {
	Display.getDefault().asyncExec(new Runnable() {
	public void run() {
	if (getControl().isDisposed()) {
	return;
	}
	populateColumnTable();
	populateColumnCombo();
	}
	});
	}
	}

	@Override
	protected void engageListeners() {
	if (this.column != null) {
	this.column.eAdapters().add(this.columnListener);
	this.addConnectionListener();
	}
	}

	@Override
	protected void disengageListeners() {
	if (this.column != null) {
	this.removeConnectionListener();
	this.column.eAdapters().remove(this.columnListener);
	}
	}

	private ConnectionProfile getConnectionProfile() {
	if (this.connectionProfile == null) {
	this.connectionProfile = this.column.getJpaProject().connectionProfile();
	}
	return this.connectionProfile;
	}

	private void addConnectionListener() {
	this.getConnectionProfile().addConnectionListener(this.connectionListener);
	}

	private void removeConnectionListener() {
	this.getConnectionProfile().removeConnectionListener(this.connectionListener);
	}

	private Table getDbTable() {
	return this.column.dbTable();
	}

	private void populateColumnCombo() {
	//TODO don't do instanceof check here - check on Table, or isRoot check on Entity
	//this.tableCombo.setEnabled(!(this.table instanceof SingleTableInheritanceChildTableImpl));
	populateDefaultColumnName();

	if (this.getConnectionProfile().isConnected()) {
	this.columnCombo.remove(1, this.columnCombo.getItemCount()-1);
	Table table = getDbTable();
	if (table != null) {
	for (Iterator i = CollectionTools.sort(CollectionTools.list(table.columnNames())).iterator(); i.hasNext();) {
	this.columnCombo.add((String) i.next());
	}
	}
	}
	else {
	this.columnCombo.remove(1, this.columnCombo.getItemCount()-1);
	}
	populateColumnName();
	}

	protected void populateDefaultColumnName() {
	String defaultTableName = column.getDefaultName();
	int selectionIndex = columnCombo.getSelectionIndex();
	columnCombo.setItem(0, NLS.bind(JptUiMappingsMessages.ColumnComposite_defaultWithOneParam, defaultTableName));
	if (selectionIndex == 0) {
	//combo text does not update when switching between 2 mappings of the same type
	//that both have a default column name. clear the selection and then set it again
	columnCombo.clearSelection();
	columnCombo.select(0);
	}
	}

	protected void populateColumnName() {
	String specifiedColumnName = this.column.getSpecifiedName();
	if (specifiedColumnName != null) {
	if (!this.columnCombo.getText().equals(specifiedColumnName)) {
	this.columnCombo.setText(specifiedColumnName);
	}
	}
	else {
	String defaultColumnName = this.column.getDefaultName();
	if (!this.columnCombo.getText().equals(NLS.bind(JptUiMappingsMessages.ColumnComposite_defaultWithOneParam, defaultColumnName))) {
	this.columnCombo.select(0);
	}
	}
	}

	private void populateTableCombo() {
	//TODO don't do instanceof check here - check on Table, or isRoot check on Entity
	//this.tableCombo.setEnabled(!(this.table instanceof SingleTableInheritanceChildTableImpl));
	populateDefaultColumnTable();
	this.tableCombo.remove(1, this.tableCombo.getItemCount()-1);

	if (this.column != null) {
	for (Iterator i = this.column.getOwner().getTypeMapping().associatedTableNamesIncludingInherited(); i.hasNext(); ) {
	this.tableCombo.add((String) i.next());
	}
	}
	populateColumnTable();
	}

	protected void populateDefaultColumnTable() {
	String defaultTableName = column.getDefaultTable();
	int selectionIndex = tableCombo.getSelectionIndex();
	tableCombo.setItem(0, NLS.bind(JptUiMappingsMessages.ColumnComposite_defaultWithOneParam, defaultTableName));
	if (selectionIndex == 0) {
	//combo text does not update when switching between 2 mappings of the same type
	//that both have a default column name. clear the selection and then set it again
	tableCombo.clearSelection();
	tableCombo.select(0);
	}
	}

	protected void populateColumnTable() {
	String tableName = this.column.getSpecifiedTable();
	String defaultTableName = this.column.getDefaultTable();
	if (tableName != null) {
	if (!this.tableCombo.getText().equals(tableName)) {
	this.tableCombo.setText(tableName);
	}
	}
	else {
	if (!this.tableCombo.getText().equals(NLS.bind(JptUiMappingsMessages.ColumnComposite_defaultWithOneParam, defaultTableName))) {
	this.tableCombo.select(0);
	}
	}
	}

	public void doPopulate(EObject obj) {
	this.column = (IColumn) obj;
	if (this.column != null) {
	populateColumnCombo();
	populateTableCombo();
	}
	this.insertableComboViewer.populate(new InsertableHolder(this.column));
	this.updatableComboViewer.populate(new UpdatableHolder(this.column));
	}

	public void doPopulate() {
	if (this.column != null) {
	populateColumnCombo();
	populateTableCombo();
	}
	else {
	this.connectionProfile = null;
	}
	this.insertableComboViewer.populate();
	this.updatableComboViewer.populate();
	}

	protected void enableWidgets(boolean enabled) {
	this.columnCombo.setEnabled(enabled);
	this.tableCombo.setEnabled(enabled);
	this.insertableComboViewer.getControl().setEnabled(enabled);
	this.updatableComboViewer.getControl().setEnabled(enabled);
	}

	@Override
	public void dispose() {
	this.insertableComboViewer.dispose();
	this.updatableComboViewer.dispose();
	super.dispose();
	}

	private class InsertableHolder extends EObjectImpl implements EnumHolder {

	private IAbstractColumn column;

	InsertableHolder(IAbstractColumn column) {
	super();
	this.column = column;
	}

	public Object get() {
	return this.column.getInsertable();
	}

	public void set(Object enumSetting) {
	this.column.setInsertable((DefaultTrueBoolean) enumSetting);

	}

	public Class featureClass() {
	return IAbstractColumn.class;
	}

	public int featureId() {
	return JpaCoreMappingsPackage.IABSTRACT_COLUMN__INSERTABLE;
	}

	public EObject wrappedObject() {
	return this.column;
	}

	public Object[] enumValues() {
	return DefaultTrueBoolean.VALUES.toArray();
	}

	public Object defaultValue() {
	return DefaultTrueBoolean.DEFAULT;
	}

	public String defaultString() {
	//TODO move this out of the UI into the model
	return "True";
	}
	}

	private class UpdatableHolder extends EObjectImpl implements EnumHolder {

	private IAbstractColumn column;

	UpdatableHolder(IAbstractColumn column) {
	super();
	this.column = column;
	}

	public Object get() {
	return this.column.getUpdatable();
	}

	public void set(Object enumSetting) {
	this.column.setUpdatable((DefaultTrueBoolean) enumSetting);

	}

	public Class featureClass() {
	return IAbstractColumn.class;
	}

	public int featureId() {
	return JpaCoreMappingsPackage.IABSTRACT_COLUMN__UPDATABLE;
	}

	public EObject wrappedObject() {
	return this.column;
	}

	public Object[] enumValues() {
	return DefaultTrueBoolean.VALUES.toArray();
	}

	public Object defaultValue() {
	return DefaultTrueBoolean.DEFAULT;
	}

	public String defaultString() {
	//TODO move this out of the UI into the model
	return "True";
	}
	}
	}