Package adams.data.spreadsheet.sql

Class AbstractTypeMapper

java.lang.Object

adams.core.logging.LoggingObject

adams.core.logging.CustomLoggingLevelObject

adams.core.option.AbstractOptionHandler

adams.data.spreadsheet.sql.AbstractTypeMapper

All Implemented Interfaces:

Destroyable, GlobalInfoSupporter, LoggingLevelHandler, LoggingSupporter, OptionHandler, SizeOfHandler, Serializable

Direct Known Subclasses:

DefaultTypeMapper

public abstract class AbstractTypeMapper
extends AbstractOptionHandler

Ancestor for type mappers (spreadsheet to/from SQL).

Version:

$Revision$

Author:

FracPete (fracpete at waikato dot ac dot nz)

See Also:

Serialized Form

Field Summary

Fields inherited from class adams.core.option.AbstractOptionHandler

m_OptionManager

Fields inherited from class adams.core.logging.LoggingObject

m_Logger, m_LoggingIsEnabled, m_LoggingLevel

Constructor Summary

Constructors

Constructor	Description
AbstractTypeMapper()

Method Summary

Modifier and Type	Method	Description
abstract String	contentTypeToSqlCreateType(Cell.ContentType contentType, String stringType)	Returns the column type used for create table statements.
abstract int	contentTypeToSqlType(Cell.ContentType contentType)	Returns the SQL type corresponding to the cell content type.
abstract Cell.ContentType	sqlTypeToContentType(int colType)	Determines the Cell.ContentType from the SQL column type.

Methods inherited from class adams.core.option.AbstractOptionHandler

cleanUpOptions, defineOptions, destroy, finishInit, getDefaultLoggingLevel, getOptionManager, globalInfo, initialize, loggingLevelTipText, newOptionManager, reset, setLoggingLevel, toCommandLine, toString

Methods inherited from class adams.core.logging.LoggingObject

configureLogger, getLogger, getLoggingLevel, initializeLogging, isLoggingEnabled, sizeOf

Methods inherited from class java.lang.Object

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

Methods inherited from interface adams.core.logging.LoggingLevelHandler

getLoggingLevel

Constructor Detail

AbstractTypeMapper

public AbstractTypeMapper()

Method Detail

sqlTypeToContentType

public abstract Cell.ContentType sqlTypeToContentType(int colType)

Determines the Cell.ContentType from the SQL column type. See Types.

Parameters:

colType - the SQL column type to interpret

Returns:

the type, default is Cell.ContentType.STRING

contentTypeToSqlType

public abstract int contentTypeToSqlType(Cell.ContentType contentType)

Returns the SQL type corresponding to the cell content type.

Parameters:

contentType - the type to convert

Returns:

the associated SQL type

See Also:

Types

contentTypeToSqlCreateType

public abstract String contentTypeToSqlCreateType(Cell.ContentType contentType,
                                                  String stringType)

Returns the column type used for create table statements.

Parameters:

contentType - the type to get the type for

stringType - the default string type

Returns:

the associated create string