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() |
|
<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.
|
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.
|
static <T> SQLSelect<T> |
SQLSelect.scalarQuery(Class<T> type,
String dataMapName,
String sql) |
Deprecated.
|
static SQLSelect<Object[]> |
SQLSelect.scalarQuery(String sql) |
Deprecated.
|
static SQLSelect<Object[]> |
SQLSelect.scalarQuery(String sql,
Class<?>... types) |
Deprecated.
|
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.
|
static SQLSelect<Object[]> |
SQLSelect.scalarQuery(String sql,
String dataMapName,
Class<?>... types) |
Deprecated.
|
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() |
|