Package rife.database.queries

Class AbstractWhereQuery<QueryType extends AbstractWhereQuery>

java.lang.Object

rife.database.queries.AbstractWhereQuery<QueryType>

All Implemented Interfaces:

Cloneable, Query

Direct Known Subclasses:

AbstractWhereGroup, Delete, Select, Update

public abstract class AbstractWhereQuery<QueryType extends AbstractWhereQuery>
extends Object
implements Cloneable

Field Summary

Fields

Modifier and Type	Field	Description
protected Datasource	datasource_
protected boolean	excludeUnsupportedCapabilities_
protected String	sql_
protected StringBuilder	where_

Method Summary

Modifier and Type	Method	Description
protected void	_fieldSubselect(Select query)
protected void	_tableSubselect(Select query)
protected void	_unionSubselect(Select query)
protected void	_whereSubselect(Select query)
protected void	addFieldParameter(String field)
protected void	addWhereParameter(String field)
void	addWhereParameters(List<String> parameters)
void	addWhereParameters(List<String> parameters)
void	clear()
protected void	clearGenerated()
protected void	clearWhereParameters()
QueryType	clone()
Datasource	getDatasource()
String	getLimitParameter()
String	getOffsetParameter()
QueryParameters	getParameters()
String	getWhere()
protected List<String>	getWhereParameters()
protected boolean	isLimitBeforeOffset()
void	setExcludeUnsupportedCapabilities(boolean flag)
protected void	setLimitParameter(String limitParameter)
protected void	setOffsetParameter(String offsetParameter)
WhereGroup<QueryType>	startWhere()
WhereGroupAnd<QueryType>	startWhereAnd()
WhereGroupOr<QueryType>	startWhereOr()
String	toString()
QueryType	where(Object bean)
QueryType	where(String where)
QueryType	where(String field, String operator, boolean value)
QueryType	where(String field, String operator, Object value)
QueryType	where(String field, String operator, Select query)
QueryType	whereAnd(String where)
QueryType	whereAnd(String field, String operator, boolean value)
QueryType	whereAnd(String field, String operator, Object value)
QueryType	whereAnd(String field, String operator, Select query)
QueryType	whereExcluded(Object bean, String[] excludedFields)
QueryType	whereFiltered(Object bean, String[] includedFields, String[] excludedFields)
QueryType	whereIncluded(Object bean, String[] includedFields)
QueryType	whereOr(String where)
QueryType	whereOr(String field, String operator, boolean value)
QueryType	whereOr(String field, String operator, Object value)
QueryType	whereOr(String field, String operator, Select query)
QueryType	whereParameter(String field, String operator)
QueryType	whereParameter(String field, String alias, String operator)
QueryType	whereParameterAnd(String field, String operator)
QueryType	whereParameterAnd(String field, String alias, String operator)
QueryType	whereParameterOr(String field, String operator)
QueryType	whereParameterOr(String field, String alias, String operator)
QueryType	whereParameters(Class beanClass)
QueryType	whereParametersExcluded(Class beanClass, String[] excludedFields)
QueryType	whereSubselect(Select query)

Methods inherited from class java.lang.Object

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

Methods inherited from interface rife.database.queries.Query

getCapabilities, getSql, setExcludeUnsupportedCapabilities

Field Details

where_

protected StringBuilder where_

datasource_

protected Datasource datasource_

sql_

protected String sql_

excludeUnsupportedCapabilities_

protected boolean excludeUnsupportedCapabilities_

Method Details

clear

public void clear()

Specified by:

clear in interface Query

getWhere

public String getWhere()

whereSubselect

public QueryType whereSubselect(Select query)

where

public QueryType where(String where)

startWhere

public WhereGroup<QueryType> startWhere()

whereAnd

public QueryType whereAnd(String where)

startWhereAnd

public WhereGroupAnd<QueryType> startWhereAnd()

whereOr

public QueryType whereOr(String where)

startWhereOr

public WhereGroupOr<QueryType> startWhereOr()

where

public QueryType where(String field,
 String operator,
 boolean value)

where

public QueryType where(String field,
 String operator,
 Select query)

where

public QueryType where(String field,
 String operator,
 Object value)

whereAnd

public QueryType whereAnd(String field,
 String operator,
 boolean value)

whereAnd

public QueryType whereAnd(String field,
 String operator,
 Select query)

whereAnd

public QueryType whereAnd(String field,
 String operator,
 Object value)

whereOr

public QueryType whereOr(String field,
 String operator,
 boolean value)

whereOr

public QueryType whereOr(String field,
 String operator,
 Select query)

whereOr

public QueryType whereOr(String field,
 String operator,
 Object value)

whereParameter

public QueryType whereParameter(String field,
 String operator)

whereParameter

public QueryType whereParameter(String field,
 String alias,
 String operator)

whereParameterAnd

public QueryType whereParameterAnd(String field,
 String operator)

whereParameterAnd

public QueryType whereParameterAnd(String field,
 String alias,
 String operator)

whereParameterOr

public QueryType whereParameterOr(String field,
 String operator)

whereParameterOr

public QueryType whereParameterOr(String field,
 String alias,
 String operator)

where

public QueryType where(Object bean)
                throws DbQueryException

Throws:

DbQueryException

whereIncluded

public QueryType whereIncluded(Object bean,
 String[] includedFields)
                        throws DbQueryException

Throws:

DbQueryException

whereExcluded

public QueryType whereExcluded(Object bean,
 String[] excludedFields)
                        throws DbQueryException

Throws:

DbQueryException

whereFiltered

public QueryType whereFiltered(Object bean,
 String[] includedFields,
 String[] excludedFields)
                        throws DbQueryException

Throws:

DbQueryException

whereParameters

public QueryType whereParameters(Class beanClass)
                          throws DbQueryException

Throws:

DbQueryException

whereParametersExcluded

public QueryType whereParametersExcluded(Class beanClass,
 String[] excludedFields)
                                  throws DbQueryException

Throws:

DbQueryException

clone

public QueryType clone()

addWhereParameters

void addWhereParameters(List<String> parameters)

_fieldSubselect

protected void _fieldSubselect(Select query)

_tableSubselect

protected void _tableSubselect(Select query)

_whereSubselect

protected void _whereSubselect(Select query)

_unionSubselect

protected void _unionSubselect(Select query)

getParameters

public QueryParameters getParameters()

Specified by:

getParameters in interface Query

addFieldParameter

protected void addFieldParameter(String field)

clearWhereParameters

protected void clearWhereParameters()

addWhereParameter

protected void addWhereParameter(String field)

getWhereParameters

protected List<String> getWhereParameters()

addWhereParameters

public void addWhereParameters(List<String> parameters)

setLimitParameter

protected void setLimitParameter(String limitParameter)

getLimitParameter

public String getLimitParameter()

setOffsetParameter

protected void setOffsetParameter(String offsetParameter)

getOffsetParameter

public String getOffsetParameter()

isLimitBeforeOffset

protected boolean isLimitBeforeOffset()

getDatasource

public Datasource getDatasource()

setExcludeUnsupportedCapabilities

public void setExcludeUnsupportedCapabilities(boolean flag)

Specified by:

setExcludeUnsupportedCapabilities in interface Query

clearGenerated

protected void clearGenerated()

toString

public String toString()

Overrides:

toString in class Object