Uses of Class
org.nuxeo.ecm.core.storage.sql.jdbc.SQLInfo.SQLInfoSelect
-
Uses of SQLInfo.SQLInfoSelect in org.nuxeo.ecm.core.storage.sql.jdbc
Modifier and TypeFieldDescriptionfinal SQLInfo.SQLInfoSelect
SQLInfo.SQLInfoSelection.selectAll
final SQLInfo.SQLInfoSelect
SQLInfo.SQLInfoSelection.selectFiltered
QueryMaker.Query.selectInfo
Modifier and TypeFieldDescriptionfinal Map<String,
SQLInfo.SQLInfoSelect> SQLInfo.selectFragmentById
Modifier and TypeMethodDescriptionSQLInfo.getCopyHier
(boolean explicitName, boolean resetVersion) SQLInfo.getSelectAncestorsIds()
Select all ancestors ids for several fragments.SQLInfo.getSelectChildrenNodeInfos
(int nids) Selects all children (not complex) for several parent ids.SQLInfo.getSelectFragmentsByIds
(String tableName, int nids) Select by ids for all values of several fragments.SQLInfo.getSelectFragmentsByIds
(String tableName, int nids, String[] orderBys, Set<String> skipColumns) Select by ids for all values of several fragments (maybe ordered along columns -- for collection fragments retrieval).SQLInfo.getSelectParentIds
(int nids) Select parentid by ids for all values of several fragments.SQLInfo.SQLInfoSelection.getSelectSelectionIds
(int nids) Select selection ids for multiple values.SQLInfo.getUpdateById
(String tableName, RowMapper.RowUpdate rowu) UPDATE tableName SET key1 = ?SQLInfo.makeSelect
(Table table, String[] orderBys, String... freeColumns) Basic SELECT x, y, z FROM table WHERE a = ?SQLInfo.makeSelect
(Table table, String from, List<String> clauses, String[] orderBys, String... freeColumns) Same as above but the FROM can be passed in, to allow JOINs.Modifier and TypeMethodDescriptionJDBCRowMapper.getSelectRows
(String tableName, SQLInfo.SQLInfoSelect select, Map<String, Serializable> criteriaMap, Map<String, Serializable> joinMap, boolean limitToOne) Fetches the rows for a select with fixed criteria given as two maps (a criteriaMap whose values and up in the returned rows, and a joinMap for other criteria).Modifier and TypeMethodDescriptionprotected <T> PartialList<T>
JDBCMapper.queryProjection
(String query, String queryType, QueryFilter queryFilter, long countUpTo, JDBCMapper.BiFunctionSQLException<SQLInfo.SQLInfoSelect, ResultSet, T> extractor, Object... params)