com.mysema.query.sql
Class AbstractSQLQuery<SubType extends AbstractSQLQuery<SubType>>

java.lang.Object
  com.mysema.query.QueryBase<SubType>
      com.mysema.query.support.QueryBaseWithProjection<SubType>
          com.mysema.query.sql.AbstractSQLQuery<SubType>

All Implemented Interfaces:

Projectable

Direct Known Subclasses:

OracleQuery, SQLQueryImpl

public abstract class AbstractSQLQuery<SubType extends AbstractSQLQuery<SubType>>
extends QueryBaseWithProjection<SubType>

AbstractSqlQuery is the base type for SQL query implementations

Version:

$Id$

Author:

tiwe

Nested Class Summary

class

AbstractSQLQuery.UnionBuilder<RT>

Field Summary

protected SQLTemplates

templates

Fields inherited from class com.mysema.query.QueryBase

_this

Constructor Summary

AbstractSQLQuery(Connection conn, SQLTemplates templates)

Method Summary

protected String	buildQueryString(boolean forCountRow)
long	count() return the amount of matched rows
protected SQLSerializer	createSerializer()
SubType	from(PEntity<?>... args)
SubType	fullJoin(Expr<?> o)
SubType	innerJoin(Expr<?> o)
Iterator<Object[]>	iterate(Expr<?> e1, Expr<?> e2, Expr<?>... rest) iterate over the results for the given projection
<RT> Iterator<RT>	iterate(Expr<RT> projection) iterate over the results for the given projection
SubType	join(Expr<?> o)
SubType	leftJoin(Expr<?> o)
List<Object[]>	list(Expr<?> expr1, Expr<?> expr2, Expr<?>... rest) list the results for the given projection
<RT> List<RT>	list(Expr<RT> expr) list the results for the given projection
<RT> SearchResults<RT>	listResults(Expr<RT> expr) list the results for the given projection
SubType	on(EBoolean... conditions)
protected String	toQueryString()
String	toString()
<RT> AbstractSQLQuery.UnionBuilder<RT>	union(ListSubQuery<RT>... sq)
<RT> AbstractSQLQuery.UnionBuilder<RT>	union(ObjectSubQuery<RT>... sq)
<RT> RT	uniqueResult(Expr<RT> expr) return a unique result for the given projection

Methods inherited from class com.mysema.query.support.QueryBaseWithProjection

asArray, countDistinct, iterateDistinct, iterateDistinct, listDistinct, listDistinct, listDistinctResults, map, uniqueResult

Methods inherited from class com.mysema.query.QueryBase

addToProjection, getMetadata, groupBy, having, limit, offset, orderBy, restrict, where

Methods inherited from class java.lang.Object

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

Field Detail

templates

protected final SQLTemplates templates

Constructor Detail

AbstractSQLQuery

public AbstractSQLQuery(Connection conn,
                        SQLTemplates templates)

Method Detail

buildQueryString

protected String buildQueryString(boolean forCountRow)

count

public long count()

Description copied from interface: Projectable

return the amount of matched rows

createSerializer

protected SQLSerializer createSerializer()

from

public SubType from(PEntity<?>... args)

fullJoin

public SubType fullJoin(Expr<?> o)

innerJoin

public SubType innerJoin(Expr<?> o)

iterate

public Iterator<Object[]> iterate(Expr<?> e1,
                                  Expr<?> e2,
                                  Expr<?>... rest)

Description copied from interface: Projectable

iterate over the results for the given projection

Returns:

an Iterator over the projection

iterate

public <RT> Iterator<RT> iterate(Expr<RT> projection)

Description copied from interface: Projectable

iterate over the results for the given projection

Type Parameters:

RT - generic type of the Iteratpr

Returns:

an Iterator over the projection

join

public SubType join(Expr<?> o)

leftJoin

public SubType leftJoin(Expr<?> o)

list

public List<Object[]> list(Expr<?> expr1,
                           Expr<?> expr2,
                           Expr<?>... rest)

Description copied from interface: Projectable

list the results for the given projection

Specified by:

list in interface Projectable

Overrides:

list in class QueryBaseWithProjection<SubType extends AbstractSQLQuery<SubType>>

rest - rest

Returns:

a List over the projection

list

public <RT> List<RT> list(Expr<RT> expr)

Description copied from interface: Projectable

list the results for the given projection

Specified by:

list in interface Projectable

Overrides:

list in class QueryBaseWithProjection<SubType extends AbstractSQLQuery<SubType>>

Type Parameters:

RT - generic type of the List

Returns:

a List over the projection

listResults

public <RT> SearchResults<RT> listResults(Expr<RT> expr)

Description copied from interface: Projectable

list the results for the given projection

Returns:

on

public SubType on(EBoolean... conditions)

toQueryString

protected String toQueryString()

toString

public String toString()

Overrides:

toString in class QueryBase<SubType extends AbstractSQLQuery<SubType>>

union

public <RT> AbstractSQLQuery.UnionBuilder<RT> union(ListSubQuery<RT>... sq)

union

public <RT> AbstractSQLQuery.UnionBuilder<RT> union(ObjectSubQuery<RT>... sq)

uniqueResult

public <RT> RT uniqueResult(Expr<RT> expr)

Description copied from interface: Projectable

return a unique result for the given projection

Specified by:

uniqueResult in interface Projectable

Overrides:

uniqueResult in class QueryBaseWithProjection<SubType extends AbstractSQLQuery<SubType>>

Type Parameters:

RT - return type

Returns:

the result or null for an empty result