Package com.blackrook.sql

Class SQLAbstractDAO.QueryStringBuilder

java.lang.Object

com.blackrook.sql.SQLAbstractDAO.QueryStringBuilder

Enclosing class:

SQLAbstractDAO

public static class SQLAbstractDAO.QueryStringBuilder
extends Object

Query string builder.

Method Summary

Modifier and Type	Method	Description
SQLAbstractDAO.QueryStringBuilder	limit(int value)	Adds "limit" criteria.
SQLAbstractDAO.QueryStringBuilder	offset(int value)	Adds "offset" criteria.
SQLAbstractDAO.QueryStringBuilder	orderBy(Function<String,String> columnEscapeFunction, SQLAbstractDAO.Ordering... ordering)	Adds "order by" criteria.
String	toString()
SQLAbstractDAO.QueryStringBuilder	where(Function<String,String> columnEscapeFunction, SQLAbstractDAO.Criterion... criteria)	Adds "where" criteria.

Methods inherited from class java.lang.Object

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

Method Details

where

public SQLAbstractDAO.QueryStringBuilder where(Function<String,String> columnEscapeFunction,
 SQLAbstractDAO.Criterion... criteria)

Adds "where" criteria.

Parameters:

columnEscapeFunction - the function to use for escaping column names (parameter is incoming column name).

criteria - the criteria.

Returns:

this builder.

orderBy

public SQLAbstractDAO.QueryStringBuilder orderBy(Function<String,String> columnEscapeFunction,
 SQLAbstractDAO.Ordering... ordering)

Adds "order by" criteria.

Parameters:

columnEscapeFunction - the function to use for escaping column names (parameter is incoming column name).

ordering - the ordering criteria.

Returns:

this builder.

limit

public SQLAbstractDAO.QueryStringBuilder limit(int value)

Adds "limit" criteria.

Parameters:

value - the limit value.

Returns:

this builder.

offset

public SQLAbstractDAO.QueryStringBuilder offset(int value)

Adds "offset" criteria.

Parameters:

value - the limit value.

Returns:

this builder.

toString

public String toString()

Overrides:

toString in class Object