org.josql.functions

Class ConversionFunctions

java.lang.Object

org.josql.functions.AbstractFunctionHandler

org.josql.functions.ConversionFunctions

All Implemented Interfaces:

FunctionHandler

public class ConversionFunctions
extends AbstractFunctionHandler

Note: creating new instances of SimpleDateFormat objects are VERY costly over large(ish) numbers of objects therefore a cache of objects is provided.

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	DAY Represents the Calendar.DATE field, is: d.
static java.lang.String	DEFAULT_DATE_FORMAT_SPEC
static java.lang.String	DEFAULT_DATE_FORMAT_SPEC_2
static java.lang.String	DEFAULT_DATE_FORMAT_SPEC_3
static java.lang.String	HANDLER_ID
static java.lang.String	HOUR Represents the Calendar.HOUR_OF_DAY field, is: h.
static java.lang.String	MINUTE Represents the Calendar.MINUTE field, is: mi.
static java.lang.String	MONTH Represents the Calendar.MONTH field, is: m.
static java.lang.String	SECOND Represents the Calendar.SECOND field, is: s.
static java.lang.String	WEEK Represents the Calendar.WEEK_OF_YEAR field, is: w.
static java.lang.String	YEAR Represents the Calendar.YEAR field, is: y.

Fields inherited from class org.josql.functions.AbstractFunctionHandler

q

Constructor Summary

Constructors

Constructor and Description
ConversionFunctions()

Method Summary

Modifier and Type	Method and Description
java.util.Date	addTime(java.util.Date d, java.lang.Double amount, java.lang.String type)
java.lang.String	lower(java.lang.Object o)
int	timeField(java.lang.Object d, java.lang.String type) This method (function) will return the associated field from a Calendar instance.
java.util.Date	to_date(java.lang.Object value)
java.util.Date	to_date(java.lang.String value, java.lang.String spec)
java.lang.Number	to_number(java.lang.Object o)
java.lang.String	to_string(java.lang.Object o)
java.util.Date	toDate(java.lang.Object value)
java.util.Date	toDate(java.lang.String value, java.lang.String spec)
java.lang.Long	toDateMillis(java.lang.String value, java.lang.String spec)
java.lang.Long	toMillis(java.util.Date d)
java.lang.Number	toNumber(java.lang.Object o)
java.lang.String	toString(java.lang.Object o)
java.lang.String	upper(java.lang.Object o)

Methods inherited from class org.josql.functions.AbstractFunctionHandler

setQuery

Methods inherited from class java.lang.Object

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

Field Detail

HANDLER_ID

public static final java.lang.String HANDLER_ID

See Also:

Constant Field Values

MINUTE

public static final java.lang.String MINUTE

Represents the Calendar.MINUTE field, is: mi.

See Also:

Constant Field Values

DAY

public static final java.lang.String DAY

Represents the Calendar.DATE field, is: d.

See Also:

Constant Field Values

YEAR

public static final java.lang.String YEAR

Represents the Calendar.YEAR field, is: y.

See Also:

Constant Field Values

SECOND

public static final java.lang.String SECOND

Represents the Calendar.SECOND field, is: s.

See Also:

Constant Field Values

HOUR

public static final java.lang.String HOUR

Represents the Calendar.HOUR_OF_DAY field, is: h.

See Also:

Constant Field Values

MONTH

public static final java.lang.String MONTH

Represents the Calendar.MONTH field, is: m.

See Also:

Constant Field Values

WEEK

public static final java.lang.String WEEK

Represents the Calendar.WEEK_OF_YEAR field, is: w.

See Also:

Constant Field Values

DEFAULT_DATE_FORMAT_SPEC

public static java.lang.String DEFAULT_DATE_FORMAT_SPEC

DEFAULT_DATE_FORMAT_SPEC_2

public static java.lang.String DEFAULT_DATE_FORMAT_SPEC_2

DEFAULT_DATE_FORMAT_SPEC_3

public static java.lang.String DEFAULT_DATE_FORMAT_SPEC_3

Constructor Detail

ConversionFunctions

public ConversionFunctions()

Method Detail

timeField

public int timeField(java.lang.Object d,
                     java.lang.String type)
              throws QueryExecutionException

This method (function) will return the associated field from a Calendar instance. The type parm should be one of the constants from this class. The default TimeZone is used.

Parameters:

d - If the type is a long value then it is first converted to a Date. Or a Date should be used.

type - The type of field to get.

Returns:

The field from Calendar.

Throws:

QueryExecutionException - If the d parm isn't an instance of Long or Date.

addTime

public java.util.Date addTime(java.util.Date d,
                              java.lang.Double amount,
                              java.lang.String type)

toDate

public java.util.Date toDate(java.lang.Object value)
                      throws QueryExecutionException

Throws:

QueryExecutionException

to_date

public java.util.Date to_date(java.lang.Object value)
                       throws QueryExecutionException

Throws:

QueryExecutionException

to_date

public java.util.Date to_date(java.lang.String value,
                              java.lang.String spec)
                       throws QueryExecutionException

Throws:

QueryExecutionException

toDate

public java.util.Date toDate(java.lang.String value,
                             java.lang.String spec)
                      throws QueryExecutionException

Throws:

QueryExecutionException

toMillis

public java.lang.Long toMillis(java.util.Date d)

toDateMillis

public java.lang.Long toDateMillis(java.lang.String value,
                                   java.lang.String spec)
                            throws QueryExecutionException

Throws:

QueryExecutionException

upper

public java.lang.String upper(java.lang.Object o)

lower

public java.lang.String lower(java.lang.Object o)

to_string

public java.lang.String to_string(java.lang.Object o)

toString

public java.lang.String toString(java.lang.Object o)

to_number

public java.lang.Number to_number(java.lang.Object o)

toNumber

public java.lang.Number toNumber(java.lang.Object o)