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
All Methods Instance Methods Abstract Methods 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 theCell.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
-
-
-
-
Method Detail
-
sqlTypeToContentType
public abstract Cell.ContentType sqlTypeToContentType(int colType)
Determines theCell.ContentType
from the SQL column type. SeeTypes
.- 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 forstringType
- the default string type- Returns:
- the associated create string
-
-