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

Introduction

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

Prototype

public Query addCriteria(CriteriaDefinition criteriaDefinition)

Source Link

Document

Adds the given CriteriaDefinition to the current Query .

Usage

From source file:st.malike.service.mongo.DemographicSummaryService.java

public List getDemographicSummaryByDate(Date dateCreated) {
    Query query = new Query();
    query.addCriteria(Criteria.where("dateCreated").is(dateCreated));
    return mongoTemplate.find(query, DemographicSummary.class, "demographic_summary");
}

From source file:st.malike.service.mongo.DemographicSummaryService.java

public DemographicSummary getDemographicSummaryByEventAndDate(String event, Date dateCreated) {
    Query query = new Query();
    query.addCriteria(Criteria.where("event").is(event));
    query.addCriteria(Criteria.where("dateCreated").is(dateCreated));
    return mongoTemplate.findOne(query, DemographicSummary.class, "demographic_summary");
}

From source file:st.malike.service.mongo.DemographicSummaryService.java

public DemographicSummary getDemographicSummaryByEventAndDateForMin(String event, String dateCreated) {
    try {/*ww  w  .j  av  a 2s. c  o  m*/
        Date startDate = new SimpleDateFormat("yyyy-MM-dd HH:mm:00").parse(dateCreated);
        Date endDate = new DateTime(startDate).plusMinutes(1).toDate();
        Query query = new Query();
        query.addCriteria(Criteria.where("event").is(event));
        query.addCriteria(Criteria.where("dateCreated").gte(startDate).lte(endDate));
        return mongoTemplate.findOne(query, DemographicSummary.class, "demographic_summary");
    } catch (ParseException ex) {
        Logger.getLogger(DemographicSummaryService.class.getName()).log(Level.SEVERE, null, ex);
    }
    return null;
}

From source file:st.malike.service.mongo.DemographicSummaryService.java

public DemographicSummary getDemographicSummaryHistoryByEventAndDateForMin(String event, String date) {
    try {/*from www .  java  2s .  c om*/
        Date startDate = new SimpleDateFormat("yyyy-MM-dd 00:00:00").parse(date);
        Date endDate = new DateTime(startDate).plusDays(1).toDate();
        Query query = new Query();
        query.addCriteria(Criteria.where("event").is(event));
        query.addCriteria(Criteria.where("dateCreated").gte(startDate).lt(endDate));
        return mongoTemplate.findOne(query, DemographicSummary.class, "demographic_summary");
    } catch (ParseException ex) {
        Logger.getLogger(DemographicSummaryService.class.getName()).log(Level.SEVERE, null, ex);
    }
    return null;
}

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

public int findMaxPageOrderByApi(String apiId) {
    Query query = new Query();
    query.limit(1);/*  www. j  a  va2  s.  c o m*/
    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.epam.ta.reportportal.database.dao.ActivityRepositoryCustomImpl.java

@Override
public List<Activity> findActivitiesByProjectId(String projectId, Filter filter, Pageable pageable) {
    Query query = QueryBuilder.newBuilder().with(filter).with(pageable).build();
    query.addCriteria(where(PROJECT_REF).is(projectId));
    return mongoTemplate.find(query, Activity.class);
}

From source file:net.cit.tetrad.schedule.DbStatusDeleteThread.java

public void run() {
    String sdate = "";
    String edate = "";
    long longEndDate = TimestampUtil.convStringToTimestamp(deleteLogEndDate);
    long longsdate;
    long longedate;
    try {/*from  w  w  w  .  j a  v  a 2s .  c om*/
        StatusInMemory.setDeleteLogDbSt(true);
        for (;;) {
            try {
                if (edate.equals(""))
                    sdate = deleteLogStartDate;
                else
                    sdate = edate;
                edate = TimestampUtil.plusHour(sdate, 1);
                longsdate = TimestampUtil.convStringToTimestamp(sdate);
                longedate = TimestampUtil.convStringToTimestamp(edate);
                if (longedate > longEndDate)
                    edate = deleteLogEndDate;

                Query query = new Query();
                query.addCriteria(Criteria.where("regtime").gte(sdate).lte(edate));
                query.sort().on("regtime", Order.ASCENDING);

                monadService.delete(query, dbStatus);
                Thread.sleep(1000);
                int remainCnt = remainderCnt();
                if (remainCnt == 0 || !StatusInMemory.isDeleteLogDbSt()) {
                    StatusInMemory.setDeleteLogDbSt(false);
                    break;
                } else if (remainCnt != 0 && longsdate > longEndDate) {
                    query.addCriteria(Criteria.where("regtime").gte(deleteLogStartDate).lte(deleteLogEndDate));
                    monadService.delete(query, dbStatus);
                }
            } catch (Exception e) {
                e.printStackTrace();
                StatusInMemory.setDeleteLogDbSt(false);
            }
        }
    } catch (Exception e) {
        e.printStackTrace();
        StatusInMemory.setDeleteLogDbSt(false);
    }
}

From source file:net.cit.tetrad.schedule.ServerStatusDeleteThread.java

public void run() {
    String sdate = "";
    String edate = "";
    long longEndDate = TimestampUtil.convStringToTimestamp(deleteLogEndDate);
    long longsdate;
    long longedate;
    try {/* ww  w . j a v  a  2 s . com*/
        StatusInMemory.setDeleteLogServerSt(true);
        for (;;) {
            try {
                if (edate.equals(""))
                    sdate = deleteLogStartDate;
                else
                    sdate = edate;
                edate = TimestampUtil.plusHour(sdate, 1);
                longsdate = TimestampUtil.convStringToTimestamp(sdate);
                longedate = TimestampUtil.convStringToTimestamp(edate);
                if (longedate > longEndDate)
                    edate = deleteLogEndDate;

                Query query = new Query();
                query.addCriteria(Criteria.where("regtime").gte(sdate).lte(edate));
                query.sort().on("regtime", Order.ASCENDING);

                monadService.delete(query, serverStatus);
                Thread.sleep(1000);
                int remainCnt = remainderCnt();
                if (remainCnt == 0 || !StatusInMemory.isDeleteLogServerSt()) {
                    StatusInMemory.setDeleteLogServerSt(false);
                    break;
                } else if (remainCnt != 0 && longsdate > longEndDate) {
                    query.addCriteria(Criteria.where("regtime").gte(deleteLogStartDate).lte(deleteLogEndDate));
                    monadService.delete(query, serverStatus);
                }
            } catch (Exception e) {
                e.printStackTrace();
                StatusInMemory.setDeleteLogServerSt(false);
            }
        }
    } catch (Exception e) {
        e.printStackTrace();
        StatusInMemory.setDeleteLogServerSt(false);
    }
}

From source file:com.monkeyk.sos.infrastructure.mongo.UserRepositoryMongo.java

@Override
public List<User> findUsersByUsername(String username) {
    Query query = new Query();
    if (StringUtils.isNotEmpty(username)) {
        query.addCriteria(Criteria.where(username).regex("/*" + username + "/*"));
    }//from w  ww  . java 2s .  c  o  m
    return mongoTemplate().find(query, User.class);
}

From source file:com.epam.ta.reportportal.database.dao.ActivityRepositoryCustomImpl.java

@Override
public List<Activity> findActivitiesByTestItemId(String testItemId, Filter filter, Pageable pageable) {
    Sort sort = new Sort(Sort.Direction.DESC, Modifiable.LAST_MODIFIED);
    Query query = QueryBuilder.newBuilder().with(filter).with(pageable).with(sort).build();
    query.addCriteria(where(LOGGED_OBJECT_REF).is(testItemId));
    return mongoTemplate.find(query, Activity.class);
}