private static Statement get(String bucket, String[] documents, int firstResult, int maxResult, Sort[] sorts) { boolean hasFistResult = firstResult > 0; boolean hasMaxResult = maxResult > 0; if (hasFistResult && hasMaxResult) { return select(documents) .from(i(bucket)) .orderBy(sorts) .limit(maxResult) .offset(firstResult); } else if (hasFistResult) { return select(documents).from(i(bucket)).orderBy(sorts).offset(firstResult); } else if (hasMaxResult) { return select(documents).from(i(bucket)).orderBy(sorts).limit(maxResult); } return select(documents).from(i(bucket)).orderBy(sorts); }
Pageable pageable = accessor.getPageable(); Assert.notNull(pageable, "Pageable must not be null!"); return selectFromWhereOrderBy.limit(pageable.getPageSize()).offset(Math.toIntExact(pageable.getOffset())); } else if (queryMethod.isSliceQuery() && accessor.getPageable().isPaged()) { Pageable pageable = accessor.getPageable(); Assert.notNull(pageable, "Pageable must not be null!"); return selectFromWhereOrderBy.limit(pageable.getPageSize() + 1).offset(Math.toIntExact(pageable.getOffset())); } else if (partTree.isLimiting()) { return selectFromWhereOrderBy.limit(partTree.getMaxResults()); } else { return selectFromWhereOrderBy;
Pageable pageable = accessor.getPageable(); Assert.notNull(pageable, "Pageable must not be null!"); return selectFromWhereOrderBy.limit(pageable.getPageSize()).offset(Math.toIntExact(pageable.getOffset())); } else if (queryMethod.isSliceQuery() && accessor.getPageable().isPaged()) { Pageable pageable = accessor.getPageable(); Assert.notNull(pageable, "Pageable must not be null!"); return selectFromWhereOrderBy.limit(pageable.getPageSize() + 1).offset(Math.toIntExact(pageable.getOffset())); } else if (partTree.isLimiting()) { return selectFromWhereOrderBy.limit(partTree.getMaxResults()); } else { return selectFromWhereOrderBy;
Statement pageStatement = limitPath.limit(pageable.getPageSize()).offset(Math.toIntExact(pageable.getOffset()));
private static Statement get(String bucket, String[] documents, int firstResult, int maxResult, Sort[] sorts, Expression condition) { boolean hasFistResult = firstResult > 0; boolean hasMaxResult = maxResult > 0; if (hasFistResult && hasMaxResult) { return select(documents).from(i(bucket)) .where(condition) .orderBy(sorts) .limit(maxResult) .offset(firstResult); } else if (hasFistResult) { return select(documents).from(i(bucket)) .where(condition) .orderBy(sorts) .offset(firstResult); } else if (hasMaxResult) { return select(documents).from(i(bucket)).where(condition) .orderBy(sorts) .limit(maxResult); } return select(documents).from(i(bucket)).where(condition).orderBy(sorts); }
Statement pageStatement = limitPath.limit(pageable.getPageSize()).offset(Math.toIntExact(pageable.getOffset()));
@Override protected Statement getStatement(ParameterAccessor accessor, Object[] runtimeParameters, ReturnedType returnedType) { String bucketName = getCouchbaseOperations().getCouchbaseBucket().name(); Expression bucket = N1qlUtils.escapedBucket(bucketName); FromPath select; if (partTree.isCountProjection()) { select = select(count("*")); } else { select = N1qlUtils.createSelectClauseForEntity(bucketName, returnedType, this.getCouchbaseOperations().getConverter()); } WherePath selectFrom = select.from(bucket); N1qlQueryCreator queryCreator = new N1qlQueryCreator(partTree, accessor, selectFrom, getCouchbaseOperations().getConverter(), getQueryMethod()); LimitPath selectFromWhereOrderBy = queryCreator.createQuery(); this.placeHolderValues = queryCreator.getPlaceHolderValues(); if (partTree.isLimiting()) { return selectFromWhereOrderBy.limit(partTree.getMaxResults()); } else { return selectFromWhereOrderBy; } } }
@Override protected Statement getStatement(ParameterAccessor accessor, Object[] runtimeParameters, ReturnedType returnedType) { String bucketName = getCouchbaseOperations().getCouchbaseBucket().name(); Expression bucket = N1qlUtils.escapedBucket(bucketName); FromPath select; if (partTree.isCountProjection()) { select = select(count("*")); } else { select = N1qlUtils.createSelectClauseForEntity(bucketName, returnedType, this.getCouchbaseOperations().getConverter()); } WherePath selectFrom = select.from(bucket); N1qlQueryCreator queryCreator = new N1qlQueryCreator(partTree, accessor, selectFrom, getCouchbaseOperations().getConverter(), getQueryMethod()); LimitPath selectFromWhereOrderBy = queryCreator.createQuery(); this.placeHolderValues = queryCreator.getPlaceHolderValues(); if (partTree.isLimiting()) { return selectFromWhereOrderBy.limit(partTree.getMaxResults()); } else { return selectFromWhereOrderBy; } } }