Uses of Class
org.apache.cayenne.query.SQLSelect

Packages that use SQLSelect

Package	Description
org.apache.cayenne.query	Defines standard queries supported by Cayenne and extension mechanism to create custom queries.

Uses of SQLSelect in org.apache.cayenne.query

Methods in org.apache.cayenne.query that return SQLSelect

Modifier and Type	Method	Description
SQLSelect<T>	SQLSelect.addPrefetch(String path, int semantics)	Merges a prefetch path with specified semantics into the query prefetch tree.
SQLSelect<T>	SQLSelect.addPrefetch(PrefetchTreeNode node)	Merges a prefetch into the query prefetch tree.
SQLSelect<T>	SQLSelect.append(String sqlChunk)	Appends a piece of SQL to the previously stored SQL template.
SQLSelect<T>	SQLSelect.cacheGroup(String cacheGroup)
SQLSelect<T>	SQLSelect.cacheStrategy(QueryCacheStrategy strategy)
SQLSelect<T>	SQLSelect.cacheStrategy(QueryCacheStrategy strategy, String cacheGroup)
SQLSelect<T>	SQLSelect.columnNameCaps(CapsStrategy columnNameCaps)	Sets a column name capitalization policy applied to selecting queries.
static SQLSelect<Object[]>	SQLSelect.columnQuery(String sql)	Creates query that selects scalar values (as Object[]) and uses default routing
static SQLSelect<Object[]>	SQLSelect.columnQuery(String sql, Class<?>... types)	Creates query that selects scalar values (as Object[]) and uses default routing
static SQLSelect<Object[]>	SQLSelect.columnQuery(String sql, String dataMapName)	Creates query that selects scalar values (as Object[]) and uses routing based on the provided DataMap name.
static SQLSelect<Object[]>	SQLSelect.columnQuery(String sql, String dataMapName, Class<?>... types)	Creates query that selects scalar values (as Object[]) and uses routing based on the provided DataMap name.
static SQLSelect<DataRow>	SQLSelect.dataRowQuery(String sql)	Creates a query that selects DataRows and uses default routing.
static SQLSelect<DataRow>	SQLSelect.dataRowQuery(String sql, Class<?>... types)	Creates a query that selects DataRows and uses default routing.
static SQLSelect<DataRow>	SQLSelect.dataRowQuery(String dataMapName, String sql)	Creates a query that selects DataRows and uses routing based on the provided DataMap name.
static SQLSelect<DataRow>	SQLSelect.dataRowQuery(String dataMapName, String sql, Class<?>... types)	Creates a query that selects DataRows and uses routing based on the provided DataMap name.
SQLSelect<T>	SQLSelect.limit(int fetchLimit)
SQLSelect<T>	SQLSelect.localCache()	Instructs Cayenne to look for query results in the "local" cache when running the query.
SQLSelect<T>	SQLSelect.localCache(String cacheGroup)	Instructs Cayenne to look for query results in the "local" cache when running the query.
SQLSelect<T>	SQLSelect.lowerColumnNames()	Equivalent of setting CapsStrategy.LOWER
<E> SQLSelect<E>	SQLSelect.map(Function<T,E> mapper)	Map result of this query by processing with a given function.
SQLSelect<T>	SQLSelect.offset(int fetchOffset)
SQLSelect<T>	SQLSelect.pageSize(int pageSize)
SQLSelect<T>	SQLSelect.param(String name, Object value)
SQLSelect<T>	SQLSelect.params(String name, Object value)	Deprecated. since 4.2 Use param(String, Object)
SQLSelect<T>	SQLSelect.params(Map<String,?> parameters)
SQLSelect<T>	SQLSelect.paramsArray(Object... params)	Initializes positional parameters of the query.
SQLSelect<T>	SQLSelect.paramsList(List<Object> params)	Initializes positional parameters of the query.
static <T> SQLSelect<T>	SQLSelect.query(Class<T> type, String sql)	Creates a query that selects DataObjects.
SQLSelect<T>	SQLSelect.queryTimeout(int queryTimeout)	Sets query timeout
static <T> SQLSelect<T>	SQLSelect.scalarQuery(Class<T> type, String sql)	Deprecated. since 4.2.
static <T> SQLSelect<T>	SQLSelect.scalarQuery(Class<T> type, String dataMapName, String sql)	Deprecated. since 4.2.
static SQLSelect<Object[]>	SQLSelect.scalarQuery(String sql)	Deprecated. since 4.2.
static SQLSelect<Object[]>	SQLSelect.scalarQuery(String sql, Class<?>... types)	Deprecated. since 4.2.
static <T> SQLSelect<T>	SQLSelect.scalarQuery(String sql, Class<T> type)	Creates query that selects scalar value and uses default routing
static SQLSelect<Object[]>	SQLSelect.scalarQuery(String sql, String dataMapName)	Deprecated. since 4.2.
static SQLSelect<Object[]>	SQLSelect.scalarQuery(String sql, String dataMapName, Class<?>... types)	Deprecated. since 4.2.
static <T> SQLSelect<T>	SQLSelect.scalarQuery(String sql, String dataMapName, Class<T> type)	Creates query that selects scalar value and uses default routing
SQLSelect<T>	SQLSelect.sharedCache()	Instructs Cayenne to look for query results in the "shared" cache when running the query.
SQLSelect<T>	SQLSelect.sharedCache(String cacheGroup)	Instructs Cayenne to look for query results in the "shared" cache when running the query.
SQLSelect<T>	SQLSelect.statementFetchSize(int size)	Sets JDBC statement's fetch size (0 for no default size)
SQLSelect<T>	SQLSelect.upperColumnNames()	Equivalent of setting CapsStrategy.UPPER