ome.tools.hibernate

Class QueryBuilder

java.lang.Object

ome.tools.hibernate.QueryBuilder

public class QueryBuilder
extends Object

Very thin wrapper around a StringBuilder to generate HQL queries. This comes from the very real deficiencies of the Criteria API when trying to implement ome.services.SearchBean. Note: It is the responsibility of each method here to end with a blank space, meaning that each method may also begin without one. This class is NOT thread-safe.

Since:

3.0-Beta3

Author:

Josh Moore, josh at glencoesoftware.com

Constructor Summary

Constructors

Constructor and Description
QueryBuilder()
QueryBuilder(boolean sqlQuery) Whether Session.createSQLQuery(String) should be used or not during query(Session) and similar.
QueryBuilder(int size)

Method Summary

Modifier and Type	Method and Description
QueryBuilder	and(String str) Appends "and" plus your string unless this is the first where-spec in which case it is simply appended.
QueryBuilder	append(String string) Simple delegate method to allow appending arbitrary strings.
QueryBuilder	appendSpace()
void	delete(String table)
void	filter(String string, Filter filter)
QueryBuilder	filterNow() In order to support the order() method in addition to a filter, we allow applying the filter and nulling the instance eagerly before the user calls order.
QueryBuilder	from(String type, String alias)
QueryBuilder	join(String path, String alias, boolean outer, boolean fetch)
QueryBuilder	or(String str) Appends "or" plus your string unless this is the first where-spec in which case it is simply appended.
QueryBuilder	order(String path, boolean ascending)
QueryBuilder	param(int id, Object o)
QueryBuilder	param(String key, Object o)
QueryBuilder	paramList(String key, Collection c)
void	params(Parameters params2)
org.hibernate.Query	query(org.hibernate.Session session)
String	queryString() Returns the current query as a String.
org.hibernate.Query	queryWithoutFilter(org.hibernate.Session session)
QueryBuilder	select(String... selects)
QueryBuilder	skipFrom()
QueryBuilder	skipWhere()
QueryBuilder	subselect(QueryBuilder subselect) Appends the string representation of the QueryBuilder argument inside of parentheses.
String	toString()
String	unique_alias(String prefix) Obtain a unique alias to be used in the SQL.
void	update(String table)
QueryBuilder	where() Marks the end of all fetches by adding a "where" clause to the string.
QueryBuilder	whereClause() Similar to how skipFrom and skipWhere were previously used, this sets the current builder to where() but without prefacing the "where " string.

Methods inherited from class java.lang.Object

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

Constructor Detail

QueryBuilder

public QueryBuilder()

QueryBuilder

public QueryBuilder(boolean sqlQuery)

Whether Session.createSQLQuery(String) should be used or not during query(Session) and similar.

QueryBuilder

public QueryBuilder(int size)

Method Detail

unique_alias

public String unique_alias(String prefix)

Obtain a unique alias to be used in the SQL.

Parameters:

prefix - the prefix for the alias

Returns:

a unique alias

append

public QueryBuilder append(String string)

Simple delegate method to allow appending arbitrary strings.

select

public QueryBuilder select(String... selects)

from

public QueryBuilder from(String type,
                         String alias)

join

public QueryBuilder join(String path,
                         String alias,
                         boolean outer,
                         boolean fetch)

where

public QueryBuilder where()

Marks the end of all fetches by adding a "where" clause to the string.

and

public QueryBuilder and(String str)

Appends "and" plus your string unless this is the first where-spec in which case it is simply appended.

or

public QueryBuilder or(String str)

Appends "or" plus your string unless this is the first where-spec in which case it is simply appended.

subselect

public QueryBuilder subselect(QueryBuilder subselect)

Appends the string representation of the QueryBuilder argument inside of parentheses.

order

public QueryBuilder order(String path,
                          boolean ascending)

param

public QueryBuilder param(int id,
                          Object o)

param

public QueryBuilder param(String key,
                          Object o)

paramList

public QueryBuilder paramList(String key,
                              Collection c)

filterNow

public QueryBuilder filterNow()

In order to support the order() method in addition to a filter, we allow applying the filter and nulling the instance eagerly before the user calls order.

queryWithoutFilter

public org.hibernate.Query queryWithoutFilter(org.hibernate.Session session)

query

public org.hibernate.Query query(org.hibernate.Session session)

appendSpace

public QueryBuilder appendSpace()

queryString

public String queryString()

Returns the current query as a String. As opposed to toString(), this method should return parseable HQL.

Returns:

the current HQL query

toString

public String toString()

Overrides:

toString in class Object

update

public void update(String table)

delete

public void delete(String table)

skipFrom

public QueryBuilder skipFrom()

skipWhere

public QueryBuilder skipWhere()

whereClause

public QueryBuilder whereClause()

Similar to how skipFrom and skipWhere were previously used, this sets the current builder to where() but without prefacing the "where " string. Instead, it adds a space so that further calls to where() also won't add it. This can be used to create a clause that can later be combined via subselect(QueryBuilder).

filter

public void filter(String string,
                   Filter filter)

params

public void params(Parameters params2)