ome.logic

Class QueryImpl

java.lang.Object

ome.logic.AbstractLevel1Service

ome.logic.QueryImpl

All Implemented Interfaces:

IQuery, LocalQuery, ServiceInterface, SelfConfigurableService

@Transactional(readOnly=true)
public class QueryImpl
extends AbstractLevel1Service
implements LocalQuery

Provides methods for directly querying object graphs.

Since:

3.0

Version:

3.0 (Internal version: $Rev$ $Date$)

Author:

Josh Moore josh.moore@gmx.de

Field Summary

Fields

Modifier and Type	Field and Description
protected java.lang.Class<? extends org.apache.lucene.analysis.Analyzer>	analyzer

Fields inherited from class ome.logic.AbstractLevel1Service

queryFactory, sessionFactory

Constructor Summary

Constructors

Constructor and Description
QueryImpl()

Method Summary

Modifier and Type	Method and Description
java.lang.Long	aggByQuery(java.lang.String agg, java.lang.String field, java.lang.String query, Parameters params)
java.util.Map<java.lang.String,java.lang.Long>	aggMapByQuery(java.lang.String agg, java.lang.String mapKey, java.lang.String field, java.lang.String query, Parameters params)
boolean	checkProperty(java.lang.String type, java.lang.String property) Checks if a property is defined on a mapped Hibernate type.
boolean	checkType(java.lang.String type) Checks if a type has been mapped in Hibernate.
void	clear()
boolean	contains(java.lang.Object obj) Tests if an object is currently contained in the session.
void	evict(java.lang.Object obj) Removes an object graph from the session.
<T> T	execute(org.springframework.orm.hibernate3.HibernateCallback callback) Executes a HibernateCallback
<T> T	execute(Query<T> query) Executes a locally defined Query.
IObject	find(java.lang.Class klass, long id) lookup an entity by class and id.
<T extends IObject> java.util.List<T>	findAll(java.lang.Class<T> klass, Filter filter) lookup all entities that belong to this class and match filter.
<T extends IObject> java.util.List<T>	findAllByExample(T example, Filter filter) search based on provided example entity.
<T extends IObject> java.util.List<T>	findAllByFullText(java.lang.Class<T> type, java.lang.String query, Parameters params) executes a full text search based on Lucene.
<T extends IObject> java.util.List<T>	findAllByQuery(java.lang.String queryName, Parameters params) executes the stored query with the given name.
<T extends IObject> java.util.List<T>	findAllByString(java.lang.Class<T> klass, java.lang.String fieldName, java.lang.String value, boolean caseSensitive, Filter filter) search a given field matching against a String.
<T extends IObject> T	findByExample(T example) search based on provided example entity.
<T extends IObject> T	findByQuery(java.lang.String queryName, Parameters params) executes the stored query with the given name.
<T extends IObject> T	findByString(java.lang.Class<T> klass, java.lang.String fieldName, java.lang.String value) search a given field matching against a String.
IObject	get(java.lang.Class klass, long id) lookup an entity by class and id.
java.lang.Class<? extends ServiceInterface>	getServiceInterface()
void	initialize(java.lang.Object obj) Uses the Hibernate static method initialize to prepare an object for shipping over the wire.
protected void	parseFilter(org.hibernate.Criteria c, Filter f) Responsible for applying the information provided in a Filter to a Criteria instance.
java.util.List<java.lang.Object[]>	projection(java.lang.String query, Parameters p) Return a list of Java Object instances (not IObject instances).
<T extends IObject> T	refresh(T iObject) refreshes an entire IObject graph, recursive loading all data for the managed instances in the graph from the database.
void	setAnalyzer(java.lang.Class<? extends org.apache.lucene.analysis.Analyzer> analyzer)

Methods inherited from class ome.logic.AbstractLevel1Service

getBeanHelper, getQueryFactory, getSessionFactory, selfConfigure, setQueryFactory, setSessionFactory

Methods inherited from class java.lang.Object

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

Field Detail

analyzer

protected java.lang.Class<? extends org.apache.lucene.analysis.Analyzer> analyzer

Constructor Detail

QueryImpl

public QueryImpl()

Method Detail

setAnalyzer

public void setAnalyzer(java.lang.Class<? extends org.apache.lucene.analysis.Analyzer> analyzer)

getServiceInterface

public java.lang.Class<? extends ServiceInterface> getServiceInterface()

Specified by:

getServiceInterface in interface SelfConfigurableService

contains

@Transactional(readOnly=false)
public boolean contains(java.lang.Object obj)

Description copied from interface: LocalQuery

Tests if an object is currently contained in the session.

Specified by:

contains in interface LocalQuery

evict

@Transactional(readOnly=false)
public void evict(java.lang.Object obj)

Description copied from interface: LocalQuery

Removes an object graph from the session. This allows for non-permanent, mutable calls on the graph.

Specified by:

evict in interface LocalQuery

clear

@Transactional(readOnly=false)
public void clear()

Specified by:

clear in interface LocalQuery

initialize

public void initialize(java.lang.Object obj)

Description copied from interface: LocalQuery

Uses the Hibernate static method initialize to prepare an object for shipping over the wire. It is better to do this in your queries.

Specified by:

initialize in interface LocalQuery

See Also:

Hibernate

checkType

@Transactional(propagation=SUPPORTS)
public boolean checkType(java.lang.String type)

Description copied from interface: LocalQuery

Checks if a type has been mapped in Hibernate.

Specified by:

checkType in interface LocalQuery

Parameters:

type - String representation of a full-qualified Hibernate-mapped type.

Returns:

yes or no.

checkProperty

@Transactional(propagation=SUPPORTS)
public boolean checkProperty(java.lang.String type,
                                                                  java.lang.String property)

Description copied from interface: LocalQuery

Checks if a property is defined on a mapped Hibernate type.

Specified by:

checkProperty in interface LocalQuery

Parameters:

type - String representation of a full-qualified Hibernate-mapped type.

property - Property as defined in Hibernate NOT the public final static Strings on our IObject classes.

Returns:

yes or no.

execute

public <T> T execute(org.springframework.orm.hibernate3.HibernateCallback callback)

Description copied from interface: LocalQuery

Executes a HibernateCallback

Specified by:

execute in interface LocalQuery

Parameters:

callback - An implementation of the HibernateCallback interface.

See Also:

LocalQuery.execute(HibernateCallback)

execute

public <T> T execute(Query<T> query)

Description copied from interface: LocalQuery

Executes a locally defined Query.

Specified by:

execute in interface LocalQuery

Parameters:

query - A subclass of the Query interface.

Returns:

result of the query See document for the query for the return type.

See Also:

LocalQuery.execute(Query)

get

public IObject get(java.lang.Class klass,
                   long id)
            throws ValidationException

Description copied from interface: IQuery

lookup an entity by class and id. If no such object exists, an exception will be thrown.

Specified by:

get in interface IQuery

Parameters:

klass - the type of the entity. Not null.

id - the entity's id

Returns:

an initialized entity

Throws:

ValidationException - if the id doesn't exist.

find

public IObject find(java.lang.Class klass,
                    long id)

Description copied from interface: IQuery

lookup an entity by class and id. If no such objects exists, return a null.

Specified by:

find in interface IQuery

Parameters:

klass - klass the type of the entity. Not null.

id - the entity's id

Returns:

an initialized entity or null if id doesn't exist.

findAll

public <T extends IObject> java.util.List<T> findAll(java.lang.Class<T> klass,
                                                     Filter filter)

Description copied from interface: IQuery

lookup all entities that belong to this class and match filter.

Specified by:

findAll in interface IQuery

Parameters:

klass - entity type to be searched. Not null.

filter - filters the result set. Can be null.

Returns:

a collection if initialized entities or an empty List if none exist.

findByExample

public <T extends IObject> T findByExample(T example)
                                    throws ApiUsageException

Description copied from interface: IQuery

search based on provided example entity. The example entity should uniquely specify the entity or an exception will be thrown. Note: findByExample does not operate on the id field. For that, use IQuery.find(Class, long), IQuery.get(Class, long), IQuery.findByQuery(String, Parameters), or IQuery.findAllByQuery(String, Parameters)

Specified by:

findByExample in interface IQuery

Parameters:

example - Non-null example object.

Returns:

Possibly null IObject result.

Throws:

ApiUsageException - if more than one result is return.

findAllByExample

public <T extends IObject> java.util.List<T> findAllByExample(T example,
                                                              Filter filter)

Description copied from interface: IQuery

search based on provided example entity. The returned entities will be limited by the Filter object. Note: findAllbyExample does not operate on the id field. For that, use IQuery.find(Class, long), IQuery.get(Class, long), IQuery.findByQuery(String, Parameters), or IQuery.findAllByQuery(String, Parameters)

Specified by:

findAllByExample in interface IQuery

Parameters:

example - Non-null example object.

filter - filters the result set. Can be null.

Returns:

Possibly empty List of IObject results.

findByString

public <T extends IObject> T findByString(java.lang.Class<T> klass,
                                          java.lang.String fieldName,
                                          java.lang.String value)
                                   throws ApiUsageException

Description copied from interface: IQuery

search a given field matching against a String. Method does not allow for case sensitive or insensitive searching since this is essentially a lookup. The existence of more than one result will result in an exception.

Specified by:

findByString in interface IQuery

Parameters:

klass - type of entity to be searched

fieldName - the name of the field, either as simple string or as public final static from the entity class, e.g. Project.NAME

value - String used for search.

Returns:

found entity or possibly null.

Throws:

ApiUsageException - if more than one result.

findAllByString

public <T extends IObject> java.util.List<T> findAllByString(java.lang.Class<T> klass,
                                                             java.lang.String fieldName,
                                                             java.lang.String value,
                                                             boolean caseSensitive,
                                                             Filter filter)
                                                      throws ApiUsageException

Description copied from interface: IQuery

search a given field matching against a String. Method allows for case sensitive or insensitive searching using the (I)LIKE comparators. Result set will be reduced by the Filter instance.

Specified by:

findAllByString in interface IQuery

Parameters:

klass - type of entity to be searched. Not null.

fieldName - the name of the field, either as simple string or as public final static from the entity class, e.g. Project.NAME. Not null.

value - String used for search. Not null.

caseSensitive - whether to use LIKE or ILIKE

filter - filters the result set. Can be null.

Returns:

A list (possibly empty) with the results.

Throws:

ApiUsageException

findByQuery

public <T extends IObject> T findByQuery(java.lang.String queryName,
                                         Parameters params)
                                  throws ValidationException

Description copied from interface: IQuery

executes the stored query with the given name. If a query with the name cannot be found, an exception will be thrown. The queryName parameter can be an actual query String if the StringQuerySource is configured on the server and the user running the query has proper permissions.

Specified by:

findByQuery in interface IQuery

Parameters:

queryName - String identifier of the query to execute

params - array of QueryParameter. Not null. The QueryParameter.name field maps to a field-name which is then matched against the QueryParameter.value

Returns:

Possibly null IObject result.

Throws:

ValidationException

findAllByQuery

public <T extends IObject> java.util.List<T> findAllByQuery(java.lang.String queryName,
                                                            Parameters params)

Description copied from interface: IQuery

executes the stored query with the given name. If a query with the name cannot be found, an exception will be thrown. The queryName parameter can be an actual query String if the StringQuerySource is configured on the server and the user running the query has proper permissions. Queries can only return lists of IObject instances. This means all must be of the form:

 select this from SomeModelClass this ...
 

though the alias "this" is unimportant. Do not try to return multiple classes in one call like:

 select this, that from SomeClass this, SomeOtherClass that ...
 

nor to project values out of an object:

 select this.name from SomeClass this ...
 

If a page is desired, add it to the query parameters.

Specified by:

findAllByQuery in interface IQuery

Parameters:

queryName - String identifier of the query to execute. Not null.

params - array of QueryParameter. The QueryParameter.name field maps to a field-name which is then matched against the QueryParameter.value

Returns:

Possibly empty List of IObject results.

findAllByFullText

public <T extends IObject> java.util.List<T> findAllByFullText(java.lang.Class<T> type,
                                                               java.lang.String query,
                                                               Parameters params)

Description copied from interface: IQuery

executes a full text search based on Lucene. Each term in the query can also be prefixed by the name of the field to which is should be restricted. Examples:

• owner:root AND annotation:someTag
• file:xml AND name:*hoechst*

For more information, see Query Parser Synax The return values are first filtered by the security system.

Specified by:

findAllByFullText in interface IQuery

Parameters:

type - A non-null class specification of which type should be searched.

query - A non-null query string. An empty string will return no results.

params - Currently the parameters themselves are unusued. But the Parameters.filter can be used to limit the number of results returned (Filter.limit) or the user for who the results will be found (Filter.owner()).

Returns:

A list of loaded IObject instances. Never null.

projection

public java.util.List<java.lang.Object[]> projection(java.lang.String query,
                                                     Parameters p)

Description copied from interface: IQuery

Return a list of Java Object instances (not IObject instances). These are the column names as specified in the HQL select statement (more than one is required). If an aggregation statement is used, a group by clause must be added. Examples:

• select i.name, i.description from Image i where i.name like '%.dv'
• select tag.textValue, tagset.textValue from TagAnnotation tag join tag.annotationLinks l join l.child tagset
• select p.pixelsType.value, count(p.id) from Pixel p group by p.pixelsType.value

Specified by:

projection in interface IQuery

aggByQuery

public java.lang.Long aggByQuery(java.lang.String agg,
                                 java.lang.String field,
                                 java.lang.String query,
                                 Parameters params)

aggMapByQuery

public java.util.Map<java.lang.String,java.lang.Long> aggMapByQuery(java.lang.String agg,
                                                                    java.lang.String mapKey,
                                                                    java.lang.String field,
                                                                    java.lang.String query,
                                                                    Parameters params)

refresh

public <T extends IObject> T refresh(T iObject)
                              throws ApiUsageException

Description copied from interface: IQuery

refreshes an entire IObject graph, recursive loading all data for the managed instances in the graph from the database. If any non-managed entities are detected (e.g. without ids), an ApiUsageException will be thrown.

Specified by:

refresh in interface IQuery

Parameters:

iObject - Non-null managed IObject graph which should have all values re-assigned from the database

Returns:

a similar IObject graph (with possible additions and deletions) which is in-sync with the database.

Throws:

ApiUsageException - if any non-managed entities are found.

parseFilter

protected void parseFilter(org.hibernate.Criteria c,
                           Filter f)

Responsible for applying the information provided in a Filter to a Criteria instance.

Parameters:

c - a criteria instance

f - a filter to limit a query