Package simpleorm.dataset

Class SFieldTimestamp

java.lang.Object

simpleorm.dataset.SFieldMeta

simpleorm.dataset.SFieldScalar

simpleorm.dataset.SFieldTimestamp

All Implemented Interfaces:

Serializable

Direct Known Subclasses:

DateField

public class SFieldTimestamp
extends SFieldScalar

Represents Timestamp field meta data. See getSqlType for issues.

See Also:

• Serialized Form

Field Summary

Fields inherited from class simpleorm.dataset.SFieldScalar

sqlDataTypeOverride, theGenerator

Fields inherited from class simpleorm.dataset.SFieldMeta

quoteName

Constructor Summary

Constructors

Constructor	Description
SFieldTimestamp(SRecordMeta meta, String columnName, SFieldFlags... pvals)

Method Summary

Modifier and Type	Method	Description
protected Object	convertToDataSetFieldType(Object raw)	Converts the parameter from the raw type parameter to the correct internal Object type that is stored in the data set.
String	defaultSqlDataType()	Time & date is a mess in SQL.
boolean	isFKeyCompatible(SFieldScalar field)
int	javaSqlType()
Object	queryFieldValue(ResultSet rs, int sqlIndex)	Issues a JDBC get*() on the result set for the field and converts the database type to the appropriate internal type, eg, Double for a double field.

Methods inherited from class simpleorm.dataset.SFieldScalar

getColumnName, getGeneratorMode, getGeneratorParameter, getMaxSize, getReferences, getTheGenerator, isForeignKey, isGenerated, isMandatory, isNotOptimisticLocked, isPrimary, overrideSqlDataType, setGeneratorMode, setMaxSize, setTheGenerator, toLongerString

Methods inherited from class simpleorm.dataset.SFieldMeta

addFlag, addValidator, doValidate, equals, getFieldName, getFlags, getRecordMeta, getUserProperties, getUserProperty, getValidators, hashCode, isDescriptive, isUnqueried, nextGeneratedValue, putUserProperty, readResolve, setQuoted, toString, writeFieldValue, writeFieldValue

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Constructor Details

SFieldTimestamp

public SFieldTimestamp(SRecordMeta meta,
 String columnName,
 SFieldFlags... pvals)

Method Details

queryFieldValue

public Object queryFieldValue(ResultSet rs,
 int sqlIndex)
                       throws Exception

Description copied from class: SFieldMeta

Issues a JDBC get*() on the result set for the field and converts the database type to the appropriate internal type, eg, Double for a double field. The first column has sqlIndex==1.

Specified by:

queryFieldValue in class SFieldMeta

Throws:

Exception

convertToDataSetFieldType

protected Object convertToDataSetFieldType(Object raw)
                                    throws Exception

Description copied from class: SFieldMeta

Converts the parameter from the raw type parameter to the correct internal Object type that is stored in the data set. Returns the object if no conversion necessary. Used by SRecordInstance.setObject etc., Not getObject.

Specified by:

convertToDataSetFieldType in class SFieldMeta

Throws:

Exception

defaultSqlDataType

public String defaultSqlDataType()

Time & date is a mess in SQL.

ISO-92: seems to only support TIMESTAMP. Maybe WITH TIME ZONE. HSQL: Seems to support both TIMESTAMP and DATETIME. No WITH TIME ZONE. MSSQL: TIMESTAMP is not a time, but a transaction id like thing. DATETIME is a date time. POSTGRESQL: Appears to support both TIMESTAMP and DATETIME. Suports? WITH TIME ZONE. MySQL: DATETIME and TIMESTAMP are different data types with different precission.

TIMESTAMP is ISO, seems to be lowest common denominator.

Specified by:

defaultSqlDataType in class SFieldScalar

isFKeyCompatible

public boolean isFKeyCompatible(SFieldScalar field)

javaSqlType

public int javaSqlType()

Specified by:

javaSqlType in class SFieldScalar

Returns:

int constant from java.sql.Types, used for setting sql datatype with null values