com.saperion.ngc.model.resultset

Class QueryModifier

java.lang.Object

com.saperion.ngc.model.resultset.QueryModifier

public final class QueryModifier
extends Object

Utility class for query modification.

Method Summary

Modifier and Type	Method and Description
String	createCountQuery() Creates count(*) query from provided query string.
static QueryModifier	defineAs() Defines QueryModifier instance.
static String	extendWithOrderBy(com.saperion.rmi.SaQueryInfo originalQuery, Map<String,String> cols) Extends the provided hql query with order by clause.
static String	extractAliasForDefinition(String definition, String query) Extracts the alias for the specified definition.
static String	extractDefinitionName(String query) Extracts the definition name from a query string.
QueryModifier	extractFromForCount(String hql) Extracts the from-part of a query.
static String	extractFromPartForCount(String hql) Extracts the from-part of a query.
static String	removeOrderByClause(String originalQuery) Removes the order-by clause from a query string.

Methods inherited from class java.lang.Object

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

Method Detail

defineAs

public static QueryModifier defineAs()

Defines QueryModifier instance.

Returns:

QueryModifier object.

extractFromForCount

public QueryModifier extractFromForCount(String hql)

Extracts the from-part of a query.

Parameters:

hql - query string

Returns:

string with from-part

createCountQuery

public String createCountQuery()

Creates count(*) query from provided query string.

Returns:

query string.

extractFromPartForCount

public static String extractFromPartForCount(String hql)

Extracts the from-part of a query.

Parameters:

hql - query string

Returns:

string with from-part

extendWithOrderBy

public static String extendWithOrderBy(com.saperion.rmi.SaQueryInfo originalQuery,
                                       Map<String,String> cols)

Extends the provided hql query with order by clause.

Parameters:

originalQuery - original query

cols - column names used as sorting criteria.

Returns:

modifyed query for sorting.

extractDefinitionName

public static String extractDefinitionName(String query)

Extracts the definition name from a query string.

Parameters:

query - query string

Returns:

definition name or empty string if no definition name was found

extractAliasForDefinition

public static String extractAliasForDefinition(String definition,
                                               String query)

Extracts the alias for the specified definition.

Parameters:

definition - the definition

query - the query-string

Returns:

the alias or an empty string if not found

removeOrderByClause

public static String removeOrderByClause(String originalQuery)

Removes the order-by clause from a query string.

Parameters:

originalQuery - original query string

Returns:

query string without order-by clause