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

Packages that use SQLSelect

Package	Description
org.apache.cayenne.query

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(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 Persistent objects.
SQLSelect<T>	SQLSelect.queryTimeout(int queryTimeout)	Sets query timeout
static <T> SQLSelect<T>	SQLSelect.scalarQuery(String sql, Class<T> type)	Creates query that selects scalar value and uses default routing
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