com.atlassian.confluence.impl.hibernate.query

Class InExpressionBuilder

java.lang.Object

com.atlassian.confluence.impl.hibernate.query.InExpressionBuilder

@Internal
public class InExpressionBuilder
extends Object

Builder for dealing with query strings using the IN clause (or NOT IN clause). Some database dialects have limits and need to be handled specifically.

Since:

6.4.1

Method Summary

Modifier and Type	Method and Description
String	buildInExpressionString() If required, split up the IN/NOT-IN expression into smaller partitions which are within the IN clause limitations.
static InExpressionBuilder	getInExpressionBuilderCustomLimit(String fieldName, String parameterName, List<String> parameterValues, int inExpressionLimit)
static InExpressionBuilder	getInExpressionBuilderDefaultLimit(String fieldName, String parameterName, List<String> parameterValues)
static InExpressionBuilder	getNotInExpressionBuilderCustomLimit(String fieldName, String parameterName, List<String> parameterValues, int inExpressionLimit)
static InExpressionBuilder	getNotInExpressionBuilderDefaultLimit(String fieldName, String parameterName, List<String> parameterValues)
void	substituteInExpressionParameters(org.hibernate.query.Query query) Takes in a Query and substitutes actual values into the parameter lists, according to the IN clause limitations.

Methods inherited from class java.lang.Object

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

Method Detail

getInExpressionBuilderDefaultLimit

public static InExpressionBuilder getInExpressionBuilderDefaultLimit(String fieldName,
                                                                     String parameterName,
                                                                     List<String> parameterValues)

getInExpressionBuilderCustomLimit

public static InExpressionBuilder getInExpressionBuilderCustomLimit(String fieldName,
                                                                    String parameterName,
                                                                    List<String> parameterValues,
                                                                    int inExpressionLimit)

getNotInExpressionBuilderDefaultLimit

public static InExpressionBuilder getNotInExpressionBuilderDefaultLimit(String fieldName,
                                                                        String parameterName,
                                                                        List<String> parameterValues)

getNotInExpressionBuilderCustomLimit

public static InExpressionBuilder getNotInExpressionBuilderCustomLimit(String fieldName,
                                                                       String parameterName,
                                                                       List<String> parameterValues,
                                                                       int inExpressionLimit)

buildInExpressionString

public String buildInExpressionString()

If required, split up the IN/NOT-IN expression into smaller partitions which are within the IN clause limitations.

Returns:

The expression modified into smaller partitions if required. If list is empty, simply returns a false expression "(1 = 0)".

substituteInExpressionParameters

public void substituteInExpressionParameters(org.hibernate.query.Query query)

Takes in a Query and substitutes actual values into the parameter lists, according to the IN clause limitations.

Parameters:

query - The query to substitute actual parameter values into.