public PreparedStatement prepareSelectAllFromTable(Connection con, Table table, Sorting sorting, Pagination pagination) throws SQLException { StringBuilder sb = new StringBuilder(selectAllFromTable(table)); if (sorting != null) { StringBuilder orderBy = new StringBuilder(); int i = 0; for (Sorting.Spec spec: sorting) { if (i > 0) { orderBy.append(","); } orderBy.append(spec.name()); if (!spec.ascending()) { orderBy.append(" DESC"); } i++; } if (orderBy.length() > 0) { sb.append(" ORDER BY ").append(orderBy); } } sb.append(" LIMIT " + pagination.limit()); if (pagination.offset() > 0) { sb.append(" OFFSET " + pagination.offset()); } return con.prepareStatement(sb.toString()); }
@Override public Collection<Resource> members(RequestContext ctx) { Pagination pagination = ctx.pagination(); Stream<String> members = this.db().getCollectionNames().stream().skip(pagination.offset()); if (pagination.limit() > 0) { members = members.limit(pagination.limit()); } return members .filter(name -> !name.equals("system.indexes")) .map(name -> new MongoCollectionResource(this, db().getCollection(name))) .collect(Collectors.toList()); }
int offset = pagination.offset(); int limit = pagination.limit();
@Override public Collection<Resource> members(RequestContext ctx) throws Exception { LinkedList<Resource> members = new LinkedList<>(); // if children requested query children info DBCollection col = getUserspace().getFilesCollection(); DBCursor result = col.find().skip(ctx.pagination().offset()).limit(ctx.pagination().limit()); while (result.hasNext()) { DBObject child = result.next(); members.add(wrapDBObject(path(), new GridFSDBObject(child))); } return members; }
if (pagination != null) { dbCursor.limit(pagination.limit()); dbCursor.skip(pagination.offset());
int offset = ctx.pagination().offset(); int limit = ctx.pagination().limit();