weave.utils

Class SQLUtils.WhereClauseBuilder<V>

java.lang.Object

weave.utils.SQLUtils.WhereClauseBuilder<V>

Enclosing class:

SQLUtils

public static class SQLUtils.WhereClauseBuilder<V>
extends java.lang.Object

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
protected static class	SQLUtils.WhereClauseBuilder.Condition

Constructor Summary

Constructors

Constructor and Description
SQLUtils.WhereClauseBuilder(boolean conjunctive)

Method Summary

Methods

Modifier and Type	Method and Description
SQLUtils.WhereClauseBuilder<V>	addGroupedConditions(java.util.Map<java.lang.String,V> fieldsAndValues, java.util.Map<java.lang.String,SQLUtils.CompareMode> compareModes) Adds a set of grouped inner conditions.
SQLUtils.WhereClauseBuilder<V>	addGroupedConditions(java.util.Map<java.lang.String,V> fieldsAndValues, java.util.Set<java.lang.String> caseSensitiveFields, java.util.Set<java.lang.String> wildcardFields) Adds a set of grouped inner conditions.
SQLUtils.WhereClause<V>	build(java.sql.Connection conn) Builds a WhereClause based on the conditions previously specified with addGroupedConditions().
protected java.lang.String	buildNormalForm(java.sql.Connection conn)
int	countGroups() Checks the number of groups which have been added via addGroupedConditions().

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLUtils.WhereClauseBuilder

public SQLUtils.WhereClauseBuilder(boolean conjunctive)

Parameters:

conjunctive - Set to true for Conjunctive Normal Form: (a OR b) AND (x OR y). Set to false for Disjunctive Normal Form: (a AND b) OR (x AND y).

Method Detail

addGroupedConditions

public SQLUtils.WhereClauseBuilder<V> addGroupedConditions(java.util.Map<java.lang.String,V> fieldsAndValues,
                                                  java.util.Set<java.lang.String> caseSensitiveFields,
                                                  java.util.Set<java.lang.String> wildcardFields)
                                                    throws java.sql.SQLException

Adds a set of grouped inner conditions. Conjunctive Normal Form uses outer AND logic and will group these inner conditions with OR logic like (field1 = value1 OR field2 = value2). Disjunctive Normal Form uses outer OR logic and will group these inner conditions with AND logic like (field1 = value1 AND field2 = value2).

Parameters:

fieldsAndValues - Unquoted field names mapped to raw values

caseSensitiveFields - A set of field names which should use case sensitive compare.

wildcardFields - A set of field names which should use a "LIKE" SQL clause for wildcard search.

Throws:

java.sql.SQLException

See Also:

SQLUtils.convertWildcards(String)

addGroupedConditions

public SQLUtils.WhereClauseBuilder<V> addGroupedConditions(java.util.Map<java.lang.String,V> fieldsAndValues,
                                                  java.util.Map<java.lang.String,SQLUtils.CompareMode> compareModes)
                                                    throws java.sql.SQLException

Adds a set of grouped inner conditions. Conjunctive Normal Form uses outer AND logic and will group these inner conditions with OR logic like (field1 = value1 OR field2 = value2). Disjunctive Normal Form uses outer OR logic and will group these inner conditions with AND logic like (field1 = value1 AND field2 = value2).

Parameters:

fieldsAndValues - Unquoted field names mapped to raw values

compareModes - Field names mapped to compare modes

Throws:

java.sql.SQLException

See Also:

SQLUtils.convertWildcards(String)

countGroups

public int countGroups()

Checks the number of groups which have been added via addGroupedConditions().

Returns:

The number of groups.

build

public SQLUtils.WhereClause<V> build(java.sql.Connection conn)
                              throws java.sql.SQLException

Builds a WhereClause based on the conditions previously specified with addGroupedConditions().

Parameters:

conn - A SQL Connection for which the query will be formatted.

Returns:

A WhereClause.

Throws:

java.sql.SQLException

buildNormalForm

protected java.lang.String buildNormalForm(java.sql.Connection conn)
                                    throws java.sql.SQLException

Throws:

java.sql.SQLException