Package adams.data.spreadsheet.sql

Class DefaultTypeMapper

java.lang.Object

adams.core.logging.LoggingObject

adams.core.logging.CustomLoggingLevelObject

adams.core.option.AbstractOptionHandler

adams.data.spreadsheet.sql.AbstractTypeMapper

adams.data.spreadsheet.sql.DefaultTypeMapper

All Implemented Interfaces:

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

Direct Known Subclasses:

MSSQLServerTypeMapper

public class DefaultTypeMapper
extends AbstractTypeMapper

Default type mapper, works with MySQL and PostgreSQL.

-logging-level <OFF|SEVERE|WARNING|INFO|CONFIG|FINE|FINER|FINEST> (property: loggingLevel)
    The logging level for outputting errors and debugging output.
    default: WARNING
 

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
DefaultTypeMapper()

Method Summary

Modifier and Type	Method	Description
String	contentTypeToSqlCreateType(Cell.ContentType contentType, String stringType)	Returns the column type used for create table statements.
int	contentTypeToSqlType(Cell.ContentType contentType)	Returns the SQL type corresponding to the cell content type.
String	globalInfo()	Returns a string describing the object.
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, 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

DefaultTypeMapper

public DefaultTypeMapper()

Method Detail

globalInfo

public String globalInfo()

Returns a string describing the object.

Specified by:

globalInfo in interface GlobalInfoSupporter

Specified by:

globalInfo in class AbstractOptionHandler

Returns:

a description suitable for displaying in the gui

sqlTypeToContentType

public Cell.ContentType sqlTypeToContentType(int colType)

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

Specified by:

sqlTypeToContentType in class AbstractTypeMapper

Parameters:

colType - the SQL column type to interpret

Returns:

the type, default is Cell.ContentType.STRING

contentTypeToSqlType

public int contentTypeToSqlType(Cell.ContentType contentType)

Returns the SQL type corresponding to the cell content type.

Specified by:

contentTypeToSqlType in class AbstractTypeMapper

Parameters:

contentType - the type to convert

Returns:

the associated SQL type

See Also:

Types

contentTypeToSqlCreateType

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

Returns the column type used for create table statements.

Specified by:

contentTypeToSqlCreateType in class AbstractTypeMapper

Parameters:

contentType - the type to get the type for

stringType - the default string type

Returns:

the associated create string