Package net.sf.basedb.core.query
This package contains the core of the Query API. Here are the
interfaces that queries must implement and the classes used to
build the queries. The actual query implementation are located
in the
net.sf.basedb.core
package since they require
access to core internal stuff, like Hibernate session, user permissions,
etc.- Version:
- 2.0
- Author:
- Nicklas
-
Interface Summary Interface Description AutoJoiner<Q extends Query,E extends QueryElement> AnAutoJoiner
is an object that automatically joins other tables in query depending on other query elements.EntityQuery This a HQL query that return enitities, ie. items.Expression An expression query element.HqlQuery This is a query that is using HQL (Hibernate Query Language) as the query language.Join A join query element.Order An ordering query element.Query This defines the simplest form of a relational query.QueryElement A query element is used in various places in aQuery
to build the structure of the query.QueryFilterAction Actions for creating restrictions on queries.QueryResult This is the root interface for query results.Restriction A restriction query element.ResultIterator<I> Return the result of a query as an iterator.ResultList<I> Return the result of a query as a list.Select A selection query element.SqlQuery This is a query that is using SQL as the query language.SqlResult This interface represents a single row in the results of aSqlQuery
.SqlResultIterator Return the result of aSqlQuery
as an iterator.SqlResultList<I> -
Class Summary Class Description AbsExpression Calculate the absolute value of an expression: abs(e).AddExpression Add two expressions: e1 + e2.Aggregations A factory class to create aggregate expressions.AndRestriction Combine one or more restrictions with AND: r[0] AND r[1] AND ...AnnotationExpression An expression representing the value of an annotation.AnnotationJoin Join annotations values to the query.Annotations A factory class to create restrictions based on annotation values.AnyToAnyRestriction Expression that can be used to filter on the existence or non-existence of a named any-to-any link.AscOrder Sort the result of a query in ascending order by the expression.BetweenRestriction Compare if one expression falls between to other expressions: e BETWEEN low AND high.BooleanExpression A constant boolean expression.CaseExpression An SQL case expression:ConditionalQueryElement CountExpression Count the number of values: COUNT(e)DescOrder Sort the result of a query in descending order by the expression.DivideExpression Divide one expression by another: e1 / e2.Dynamic A factory class to create expressions, joins, etc. that are only used by queries in the dynamic database.EqRestriction Compare if two expressions are equal: e1 == e2, or e1 IS NULLExpExpression Calculate the exponential of an expression: exp(e).Expressions A factory class to create expressions.ExpressionSelect A selection query element that selects an expression, optionally giving it an alias.FloatExpression A constant float expression.GeometricMeanExpression Calculates the geometric mean of an expression: EXP(AVG(LN(e)))GteqRestriction Compare if one expression is greater than or equal to another: e1 > e2.GtRestriction Compare if one expression is greater than another: e1 > e2.Hql A factory class to create expressions, joins, etc. that are only used by HQL queries.HqlElementsExpression An expression representing the elements collection of a collection of a Hibernate entity: elements(alias.property).HqlEntityExpression An expression representing a Hibernate entity.HqlEntityParameterExpression Entity parameter expression.HqlExpression A class holding an expression or a restriction where a prefix can be used to represent a root alias in a HQL.HqlIndexExpression An expression representing the index collection of a map or list of a Hibernate entity: index(alias.property)HqlInnerJoin Inner joins an association to another item:JOIN <alias.property> <joinedAlias>
to the query.HqlLeftJoin Left joins an association to another item:LEFT JOIN <alias.property> <joinedAlias>
to the query.HqlPropertyExpression An expression representing the property of a Hibernate entity: alias.property or alias.property[index]HqlRightJoin Right joins an association to another item:RIGHT JOIN <alias.property> <joinedAlias>
to the query.HqlSizeExpression An expression representing the size of the of a collection of a Hibernate entity: size(alias.property).IdListRestriction Restriction that filters on a list of ID values: id IN (a, b, c, ....)InRestriction Compare if one expression is contained in a set of other expressions: e1 IN (e2[0], e2[1], ...)IntegerExpression A constant integer expression.LikeRestriction Check if one expression matches another: e1 LIKE e2LogExpression Take the n-based logarithm of an expression: log(n, e).LteqRestriction Compare if one expression is less than or equal to another: e1 <= e2.LtRestriction Compare if one expression is less than another: e1 < e2.MaxExpression Calculates the maximum of an expression: MIN(e)MeanExpression Calculates the arithmetic mean of an expression: AVG(e)MinExpression Calculates the minumum of an expression: MIN(e)MultiplyExpression Multiply two expressions: e1 * e2.NegateExpression Negate an expression: -e1.NeqRestriction Compare if two expressions are inequal: e1 <> e2, or NOT e1 IS NULLNotRestriction Negate a restriction: NOT rOrders A factory class to create order by expressions.OrRestriction Combine one or more restrictions with OR: r[0] OR r[1] OR ...ParameterExpression Parameter expression.PermissionRestriction Restriction that inserts an "impossible" filter requirement (1=0) if the logged in user is lacking a given permission.PowerExpression Calculate the power: base ^ exponentQuadraticMeanExpression Calculates the quadratic mean of an expressionQueryParameter Holds information (name, type and value) about a single parameter to a query.ReporterListExpression Represents a property of a reporter list in a dynamic query:alias.property
.Restrictions A factory class to create restrictions.ReturnClassFilter Filter implementation that checks if the items returned by aEntityQuery
are compatible with the specified class.RlikeRestriction Checks if an expression matches a regular expression: e RLIKE regexp (MySQL) or e ~ regexp (Postgres).SelectedExpression An expression representing an already selected expression.Selects A factory class to create select expressions.SharedToRestriction A special restriction that works onShareable
items.SqlColumnExpression An expression representing the column in a database tabe: alias.column.SqrtExpression SubqueryExpression Expression that returns the result of a query as it's value.SubtractExpression Subtract one expression from another: e1 - e2.SumExpression Calculates the sum of an expression: SUM(e)ToDateExpression Get the date part of a date or timestamp epxression.VirtualColumnExpression VirtualColumnExpression.WrappedExpression WhenStatement Create a WHEN statement to be used in aCaseExpression
. -
Enum Summary Enum Description JoinType An enumeration used to specify the type of join.QuerySection Indicates which part of a query that is currently beeing built.QueryType A type representing the language of the query.