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

Class DBUtil

java.lang.Object

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

public class DBUtil
extends Object

Author:

Budi Yanto, KNIME.com

Field Summary

Fields

Modifier and Type	Field and Description
(package private) static String	SQL_TYPE_BLOB Default SQL-Type for Binary
(package private) static String	SQL_TYPE_BOOLEAN Default SQL-Type for Boolean
(package private) static String	SQL_TYPE_DATEANDTIME Default SQL-Type for Timestamps
(package private) static String	SQL_TYPE_DOUBLE Default SQL-Type for Double
(package private) static String	SQL_TYPE_INTEGER Default SQL-Type for Integer
(package private) static String	SQL_TYPE_STRING Default SQL-Type for String

Constructor Summary

Constructors

Constructor and Description
DBUtil()

Method Summary

Modifier and Type	Method and Description
(package private) static String	getDefaultSQLType(DataType knimeType)
(package private) static List<DataType>	getKNIMETypeList(DataTableSpec spec)
(package private) static List<String>	getSqlTypes()
(package private) static List<String>	getSqlTypes(String dbIdentifier)
(package private) static Map<DataType,Set<String>>	getSqlTypesMap()
(package private) static Map<DataType,Set<String>>	getSqlTypesMap(String dbIdentifier)

Methods inherited from class java.lang.Object

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

Field Detail

SQL_TYPE_STRING

static final String SQL_TYPE_STRING

Default SQL-Type for String

See Also:

Constant Field Values

SQL_TYPE_BOOLEAN

static final String SQL_TYPE_BOOLEAN

Default SQL-Type for Boolean

See Also:

Constant Field Values

SQL_TYPE_INTEGER

static final String SQL_TYPE_INTEGER

Default SQL-Type for Integer

See Also:

Constant Field Values

SQL_TYPE_DOUBLE

static final String SQL_TYPE_DOUBLE

Default SQL-Type for Double

See Also:

Constant Field Values

SQL_TYPE_DATEANDTIME

static final String SQL_TYPE_DATEANDTIME

Default SQL-Type for Timestamps

See Also:

Constant Field Values

SQL_TYPE_BLOB

static final String SQL_TYPE_BLOB

Default SQL-Type for Binary

See Also:

Constant Field Values

Constructor Detail

DBUtil

public DBUtil()

Method Detail

getKNIMETypeList

static List<DataType> getKNIMETypeList(DataTableSpec spec)

Parameters:

spec -

Returns:

the List of DataTypes the user can choose from

getSqlTypesMap

static Map<DataType,Set<String>> getSqlTypesMap()

getSqlTypesMap

static Map<DataType,Set<String>> getSqlTypesMap(String dbIdentifier)

getSqlTypes

static List<String> getSqlTypes(String dbIdentifier)

getSqlTypes

static List<String> getSqlTypes()

Returns:

all supported SQL types

getDefaultSQLType

static String getDefaultSQLType(DataType knimeType)

Parameters:

knimeType - the KNIME data type whose default SQL type should be returned

Returns:

the default SQL type of the given KNIME data type