Example usage for org.springframework.data.mongodb.core.query Query limit

List of usage examples for org.springframework.data.mongodb.core.query Query limit

  1. HOME
  2. Java
  3. org.springframework
  4. org.springframework.data.mongodb.core.query.*
  5. Query
  6. limit

Introduction

In this page you can find the example usage for org.springframework.data.mongodb.core.query Query limit.

Prototype

int limit

To view the source code for org.springframework.data.mongodb.core.query Query limit.

Click Source Link

Usage

From source file:com.trenako.repositories.mongo.RollingStockQueryBuilder.java

/**
 * Builds a new query applying the range request to the
 * provided selection criteria./*from  w w w  .j av  a  2  s .  co m*/
 *
 * @param criteria the selection {@code Criteria}
 * @param range    the range information
 * @return a {@code Query}
 */
public static Query buildQuery(Criteria criteria, RangeRequest range) {
    String prop = range.getSortProperty();

    if (range.getSince() != null && range.getMax() != null) {
        criteria.and(prop).lt(range.getSince()).gt(range.getMax());
    } else if (range.getSince() != null) {
        criteria.and(prop).lt(range.getSince());
    } else if (range.getMax() != null) {
        criteria.and(prop).gt(range.getMax());
    }

    final Query q = query(criteria);
    q.limit(range.getSize() + 1);
    q.with(range.getSort());

    return q;
}

From source file:io.gravitee.repository.mongodb.management.internal.page.PageMongoRepositoryImpl.java

public int findMaxPageOrderByApi(String apiId) {
    Query query = new Query();
    query.limit(1);
    query.with(new Sort(Sort.Direction.DESC, "order"));
    query.addCriteria(Criteria.where("api").is(apiId));

    PageMongo page = mongoTemplate.findOne(query, PageMongo.class);
    return (page != null) ? page.getOrder() : 0;
}

From source file:com.github.camellabs.iot.cloudlet.webcam.service.DefaultWebcamService.java

@Override
public WebcamImage latestImage(String deviceId, String webcamName) {
    Query query = new Query();
    query.limit(1);
    query.with(new Sort(Sort.Direction.DESC, "timestamp"));
    query.addCriteria(where("deleted").is(null)).addCriteria(where("deviceId").is(deviceId));
    return mongoTemplate.findOne(query, WebcamImage.class);
}

From source file:uk.gov.nationalarchives.discovery.taxonomy.common.repository.mongo.impl.IAViewUpdateRepositoryImpl.java

@Override
public IAViewUpdate findLastIAViewUpdate() {
    Query query = new Query();
    query.limit(1);
    query.with(new Sort(Sort.Direction.DESC, IAViewUpdate.FIELD_ID));
    return mongoTemplate.findOne(query, IAViewUpdate.class);
}

From source file:com.skymobi.monitor.model.LogQueryTest.java

public void test_query() throws Exception {

    assertEquals("{ }", query.toQuery().toString());
    query.setStart("2012-06-08 10:00:00");

    assertEquals("{ \"timestamp\" : { \"$gt\" : { \"$date\" : \"2012-06-08T02:00:00.000Z\"}}}",
            query.toQuery().toString());
    query.setEnd("2012-06-08 11:00:00");
    query.setLevel("ERROR");
    query.setKeyWord("111");
    System.out.println(query.toQuery().toString());

    Query bquery = new BasicQuery(query.toQuery());
    bquery.limit(100);

    bquery.sort().on("$timestamp", Order.DESCENDING);
    System.out.println(bquery.getQueryObject());
    System.out.println(bquery.getFieldsObject());
    System.out.println(bquery.getSortObject());
    //        assertEquals("{ \"timestamp\" : { \"$gt\" : { \"$date\" : \"1970-01-01T00:01:40.000Z\"}} , \"$where\" : \"this.message && this.message.match('hello')\"}",query.toQuery().toString());
}

From source file:com.appleframework.monitor.model.LogQueryTest.java

public void test_query() throws Exception {

    assertEquals("{ }", query.toQuery().toString());
    query.setStart("2012-06-08 10:00:00");

    assertEquals("{ \"timestamp\" : { \"$gt\" : { \"$date\" : \"2012-06-08T02:00:00.000Z\"}}}",
            query.toQuery().toString());
    query.setEnd("2012-06-08 11:00:00");
    query.setLevel("ERROR");
    query.setKeyWord("111");
    System.out.println(query.toQuery().toString());

    Query bquery = new BasicQuery(query.toQuery());
    bquery.limit(100);

    //bquery.sort().on("$timestamp", Order.DESCENDING);
    bquery.with(new Sort(Direction.DESC, "$timestamp"));
    System.out.println(bquery.getQueryObject());
    System.out.println(bquery.getFieldsObject());
    System.out.println(bquery.getSortObject());
    //        assertEquals("{ \"timestamp\" : { \"$gt\" : { \"$date\" : \"1970-01-01T00:01:40.000Z\"}} , \"$where\" : \"this.message && this.message.match('hello')\"}",query.toQuery().toString());
}

From source file:com.skymobi.monitor.service.LogsService.java

public DBCursor findLogs(String projectName, LogQuery logQuery, int max) throws ParseException {
    Project project = projectService.findProject(projectName);
    MongoTemplate template = project.fetchMongoTemplate();

    Query query = new BasicQuery(logQuery.toQuery());
    query.limit(max);

    query.sort().on("timestamp", Order.DESCENDING);
    logger.debug("find logs from {}  by query {} by sort {}",
            new Object[] { project.getLogCollection(), query.getQueryObject(), query.getSortObject() });
    DBCursor cursor = template.getCollection(project.getLogCollection()).find(query.getQueryObject())
            .sort(query.getSortObject()).limit(max);
    return cursor;
}

From source file:com.appleframework.monitor.service.LogsService.java

public DBCursor findLogs(String projectName, LogQuery logQuery, int max) throws ParseException {
    Project project = projectService.findProject(projectName);
    MongoTemplate template = project.fetchMongoTemplate();

    Query query = new BasicQuery(logQuery.toQuery());
    query.limit(max);

    //query.sort().on("timestamp", Order.DESCENDING);
    query.with(new Sort(Direction.DESC, "timestamp"));
    logger.debug("find logs from {}  by query {} by sort {}",
            new Object[] { project.getLogCollection(), query.getQueryObject(), query.getSortObject() });
    DBCursor cursor = template.getCollection(project.getLogCollection()).find(query.getQueryObject())
            .sort(query.getSortObject()).limit(max);
    return cursor;
}

From source file:quanlyhocvu.api.mongodb.DAO.NewsDAO.java

/**
 * get all data pagination/*from  ww  w .j  av a2  s.  co  m*/
 * @param limit
 * @param offset
 * @return 
 */
public List<NewsDTO> getAllNewsByPage(int limit, int offset) {
    Query query = Query.query(Criteria.where("id").exists(true));
    query.limit(limit);
    query.skip(offset);
    query.with(new Sort(Sort.Direction.DESC, "date"));
    return mongoOperation.find(query, NewsDTO.class);
}

From source file:quanlyhocvu.api.mongodb.DAO.NewsDAO.java

/**
 * get pagination of news by catalogId//from w  w  w  .  j  a  va 2s  .com
 * @param catalogId
 * @param limit
 * @param offset
 * @return 
 */
public List<NewsDTO> getNewsByCatalogIdAndPate(String catalogId, int limit, int offset) {
    Query query = Query.query(Criteria.where("catalogs.$id").is(new ObjectId(catalogId)));
    query.limit(limit);
    query.skip(offset);
    query.with(new Sort(Sort.Direction.DESC, "date"));
    return mongoOperation.find(query, NewsDTO.class);
}