com.feedzai.commons.sql.abstraction.dml

Class Query

java.lang.Object

com.feedzai.commons.sql.abstraction.dml.Expression

com.feedzai.commons.sql.abstraction.dml.Query

All Implemented Interfaces:

Serializable

public class Query
extends Expression

Represents a SQL Query.

Since:

2.0.0

Author:

Rui Vilao (rui.vilao@feedzai.com)

See Also:

Serialized Form

Field Summary

Fields inherited from class com.feedzai.commons.sql.abstraction.dml.Expression

alias, enclosed, joins, ordering, properties, quotes, translator, withNoLock

Constructor Summary

Constructors

Constructor and Description
Query() Creates a new instance of Query.

Method Summary

Methods

Modifier and Type	Method and Description
Query	andWhere(Expression where) The WHERE clause.
Query	distinct() Sets the SELECT expression as DISTINCT.
Query	from(Collection<? extends Expression> fromColumns) Adds the FROM columns.
Query	from(Expression... fromColumns) Adds the FROM columns.
List<Expression>	getFromColumns() Gets the FROM columns.
List<Expression>	getGroupbyColumns() Gets the GROUP BY expressions.
Expression	getHaving() Gets the HAVING expression.
Integer	getLimit() Gets the limit.
Integer	getOffset() Gets the offset.
List<Expression>	getOrderbyColumns() Gets the ORDER BY expressions.
List<Expression>	getSelectColumns() Gets the SELECT columns.
Expression	getWhere() Gets the WHERE expression.
Query	groupby(Collection<? extends Expression> groupbyColumns) Adds the GROUP BY columns.
Query	groupby(Expression... groupbyColumns) Adds the GROUP BY columns.
Query	having(Expression having) Adds the HAVING expression.
boolean	isDistinct() Checks if the SELECT expression is distinct.
Query	limit(Integer limit) Sets the limit.
Query	offset(Integer offset) Sets the offset.
Query	orderby(Collection<? extends Expression> orderbyColumns) Adds the ORDER BY columns.
Query	orderby(Expression... orderbyColumns) Adds the ORDER BY columns.
Query	select(Collection<? extends Expression> selectColumns) Adds the SELECT columns.
Query	select(Expression... selectColumns) Adds the SELECT columns.
String	translate() Translates the expression.
Query	where(Expression where) The where clause.

Methods inherited from class com.feedzai.commons.sql.abstraction.dml.Expression

alias, asc, desc, enclose, fullOuterJoin, getAlias, getJoins, getOrdering, innerJoin, isAliased, isEnclosed, isQuote, isQuotes, isWithNoLock, leftOuterJoin, rightOuterJoin, unquote, withNoLock

Methods inherited from class java.lang.Object

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

Constructor Detail

Query

public Query()

Creates a new instance of Query.

Method Detail

translate

public String translate()

Description copied from class: Expression

Translates the expression.

Specified by:

translate in class Expression

Returns:

A translation of the implementing expression.

getSelectColumns

public List<Expression> getSelectColumns()

Gets the SELECT columns.

Returns:

The SELECT columns.

getFromColumns

public List<Expression> getFromColumns()

Gets the FROM columns.

Returns:

The FROM columns.

getWhere

public Expression getWhere()

Gets the WHERE expression.

Returns:

The WHERE expression.

getGroupbyColumns

public List<Expression> getGroupbyColumns()

Gets the GROUP BY expressions.

Returns:

The GROUP BY expressions.

getHaving

public Expression getHaving()

Gets the HAVING expression.

Returns:

The HAVING expression.

getOrderbyColumns

public List<Expression> getOrderbyColumns()

Gets the ORDER BY expressions.

Returns:

The ORDER BY expressions.

getLimit

public Integer getLimit()

Gets the limit. null is returned when not applicable.

Returns:

The limit.

getOffset

public Integer getOffset()

Gets the offset. null is returned when not applicable.

Returns:

The offset.

isDistinct

public boolean isDistinct()

Checks if the SELECT expression is distinct.

Returns:

true is the SELECT expression is distinct, false otherwise.

distinct

public Query distinct()

Sets the SELECT expression as DISTINCT.

Returns:

This expression.

select

public Query select(Expression... selectColumns)

Adds the SELECT columns.

Parameters:

selectColumns - The columns.

Returns:

This expression.

select

public Query select(Collection<? extends Expression> selectColumns)

Adds the SELECT columns.

Parameters:

selectColumns - The columns.

Returns:

This expression.

from

public Query from(Expression... fromColumns)

Adds the FROM columns.

Parameters:

fromColumns - The columns.

Returns:

This expression.

from

public Query from(Collection<? extends Expression> fromColumns)

Adds the FROM columns.

Parameters:

fromColumns - The columns.

Returns:

This expression.

andWhere

public Query andWhere(Expression where)

The WHERE clause.

If there is no where clause already defined, sets to the defined value.

If there is already an expression for where defined, defines an and expression between old and new clauses.

Example:

     query.where(eq(column("col1"),k(1)).andWhere(eq(column("col2"),k(2))

     will be translated to

     ("col1" = 1) AND ("col2" = 2)
 

Parameters:

where - The WHERE expression.

Returns:

This expression.

where

public Query where(Expression where)

The where clause.

Note:This method replaces any where clauses previously defined.

Parameters:

where - The object.

Returns:

This expression.

groupby

public Query groupby(Expression... groupbyColumns)

Adds the GROUP BY columns.

Parameters:

groupbyColumns - The columns.

Returns:

This expression.

groupby

public Query groupby(Collection<? extends Expression> groupbyColumns)

Adds the GROUP BY columns.

Parameters:

groupbyColumns - The columns.

Returns:

This expression.

having

public Query having(Expression having)

Adds the HAVING expression.

Parameters:

having - The having expression.

Returns:

This expression.

orderby

public Query orderby(Expression... orderbyColumns)

Adds the ORDER BY columns.

Parameters:

orderbyColumns - The columns.

Returns:

This expression.

orderby

public Query orderby(Collection<? extends Expression> orderbyColumns)

Adds the ORDER BY columns.

Parameters:

orderbyColumns - The columns.

Returns:

This expression.

limit

public Query limit(Integer limit)

Sets the limit.

Parameters:

limit - The number of rows that the query returns.

Returns:

This expression.

offset

public Query offset(Integer offset)

Sets the offset.

Parameters:

offset - The start position

Returns:

This expression.