org.datanucleus.query.typesafe
Interface TypesafeQuery<T>

public interface TypesafeQuery<T>

Interface for a type-safe query, using a fluent API. Designed to handle JDO query requirements as a whole.

Field Summary

static String

QUERY_CLASS_PREFIX

Method Summary

TypesafeQuery<T>	addExtension(String key, Object value) Add a vendor-specific extension to this query.
PersistableExpression	candidate() Method to return an expression for the candidate of the query.
CharacterExpression	characterParameter(String name) Method to return a character parameter for the query.
void	close(Object result) Method to close the specified query result.
void	closeAll() Method to close all query results from this query.
CollectionExpression	collectionParameter(String name) Method to return a collection parameter for the query.
DateExpression<Date>	dateParameter(String name) Method to return a date parameter for the query.
DateTimeExpression<Date>	datetimeParameter(String name) Method to return a datetime parameter for the query.
long	deletePersistentAll() Method to execute the query deleting the affected instances.
NumericExpression<Double>	doubleParameter(String name) Method to return a numeric parameter for the query.
TypesafeQuery<T>	excludeSubclasses() Method to remove subclasses (of the candidate) from the query
<T> List<T>	executeList() Method to execute the query where there are (potentially) multiple rows and we are returning the candidate type.
List<Object[]>	executeResultList(boolean distinct, Expression... exprs) Method to execute the query where there are (potentially) multiple rows and we have a result defined but no result class.
List<Object>	executeResultList(boolean distinct, Expression expr) Method to execute the query where there are (potentially) multiple rows and we have a single result defined but no result class.
<R> List<R>	executeResultList(Class<R> resultCls, boolean distinct, Expression... exprs) Method to execute the query where there are (potentially) multiple rows and we are returning either a result type or the candidate type.
Object[]	executeResultUnique(boolean distinct, Expression... exprs) Method to execute the query where there is a single row and we have a result defined but no result class.
Object	executeResultUnique(boolean distinct, Expression expr) Method to execute the query where there is a single row and we have a single result defined but no result class.
<R> R	executeResultUnique(Class<R> resultCls, boolean distinct, Expression... exprs) Method to execute the query where there is a single row and we are returning either a result type or the candidate type.
<T> T	executeUnique() Method to execute the query where there is a single row and we are returning the candidate type.
TypesafeQuery<T>	filter(BooleanExpression expr) Method to set the filter of the query.
NumericExpression<Float>	floatParameter(String name) Method to return a numeric parameter for the query.
javax.jdo.FetchPlan	getFetchPlan() Accessor for the FetchPlan for this query
javax.jdo.PersistenceManager	getPersistenceManager() Accessor for the PersistenceManager for this query
TypesafeQuery<T>	groupBy(Expression... exprs) Method to set the grouping(s) for the query.
TypesafeQuery<T>	having(Expression expr) Method to set the having clause of the query.
TypesafeQuery<T>	includeSubclasses() Method to include subclasses (of the candidate) to the query
NumericExpression<Integer>	integerParameter(String name) Method to return a numeric parameter for the query.
ListExpression	listParameter(String name) Method to return a list parameter for the query.
NumericExpression<Long>	longParameter(String name) Method to return a numeric parameter for the query.
MapExpression	mapParameter(String name) Method to return a map parameter for the query.
TypesafeQuery<T>	orderBy(OrderExpression... orderExprs) Method to set the ordering of the query.
Expression	parameter(String name, Class type) Method to return a parameter for the query.
TypesafeQuery<T>	range(Expression paramLowerInclExpr, Expression paramUpperExclExpr) Method to set the range of any required results, using parameters (expressions).
TypesafeQuery<T>	range(long lowerIncl, long upperExcl) Method to set the range of any required results, using long values.
TypesafeQuery<T>	range(NumericExpression lowerInclExpr, NumericExpression upperExclExpr) Method to set the range of any required results, using expressions.
TypesafeQuery<T>	setCandidates(Collection<T> candidates) Method to set the candidates to use over which we are querying.
TypesafeQuery<T>	setExtensions(Map<String,Object> extensions) Set multiple extensions, or use null to clear all extensions.
TypesafeQuery<T>	setIgnoreCache(boolean ignore) Whether the query should ignore the cache and go straight to the datastore.
TypesafeQuery<T>	setParameter(Expression paramExpr, Object value) Method to set a parameter value for use when executing the query.
TypesafeQuery<T>	setParameter(String paramName, Object value) Method to set a parameter value for use when executing the query.
NumericExpression<Short>	shortParameter(String name) Method to return a numeric parameter for the query.
StringExpression	stringParameter(String name) Method to return a string parameter for the query.
<S> TypesafeSubquery<S>	subquery(Class<S> candidate, String candidateAlias) Method to return a subquery for use in this query.
TypesafeSubquery<T>	subquery(String candidateAlias) Method to return a subquery for use in this query using the same candidate class as this query.
TimeExpression<Time>	timeParameter(String name) Method to return a time parameter for the query.
String	toString() Method to return the equivalent String form of this query (if applicable for the query language).
Expression	variable(String name, Class type) Method to return a variable for this query.

Field Detail

QUERY_CLASS_PREFIX

static final String QUERY_CLASS_PREFIX

See Also:

Constant Field Values

Method Detail

candidate

PersistableExpression candidate()

Method to return an expression for the candidate of the query. Cast the returned expression to the candidate "Q" type to be able to call methods on it. This calls the method "Q{type}.candidate(null)" The preference is to use the "Q{type}.candidate()" method for real type-safe handling.

Returns:

Expression for the candidate

parameter

Expression parameter(String name,
                     Class type)

Method to return a parameter for the query. Cast the returned parameter to the right type to be able to call methods on it. The preference is to use the "xxxParameter(String)" methods for real type-safe handling.

Parameters:

name - Name of the parameter

type - Java type of the parameter

Returns:

Expression for the parameter

stringParameter

StringExpression stringParameter(String name)

Method to return a string parameter for the query.

Parameters:

name - Name of the parameter

Returns:

StringExpression for the parameter

characterParameter

CharacterExpression characterParameter(String name)

Method to return a character parameter for the query.

Parameters:

name - Name of the parameter

Returns:

Expression for the parameter

longParameter

NumericExpression<Long> longParameter(String name)

Method to return a numeric parameter for the query.

Parameters:

name - Name of the parameter

Returns:

NumericExpression for the parameter

integerParameter

NumericExpression<Integer> integerParameter(String name)

Method to return a numeric parameter for the query.

Parameters:

name - Name of the parameter

Returns:

NumericExpression for the parameter

shortParameter

NumericExpression<Short> shortParameter(String name)

Method to return a numeric parameter for the query.

Parameters:

name - Name of the parameter

Returns:

NumericExpression for the parameter

doubleParameter

NumericExpression<Double> doubleParameter(String name)

Method to return a numeric parameter for the query.

Parameters:

name - Name of the parameter

Returns:

NumericExpression for the parameter

floatParameter

NumericExpression<Float> floatParameter(String name)

Method to return a numeric parameter for the query.

Parameters:

name - Name of the parameter

Returns:

NumericExpression for the parameter

dateParameter

DateExpression<Date> dateParameter(String name)

Method to return a date parameter for the query.

Parameters:

name - Name of the parameter

Returns:

Expression for the parameter

timeParameter

TimeExpression<Time> timeParameter(String name)

Method to return a time parameter for the query.

Parameters:

name - Name of the parameter

Returns:

Expression for the parameter

datetimeParameter

DateTimeExpression<Date> datetimeParameter(String name)

Method to return a datetime parameter for the query.

Parameters:

name - Name of the parameter

Returns:

Expression for the parameter

collectionParameter

CollectionExpression collectionParameter(String name)

Method to return a collection parameter for the query.

Parameters:

name - Name of the parameter

Returns:

Expression for the parameter

mapParameter

MapExpression mapParameter(String name)

Method to return a map parameter for the query.

Parameters:

name - Name of the parameter

Returns:

Expression for the parameter

listParameter

ListExpression listParameter(String name)

Method to return a list parameter for the query.

Parameters:

name - Name of the parameter

Returns:

Expression for the parameter

variable

Expression variable(String name,
                    Class type)

Method to return a variable for this query. Cast the returned variable to the right type to be able to call methods on it.

Parameters:

name - Name of the variable

type - Type of the variable

Returns:

Expression for the variable

getPersistenceManager

javax.jdo.PersistenceManager getPersistenceManager()

Accessor for the PersistenceManager for this query

Returns:

The PersistenceManager

getFetchPlan

javax.jdo.FetchPlan getFetchPlan()

Accessor for the FetchPlan for this query

Returns:

The FetchPlan

setIgnoreCache

TypesafeQuery<T> setIgnoreCache(boolean ignore)

Whether the query should ignore the cache and go straight to the datastore.

Parameters:

ignore - Ignore the cache flag

Returns:

The query

setCandidates

TypesafeQuery<T> setCandidates(Collection<T> candidates)

Method to set the candidates to use over which we are querying. If no candidates are set then the query is performed on the datastore.

Parameters:

candidates - The candidates

Returns:

The query

excludeSubclasses

TypesafeQuery<T> excludeSubclasses()

Method to remove subclasses (of the candidate) from the query

Returns:

The query

includeSubclasses

TypesafeQuery<T> includeSubclasses()

Method to include subclasses (of the candidate) to the query

Returns:

The query

filter

TypesafeQuery<T> filter(BooleanExpression expr)

Method to set the filter of the query.

Parameters:

expr - Filter expression

Returns:

The query

groupBy

TypesafeQuery<T> groupBy(Expression... exprs)

Method to set the grouping(s) for the query.

Parameters:

exprs - Grouping expression(s)

Returns:

The query

having

TypesafeQuery<T> having(Expression expr)

Method to set the having clause of the query.

Parameters:

expr - Having expression

Returns:

The query

orderBy

TypesafeQuery<T> orderBy(OrderExpression... orderExprs)

Method to set the ordering of the query.

Parameters:

orderExprs - Ordering expression(s)

Returns:

The query

range

TypesafeQuery<T> range(NumericExpression lowerInclExpr,
                       NumericExpression upperExclExpr)

Method to set the range of any required results, using expressions.

Parameters:

lowerInclExpr - The position of the first result (inclusive)

upperExclExpr - The position of the last result (exclusive)

Returns:

The query

range

TypesafeQuery<T> range(long lowerIncl,
                       long upperExcl)

Method to set the range of any required results, using long values.

Parameters:

lowerIncl - The position of the first result (inclusive)

upperExcl - The position of the last result (exclusive)

Returns:

The query

range

TypesafeQuery<T> range(Expression paramLowerInclExpr,
                       Expression paramUpperExclExpr)

Method to set the range of any required results, using parameters (expressions).

Parameters:

paramLowerInclExpr - Expression for a parameter defining the position of the first result (inclusive)

paramUpperExclExpr - Expression for a parameter defining the position of the last result (exclusive)

Returns:

The query

subquery

TypesafeSubquery<T> subquery(String candidateAlias)

Method to return a subquery for use in this query using the same candidate class as this query. To obtain the expression for the subquery to link it back to this query, call "result(...)" on the subquery.

Parameters:

candidateAlias - Alias for the candidate

Returns:

The subquery

subquery

<S> TypesafeSubquery<S> subquery(Class<S> candidate,
                                 String candidateAlias)

Method to return a subquery for use in this query. To obtain the expression for the subquery to link it back to this query, call "result(...)" on the subquery.

Parameters:

candidate - Candidate for the subquery

candidateAlias - Alias for the candidate

Returns:

The subquery

setParameter

TypesafeQuery<T> setParameter(Expression paramExpr,
                              Object value)

Method to set a parameter value for use when executing the query.

Parameters:

paramExpr - Parameter expression

value - The value

Returns:

The query

setParameter

TypesafeQuery<T> setParameter(String paramName,
                              Object value)

Method to set a parameter value for use when executing the query.

Parameters:

paramName - Parameter name

value - The value

Returns:

The query

addExtension

TypesafeQuery<T> addExtension(String key,
                              Object value)

Add a vendor-specific extension to this query. The key and value are not standard. An implementation must ignore keys that are not recognized.

Parameters:

key - the key of the extension

value - the value of the extension

Returns:

The query

setExtensions

TypesafeQuery<T> setExtensions(Map<String,Object> extensions)

Set multiple extensions, or use null to clear all extensions. Map keys and values are not standard.

Parameters:

extensions - the map of extensions

Returns:

The query

See Also:

addExtension(java.lang.String, java.lang.Object)

executeList

<T> List<T> executeList()

Method to execute the query where there are (potentially) multiple rows and we are returning the candidate type.

Returns:

The results

executeUnique

<T> T executeUnique()

Method to execute the query where there is a single row and we are returning the candidate type.

Returns:

The result

executeResultList

<R> List<R> executeResultList(Class<R> resultCls,
                              boolean distinct,
                              Expression... exprs)

Method to execute the query where there are (potentially) multiple rows and we are returning either a result type or the candidate type.

Parameters:

resultCls - Result class

distinct - Whether to provide distinct results

exprs - Result expression(s)

Returns:

The results

executeResultUnique

<R> R executeResultUnique(Class<R> resultCls,
                          boolean distinct,
                          Expression... exprs)

Method to execute the query where there is a single row and we are returning either a result type or the candidate type.

Parameters:

resultCls - Result class

distinct - Whether to provide distinct results

exprs - Result expression(s)

Returns:

The result

executeResultList

List<Object> executeResultList(boolean distinct,
                               Expression expr)

Method to execute the query where there are (potentially) multiple rows and we have a single result defined but no result class.

Parameters:

distinct - Whether to provide distinct results

expr - Result expression

Returns:

The results

executeResultUnique

Object executeResultUnique(boolean distinct,
                           Expression expr)

Method to execute the query where there is a single row and we have a single result defined but no result class.

Parameters:

distinct - Whether to provide distinct results

expr - Result expression

Returns:

The results

executeResultList

List<Object[]> executeResultList(boolean distinct,
                                 Expression... exprs)

Method to execute the query where there are (potentially) multiple rows and we have a result defined but no result class.

Parameters:

distinct - Whether to provide distinct results

exprs - Result expression(s)

Returns:

The results

executeResultUnique

Object[] executeResultUnique(boolean distinct,
                             Expression... exprs)

Method to execute the query where there is a single row and we have a result defined but no result class.

Parameters:

distinct - Whether to provide distinct results

exprs - Result expression(s)

Returns:

The results

deletePersistentAll

long deletePersistentAll()

Method to execute the query deleting the affected instances.

Returns:

The number of objects deleted

close

void close(Object result)

Method to close the specified query result.

Parameters:

result - The result

closeAll

void closeAll()

Method to close all query results from this query.

toString

String toString()

Method to return the equivalent String form of this query (if applicable for the query language).

Overrides:

toString in class Object

Returns:

The single-string form of this query