com.denodo.scheduler.client.commons.utils

Class QueryUtil

java.lang.Object

com.denodo.scheduler.client.commons.utils.QueryUtil

public final class QueryUtil
extends java.lang.Object

Utility class for parameterized queries

Since:

5.0

Method Summary

Modifier and Type	Method and Description
static java.lang.String	buildFromMap(java.lang.String element, java.util.Map<java.lang.String,java.lang.Object> parameters)
static java.util.Map<java.lang.String,java.lang.String>	buildMap(java.lang.String query)
static java.lang.String	escapeQueryParam(java.lang.String query) Escape unsafe characters.
static java.lang.String	escapeQueryParam(java.lang.String query, java.lang.String value)
static java.lang.String	fixQuery(java.lang.String query) Removes carriage return characters from query
static java.lang.String	getViewNameFromQuery(java.lang.String query)
static java.lang.String	interpolateQuery(java.lang.String query, java.util.Map<java.lang.String,java.lang.Object> params) Obtains a valid statement filling the parameters with the values supplied.
static boolean	isNonParameterizedQuery(java.lang.String query) Returns false if the given query is a parameterized one: 'SELECT f1, f2, f3 FROM v1 WHERE f1=@f1 AND f2=@f2'.
static java.util.Collection<java.lang.String>	obtainQueryParams(java.lang.String query) Returns the name of the parameters of a parameterized query of the form: 'SELECT f1, f2, f3 FROM v1 WHERE f1=@f1 AND f2=@f2'.
static java.lang.String	stripSemicolon(java.lang.String query)
static java.lang.String	unescapeQuery(java.lang.String query) Unescape unsafe characters.
static java.lang.String	unescapeQueryParam(java.lang.String query) Unescape unsafe characters.
static java.lang.String	unescapeQueryParam(java.lang.String query, java.lang.String value)

Methods inherited from class java.lang.Object

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

Method Detail

fixQuery

public static java.lang.String fixQuery(java.lang.String query)

Removes carriage return characters from query

isNonParameterizedQuery

public static boolean isNonParameterizedQuery(java.lang.String query)

Returns false if the given query is a parameterized one: 'SELECT f1, f2, f3 FROM v1 WHERE f1=@f1 AND f2=@f2'. A variable in a parameterized query must be specified by prefixing it with the symbol '@'. A non parameterized query only could have escaped '@'.

obtainQueryParams

public static java.util.Collection<java.lang.String> obtainQueryParams(java.lang.String query)

Returns the name of the parameters of a parameterized query of the form: 'SELECT f1, f2, f3 FROM v1 WHERE f1=@f1 AND f2=@f2'.

interpolateQuery

public static java.lang.String interpolateQuery(java.lang.String query,
                                                java.util.Map<java.lang.String,java.lang.Object> params)

Obtains a valid statement filling the parameters with the values supplied.

Parameters:

params - a Map of

unescapeQuery

public static java.lang.String unescapeQuery(java.lang.String query)

Unescape unsafe characters. Returns a string with each "\@" sequence replaced with the actual "@".

Parameters:

query -

Returns:

a string with each "\@" sequence replaced with the actual "@".

unescapeQueryParam

public static java.lang.String unescapeQueryParam(java.lang.String query)

Unescape unsafe characters. Returns a string with each "\@" sequence replaced with the actual "@".

Parameters:

query -

Returns:

a string with each "\@" sequence replaced with the actual "@".

unescapeQueryParam

public static java.lang.String unescapeQueryParam(java.lang.String query,
                                                  java.lang.String value)

escapeQueryParam

public static java.lang.String escapeQueryParam(java.lang.String query)

Escape unsafe characters. Returns a string with each "=","?" and "&" sequence replaced with "\\=","\\?" and "\\&".

Parameters:

query -

Returns:

a string with each "=","?" and "&" sequence replaced with "\\=","\\?" and "\\&".

escapeQueryParam

public static java.lang.String escapeQueryParam(java.lang.String query,
                                                java.lang.String value)

stripSemicolon

public static java.lang.String stripSemicolon(java.lang.String query)

buildMap

public static java.util.Map<java.lang.String,java.lang.String> buildMap(java.lang.String query)

Parameters:

query - follow a 'name then equal sign then value then ampersand' convention.

Returns:

a Map of pairs name of attribute/value. If query is null an empty Map is returned.

buildFromMap

public static java.lang.String buildFromMap(java.lang.String element,
                                            java.util.Map<java.lang.String,java.lang.Object> parameters)

Parameters:

element -

parameters - a Map of pairs name of attribute/value.

Returns:

a query defined as element[?parameters] and the parameters following the 'name then equal sign then value then ampersand' convention.

getViewNameFromQuery

public static java.lang.String getViewNameFromQuery(java.lang.String query)