info.magnolia.cms.util

Class QueryUtil

java.lang.Object

info.magnolia.cms.util.QueryUtil

public class QueryUtil
extends Object

Util to execute queries as simple as possible.

Constructor Summary

Constructors

Constructor and Description
QueryUtil()

Method Summary

Modifier and Type	Method and Description
static String	buildQuery(String statement, String startPath) Creates a simple SQL2 query statement.
static String	createDateExpression(Calendar calendar) Deprecated. since 4.5.4 use info.magnolia.cms.util.DateUtil.createDateExpression(calendar)
static String	createDateExpression(int year, int month, int day) Deprecated.
static String	createDateTimeExpression(Calendar calendar) Deprecated. since 4.5.4 use info.magnolia.cms.util.DateUtil.createDateTimeExpression(calendar)
static String	createDateTimeExpression(int year, int month, int day, int hour, int minutes, int seconds) Deprecated.
static String	createDateTimeExpressionIgnoreTimeZone(Calendar calendar) Deprecated. since 4.5.4 use info.magnolia.cms.util.DateUtil.createDateTimeExpressionIgnoreTimeZone(calendar)
static String	createDateTimeExpressionIgnoreTimeZone(int year, int month, int day, int hour, int minutes, int seconds) Deprecated.
static javax.jcr.NodeIterator	search(javax.jcr.query.qom.QueryObjectModel model, String returnItemType) Executes the query based on QOM and then pops-up in the node hierarchy until returnItemType is found.
static javax.jcr.NodeIterator	search(String workspace, String statement) Executes the query using JCR SQL2 language.
static javax.jcr.NodeIterator	search(String workspace, String statement, String language) Executes the query with given language.Unlike in the old API item type has to be specified in query itself.
static javax.jcr.NodeIterator	search(String workspace, String statement, String language, String returnItemType) Searches for statement and then pops-up in the node hierarchy until returnItemType is found.
static javax.jcr.NodeIterator	search(String workspace, String statement, String language, String returnItemType, boolean isSelector) Searches for statement and then pops-up in the node hierarchy until returnItemType is found.

Methods inherited from class java.lang.Object

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

Constructor Detail

QueryUtil

public QueryUtil()

Method Detail

createDateExpression

@Deprecated
public static String createDateExpression(int year,
                                                      int month,
                                                      int day)

Deprecated.

Parameters:

month - 1-12 (as opposed to java.util.Calendar 0-11 notation)

createDateExpression

@Deprecated
public static String createDateExpression(Calendar calendar)

Deprecated. since 4.5.4 use info.magnolia.cms.util.DateUtil.createDateExpression(calendar)

Expression representing a date.

createDateTimeExpression

@Deprecated
public static String createDateTimeExpression(int year,
                                                          int month,
                                                          int day,
                                                          int hour,
                                                          int minutes,
                                                          int seconds)

Deprecated.

Parameters:

month - 1-12 (as opposed to java.util.Calendar 0-11 notation)

createDateTimeExpression

@Deprecated
public static String createDateTimeExpression(Calendar calendar)

Deprecated. since 4.5.4 use info.magnolia.cms.util.DateUtil.createDateTimeExpression(calendar)

Expression representing a date and time.

createDateTimeExpressionIgnoreTimeZone

@Deprecated
public static String createDateTimeExpressionIgnoreTimeZone(int year,
                                                                        int month,
                                                                        int day,
                                                                        int hour,
                                                                        int minutes,
                                                                        int seconds)

Deprecated.

Parameters:

month - 1-12 (as opposed to java.util.Calendar 0-11 notation)

createDateTimeExpressionIgnoreTimeZone

@Deprecated
public static String createDateTimeExpressionIgnoreTimeZone(Calendar calendar)

Deprecated. since 4.5.4 use info.magnolia.cms.util.DateUtil.createDateTimeExpressionIgnoreTimeZone(calendar)

Do not consider the timezone.

search

public static javax.jcr.NodeIterator search(javax.jcr.query.qom.QueryObjectModel model,
                                            String returnItemType)
                                     throws javax.jcr.query.InvalidQueryException,
                                            javax.jcr.RepositoryException

Executes the query based on QOM and then pops-up in the node hierarchy until returnItemType is found. If the result is not returnItemType or none of its parents are then next node in result is checked. Duplicate nodes are removed from result. For date/time expressions use DateUtil.create*Expression() methods.

Returns:

Result as NodeIterator

Throws:

javax.jcr.query.InvalidQueryException

javax.jcr.RepositoryException

search

public static javax.jcr.NodeIterator search(String workspace,
                                            String statement,
                                            String language)
                                     throws javax.jcr.query.InvalidQueryException,
                                            javax.jcr.RepositoryException

Executes the query with given language.Unlike in the old API item type has to be specified in query itself. SELECT * FROM [mgnl:page] example for selecting just pages in JCR SQL2 language. Duplicate nodes are removed from result. For date/time expressions use DateUtil.create*Expression() methods.

Returns:

Result as NodeIterator

Throws:

javax.jcr.query.InvalidQueryException

javax.jcr.RepositoryException

search

public static javax.jcr.NodeIterator search(String workspace,
                                            String statement)
                                     throws javax.jcr.query.InvalidQueryException,
                                            javax.jcr.RepositoryException

Executes the query using JCR SQL2 language. Unlike in the old API item type has to be specified in query itself. SELECT * FROM [mgnl:page] example for selecting just pages. For executing old query use info.magnolia.cms.util.QueryUtil.search(String workspace, String statement, String language) where you specify Query.SQL as the language. For date/time expressions use DateUtil.create*Expression() methods.

Returns:

Result as NodeIterator

Throws:

javax.jcr.query.InvalidQueryException

javax.jcr.RepositoryException

search

public static javax.jcr.NodeIterator search(String workspace,
                                            String statement,
                                            String language,
                                            String returnItemType)
                                     throws javax.jcr.LoginException,
                                            javax.jcr.RepositoryException

Searches for statement and then pops-up in the node hierarchy until returnItemType is found. If the result is not returnItemType or none of its parents are then next node in result is checked. Duplicate nodes are removed from result. For date/time expressions use DateUtil.create*Expression() methods.

Returns:

query result as collection of nodes

Throws:

javax.jcr.LoginException

javax.jcr.RepositoryException

search

public static javax.jcr.NodeIterator search(String workspace,
                                            String statement,
                                            String language,
                                            String returnItemType,
                                            boolean isSelector)
                                     throws javax.jcr.RepositoryException

Searches for statement and then pops-up in the node hierarchy until returnItemType is found. If the result is not returnItemType or none of its parents are then next node in result is checked. Duplicate nodes are removed from result. If isSelector is set to true then returnItemType will be used as the selector and result will contain only nodes that are marked by this selector. For date/time expressions use DateUtil.create*Expression() methods.

Returns:

iterator of nodes

Throws:

javax.jcr.RepositoryException

buildQuery

public static String buildQuery(String statement,
                                String startPath)

Creates a simple SQL2 query statement.