org.springframework.data.r2dbc.core

Class NamedParameterExpander

java.lang.Object

org.springframework.data.r2dbc.core.NamedParameterExpander

Deprecated.

since 1.2, without replacement.

@Deprecated
public class NamedParameterExpander
extends Object

SQL translation support allowing the use of named parameters rather than native placeholders.

This class expands SQL from named parameters to native style placeholders at execution time. It also allows for expanding a List of values to the appropriate number of placeholders.

References to the same parameter name are substituted with the same bind marker placeholder if a BindMarkersFactory uses identifiable placeholders.

NOTE: An instance of this class is thread-safe once configured.

Author:

Mark Paluch

Field Summary

Fields

Modifier and Type	Field and Description
static int	DEFAULT_CACHE_LIMIT Deprecated. Default maximum number of entries for the SQL cache: 256.

Constructor Summary

Constructors

Constructor and Description
NamedParameterExpander() Deprecated. Create a new enabled instance of NamedParameterExpander.

Method Summary

Modifier and Type	Method and Description
PreparedOperation<String>	expand(String sql, BindMarkersFactory bindMarkersFactory, BindParameterSource paramSource) Deprecated. Parse the SQL statement and locate any placeholders or named parameters.
int	getCacheLimit() Deprecated. Return the maximum number of entries for the SQL cache.
List<String>	getParameterNames(String sql) Deprecated. Parse the SQL statement and locate any placeholders or named parameters.
void	setCacheLimit(int cacheLimit) Deprecated. Specify the maximum number of entries for the SQL cache.

Methods inherited from class java.lang.Object

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

Field Detail

DEFAULT_CACHE_LIMIT

public static final int DEFAULT_CACHE_LIMIT

Deprecated.

Default maximum number of entries for the SQL cache: 256.

See Also:

Constant Field Values

Constructor Detail

NamedParameterExpander

public NamedParameterExpander()

Deprecated.

Create a new enabled instance of NamedParameterExpander.

Method Detail

setCacheLimit

public void setCacheLimit(int cacheLimit)

Deprecated.

Specify the maximum number of entries for the SQL cache. Default is 256.

getCacheLimit

public int getCacheLimit()

Deprecated.

Return the maximum number of entries for the SQL cache.

expand

public PreparedOperation<String> expand(String sql,
                                        BindMarkersFactory bindMarkersFactory,
                                        BindParameterSource paramSource)

Deprecated.

Parse the SQL statement and locate any placeholders or named parameters. Named parameters are substituted for a native placeholder, and any select list is expanded to the required number of placeholders. Select lists may contain an array of objects, and in that case the placeholders will be grouped and enclosed with parentheses. This allows for the use of "expression lists" in the SQL statement like:

select id, name, state from table where (name, age) in (('John', 35), ('Ann', 50))

The parameter values passed in are used to determine the number of placeholders to be used for a select list. Select lists should be limited to 100 or fewer elements. A larger number of elements is not guaranteed to be supported by the database and is strictly vendor-dependent.

Parameters:

sql - sql the original SQL statement

bindMarkersFactory - the bind marker factory.

paramSource - the source for named parameters.

Returns:

the expanded sql that accepts bind parameters and allows for execution without further translation wrapped as PreparedOperation.

getParameterNames

public List<String> getParameterNames(String sql)

Deprecated.

Parse the SQL statement and locate any placeholders or named parameters. Named parameters are returned as result of this method invocation.

Returns:

the parameter names.