Package com.saperion.ngc.model.resultset

Class QueryModifier

  • public final class QueryModifier
extends java.lang.Object
    Utility class for query modification.

    • Method Summary

      All Methods Static Methods Instance Methods Concrete Methods 
      Modifier and Type Method Description
      java.lang.String createCountQuery()
      Creates count(*) query from provided query string.
      static QueryModifier defineAs()
      Defines QueryModifier instance.
      static java.lang.String extendWithOrderBy​(com.saperion.rmi.SaQueryInfo originalQuery, java.util.Map<java.lang.String,​java.lang.String> cols)
      Extends the provided hql query with order by clause.
      static java.lang.String extractAliasForDefinition​(java.lang.String definition, java.lang.String query)
      Extracts the alias for the specified definition.
      static java.lang.String extractDefinitionName​(java.lang.String query)
      Extracts the definition name from a query string.
      QueryModifier extractFromForCount​(java.lang.String hql)
      Extracts the from-part of a query.
      static java.lang.String extractFromPartForCount​(java.lang.String hql)
      Extracts the from-part of a query.
      static java.lang.String removeOrderByClause​(java.lang.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​(java.lang.String hql)
        Extracts the from-part of a query.
        Parameters:
        hql - query string
        Returns:
        string with from-part

      • createCountQuery

        public java.lang.String createCountQuery()
        Creates count(*) query from provided query string.
        Returns:
        query string.

      • extractFromPartForCount

        public static java.lang.String extractFromPartForCount​(java.lang.String hql)
        Extracts the from-part of a query.
        Parameters:
        hql - query string
        Returns:
        string with from-part

      • extendWithOrderBy

        public static java.lang.String extendWithOrderBy​(com.saperion.rmi.SaQueryInfo originalQuery,
                                                 java.util.Map<java.lang.String,​java.lang.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 java.lang.String extractDefinitionName​(java.lang.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 java.lang.String extractAliasForDefinition​(java.lang.String definition,
                                                         java.lang.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 java.lang.String removeOrderByClause​(java.lang.String originalQuery)
        Removes the order-by clause from a query string.
        Parameters:
        originalQuery - original query string
        Returns:
        query string without order-by clause