public String toString() { return "[Page: " + page + " total: " + total + " size: " + pageSize + " offset: " + getOffset() + "]"; }
public static <T> List<T> pageCollection( Collection<T> col, Pager pager ) { return pageCollection( col, pager.getOffset(), pager.getPageSize() ); }
@Override public List<MetadataAudit> query( MetadataAuditQuery query ) { CriteriaBuilder builder = getCurrentSession().getCriteriaBuilder(); CriteriaQuery<MetadataAudit> criteriaQuery = builder.createQuery( MetadataAudit.class ); Root<MetadataAudit> root = criteriaQuery.from( MetadataAudit.class ); criteriaQuery.where( buildCriteria( builder, root, query ).toArray( new Predicate[0] ) ); Query<MetadataAudit> typedQuery = getCurrentSession().createQuery( criteriaQuery ); if ( !query.isSkipPaging() ) { Pager pager = query.getPager(); typedQuery.setFirstResult( pager.getOffset() ); typedQuery.setMaxResults( pager.getPageSize() ); } return typedQuery.getResultList(); }
@Override public List<DeletedObject> query( DeletedObjectQuery query ) { CriteriaBuilder builder = getCurrentSession().getCriteriaBuilder(); CriteriaQuery<DeletedObject> criteriaQuery = builder.createQuery( DeletedObject.class ); Root<DeletedObject> root = criteriaQuery.from( DeletedObject.class ); Predicate predicate = buildCriteria( builder, root, query ); criteriaQuery.select( root ); if ( !predicate.getExpressions().isEmpty() ) criteriaQuery.where( predicate ); Query<DeletedObject> typedQuery = getCurrentSession().createQuery( criteriaQuery ); if ( !query.isSkipPaging() ) { Pager pager = query.getPager(); typedQuery.setFirstResult( pager.getOffset() ); typedQuery.setMaxResults( pager.getPageSize() ); } return typedQuery.list(); }
@Override public List<ValidationResult> query( ValidationResultQuery validationResultQuery ) { Query<ValidationResult> hibernateQuery = getQuery( "from ValidationResult vr" + getRestrictions( "where" ) ); if ( !validationResultQuery.isSkipPaging() ) { Pager pager = validationResultQuery.getPager(); hibernateQuery.setFirstResult( pager.getOffset() ); hibernateQuery.setMaxResults( pager.getPageSize() ); } return hibernateQuery.getResultList(); }
@Override public List<MinMaxDataElement> query( MinMaxDataElementQueryParams query ) { CriteriaBuilder builder = getCriteriaBuilder(); JpaQueryParameters<MinMaxDataElement> parameters = newJpaParameters(); parameters.addPredicate( root -> parseFilter( builder, root, query.getFilters() ) ); if ( !query.isSkipPaging() ) { Pager pager = query.getPager(); parameters.setFirstResult( pager.getOffset() ); parameters.setMaxResults( pager.getPageSize() ); } return getList( builder, parameters ); }