com.saperion.database

Interface QueryTextGenerator

public interface QueryTextGenerator

Interface for use with database sessions able to create query text from given data.

Author:

jschwarz

Nested Class Summary

Nested Classes

Modifier and Type	Interface and Description
static interface	QueryTextGenerator.StringBuilderAppender

Field Summary

Fields

Modifier and Type	Field and Description
static String	PREFIX_PARAMETER_IDENTIFIER

Method Summary

Methods

Modifier and Type	Method and Description
void	appendBinaryOperation(String operatorIdentifier, int precedence, QueryTextGenerator.StringBuilderAppender operand1Appender, QueryTextGenerator.StringBuilderAppender operand2Appender, StringBuilder builder)
void	appendBooleanLiteral(boolean value, StringBuilder builder)
void	appendFieldName(String fieldName, StringBuilder builder)
void	appendNumericalLiteral(Number value, StringBuilder builder)
void	appendOperand(QueryExpression operand, int precedence, StringBuilder builder) Appends the given operand as child of an operation with the given precedence to the given StringBuilder.
void	appendParameterName(String parameterName, StringBuilder builder)
void	appendStringLiteral(String value, StringBuilder builder)
void	appendUnaryOperation(String operatorIdentifier, QueryTextGenerator.StringBuilderAppender stringBuilderAppender, StringBuilder builder)
int	binaryOperationSizeGuess(String operatorIdentifier, int sizeGuessOperand1, int sizeGuessOperand2)
int	booleanLiteralSizeGuess()
String	createSelectQuery(String tableName, String tableAlias, QueryExpression condition) Creates the string of a select query for the given parameters.
int	fieldNameSizeGuess(String fieldName)
int	numericalLiteralSizeGuess()
int	parameterNameSizeGuess(String parameterName)
int	stringLiteralSizeGuess(String value)
String	translateSaperionPattern(String parameterValue)
int	unaryOperationSizeGuess(String operatorIdentifier, int sizeGuessOperand)
String	uniqueIdentifier(String identifierPrefix) creates an syntactically valid identifier that is unique and starts with the given prefix.

Field Detail

PREFIX_PARAMETER_IDENTIFIER

static final String PREFIX_PARAMETER_IDENTIFIER

See Also:

Constant Field Values

Method Detail

uniqueIdentifier

String uniqueIdentifier(String identifierPrefix)

creates an syntactically valid identifier that is unique and starts with the given prefix. The given prefix needs to be syntactically correct. If the given prefix is not a valid identifier the behaviour of this method is undefined.

Parameters:

identifierPrefix - the prefix for the identifier

Returns:

an syntactically valid identifier that is unique and starts with the given prefix

createSelectQuery

String createSelectQuery(String tableName,
                       String tableAlias,
                       QueryExpression condition)

Creates the string of a select query for the given parameters.

Parameters:

tableName - the name of the table to select on

tableAlias - the alias to give the table - for reference in the condition

condition - the where clause of the query

Returns:

the string of a select query for the given parameters

appendOperand

void appendOperand(QueryExpression operand,
                 int precedence,
                 StringBuilder builder)

Appends the given operand as child of an operation with the given precedence to the given StringBuilder. It is assumed, that the builder builds the where clause of a query.

Parameters:

operand - the operand to append

precedence - the precedence of the operands operation

builder - the builder to append to

appendBinaryOperation

void appendBinaryOperation(String operatorIdentifier,
                         int precedence,
                         QueryTextGenerator.StringBuilderAppender operand1Appender,
                         QueryTextGenerator.StringBuilderAppender operand2Appender,
                         StringBuilder builder)

appendUnaryOperation

void appendUnaryOperation(String operatorIdentifier,
                        QueryTextGenerator.StringBuilderAppender stringBuilderAppender,
                        StringBuilder builder)

binaryOperationSizeGuess

int binaryOperationSizeGuess(String operatorIdentifier,
                           int sizeGuessOperand1,
                           int sizeGuessOperand2)

unaryOperationSizeGuess

int unaryOperationSizeGuess(String operatorIdentifier,
                          int sizeGuessOperand)

appendBooleanLiteral

void appendBooleanLiteral(boolean value,
                        StringBuilder builder)

booleanLiteralSizeGuess

int booleanLiteralSizeGuess()

appendFieldName

void appendFieldName(String fieldName,
                   StringBuilder builder)

appendParameterName

void appendParameterName(String parameterName,
                       StringBuilder builder)

fieldNameSizeGuess

int fieldNameSizeGuess(String fieldName)

parameterNameSizeGuess

int parameterNameSizeGuess(String parameterName)

translateSaperionPattern

String translateSaperionPattern(String parameterValue)

appendNumericalLiteral

void appendNumericalLiteral(Number value,
                          StringBuilder builder)

numericalLiteralSizeGuess

int numericalLiteralSizeGuess()

appendStringLiteral

void appendStringLiteral(String value,
                       StringBuilder builder)

stringLiteralSizeGuess

int stringLiteralSizeGuess(String value)