org.assistments.service.dao.base.impl

Class QueryBuilder

java.lang.Object

org.assistments.service.dao.base.impl.QueryBuilder

public class QueryBuilder
extends java.lang.Object

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	QueryBuilder(SchemaTable table, QueryType qType) Currently QueryType.CREATE_TABLE is built entirely in QueryTerm.

Method Summary

Modifier and Type	Method and Description
QueryBuilder	addFirstQueryExpression(java.util.List<QueryTerm> terms, LogicalOpType joinOp) Adds a group of query terms as start of your query expression.
QueryBuilder	addFirstQueryExpression(QueryTerm term) Adds the first query term to your query expression.
void	addNameValuePair(NVPair nvp)
void	addNameValuePairs(java.util.List<NVPair> nvps)
QueryBuilder	addNextQueryExpression(LogicalOpType beforeOp, java.util.List<QueryTerm> terms, LogicalOpType joinOp) Adds a single query term to the query expression
QueryBuilder	addNextQueryExpression(LogicalOpType beforeOp, QueryTerm term) Adds a single query term to the query expression
protected org.springframework.jdbc.core.namedparam.MapSqlParameterSource	addToParams(java.util.List<NVPair> nvps)
QueryInstance	createQuery()
protected java.lang.StringBuilder	getFieldNamesAsCSV()
protected java.lang.StringBuilder	getFieldNamesAsCSV(java.util.List<NVPair> nvps)
protected java.lang.StringBuilder	getFieldNameSymbolicNamePairsAsCSV()
protected java.lang.StringBuilder	getFieldNameSymbolicNamePairsAsCSV(java.util.List<NVPair> nvps)
QueryBuilder	getInnerQueryBuilder(SchemaTable table, QueryType qType) Returns a QueryBuilder for creating an inner (sub) query.
java.lang.String	getReturnField()
protected SchemaTable	getSchemaTable()
protected java.lang.StringBuilder	getSymbolicExpression()
protected java.lang.StringBuilder	getSymbolicExpression(java.util.List<QueryExpression> expressions)
protected java.lang.StringBuilder	getSymbolicNamesAsCSV()
protected java.lang.StringBuilder	getSymbolicNamesAsCSV(java.util.List<NVPair> nvps)
QueryBuilder	setLimit(int limit)
void	setParamsSource(org.springframework.jdbc.core.namedparam.MapSqlParameterSource params)
QueryBuilder	setResultsOrderType(java.lang.String orderingField, ResultsOrderType ordering)
QueryBuilder	setReturnField(java.lang.String fieldName) For an inner query, specifies the field name to return.
java.lang.String	toString()

Methods inherited from class java.lang.Object

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

Constructor Detail

QueryBuilder

protected QueryBuilder(SchemaTable table,
                       QueryType qType)

Currently QueryType.CREATE_TABLE is built entirely in QueryTerm.

Currently QueryType.INSERT needs only NVPairs set up here.

Parameters:

table -

qType -

Method Detail

getInnerQueryBuilder

public QueryBuilder getInnerQueryBuilder(SchemaTable table,
                                         QueryType qType)

Returns a QueryBuilder for creating an inner (sub) query.

After building the inner query, you add it to the parent builder by:

1. Creating an InnerQueryTerm using the inner QueryBuilder, and
2. Calling addFirstQueryExpression(QueryTerm), addFirstQueryExpression(List, LogicalOpType), addNextQueryExpression(LogicalOpType, QueryTerm), or addNextQueryExpression(LogicalOpType, List, LogicalOpType) to add that new InnerQueryTerm, as an expression, to the parent builder.

Parameters:

table - Table the inner query operates on

qType - Query type

Returns:

getSchemaTable

protected SchemaTable getSchemaTable()

setReturnField

public QueryBuilder setReturnField(java.lang.String fieldName)

For an inner query, specifies the field name to return.

Parameters:

fieldName -

getReturnField

public java.lang.String getReturnField()

addFirstQueryExpression

public QueryBuilder addFirstQueryExpression(QueryTerm term)

Adds the first query term to your query expression.

Parameters:

term - Query term

addFirstQueryExpression

public QueryBuilder addFirstQueryExpression(java.util.List<QueryTerm> terms,
                                            LogicalOpType joinOp)

Adds a group of query terms as start of your query expression.

Parameters:

terms - List of query terms

joinOp - Logical operator used to join each individual query term. For example: <term1> AND <term2> AND <term3>
Or: <term1> OR <term2> OR <term3>

addNextQueryExpression

public QueryBuilder addNextQueryExpression(LogicalOpType beforeOp,
                                           QueryTerm term)

Adds a single query term to the query expression

Parameters:

beforeOp - Logical operator to join this term to the expression.

term - Query term

addNextQueryExpression

public QueryBuilder addNextQueryExpression(LogicalOpType beforeOp,
                                           java.util.List<QueryTerm> terms,
                                           LogicalOpType joinOp)

Adds a single query term to the query expression

Parameters:

beforeOp - Logical operator to join these terms to the expression. *

terms - List of query terms

joinOp - Logical operator used to join each individual query term.

getFieldNamesAsCSV

protected java.lang.StringBuilder getFieldNamesAsCSV()

getFieldNamesAsCSV

protected java.lang.StringBuilder getFieldNamesAsCSV(java.util.List<NVPair> nvps)

getSymbolicNamesAsCSV

protected java.lang.StringBuilder getSymbolicNamesAsCSV()

getSymbolicNamesAsCSV

protected java.lang.StringBuilder getSymbolicNamesAsCSV(java.util.List<NVPair> nvps)

getFieldNameSymbolicNamePairsAsCSV

protected java.lang.StringBuilder getFieldNameSymbolicNamePairsAsCSV()

getFieldNameSymbolicNamePairsAsCSV

protected java.lang.StringBuilder getFieldNameSymbolicNamePairsAsCSV(java.util.List<NVPair> nvps)

getSymbolicExpression

protected java.lang.StringBuilder getSymbolicExpression()

getSymbolicExpression

protected java.lang.StringBuilder getSymbolicExpression(java.util.List<QueryExpression> expressions)

setParamsSource

public void setParamsSource(org.springframework.jdbc.core.namedparam.MapSqlParameterSource params)

addToParams

protected org.springframework.jdbc.core.namedparam.MapSqlParameterSource addToParams(java.util.List<NVPair> nvps)

addNameValuePair

public void addNameValuePair(NVPair nvp)

addNameValuePairs

public void addNameValuePairs(java.util.List<NVPair> nvps)

setLimit

public QueryBuilder setLimit(int limit)

setResultsOrderType

public QueryBuilder setResultsOrderType(java.lang.String orderingField,
                                        ResultsOrderType ordering)

createQuery

public QueryInstance createQuery()

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object