Example usage for org.springframework.data.mongodb.core.query Criteria where

Introduction

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

Prototype

public static Criteria where(String key)

Source Link

Document

Static factory method to create a Criteria using the provided key

Usage

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 www.  ja va 2s . com*/
        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:com.springsource.html5expense.mongodb.services.ExpenseRepository.java

@Override
public List<Expense> getPendingExpensesList() {
    List<State> stateList = new ArrayList<State>();
    stateList.add(State.NEW);//from w w  w .  j av a2 s .c  o m
    stateList.add(State.OPEN);
    stateList.add(State.IN_REVIEW);
    return mongoTemplate.find(new Query(Criteria.where("state").in(stateList)), Expense.class,
            EXPENSE_COLLECTION_NAME);
}

From source file:strat.mining.multipool.stats.persistence.dao.coinshift.impl.GlobalStatsDAOMongo.java

@Override
public int deleteGlobalStatsBefore(Date time) {
    Query query = new Query(Criteria.where("refreshTime").lt(time));
    long result = mongoOperation.count(query, GlobalStats.class);
    mongoOperation.remove(query, GlobalStats.class);
    return (int) result;
}

From source file:com.pubkit.platform.persistence.impl.ApplicationDaoImpl.java

public Application findByApplicationId(String applicationId) {
    Criteria criteria = Criteria.where("applicationId").is(applicationId);
    return mongoTemplate.findOne(Query.query(criteria), Application.class);
}

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  va2  s. c o m
        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.okode.demos.mmaps.controller.APIController.java

@ApiOperation("Find entities by filter and fields inside a view")
@RequestMapping(value = "/findentities", method = RequestMethod.GET)
private GeoJSON findEntitiesInsideViewByFilterFields(@RequestParam(defaultValue = "24.25079") float lat1,
        @RequestParam(defaultValue = "-35.912262") float lng1,
        @RequestParam(defaultValue = "53.46439") float lat2,
        @RequestParam(defaultValue = "28.951021") float lng2,
        @RequestParam(defaultValue = "office") String collection,
        @RequestParam(defaultValue = "{\"properties.address.region\":\"MADRID\"}") String filter,
        @RequestParam(defaultValue = "{\"_id\":0,\"type\":1,\"geometry\":1,\"properties.name\":1,\"properties.url\":1,\"properties.pictures\":1}") String fields) {
    Criteria isInsideView = Criteria.where("geometry.coordinates")
            .within(new Box(new Point(lng1, lat1), new Point(lng2, lat2)));
    Query query = new BasicQuery(filter, fields).addCriteria(isInsideView);
    return new GeoJSON(mongoTemplate.find(query, DBObject.class, collection));
}

From source file:org.springframework.session.data.mongo.JacksonMongoSessionConverter.java

protected Query getQueryForIndex(String indexName, Object indexValue) {
    if (FindByIndexNameSessionRepository.PRINCIPAL_NAME_INDEX_NAME.equals(indexName)) {
        return Query.query(Criteria.where(PRINCIPAL_FIELD_NAME).is(indexValue));
    }/*  ww  w. ja  v a  2s.  c  o m*/
    return Query
            .query(Criteria.where(ATTRS_FIELD_NAME + MongoExpiringSession.coverDot(indexName)).is(indexValue));
}

From source file:org.openinfinity.domain.repository.ProductRepositoryMongoDBImpl.java

@Log
@AuditTrail//from  ww w  .j  a  v  a2 s.  com
public void delete(Product product) {
    Query query = new Query(Criteria.where("id").is(product.getId()));
    mongoTemplate.remove(query, product.getClass());
}

From source file:strat.mining.multipool.stats.persistence.dao.coinshift.impl.TransactionDAOMongo.java

@Override
public Transaction getLastTransaction(Integer addressId) {
    Query query = new Query(Criteria.where("addressId").is(addressId));
    query.with(new Sort(Sort.Direction.DESC, "date"));
    return mongoOperation.findOne(query, Transaction.class);
}

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

@Override
public List<String> findProjectUsers(String projectName, String value) {
    Query query = Query.query(Criteria.where("name").is(projectName));
    query.fields().include("users");
    Project p = mongoTemplate.findOne(query, Project.class);
    return p == null ? null
            : p.getUsers().keySet().stream().filter(userNameContains(value)).collect(Collectors.toList());
}