com.communote.server.persistence.helper.dao

Class QueryHelper

java.lang.Object

com.communote.server.persistence.helper.dao.QueryHelper

public final class QueryHelper
extends Object

Query helper class

Author:

Communote GmbH - http://www.communote.com/

Field Summary

Fields

Modifier and Type	Field and Description
static int	NUMBER_MORE_PAGES Number of pages that are shown (if available) after the current pages

Method Summary

Modifier and Type	Method and Description
static org.hibernate.Query	getQuery(org.hibernate.Session session, String mainQuery, ResultSpecification filterSpecification, Object... params) Get a query
static <I> PageableList<I>	queryAsPageableList(org.hibernate.Query query, ResultSpecification resultSpecification, boolean logPerformance) Execute the query and also retrieve the overall count to successfully build the pageable list

Methods inherited from class java.lang.Object

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

Field Detail

NUMBER_MORE_PAGES

public static final int NUMBER_MORE_PAGES

Number of pages that are shown (if available) after the current pages

See Also:

Constant Field Values

Method Detail

getQuery

public static org.hibernate.Query getQuery(org.hibernate.Session session,
                                           String mainQuery,
                                           ResultSpecification filterSpecification,
                                           Object... params)

Get a query

Parameters:

session - the session

mainQuery - the main query string

filterSpecification - the filter specification

params - the parameters

Returns:

the configured query

queryAsPageableList

public static <I> PageableList<I> queryAsPageableList(org.hibernate.Query query,
                                                      ResultSpecification resultSpecification,
                                                      boolean logPerformance)

Execute the query and also retrieve the overall count to successfully build the pageable list

Type Parameters:

I - the type of the item (anyway no check will be done)

Parameters:

query - the configured query to execute

resultSpecification - the ResultSpecification containing offset and overall count

logPerformance - true if the performance should be logged

Returns:

the pageable list with the result values