org.identityconnectors.dbcommon

Class FilterWhereBuilder

java.lang.Object

org.identityconnectors.dbcommon.FilterWhereBuilder

public class FilterWhereBuilder
extends Object

The Filter Where builder is component intended to be used within subclass of AbstractFilterTranslator to help create the database WHERE query clause.

The main functionality of this helper class is create SQL WHERE query clause

The builder can return a List of params to be used within preparedStatement creation

Since:

1.0

Constructor Summary

Constructors

Constructor and Description
FilterWhereBuilder()

Method Summary

Modifier and Type	Method and Description
void	addBind(SQLParam param, String operator) Add name value pair bindings with operator, this is lazy bindings resolved at getWhereClause().
void	addNull(String name) Add null value.
List<SQLParam>	getParams()
StringBuilder	getWhere()
String	getWhereClause() Gets the where clause.
boolean	isIn() There is a need to put the content into brackets.
void	join(String operator, FilterWhereBuilder l, FilterWhereBuilder r) Compound join operator.

Methods inherited from class java.lang.Object

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

Constructor Detail

FilterWhereBuilder

public FilterWhereBuilder()

Method Detail

join

public void join(String operator,
                 FilterWhereBuilder l,
                 FilterWhereBuilder r)

Compound join operator.

Parameters:

operator - AND/OR

l - left FilterQueryBuiler

r - right FilterQueryBuiler

getParams

public List<SQLParam> getParams()

Returns:

the params

getWhere

public StringBuilder getWhere()

Returns:

the where

addBind

public void addBind(SQLParam param,
                    String operator)

Add name value pair bindings with operator, this is lazy bindings resolved at getWhereClause().

Parameters:

param - value to builder

operator - an operator to compare

See Also:

getWhereClause()

addNull

public void addNull(String name)

Add null value.

Parameters:

name - of the column

See Also:

getWhereClause()

isIn

public boolean isIn()

There is a need to put the content into brackets.

Returns:

boolean a in

getWhereClause

public String getWhereClause()

Gets the where clause.

Returns:

the where clause as a String