Package org.dhatim.safesql.builder

Class SelectQuery

java.lang.Object

org.dhatim.safesql.builder.SelectQuery

All Implemented Interfaces:

Expression, SqlQuery, WhereClause, SafeSqlizable

public class SelectQuery
extends java.lang.Object
implements WhereClause, SqlQuery

Constructor Summary

Constructors

Constructor	Description
SelectQuery()
SelectQuery(SelectQuery other)

Method Summary

Modifier and Type	Method	Description
SelectQuery	and(Condition condition)
void	appendTo(SafeSqlBuilder sb)
void	clearFroms()
void	clearGroupBys()
void	clearHavings()
void	clearSelects()
void	clearWindows()
SelectQuery	distinct()
From	from(java.lang.String tableName)
From	from(java.lang.String schema, java.lang.String tableName)
From	from(java.lang.String schema, java.lang.String tableName, Alias alias)
From	from(java.lang.String schema, java.lang.String tableName, Alias alias, java.util.List<java.lang.String> columnNames)
From	from(java.lang.String tableName, Alias alias)
From	from(SqlQuery query, Alias alias)
From	from(SqlQuery query, Alias alias, java.util.List<java.lang.String> columnNames)
Alias	generate()
Alias	generate(java.lang.String suggestion)
java.lang.String	generateIdentifier()
java.lang.String	generateIdentifier(java.lang.String suggestion)
SelectQuery	groupBy(Column column)
SelectQuery	groupBy(Column... columns)
Having	having()
SelectQuery	having(Condition condition)
SelectQuery	limit(int limit)
SelectQuery	noLimit()
SelectQuery	orderBy(java.lang.String column, Order order)
SelectQuery	orderBy(Alias alias, java.lang.String column, Order order)
SelectQuery	select(java.lang.String columnName)
SelectQuery	select(java.lang.String columnName, From from)
SelectQuery	select(Alias alias, java.lang.String columnName)
SelectQuery	select(Operand operand)
SelectQuery	select(Operand operand, Alias alias)
SelectQuery	window(NamedWindow window)
SelectQuery	windows(NamedWindow... namedWindows)
SelectQuery	with(java.lang.String name, java.util.List<java.lang.String> columnNames, SqlQuery query)
SelectQuery	with(java.lang.String name, SqlQuery query)
static SelectQuery	withContextOf(SelectQuery other)

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.dhatim.safesql.SafeSqlizable

toSafeSql

Methods inherited from interface org.dhatim.safesql.builder.SqlQuery

fromSqlizable, of

Methods inherited from interface org.dhatim.safesql.builder.WhereClause

and, and, and, and, and, andIn, andIsNotNull, andIsNull, andNotIn

Constructor Detail

SelectQuery

public SelectQuery()

SelectQuery

public SelectQuery(SelectQuery other)

Method Detail

select

public SelectQuery select(Operand operand)

clearSelects

public void clearSelects()

with

public SelectQuery with(java.lang.String name,
                        SqlQuery query)

with

public SelectQuery with(java.lang.String name,
                        java.util.List<java.lang.String> columnNames,
                        SqlQuery query)

select

public SelectQuery select(java.lang.String columnName)

select

public SelectQuery select(Alias alias,
                          java.lang.String columnName)

select

public SelectQuery select(java.lang.String columnName,
                          From from)

select

public SelectQuery select(Operand operand,
                          Alias alias)

from

public From from(java.lang.String tableName)

from

public From from(java.lang.String tableName,
                 Alias alias)

from

public From from(java.lang.String schema,
                 java.lang.String tableName)

from

public From from(java.lang.String schema,
                 java.lang.String tableName,
                 Alias alias,
                 java.util.List<java.lang.String> columnNames)

from

public From from(java.lang.String schema,
                 java.lang.String tableName,
                 Alias alias)

from

public From from(SqlQuery query,
                 Alias alias)

from

public From from(SqlQuery query,
                 Alias alias,
                 java.util.List<java.lang.String> columnNames)

clearFroms

public void clearFroms()

groupBy

public SelectQuery groupBy(Column... columns)

groupBy

public SelectQuery groupBy(Column column)

clearGroupBys

public void clearGroupBys()

having

public SelectQuery having(Condition condition)

having

public Having having()

clearHavings

public void clearHavings()

windows

public SelectQuery windows(NamedWindow... namedWindows)

window

public SelectQuery window(NamedWindow window)

clearWindows

public void clearWindows()

generate

public Alias generate()

generate

public Alias generate(java.lang.String suggestion)

generateIdentifier

public java.lang.String generateIdentifier()

generateIdentifier

public java.lang.String generateIdentifier(java.lang.String suggestion)

appendTo

public void appendTo(SafeSqlBuilder sb)

Specified by:

appendTo in interface SafeSqlizable

and

public SelectQuery and(Condition condition)

Specified by:

and in interface WhereClause

distinct

public SelectQuery distinct()

limit

public SelectQuery limit(int limit)

noLimit

public SelectQuery noLimit()

orderBy

public SelectQuery orderBy(java.lang.String column,
                           Order order)

orderBy

public SelectQuery orderBy(Alias alias,
                           java.lang.String column,
                           Order order)

withContextOf

public static SelectQuery withContextOf(SelectQuery other)