org.knime.base.node.io.database.groupby.dialog.column

Class DBColumnAggregationFunctionPanel

java.lang.Object

java.awt.event.MouseAdapter

org.knime.base.data.aggregation.dialogutil.AbstractAggregationPanel<DBColumnAggregationFunctionTableModel,DBColumnAggregationFunctionRow,DataColumnSpec>

org.knime.base.node.io.database.groupby.dialog.column.DBColumnAggregationFunctionPanel

All Implemented Interfaces:

MouseListener, MouseMotionListener, MouseWheelListener, EventListener

public class DBColumnAggregationFunctionPanel
extends AbstractAggregationPanel<DBColumnAggregationFunctionTableModel,DBColumnAggregationFunctionRow,DataColumnSpec>

This class creates the aggregation column panel that allows the user to define the aggregation columns and their aggregation method.

Author:

Tobias Koetter, University of Konstanz

Field Summary

Fields inherited from class org.knime.base.data.aggregation.dialogutil.AbstractAggregationPanel

MISSING_CELL_OPTION_SIZE, PANEL_DIMENSION, SETTINGS_BUTTON_CELL_SIZE

Constructor Summary

Constructors

Constructor and Description
DBColumnAggregationFunctionPanel(String key) Constructor for class AggregationColumnPanel.
DBColumnAggregationFunctionPanel(String title, String key)

Method Summary

Modifier and Type	Method and Description
protected void	adaptTableColumnModel(TableColumnModel columnModel) Override this method to set specific renderer and column widths.
protected void	changeAggregationMethod(String methodId) Changes the aggregation method of all selected rows to the method with the given label.
protected DBColumnAggregationFunctionRow	createRow(DataColumnSpec colSpec)
protected JPopupMenu	createTablePopupMenu()
void	excludeColsChange(Collection<String> excludeColNames)
protected List<DBAggregationFunction>	getMethods4SelectedItems()
void	initialize(DataTableSpec spec, List<DBColumnAggregationFunctionRow> colAggrs) Initializes the panel.
void	loadSettingsFrom(NodeSettingsRO settings, String dbIdentifier, DataTableSpec spec)
(package private) int	noOfCompatibleRows(DataType type) Returns the number of rows that are compatible to the given type.
void	saveSettingsTo(NodeSettingsWO settings)
protected void	selectCompatibleRows(DataType type) Selects all rows that are compatible with the given type.
void	setAggregationFunctionProvider(AggregationFunctionProvider<DBAggregationFunction> provider)
void	validate() Validates the internal state of the aggregation functions.

Methods inherited from class org.knime.base.data.aggregation.dialogutil.AbstractAggregationPanel

addRows, appendMissingValuesEntry, createButtonComponent, createInvalidRowsSelectionMenu, createListComponent, createTableComponent, getComponentPanel, getInputTableSpec, getList, getListElements, getListModel, getMissingCellRenderer, getNoOfSelectedRows, getNoOfTableRows, getOperator, getSelectedRows, getTable, getTableModel, getTableMouseAdapter, initialize, onAddAll, onAddIt, onRemAll, onRemIt, selectAllCompatibleMethods, selectAllCompatibleRows, selectAllRows, selectAllSelectedMethods, tableRowsSelected, toggleMissingCellOption, updateSelection

Methods inherited from class java.awt.event.MouseAdapter

mouseClicked, mouseDragged, mouseEntered, mouseExited, mouseMoved, mousePressed, mouseReleased, mouseWheelMoved

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DBColumnAggregationFunctionPanel

public DBColumnAggregationFunctionPanel(String key)

Constructor for class AggregationColumnPanel.

Parameters:

key - the unique settings key

DBColumnAggregationFunctionPanel

public DBColumnAggregationFunctionPanel(String title,
                                        String key)

Parameters:

title - the title of the border or null for no border

key - the unique settings key

Method Detail

createTablePopupMenu

protected JPopupMenu createTablePopupMenu()

Specified by:

createTablePopupMenu in class AbstractAggregationPanel<DBColumnAggregationFunctionTableModel,DBColumnAggregationFunctionRow,DataColumnSpec>

Returns:

the JPopupMenu or null for no popup menu

setAggregationFunctionProvider

public void setAggregationFunctionProvider(AggregationFunctionProvider<DBAggregationFunction> provider)

Parameters:

provider - the AggregationFunctionProvider

adaptTableColumnModel

protected void adaptTableColumnModel(TableColumnModel columnModel)

Override this method to set specific renderer and column widths. The missing cell option column is

Overrides:

adaptTableColumnModel in class AbstractAggregationPanel<DBColumnAggregationFunctionTableModel,DBColumnAggregationFunctionRow,DataColumnSpec>

Parameters:

columnModel - the TableColumnModel to adapt

changeAggregationMethod

protected void changeAggregationMethod(String methodId)

Changes the aggregation method of all selected rows to the method with the given label.

Parameters:

methodId - the label of the aggregation method

selectCompatibleRows

protected void selectCompatibleRows(DataType type)

Selects all rows that are compatible with the given type.

Parameters:

type - the type to check for compatibility

noOfCompatibleRows

int noOfCompatibleRows(DataType type)

Returns the number of rows that are compatible to the given type.

Parameters:

type - the type to check for

Returns:

the number of compatible rows

excludeColsChange

public void excludeColsChange(Collection<String> excludeColNames)

Parameters:

excludeColNames - the name of all columns that should be excluded from the aggregation panel

saveSettingsTo

public void saveSettingsTo(NodeSettingsWO settings)

Parameters:

settings - the settings object to write to

loadSettingsFrom

public void loadSettingsFrom(NodeSettingsRO settings,
                             String dbIdentifier,
                             DataTableSpec spec)
                      throws InvalidSettingsException

Parameters:

settings - the settings to read from

dbIdentifier - the database identifier

spec - initializes the component

Throws:

InvalidSettingsException - if the settings are invalid

validate

public void validate()
              throws InvalidSettingsException

Validates the internal state of the aggregation functions.

Overrides:

validate in class AbstractAggregationPanel<DBColumnAggregationFunctionTableModel,DBColumnAggregationFunctionRow,DataColumnSpec>

Throws:

InvalidSettingsException - if the internal state of a function is invalid

initialize

public void initialize(DataTableSpec spec,
                       List<DBColumnAggregationFunctionRow> colAggrs)

Initializes the panel.

Parameters:

spec - the DataTableSpec of the input table

colAggrs - the List of ColumnAggregators that are initially used

getMethods4SelectedItems

protected List<DBAggregationFunction> getMethods4SelectedItems()

Returns:

a label list of all supported methods for the currently selected rows

createRow

protected DBColumnAggregationFunctionRow createRow(DataColumnSpec colSpec)

Specified by:

createRow in class AbstractAggregationPanel<DBColumnAggregationFunctionTableModel,DBColumnAggregationFunctionRow,DataColumnSpec>

Parameters:

colSpec - the list element to create the AggregationFunctionRow for

Returns:

the concrete implementation of the used AggregationFunctionRow class