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

List of usage examples for org.springframework.data.mongodb.core.query Criteria where

  1. HOME
  2. Java
  3. org.springframework
  4. org.springframework.data.mongodb.core.query.*
  5. Criteria
  6. 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:br.com.ezequieljuliano.argos.persistence.LoggerDAO.java

public List<Logger> findByUserAndTerms(User user, List<UserTerm> terms, long limit) {
    if (user.haveProfile(Profile.admin)) {
        Criteria criteria = Criteria.where("_id").ne(null);
        return findByTermsAndCriteria(terms, criteria, limit);
    } else {/* w ww  . j  av a2 s.c o  m*/
        //List<Entity> entitysTreeOfUser = userDAO.findEntitysTreeByUser(user);
        //Criteria criteria = Criteria.where("entity").in(entitysTreeOfUser);
        //return findByTermsAndCriteria(terms, criteria, limit);
        //Mtodo temporrio devido a bug do SpringDataMongoDB            
        List<ObjectId> objectIds = findEntityObjectIdsByUser(user);
        Criteria criteria = Criteria.where("entity._id").in(objectIds);
        return findByTermsAndCriteria(terms, criteria, limit);
    }
}

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

/**
 * update user by current user/*  ww w  .j  a v  a2 s . c  o  m*/
 * @param user 
 */
public void updateUser(UserDTO user) {
    Query query = Query.query(Criteria.where("username").is(user.getUsername()));
    Update update = new Update();
    update.set("enabled", user.isEnabled());
    update.set("nonlocked", user.isNonlocked());
    if (user.getRoles().size() > 0) {
        update.set("roles", user.getRoles());
    }
    if (!"".equals(user.getPassword())) {
        update.set("password", MD5.getMD5(user.getPassword()));
    }
    mongoOperation.findAndModify(query, update, UserDTO.class);
}

From source file:com.tlantic.integration.authentication.service.security.TokenStoreService.java

@Override
public Collection<OAuth2AccessToken> findTokensByClientIdAndUserName(String clientId, String userName) {
    Query query = new Query();
    query.addCriteria(Criteria.where("clientId").is(clientId));
    query.addCriteria(Criteria.where("userName").is(userName));
    List<OAuth2AuthenticationAccessToken> accessTokens = mongoTemplate.find(query,
            OAuth2AuthenticationAccessToken.class, "oauth2_access_token");
    return extractAccessTokens(accessTokens);
}

From source file:net.cit.tetrad.utility.QueryUtils.java

public static Query sortDate(int auth, int userCode, String tablenm) {
    Query query = new Query();
    if (tablenm.equals("user")) {
        Criteria c = new Criteria();
        c.orOperator(Criteria.where("idx").is(userCode), Criteria.where("authority").lt(auth));
        query.addCriteria(c);//from  w w w  .jav a  2 s . co  m
        query.sort().on("authority", Order.DESCENDING);
    }
    query.sort().on("reg_date", Order.DESCENDING);
    query.sort().on("groupCode", Order.ASCENDING);
    query.sort().on("deviceCode", Order.ASCENDING);
    query.sort().on("reg_date", Order.DESCENDING);
    return query;
}

From source file:it.smartcommunitylab.tocati.controller.UserAuthController.java

@RequestMapping("/{ownerId}/userregisterevway")
public @ResponseBody UserData registerEVWay(@PathVariable String ownerId, @RequestParam String email,
        @RequestParam String password, @RequestParam String language,
        @RequestParam(required = false) String name, @RequestParam(required = false) String surname,
        HttpServletRequest request, HttpServletResponse response) throws IOException, UnauthorizedException {
    //      if(!Utils.validateAPIRequest(request, dataSetSetup, storageManager)) {
    //         throw new UnauthorizedException("Unauthorized Exception: token not valid");
    //      }/*from  w  w  w .j a v a2s.  c  om*/
    if (logger.isInfoEnabled()) {
        logger.info(String.format("loginEVWay[%s] register: %s", ownerId, email));
    }

    try {
        UserData userData = evwayAuth.register(email, password, language);
        if (userData == null) {
            response.setStatus(HttpStatus.SC_INTERNAL_SERVER_ERROR);
            return null;
        }

        userData.setOwnerId(ownerId);
        userData.setDisplayName(email);
        userData.setName(name);
        userData.setSurname(surname);

        Criteria criteria = Criteria.where("userId").is(userData.getUserId());
        UserData userDB = storageManager.findOneData(UserData.class, criteria, userData.getOwnerId());
        if (userDB == null) {
            userData.setObjectId(Utils.getUUID());
            userData = storageManager.addUser(userData);
        } else {
            response.setStatus(HttpStatus.SC_CONFLICT);
            return null;
        }
        return userData;

    } catch (Exception e) {
        response.setStatus(HttpStatus.SC_INTERNAL_SERVER_ERROR);
    }
    return null;
}

From source file:no.nlf.dal.ParachutistController.java

public boolean existsUserNotPassword(String melwinId, String nakkey) {
    Query searchPerson = new Query(Criteria.where("nak").is(melwinId));
    mongoParachutist = appContext.mongoOperation().findOne(searchPerson, MongoParachutist.class);

    if (mongoParachutist.getNakKey().equals(""))
        return true;
    return false;
}

From source file:com.bosch.iot.things.example.historian.Collector.java

/**
 * Write history to the the MongoDB// w  w  w  .  j  ava2s. c  o  m
 */
private void storeHistory(History h) {
    LOGGER.trace("Store history: {}", h);

    // do combined update query: add newest value+timestamp to the array property and slice array if too long
    String id = h.thingId + "/features/" + h.featureId + h.path;
    Update update = new Update()
            .push("values",
                    new BasicDBObject("$each", Arrays.asList(getJavaValue(h.value))).append("$slice",
                            -HISTORY_SIZE))
            .push("timestamps",
                    new BasicDBObject("$each", Arrays.asList(h.timestamp)).append("$slice", -HISTORY_SIZE));

    // update or create document for this specific property in this thing/feature 
    mongoTemplate.upsert(Query.query(Criteria.where("_id").is(id)), update, String.class, "history");
}

From source file:it.smartcommunitylab.climb.domain.controller.ChildController.java

@RequestMapping(value = "/api/child/{ownerId}/{objectId}", method = RequestMethod.PUT)
public @ResponseBody Child updateChild(@RequestBody Child child, @PathVariable String ownerId,
        @PathVariable String objectId, HttpServletRequest request, HttpServletResponse response)
        throws Exception {
    if (!validateAuthorization(ownerId, child.getInstituteId(), child.getSchoolId(), null, null,
            Const.AUTH_RES_Child, Const.AUTH_ACTION_UPDATE, request)) {
        throw new UnauthorizedException("Unauthorized Exception: token not valid");
    }//from  w w  w .  ja v a2 s. co m
    Criteria criteria = Criteria.where("objectId").is(objectId).and("ownerId").is(ownerId);
    Child oldChild = storage.findOneData(Child.class, criteria, ownerId);
    child.setOwnerId(ownerId);
    child.setObjectId(objectId);
    storage.updateChild(child);
    if (child.isActiveForGame() && !oldChild.isActiveForGame()) {
        //add player
        String instituteId = child.getInstituteId();
        String schoolId = child.getSchoolId();
        addPlayer(child, ownerId, instituteId, schoolId);
    } else if (!child.isActiveForGame() && oldChild.isActiveForGame()) {
        //delete player
        String instituteId = child.getInstituteId();
        String schoolId = child.getSchoolId();
        deletePlayer(oldChild, ownerId, instituteId, schoolId);
    } else if (child.isActiveForGame() && !child.getClassRoom().equals(oldChild.getClassRoom())) {
        String instituteId = child.getInstituteId();
        String schoolId = child.getSchoolId();
        List<PedibusGame> gameList = storage.getPedibusGames(ownerId, instituteId, schoolId);
        for (PedibusGame game : gameList) {
            if (game.isDeployed()) {
                deletePlayerToTeam(ownerId, game, oldChild);
                addPlayerToTeam(ownerId, game, child);
            }
        }
    }
    if (logger.isInfoEnabled()) {
        logger.info(String.format("updateChild[%s]:%s", ownerId, child.getName()));
    }
    return child;
}

From source file:things.mongo.MongoConnector.java

@Override
public Observable<? extends Thing<?>> findThingsForTypeAndKey(String type, String key) {

    final Timer.Context context = find_exact_type_and_key_timer.time();
    try {/*ww  w  .j  av  a  2s . co m*/
        Query q = new Query();

        q.addCriteria(Criteria.where("thingType").is(type).and("key").is(key));

        List<Thing> things = mongoTemplate.find(q, Thing.class);

        return Observable.from(things).map(t -> (Thing<?>) t);
    } finally {
        context.stop();
    }
}

From source file:net.cit.tetrad.utility.QueryUtils.java

public static Query setDeviceCode(int deviceCode) {
    Query query = new Query(Criteria.where(DEVICECODE).is(deviceCode));
    return query;
}