org.knime.base.node.io.database.tablecreator.util

Class KNIMEBasedMappingElement

java.lang.Object

org.knime.base.node.io.database.tablecreator.util.RowElement

org.knime.base.node.io.database.tablecreator.util.KNIMEBasedMappingElement

class KNIMEBasedMappingElement
extends RowElement

KnimeBasedMapping row element of the KnimeBasedMappingPanel

Author:

Budi Yanto, KNIME.com

Field Summary

Fields

Modifier and Type	Field and Description
(package private) static Class<?>[]	COLUMN_CLASSES The column classes
(package private) static String[]	COLUMN_NAMES The column names
(package private) static DataType	DEFAULT_KNIME_TYPE Default KNIME type
(package private) static boolean	DEFAULT_NOT_NULL Default not null value
(package private) static String	DEFAULT_PREFIX Default prefix of this element
(package private) static String	DEFAULT_SQL_TYPE Default SQL type
(package private) static int	KNIME_TYPE_IDX The column index of the knime type in the table
(package private) static int	NOT_NULL_IDX The column index of the not null in the table
(package private) static int	SQL_TYPE_IDX The column index of the SQL type in the table

Constructor Summary

Constructors

Constructor and Description
KNIMEBasedMappingElement(DataType knimeType, String sqlType, boolean notNull) Creates a new instance of KnimeBasedMappingElement
KNIMEBasedMappingElement(NodeSettingsRO settings) Creates a new instance of KnimeBasedMappingElement

Method Summary

Modifier and Type	Method and Description
DataType	getKnimeType() Returns the Knime data type
String	getSqlType() Returns the SQL data type
boolean	isNotNull() Returns true if the generated column cannot be null, otherwise returns false
protected void	loadSettingsFrom(NodeSettingsRO settings) Load the attributes of RowElement from the given NodeSettingsRO instance
protected void	saveSettingsTo(NodeSettingsWO settings) Save the properties of RowElement to the NodeSettingsWO instance
(package private) void	setKnimeType(DataType knimeType) Sets the Knime data type
(package private) void	setNotNull(boolean notNull) Sets to true if the generated column cannot be null, otherwise sets to false
(package private) void	setSqlType(String sqlType) Sets the SQL data type

Methods inherited from class org.knime.base.node.io.database.tablecreator.util.RowElement

getPrefix

Methods inherited from class java.lang.Object

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

Field Detail

DEFAULT_PREFIX

static final String DEFAULT_PREFIX

Default prefix of this element

See Also:

Constant Field Values

KNIME_TYPE_IDX

static final int KNIME_TYPE_IDX

The column index of the knime type in the table

See Also:

Constant Field Values

SQL_TYPE_IDX

static final int SQL_TYPE_IDX

The column index of the SQL type in the table

See Also:

Constant Field Values

NOT_NULL_IDX

static final int NOT_NULL_IDX

The column index of the not null in the table

See Also:

Constant Field Values

COLUMN_NAMES

static final String[] COLUMN_NAMES

The column names

COLUMN_CLASSES

static final Class<?>[] COLUMN_CLASSES

The column classes

DEFAULT_KNIME_TYPE

static final DataType DEFAULT_KNIME_TYPE

Default KNIME type

DEFAULT_SQL_TYPE

static final String DEFAULT_SQL_TYPE

Default SQL type

See Also:

Constant Field Values

DEFAULT_NOT_NULL

static final boolean DEFAULT_NOT_NULL

Default not null value

See Also:

Constant Field Values

Constructor Detail

KNIMEBasedMappingElement

KNIMEBasedMappingElement(DataType knimeType,
                         String sqlType,
                         boolean notNull)

Creates a new instance of KnimeBasedMappingElement

Parameters:

knimeType - the Knime data type to map

sqlType - the SQL data type to be mapped to

notNull - default not null value of the generated column

KNIMEBasedMappingElement

KNIMEBasedMappingElement(NodeSettingsRO settings)

Creates a new instance of KnimeBasedMappingElement

Parameters:

settings - the NodeSettingsRO instance to load from

Method Detail

getKnimeType

public DataType getKnimeType()

Returns the Knime data type

Returns:

the knimeType

setKnimeType

void setKnimeType(DataType knimeType)

Sets the Knime data type

Parameters:

knimeType - the knimeType to set

getSqlType

public String getSqlType()

Returns the SQL data type

Returns:

the sqlType

setSqlType

void setSqlType(String sqlType)

Sets the SQL data type

Parameters:

sqlType - the sqlType to set

isNotNull

public boolean isNotNull()

Returns true if the generated column cannot be null, otherwise returns false

Returns:

true if the generated column cannot be null, otherwise false

setNotNull

void setNotNull(boolean notNull)

Sets to true if the generated column cannot be null, otherwise sets to false

Parameters:

notNull - true if the generated column cannot be null, otherwise false

loadSettingsFrom

protected void loadSettingsFrom(NodeSettingsRO settings)

Load the attributes of RowElement from the given NodeSettingsRO instance

Specified by:

loadSettingsFrom in class RowElement

Parameters:

settings - the NodeSettingsRO instance to load from

saveSettingsTo

protected void saveSettingsTo(NodeSettingsWO settings)

Save the properties of RowElement to the NodeSettingsWO instance

Specified by:

saveSettingsTo in class RowElement

Parameters:

settings - the NodeSettingsWO instance to save to