Package net.sf.basedb.core.query
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
-
ClassDescriptionCalculate the absolute value of an expression: abs(e).Add two expressions: e1 + e2.A factory class to create aggregate expressions.Combine one or more restrictions with AND: r[0] AND r[1] AND ...An expression representing the value of an annotation.Join annotations values to the query.A factory class to create restrictions based on annotation values.Expression that can be used to filter on the existence or non-existence of a named any-to-any link.Sort the result of a query in ascending order by the expression.An
AutoJoiner
is an object that automatically joins other tables in query depending on other query elements.Compare if one expression falls between to other expressions: e BETWEEN low AND high.A constant boolean expression.An SQL case expression:Count the number of values: COUNT(e)Sort the result of a query in descending order by the expression.Divide one expression by another: e1 / e2.A factory class to create expressions, joins, etc. that are only used by queries in the dynamic database.This a HQL query that return enitities, ie. items.Compare if two expressions are equal: e1 == e2, or e1 IS NULLCalculate the exponential of an expression: exp(e).An expression query element.A factory class to create expressions.A selection query element that selects an expression, optionally giving it an alias.A constant float expression.Calculates the geometric mean of an expression: EXP(AVG(LN(e)))Compare if one expression is greater than or equal to another: e1 > e2.Compare if one expression is greater than another: e1 > e2.A factory class to create expressions, joins, etc. that are only used by HQL queries.An expression representing the elements collection of a collection of a Hibernate entity: elements(alias.property).An expression representing a Hibernate entity.Entity parameter expression.A class holding an expression or a restriction where a prefix can be used to represent a root alias in a HQL.An expression representing the index collection of a map or list of a Hibernate entity: index(alias.property)Inner joins an association to another item:JOIN <alias.property> <joinedAlias>
to the query.Left joins an association to another item:LEFT JOIN <alias.property> <joinedAlias>
to the query.An expression representing the property of a Hibernate entity: alias.property or alias.property[index]This is a query that is using HQL (Hibernate Query Language) as the query language.Right joins an association to another item:RIGHT JOIN <alias.property> <joinedAlias>
to the query.An expression representing the size of the of a collection of a Hibernate entity: size(alias.property).Restriction that filters on a list of ID values: id IN (a, b, c, ....)Compare if one expression is contained in a set of other expressions: e1 IN (e2[0], e2[1], ...)A constant integer expression.A join query element.An enumeration used to specify the type of join.Check if one expression matches another: e1 LIKE e2Take the n-based logarithm of an expression: log(n, e).Compare if one expression is less than or equal to another: e1 <= e2.Compare if one expression is less than another: e1 < e2.Calculates the maximum of an expression: MIN(e)Calculates the arithmetic mean of an expression: AVG(e)Calculates the minumum of an expression: MIN(e)Multiply two expressions: e1 * e2.Negate an expression: -e1.Compare if two expressions are inequal: e1 <> e2, or NOT e1 IS NULLNegate a restriction: NOT rAn ordering query element.A factory class to create order by expressions.Combine one or more restrictions with OR: r[0] OR r[1] OR ...Parameter expression.Restriction that inserts an "impossible" filter requirement (1=0) if the logged in user is lacking a given permission.Calculate the power: base ^ exponentCalculates the quadratic mean of an expressionThis defines the simplest form of a relational query.A query element is used in various places in aQuery
to build the structure of the query.Actions for creating restrictions on queries.Holds information (name, type and value) about a single parameter to a query.This is the root interface for query results.Indicates which part of a query that is currently beeing built.A type representing the language of the query.Represents a property of a reporter list in a dynamic query:alias.property
.A restriction query element.A factory class to create restrictions.Return the result of a query as an iterator.ResultList<I>Return the result of a query as a list.Filter implementation that checks if the items returned by aEntityQuery
are compatible with the specified class.Checks if an expression matches a regular expression: e RLIKE regexp (MySQL) or e ~ regexp (Postgres).A selection query element.An expression representing an already selected expression.A factory class to create select expressions.A special restriction that works onShareable
items.An expression representing the column in a database tabe: alias.column.This is a query that is using SQL as the query language.This interface represents a single row in the results of aSqlQuery
.Return the result of aSqlQuery
as an iterator.Expression that returns the result of a query as it's value.Subtract one expression from another: e1 - e2.Calculates the sum of an expression: SUM(e)Get the date part of a date or timestamp epxression.Create a WHEN statement to be used in aCaseExpression
.