SQLSelect (Cayenne Server 4.0.M2 API)

java.lang.Object
- org.apache.cayenne.query.IndirectQuery
- - org.apache.cayenne.query.SQLSelect<T>

All Implemented Interfaces:

Serializable, ConfigurationNode, Query, Select<T>
```
public class SQLSelect<T>
extends IndirectQuery
implements Select<T>
```
A selecting query based on raw SQL and featuring fluent API.

Since:

4.0

See Also:
Serialized Form

Field Summary

Fields
Modifier and Type	Field and Description
`protected String[]`	`cacheGroups`
`protected QueryCacheStrategy`	`cacheStrategy`
`protected CapsStrategy`	`columnNameCaps`
`protected String`	`dataMapName`
`protected int`	`limit`
`protected int`	`offset`
`protected int`	`pageSize`
`protected Map<String,Object>`	`params`
`protected Class<T>`	`persistentType`
`protected List<Object>`	`positionalParams`
`protected Class<T>`	`scalarType`
`protected StringBuilder`	`sqlBuffer`
`protected int`	`statementFetchSize`

Fields inherited from class org.apache.cayenne.query.IndirectQuery
dataMap, lastResolver, name, replacementQuery

Constructor Summary

Constructors
Constructor and Description

SQLSelect(Class<T> persistentType, String sql)

SQLSelect(String sql)

Constructors
Constructor and Description
`SQLSelect(Class<T> persistentType, String sql)`
`SQLSelect(String sql)`

Method Summary

Methods
Modifier and Type	Method and Description
`SQLSelect<T>`	`append(String sqlChunk)` Appends a piece of SQL to the previously stored SQL template.
`SQLSelect<T>`	`cacheGroups(Collection<String> cacheGroups)`
`SQLSelect<T>`	`cacheGroups(String... cacheGroups)`
`SQLSelect<T>`	`cacheStrategy(QueryCacheStrategy strategy, String... cacheGroups)`
`SQLSelect<T>`	`columnNameCaps(CapsStrategy columnNameCaps)` Sets a column name capitalization policy applied to selecting queries.
`protected Query`	`createReplacementQuery(EntityResolver resolver)` Creates a substitute query.
`static SQLSelect<DataRow>`	`dataRowQuery(String sql)` Creates a query that selects DataRows and uses default routing.
`static SQLSelect<DataRow>`	`dataRowQuery(String dataMapName, String sql)` Creates a query that selects DataRows and uses routing based on the provided DataMap name.
`String[]`	`getCacheGroups()`
`QueryCacheStrategy`	`getCacheStrategy()`
`CapsStrategy`	`getColumnNameCaps()` Returns a column name capitalization policy applied to selecting queries.
`int`	`getLimit()`
`int`	`getOffset()`
`int`	`getPageSize()`
`Map<String,Object>`	`getParams()` Returns a potentially immmutable map of named parameters that will be bound to SQL.
`List<Object>`	`getPositionalParams()` Returns a potentially immmutable list of positional parameters that will be bound to SQL.
`String`	`getSql()`
`int`	`getStatementFetchSize()`
`boolean`	`isFetchingDataRows()`
`boolean`	`isFetchingScalars()`
`SQLSelect<T>`	`limit(int fetchLimit)`
`SQLSelect<T>`	`localCache(String... cacheGroups)` Instructs Cayenne to look for query results in the "local" cache when running the query.
`SQLSelect<T>`	`lowerColumnNames()` Equivalent of setting `CapsStrategy.LOWER`
`SQLSelect<T>`	`offset(int fetchOffset)`
`SQLSelect<T>`	`pageSize(int pageSize)`
`SQLSelect<T>`	`params(Map<String,?> parameters)`
`SQLSelect<T>`	`params(String name, Object value)`
`SQLSelect<T>`	`paramsArray(Object... params)` Initializes positional parameters of the query.
`SQLSelect<T>`	`paramsList(List<Object> params)` Initializes positional parameters of the query.
`static <T> SQLSelect<T>`	`query(Class<T> type, String sql)` Creates a query that selects DataObjects.
`static <T> SQLSelect<T>`	`scalarQuery(Class<T> type, String sql)` Creates a query that selects scalar values and uses default routing.
`static <T> SQLSelect<T>`	`scalarQuery(Class<T> type, String dataMapName, String sql)` Creates a query that selects scalar values and uses routing based on the provided DataMap name.
`List<T>`	`select(ObjectContext context)` Selects objects using provided context.
`T`	`selectFirst(ObjectContext context)` Selects a single object using provided context.
`T`	`selectOne(ObjectContext context)` Selects a single object using provided context.
`SQLSelect<T>`	`sharedCache(String... cacheGroups)` Instructs Cayenne to look for query results in the "shared" cache when running the query.
`SQLSelect<T>`	`statementFetchSize(int size)` Sets JDBC statement's fetch size (0 for no default size)
`SQLSelect<T>`	`upperColumnNames()` Equivalent of setting `CapsStrategy.UPPER`

Methods inherited from class org.apache.cayenne.query.IndirectQuery
acceptVisitor, createSQLAction, getDataMap, getMetaData, getName, getReplacementQuery, route, setDataMap, setName

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface org.apache.cayenne.query.Query
createSQLAction, getDataMap, getMetaData, getName, route

Methods inherited from interface org.apache.cayenne.configuration.ConfigurationNode
acceptVisitor

- Field Detail
  - persistentType
```
protected Class<T> persistentType
```
  - scalarType
```
protected Class<T> scalarType
```
  - dataMapName
```
protected String dataMapName
```
  - sqlBuffer
```
protected StringBuilder sqlBuffer
```
  - cacheStrategy
```
protected QueryCacheStrategy cacheStrategy
```
  - cacheGroups
```
protected String[] cacheGroups
```
  - params
```
protected Map<String,Object> params
```
  - positionalParams
```
protected List<Object> positionalParams
```
  - columnNameCaps
```
protected CapsStrategy columnNameCaps
```
  - limit
```
protected int limit
```
  - offset
```
protected int offset
```
  - pageSize
```
protected int pageSize
```
  - statementFetchSize
```
protected int statementFetchSize
```
- Constructor Detail
  - SQLSelect
```
public SQLSelect(String sql)
```
  - SQLSelect
```
public SQLSelect(Class<T> persistentType,
         String sql)
```
- Method Detail
  - dataRowQuery
```
public static SQLSelect<DataRow> dataRowQuery(String sql)
```
    Creates a query that selects DataRows and uses default routing.
  - dataRowQuery
```
public static SQLSelect<DataRow> dataRowQuery(String dataMapName,
                              String sql)
```
    Creates a query that selects DataRows and uses routing based on the provided DataMap name.
  - query
```
public static <T> SQLSelect<T> query(Class<T> type,
                     String sql)
```
    Creates a query that selects DataObjects.
  - scalarQuery
```
public static <T> SQLSelect<T> scalarQuery(Class<T> type,
                           String sql)
```
    Creates a query that selects scalar values and uses default routing.
  - scalarQuery
```
public static <T> SQLSelect<T> scalarQuery(Class<T> type,
                           String dataMapName,
                           String sql)
```
    Creates a query that selects scalar values and uses routing based on the provided DataMap name.
  - select
```
public List<T> select(ObjectContext context)
```
    Selects objects using provided context. Essentially the inversion of "ObjectContext.select(query)".
  - selectOne
```
public T selectOne(ObjectContext context)
```
    Selects a single object using provided context. The query is expected to match zero or one object. It returns null if no objects were matched. If query matched more than one object, CayenneRuntimeException is thrown.
    Essentially the inversion of "ObjectContext.selectOne(Select)".
  - selectFirst
```
public T selectFirst(ObjectContext context)
```
    Selects a single object using provided context. The query itself can match any number of objects, but will return only the first one. It returns null if no objects were matched.
    If it matched more than one object, the first object from the list is returned. This makes 'selectFirst' different from selectOne(ObjectContext), which would throw in this situation. 'selectFirst' is useful e.g. when the query is ordered and we only want to see the first object (e.g. "most recent news article"), etc.
    This method is equivalent to calling "limit(1).selectOne(context)".
  - isFetchingDataRows
```
public boolean isFetchingDataRows()
```
  - isFetchingScalars
```
public boolean isFetchingScalars()
```
  - getSql
```
public String getSql()
```
  - append
```
public SQLSelect<T> append(String sqlChunk)
```
    Appends a piece of SQL to the previously stored SQL template.
  - params
```
public SQLSelect<T> params(String name,
                  Object value)
```
  - params
```
public SQLSelect<T> params(Map<String,?> parameters)
```
  - paramsArray
```
public SQLSelect<T> paramsArray(Object... params)
```
    Initializes positional parameters of the query. Parameters are bound in the order they are found in the SQL template. If a given parameter name is used more than once, only the first occurrence is treated as "position", subsequent occurrences are bound with the same value as the first one. If template parameters count is different from the array parameter count, an exception will be thrown.
    Note that calling this method will reset any previously set *named* parameters.
  - paramsList
```
public SQLSelect<T> paramsList(List<Object> params)
```
    Initializes positional parameters of the query. Parameters are bound in the order they are found in the SQL template. If a given parameter name is used more than once, only the first occurrence is treated as "position", subsequent occurrences are bound with the same value as the first one. If template parameters count is different from the list parameter count, an exception will be thrown.
    Note that calling this method will reset any previously set *named* parameters.
  - getParams
```
public Map<String,Object> getParams()
```
    Returns a potentially immmutable map of named parameters that will be bound to SQL.
  - getPositionalParams
```
public List<Object> getPositionalParams()
```
    Returns a potentially immmutable list of positional parameters that will be bound to SQL.
  - createReplacementQuery
```
protected Query createReplacementQuery(EntityResolver resolver)
```
    Description copied from class: IndirectQuery
    
    Creates a substitute query. An implementor is free to provide an arbitrary replacement query.
    
    Specified by:
    
    createReplacementQuery in class IndirectQuery
  - localCache
```
public SQLSelect<T> localCache(String... cacheGroups)
```
    Instructs Cayenne to look for query results in the "local" cache when running the query. This is a short-hand notation for:
```
 query.cacheStrategy(QueryCacheStrategy.LOCAL_CACHE, cacheGroups);
 
```
  - sharedCache
```
public SQLSelect<T> sharedCache(String... cacheGroups)
```
    Instructs Cayenne to look for query results in the "shared" cache when running the query. This is a short-hand notation for:
```
 query.cacheStrategy(QueryCacheStrategy.SHARED_CACHE, cacheGroups);
 
```
  - getCacheStrategy
```
public QueryCacheStrategy getCacheStrategy()
```
  - cacheStrategy
```
public SQLSelect<T> cacheStrategy(QueryCacheStrategy strategy,
                         String... cacheGroups)
```
  - getCacheGroups
```
public String[] getCacheGroups()
```
  - cacheGroups
```
public SQLSelect<T> cacheGroups(String... cacheGroups)
```
  - cacheGroups
```
public SQLSelect<T> cacheGroups(Collection<String> cacheGroups)
```
  - getColumnNameCaps
```
public CapsStrategy getColumnNameCaps()
```
    Returns a column name capitalization policy applied to selecting queries. This is used to simplify mapping of the queries like "SELECT * FROM ...", ensuring that a chosen Cayenne column mapping strategy (e.g. all column names in uppercase) is portable across database engines that can have varying default capitalization. Default (null) value indicates that column names provided in result set are used unchanged.
  - columnNameCaps
```
public SQLSelect<T> columnNameCaps(CapsStrategy columnNameCaps)
```
    Sets a column name capitalization policy applied to selecting queries. This is used to simplify mapping of the queries like "SELECT * FROM ...", ensuring that a chosen Cayenne column mapping strategy (e.g. all column names in uppercase) is portable across database engines that can have varying default capitalization. Default (null) value indicates that column names provided in result set are used unchanged.
    Note that while a non-default setting is useful for queries that do not rely on a #result directive to describe columns, it works for all SQLTemplates the same way.
  - upperColumnNames
```
public SQLSelect<T> upperColumnNames()
```
    Equivalent of setting CapsStrategy.UPPER
  - lowerColumnNames
```
public SQLSelect<T> lowerColumnNames()
```
    Equivalent of setting CapsStrategy.LOWER
  - getLimit
```
public int getLimit()
```
  - limit
```
public SQLSelect<T> limit(int fetchLimit)
```
  - getOffset
```
public int getOffset()
```
  - offset
```
public SQLSelect<T> offset(int fetchOffset)
```
  - getPageSize
```
public int getPageSize()
```
  - pageSize
```
public SQLSelect<T> pageSize(int pageSize)
```
  - statementFetchSize
```
public SQLSelect<T> statementFetchSize(int size)
```
    Sets JDBC statement's fetch size (0 for no default size)
  - getStatementFetchSize
```
public int getStatementFetchSize()
```
    Returns:
    JBDC statement's fetch size

Class SQLSelect<T>

Field Summary

Fields inherited from class org.apache.cayenne.query.IndirectQuery

Constructor Summary

Method Summary

Methods inherited from class org.apache.cayenne.query.IndirectQuery

Methods inherited from class java.lang.Object

Methods inherited from interface org.apache.cayenne.query.Query

Methods inherited from interface org.apache.cayenne.configuration.ConfigurationNode

Field Detail

persistentType

scalarType

dataMapName

sqlBuffer

cacheStrategy

cacheGroups

params

positionalParams

columnNameCaps

limit

offset

pageSize

statementFetchSize

Constructor Detail

SQLSelect

SQLSelect

Method Detail

dataRowQuery

dataRowQuery

query

scalarQuery

scalarQuery

select

selectOne

selectFirst

isFetchingDataRows

isFetchingScalars

getSql

append

params

params

paramsArray

paramsList

getParams

getPositionalParams

createReplacementQuery

localCache

sharedCache

getCacheStrategy

cacheStrategy

getCacheGroups

cacheGroups

cacheGroups

getColumnNameCaps

columnNameCaps

upperColumnNames

lowerColumnNames

getLimit

limit

getOffset

offset

getPageSize

pageSize

statementFetchSize

getStatementFetchSize