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 and Description
SQLSelect<T>	SQLSelect.append(String sqlChunk) Appends a piece of SQL to the previously stored SQL template.
SQLSelect<T>	SQLSelect.cacheGroups(Collection<String> cacheGroups)
SQLSelect<T>	SQLSelect.cacheGroups(String... cacheGroups)
SQLSelect<T>	SQLSelect.cacheStrategy(QueryCacheStrategy strategy, String... cacheGroups)
SQLSelect<T>	SQLSelect.columnNameCaps(CapsStrategy columnNameCaps) Sets a column name capitalization policy applied to selecting queries.
static SQLSelect<DataRow>	SQLSelect.dataRowQuery(String sql) 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.
SQLSelect<T>	SQLSelect.limit(int fetchLimit)
SQLSelect<T>	SQLSelect.localCache(String... cacheGroups) Instructs Cayenne to look for query results in the "local" cache when running the query.
SQLSelect<T>	SQLSelect.lowerColumnNames() Equivalent of setting CapsStrategy.LOWER
SQLSelect<T>	SQLSelect.offset(int fetchOffset)
SQLSelect<T>	SQLSelect.pageSize(int pageSize)
SQLSelect<T>	SQLSelect.params(Map<String,?> parameters)
SQLSelect<T>	SQLSelect.params(String name, Object value)
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.
static <T> SQLSelect<T>	SQLSelect.scalarQuery(Class<T> type, String sql) Creates a query that selects scalar values and uses default routing.
static <T> SQLSelect<T>	SQLSelect.scalarQuery(Class<T> type, String dataMapName, String sql) Creates a query that selects scalar values and uses routing based on the provided DataMap name.
SQLSelect<T>	SQLSelect.sharedCache(String... cacheGroups) 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