com.whitestein.lsps.engine.sharedrecord

Class QueryExecutor

java.lang.Object

com.whitestein.lsps.engine.sharedrecord.QueryExecutor

public class QueryExecutor
extends java.lang.Object

This class can execute queries given by the QuerySpecification.

Author:

rba

Constructor Summary

Constructors

Constructor and Description
QueryExecutor(ExecutionContext context) Creates new instance.
QueryExecutor(ExecutionContext context, InterpreterStackTrace stackTrace) Creates new instance.

Method Summary

Modifier and Type	Method and Description
boolean	contains(com.whitestein.lsps.model.sharedrecord.QuerySpecification spec, java.util.Collection<?> parameters, java.lang.Object entity) Returns true if the given query result list contains the given entity.
Decimal	count(ClosureHolder closureWithQuery, java.lang.String recordIterator, Expression additionalWhereExp) Dynamically creates query and executes it.
Decimal	count(com.whitestein.lsps.model.sharedrecord.HQLQuerySpecification spec, java.util.Collection<?> parameters) Executes the count query.
protected Decimal	count(java.util.List<com.whitestein.lsps.engine.sharedrecord.QueryExecutor.WhereExpression> whereExpressions) Dynamically creates query and executes it.
Decimal	count(com.whitestein.lsps.model.sharedrecord.QuerySpecification spec, java.util.Collection<?> parameters) Executes the given query and returns a list of results.
Decimal	count(com.whitestein.lsps.model.sharedrecord.SharedRecordType type, java.lang.String recordIterator, Expression whereExp) Dynamically creates query and executes it.
Decimal	countAll(RecordType recordType) Runs a count query for records of a given type.
java.util.List<com.whitestein.lsps.model.sharedrecord.ExternalRecordEntity>	getAll(RecordType recordType) Returns all the entities for the given type.
QueryResult<com.whitestein.lsps.model.sharedrecord.ExternalRecordEntity>	getAll(RecordType recordType, OrderingAndPagingCriteria pagingCriteria) Returns all the entities for the given type.
protected java.util.List<java.lang.Object>	getAuditResultList(java.util.List<com.whitestein.lsps.engine.sharedrecord.QueryExecutor.WhereExpression> whereExpressions, java.util.List<com.whitestein.lsps.model.sharedrecord.QueryOrderingItem> orderings, java.lang.Integer index, java.lang.Integer count, java.lang.Long revision, java.util.List<AuditCriteria> auditCriteria) Dynamically creates query and executes it.
java.util.List<java.lang.Object>	getAuditResultList(com.whitestein.lsps.model.sharedrecord.SharedRecordType type, java.lang.String recordIterator, Expression whereExp, java.util.List<com.whitestein.lsps.model.sharedrecord.QueryOrderingItem> orderings, java.lang.Integer index, java.lang.Integer count, java.lang.Long revision, java.util.List<AuditCriteria> auditCriteria) Dynamically creates query and executes it.
protected java.util.List<java.lang.Object>	getAuditResultListInternal(java.util.List<com.whitestein.lsps.engine.sharedrecord.QueryExecutor.WhereExpression> whereExpressions, java.util.List<com.whitestein.lsps.model.sharedrecord.QueryOrderingItem> orderings, java.lang.Integer index, java.lang.Integer count, java.lang.Long revision, java.util.List<AuditCriteria> auditCriteria)
java.util.List<java.lang.Object>	getAuditRevisions(java.lang.Object id, com.whitestein.lsps.model.sharedrecord.SharedRecordType sharedRecordType, java.util.Date from, java.util.Date to) Returns audit revisions.
java.util.List<java.lang.Object>	getResultList(ClosureHolder closureWithQuery, java.lang.String recordIterator, Expression additionalWhereExp, java.util.List<com.whitestein.lsps.model.sharedrecord.QueryOrderingItem> orderings, java.lang.Integer index, java.lang.Integer count) Dynamically creates query and executes it.
java.util.List<com.whitestein.lsps.model.sharedrecord.ExternalRecordEntity>	getResultList(com.whitestein.lsps.model.sharedrecord.HQLQuerySpecification spec, java.util.Collection<?> parameters) Executes the query and returns a result list.
protected java.util.List<java.lang.Object>	getResultList(java.util.List<com.whitestein.lsps.engine.sharedrecord.QueryExecutor.WhereExpression> whereExpressions, com.whitestein.lsps.engine.sharedrecord.QueryExecutor.Orderings orderings, java.lang.Integer index, java.lang.Integer count) Dynamically creates query and executes it.
java.util.List<com.whitestein.lsps.model.sharedrecord.ExternalRecordEntity>	getResultList(com.whitestein.lsps.model.sharedrecord.QuerySpecification spec, java.util.Collection<?> parameters) Executes the given query and returns a list of results.
QueryResult<com.whitestein.lsps.model.sharedrecord.ExternalRecordEntity>	getResultList(com.whitestein.lsps.model.sharedrecord.QuerySpecification spec, java.util.Collection<?> parameters, OrderingAndPagingCriteria pagingCriteria) Executes the given query and returns a list of results.
java.util.List<java.lang.Object>	getResultList(com.whitestein.lsps.model.sharedrecord.SharedRecordType type, java.lang.String recordIterator, Expression whereExp, java.util.List<com.whitestein.lsps.model.sharedrecord.QueryOrderingItem> orderings, java.lang.Integer index, java.lang.Integer count) Dynamically creates query and executes it.
protected org.hibernate.Session	getSession(java.lang.String jndi)
com.whitestein.lsps.model.sharedrecord.ExternalRecordEntity	getSingleResult(com.whitestein.lsps.model.sharedrecord.HQLQuerySpecification spec, java.util.Collection<?> parameters) Executes the query and returns a unique result.
com.whitestein.lsps.model.sharedrecord.ExternalRecordEntity	getSingleResult(com.whitestein.lsps.model.sharedrecord.QuerySpecification spec, java.util.Collection<?> parameters) Executes the given query and returns only the first result.

Methods inherited from class java.lang.Object

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

Constructor Detail

QueryExecutor

public QueryExecutor(ExecutionContext context)

Creates new instance.

Parameters:

context -

QueryExecutor

public QueryExecutor(ExecutionContext context,
                     InterpreterStackTrace stackTrace)

Creates new instance.

Parameters:

context -

stackTrace -

Method Detail

getSession

protected org.hibernate.Session getSession(java.lang.String jndi)

getAll

public java.util.List<com.whitestein.lsps.model.sharedrecord.ExternalRecordEntity> getAll(RecordType recordType)
                                                                                   throws ErrorException

Returns all the entities for the given type.

Parameters:

recordType -

Returns:

all the entities for the given type

Throws:

ErrorException

getAll

public QueryResult<com.whitestein.lsps.model.sharedrecord.ExternalRecordEntity> getAll(RecordType recordType,
                                                                                       OrderingAndPagingCriteria pagingCriteria)
                                                                                throws ErrorException

Returns all the entities for the given type.

Parameters:

recordType -

pagingCriteria -

Returns:

all the entities for the given type

Throws:

ErrorException

getResultList

public java.util.List<com.whitestein.lsps.model.sharedrecord.ExternalRecordEntity> getResultList(com.whitestein.lsps.model.sharedrecord.QuerySpecification spec,
                                                                                                 java.util.Collection<?> parameters)
                                                                                          throws ErrorException

Executes the given query and returns a list of results.

Parameters:

spec -

parameters -

Returns:

the given query and returns a list of results

Throws:

ErrorException

count

public Decimal count(com.whitestein.lsps.model.sharedrecord.QuerySpecification spec,
                     java.util.Collection<?> parameters)
              throws ErrorException

Executes the given query and returns a list of results.

Parameters:

spec -

parameters -

Returns:

the given query and returns a list of results

Throws:

ErrorException

getResultList

public QueryResult<com.whitestein.lsps.model.sharedrecord.ExternalRecordEntity> getResultList(com.whitestein.lsps.model.sharedrecord.QuerySpecification spec,
                                                                                              java.util.Collection<?> parameters,
                                                                                              OrderingAndPagingCriteria pagingCriteria)
                                                                                       throws ErrorException

Executes the given query and returns a list of results.

Parameters:

spec -

pagingCriteria -

parameters -

Returns:

the given query and returns a list of results

Throws:

ErrorException

getSingleResult

public com.whitestein.lsps.model.sharedrecord.ExternalRecordEntity getSingleResult(com.whitestein.lsps.model.sharedrecord.QuerySpecification spec,
                                                                                   java.util.Collection<?> parameters)
                                                                            throws ErrorException

Executes the given query and returns only the first result.

Parameters:

spec -

parameters -

Returns:

the given query and returns only the first result

Throws:

ErrorException

contains

public boolean contains(com.whitestein.lsps.model.sharedrecord.QuerySpecification spec,
                        java.util.Collection<?> parameters,
                        java.lang.Object entity)
                 throws ErrorException

Returns true if the given query result list contains the given entity.

Parameters:

spec -

parameters -

entity -

Returns:

true if the given query result list contains the given entity

Throws:

ErrorException

getAuditResultListInternal

protected java.util.List<java.lang.Object> getAuditResultListInternal(java.util.List<com.whitestein.lsps.engine.sharedrecord.QueryExecutor.WhereExpression> whereExpressions,
                                                                      java.util.List<com.whitestein.lsps.model.sharedrecord.QueryOrderingItem> orderings,
                                                                      java.lang.Integer index,
                                                                      java.lang.Integer count,
                                                                      java.lang.Long revision,
                                                                      java.util.List<AuditCriteria> auditCriteria)
                                                               throws ErrorException,
                                                                      ValidationException

Parameters:

whereExpressions -

orderings -

index -

count -

revision -

auditCriteria -

Returns:

query result

Throws:

ErrorException

ValidationException

getAuditRevisions

public java.util.List<java.lang.Object> getAuditRevisions(java.lang.Object id,
                                                          com.whitestein.lsps.model.sharedrecord.SharedRecordType sharedRecordType,
                                                          java.util.Date from,
                                                          java.util.Date to)
                                                   throws ErrorException

Returns audit revisions.

Parameters:

id -

sharedRecordType -

from -

to -

Returns:

audit revisions

Throws:

ErrorException

getAuditResultList

protected java.util.List<java.lang.Object> getAuditResultList(java.util.List<com.whitestein.lsps.engine.sharedrecord.QueryExecutor.WhereExpression> whereExpressions,
                                                              java.util.List<com.whitestein.lsps.model.sharedrecord.QueryOrderingItem> orderings,
                                                              java.lang.Integer index,
                                                              java.lang.Integer count,
                                                              java.lang.Long revision,
                                                              java.util.List<AuditCriteria> auditCriteria)
                                                       throws ErrorException,
                                                              ValidationException

Dynamically creates query and executes it. Query joins in the whereExpressions must be non-conflicting.

Parameters:

whereExpressions -

orderings -

index -

count -

revision -

auditCriteria -

Returns:

query result

Throws:

ErrorException

ValidationException

getAuditResultList

public java.util.List<java.lang.Object> getAuditResultList(com.whitestein.lsps.model.sharedrecord.SharedRecordType type,
                                                           java.lang.String recordIterator,
                                                           Expression whereExp,
                                                           java.util.List<com.whitestein.lsps.model.sharedrecord.QueryOrderingItem> orderings,
                                                           java.lang.Integer index,
                                                           java.lang.Integer count,
                                                           java.lang.Long revision,
                                                           java.util.List<AuditCriteria> auditCriteria)
                                                    throws ErrorException,
                                                           ValidationException

Dynamically creates query and executes it.

Parameters:

type -

recordIterator -

whereExp -

orderings -

index -

count -

revision -

auditCriteria -

Returns:

query result

Throws:

ErrorException

ValidationException

getResultList

protected java.util.List<java.lang.Object> getResultList(java.util.List<com.whitestein.lsps.engine.sharedrecord.QueryExecutor.WhereExpression> whereExpressions,
                                                         com.whitestein.lsps.engine.sharedrecord.QueryExecutor.Orderings orderings,
                                                         java.lang.Integer index,
                                                         java.lang.Integer count)
                                                  throws ErrorException,
                                                         ValidationException

Dynamically creates query and executes it. Query joins in the whereExpressions must be non-conflicting.

Parameters:

whereExpressions -

orderings -

index -

count -

Returns:

query result

Throws:

ErrorException

ValidationException

getResultList

public java.util.List<java.lang.Object> getResultList(com.whitestein.lsps.model.sharedrecord.SharedRecordType type,
                                                      java.lang.String recordIterator,
                                                      Expression whereExp,
                                                      java.util.List<com.whitestein.lsps.model.sharedrecord.QueryOrderingItem> orderings,
                                                      java.lang.Integer index,
                                                      java.lang.Integer count)
                                               throws ErrorException,
                                                      ValidationException

Dynamically creates query and executes it.

Parameters:

type -

recordIterator -

whereExp -

orderings -

index -

count -

Returns:

query result

Throws:

ErrorException

ValidationException

getResultList

public java.util.List<java.lang.Object> getResultList(ClosureHolder closureWithQuery,
                                                      java.lang.String recordIterator,
                                                      Expression additionalWhereExp,
                                                      java.util.List<com.whitestein.lsps.model.sharedrecord.QueryOrderingItem> orderings,
                                                      java.lang.Integer index,
                                                      java.lang.Integer count)
                                               throws ErrorException,
                                                      ValidationException

Dynamically creates query and executes it.

Parameters:

closureWithQuery -

recordIterator -

additionalWhereExp -

orderings -

index -

count -

Returns:

query result

Throws:

ErrorException

ValidationException

count

protected Decimal count(java.util.List<com.whitestein.lsps.engine.sharedrecord.QueryExecutor.WhereExpression> whereExpressions)
                 throws ErrorException,
                        ValidationException

Dynamically creates query and executes it. Query joins in the whereExpressions must be non-conflicting.

Parameters:

whereExpressions -

Returns:

count

Throws:

ErrorException

ValidationException

count

public Decimal count(com.whitestein.lsps.model.sharedrecord.SharedRecordType type,
                     java.lang.String recordIterator,
                     Expression whereExp)
              throws ErrorException,
                     ValidationException

Dynamically creates query and executes it.

Parameters:

type -

recordIterator -

whereExp -

Returns:

count

Throws:

ErrorException

ValidationException

countAll

public Decimal countAll(RecordType recordType)
                 throws ErrorException

Runs a count query for records of a given type.

Parameters:

recordType -

Returns:

count

Throws:

ErrorException

count

public Decimal count(ClosureHolder closureWithQuery,
                     java.lang.String recordIterator,
                     Expression additionalWhereExp)
              throws ErrorException,
                     ValidationException

Dynamically creates query and executes it.

Parameters:

closureWithQuery -

recordIterator -

additionalWhereExp -

Returns:

count

Throws:

ErrorException

ValidationException

getResultList

public java.util.List<com.whitestein.lsps.model.sharedrecord.ExternalRecordEntity> getResultList(com.whitestein.lsps.model.sharedrecord.HQLQuerySpecification spec,
                                                                                                 java.util.Collection<?> parameters)
                                                                                          throws ErrorException

Executes the query and returns a result list.

Parameters:

spec -

parameters -

Returns:

a result list

Throws:

ErrorException

getSingleResult

public com.whitestein.lsps.model.sharedrecord.ExternalRecordEntity getSingleResult(com.whitestein.lsps.model.sharedrecord.HQLQuerySpecification spec,
                                                                                   java.util.Collection<?> parameters)
                                                                            throws ErrorException

Executes the query and returns a unique result.

Parameters:

spec -

parameters -

Returns:

a result

Throws:

ErrorException

count

public Decimal count(com.whitestein.lsps.model.sharedrecord.HQLQuerySpecification spec,
                     java.util.Collection<?> parameters)
              throws ErrorException

Executes the count query.

Parameters:

spec -

parameters -

Returns:

the result

Throws:

ErrorException