ch.jalu.datasourcecolumns.sqlimplementation

Class PredicateSqlGenerator<C>

java.lang.Object

ch.jalu.datasourcecolumns.sqlimplementation.PredicateSqlGenerator<C>

Type Parameters:

C - the context type

public class PredicateSqlGenerator<C>
extends Object

Converts Predicate instances to SQL.

Constructor Summary

Constructors

Constructor and Description
PredicateSqlGenerator(C context) Constructor.
PredicateSqlGenerator(C context, boolean useNoCaseCollationForCaseInsensitiveEquals) Constructor.

Method Summary

Modifier and Type	Method and Description
protected void	addAlwaysTruePredicate(StringBuilder sqlResult)
protected String	convertComparingTypeToSqlOperator(ComparingPredicate.Type type)
GeneratedSqlWithBindings	generateWhereClause(Predicate<C> predicate) Generates SQL to use as WHERE clause in a query.
protected void	generateWhereClause(Predicate<C> predicate, StringBuilder sqlResult, List<Object> objects)
protected void	processCombiningClause(Predicate<C> left, Predicate<C> right, String operator, StringBuilder sqlResult, List<Object> objects)
protected void	processComparingClause(ComparingPredicate<?,C> predicate, StringBuilder sqlResult, List<Object> objects)
protected void	processEqualsIgnoreCasePredicate(EqualsIgnoreCasePredicate<C> predicate, StringBuilder sqlResult, List<Object> objects) Adds the SQL code for the given predicate.
protected void	processIsNullAndNotNullPredicate(boolean isNegated, Column<?,C> column, StringBuilder sqlResult)

Methods inherited from class java.lang.Object

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

Constructor Detail

PredicateSqlGenerator

public PredicateSqlGenerator(C context)

Constructor.

Parameters:

context - the context

PredicateSqlGenerator

public PredicateSqlGenerator(C context,
                             boolean useNoCaseCollationForCaseInsensitiveEquals)

Constructor.

Parameters:

context - the context

useNoCaseCollationForCaseInsensitiveEquals - true to generate SQL with COLLATE NOCASE for EqualsIgnoreCasePredicate. Not supported and/or needed by all database engines; see class JavaDoc on EqualsIgnoreCasePredicate.

Method Detail

generateWhereClause

public GeneratedSqlWithBindings generateWhereClause(Predicate<C> predicate)

Generates SQL to use as WHERE clause in a query.

Parameters:

predicate - the predicate to convert to SQL

Returns:

the generated SQL code

generateWhereClause

protected void generateWhereClause(Predicate<C> predicate,
                                   StringBuilder sqlResult,
                                   List<Object> objects)

addAlwaysTruePredicate

protected void addAlwaysTruePredicate(StringBuilder sqlResult)

processComparingClause

protected void processComparingClause(ComparingPredicate<?,C> predicate,
                                      StringBuilder sqlResult,
                                      List<Object> objects)

processEqualsIgnoreCasePredicate

protected void processEqualsIgnoreCasePredicate(EqualsIgnoreCasePredicate<C> predicate,
                                                StringBuilder sqlResult,
                                                List<Object> objects)

Adds the SQL code for the given predicate. Please note that class Javadoc on EqualsIgnoreCasePredicate for an important caveat!

Parameters:

predicate - the predicate to generate SQL for

sqlResult - the string builder saving the SQL for all predicates

objects - list objects to bind to the generated SQL code

convertComparingTypeToSqlOperator

protected String convertComparingTypeToSqlOperator(ComparingPredicate.Type type)

processIsNullAndNotNullPredicate

protected void processIsNullAndNotNullPredicate(boolean isNegated,
                                                Column<?,C> column,
                                                StringBuilder sqlResult)

processCombiningClause

protected void processCombiningClause(Predicate<C> left,
                                      Predicate<C> right,
                                      String operator,
                                      StringBuilder sqlResult,
                                      List<Object> objects)