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

List of usage examples 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:app.data.local.CollectionBindingRepositoryImpl.java

@Nullable
@Override//from   www. j  a  va  2s.c om
public List<CollectionBinding> findByUid(String uid, @Nullable Pageable pageable) {
    Query query = new Query();
    query.addCriteria(Criteria.where("favors").elemMatch(Criteria.where("uid").is(uid))).with(pageable);

    return mMongoTemplate.find(query, CollectionBinding.class);
}

From source file:org.cbioportal.session_service.domain.internal.SessionRepositoryImpl.java

public List<Session> findBySourceAndTypeAndQuery(String source, String type, String field, String value) {
    return this.mongoTemplate.find(
            new Query(Criteria.where("source").is(source).and("type").is(type).and(field).is(value)),
            Session.class, type);
}

From source file:uk.gov.nationalarchives.discovery.taxonomy.common.service.impl.IAViewServiceImpl.java

public List<MongoInformationAssetView> findUntaggedDocumentsBySeriesMongo(String seriesIaid, Integer limit,
        Integer offset) {//from   w w  w .  ja  v  a 2s .  c o  m
    Query query = Query.query(Criteria.where("series").is(seriesIaid).and("categories").size(0));
    query.limit(limit);
    query.skip(offset);
    query.with(new Sort(Sort.Direction.ASC, "_id"));
    return mongoTemplate.find(query, MongoInformationAssetView.class);
}

From source file:com.epam.ta.reportportal.database.search.QueryBuilder.java

public static Function<FilterCondition, Criteria> filterConverter(CriteriaMap<?> map) {
    return filterCondition -> {
        Optional<CriteriaHolder> criteriaHolder = map
                .getCriteriaHolderUnchecked(filterCondition.getSearchCriteria());
        BusinessRule.expect(criteriaHolder, Preconditions.IS_PRESENT)
                .verify(ErrorType.INCORRECT_FILTER_PARAMETERS, Suppliers.formattedSupplier(
                        "Filter parameter {} is not defined", filterCondition.getSearchCriteria()));

        Criteria searchCriteria;/*ww  w.j  ava  2s  .  c om*/
        if (criteriaHolder.get().isReference()) {
            searchCriteria = Criteria.where(criteriaHolder.get().getQueryCriteria().concat(REFERENCE_POSTFIX));
        } else {
            searchCriteria = Criteria.where(criteriaHolder.get().getQueryCriteria());
        }

        /* Does FilterCondition contains negative=true? */
        if (filterCondition.isNegative()) {
            searchCriteria = searchCriteria.not();
        }

        filterCondition.getCondition().addCondition(searchCriteria, filterCondition, criteriaHolder.get());

        return searchCriteria;
    };
}

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

@Override
public OAuth2RefreshToken readRefreshToken(String accessToken) {
    Query query = new Query();
    query.addCriteria(Criteria.where("tokenId").is(accessToken));
    OAuth2AuthenticationRefreshToken token = mongoTemplate.findOne(query,
            OAuth2AuthenticationRefreshToken.class, "oauth2_refresh_token");
    return token.getoAuth2RefreshToken();
}

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

@Override
public synchronized void clearExternalSystems(String projectId) {
    Query query = Query.query(Criteria.where(PROJECT_ID).is(projectId));
    Project first = mongoTemplate.findOne(query, Project.class);
    first.getConfiguration().setExternalSystem(Collections.emptyList());
    mongoTemplate.save(first);//w w  w .  ja  v a2s.  com
}

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

/**
 * generate password and user by class default: user = MaObj, pass = 'admin'
 *
 * @param cls//  w  w w .j  a  v  a  2s.  com
 */
public void generateUserByType(Class cls) {
    if (cls == GiaoVienDTO.class) {
        List<GiaoVienDTO> giaoviens = mongoOperation.findAll(GiaoVienDTO.class);
        if (giaoviens != null) {
            for (GiaoVienDTO giaovien : giaoviens) {
                if (giaovien.getmaGiaoVien() != null) {
                    UserDTO user = new UserDTO(giaovien.getmaGiaoVien(), MD5.getMD5("admin"), giaovien.getid());
                    user.getRoles()
                            .add(mongoOperation.findOne(
                                    Query.query(Criteria.where("rolename").is(Authorities.TEACHER.toString())),
                                    RoleDTO.class));

                    try {
                        this.insertUser(user);
                    } catch (Exception ex) {
                    }
                }
            }
        }
    } else if (cls == StaffDTO.class) {
        List<StaffDTO> staffs = mongoOperation.findAll(StaffDTO.class);
        if (staffs != null) {
            for (StaffDTO staff : staffs) {
                if (staff.getManhanvien() != null) {
                    UserDTO user = new UserDTO(staff.getManhanvien(), MD5.getMD5("admin"), staff.getid());
                    user.getRoles()
                            .add(mongoOperation.findOne(
                                    Query.query(Criteria.where("rolename").is(Authorities.STAFF.toString())),
                                    RoleDTO.class));
                    try {
                        this.insertUser(user);
                    } catch (Exception ex) {
                    }
                }
            }
        }
    } else if (cls == HocSinhDTO.class) {
        List<HocSinhDTO> hocsinhs = mongoOperation.findAll(HocSinhDTO.class);
        if (hocsinhs != null) {
            for (HocSinhDTO hocsinh : hocsinhs) {
                if (hocsinh.getmaHocSinh() != null) {
                    UserDTO user = new UserDTO(hocsinh.getmaHocSinh(), MD5.getMD5("admin"), hocsinh.getid());
                    user.getRoles()
                            .add(mongoOperation.findOne(
                                    Query.query(Criteria.where("rolename").is(Authorities.STUDENT.toString())),
                                    RoleDTO.class));
                    try {
                        this.insertUser(user);
                    } catch (Exception ex) {
                    }
                }
            }
        }
    }
}

From source file:com.comcast.video.dawg.controller.house.filter.FieldCondition.java

/**
 * {@inheritDoc}/*from w  w w.  j  a v a  2s  .c  om*/
 */
@Override
public Criteria toCriteria(boolean negate) {
    boolean notToUse = negate ? !not : not;
    Criteria crit = Criteria.where("data." + field);
    switch (this.op) {
    case equals:
        return notToUse ? crit.ne(value) : crit.is(value);
    case contains:
        crit = notToUse ? crit.not() : crit;
        if (array) {
            return crit.in(value);
        } else {
            return crit.regex(".*" + value + ".*");
        }
    case matches:
        crit = notToUse ? crit.not() : crit;
        return crit.regex(value);
    default:
        return null;
    }
}

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

public DemographicSummary getDemographicSummaryHistoryByEventAndDateForMin(String event, String date) {
    try {//from  ww  w  . j  a va  2  s .  c o  m
        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:tv.arte.resteventapi.core.querying.mongo.db.AbstractBaseMongoDBQueryBuilder.java

/**
 * Build a Mongo query based on a field name, {@link QueryOp} and a given value suited for the 
 * provided operation //from  w w  w.  j  a  v a2s.  co m
 * 
 * @param fieldName The field name (Should never be <code>null</code>)
 * @param queryOpParamValue A query op / value param
 * @return A Mongo query based on a field name, {@link QueryOp} and a given value suited for the 
 *          provided operation 
 */
protected Criteria buildSimpleCriteria(String fieldName, QueryOpParamValue<?> queryOpParamValue) {
    Criteria criteria = null;
    QueryOp paramQueryOp = queryOpParamValue.getQueryOp();
    Object paramValue = queryOpParamValue.getValue();

    if (paramQueryOp == null) {
        if (paramValue == null) {
            criteria = Criteria.where(fieldName).exists(false);
        } else {
            criteria = Criteria.where(fieldName).is(paramValue);
        }
    } else {
        switch (paramQueryOp) {
        case GT:
            criteria = Criteria.where(fieldName).gt(paramValue);
            break;
        case GTE:
            criteria = Criteria.where(fieldName).gte(paramValue);
            break;
        case LT:
            criteria = Criteria.where(fieldName).lt(paramValue);
            break;
        case LTE:
            criteria = Criteria.where(fieldName).lte(paramValue);
            break;
        case NE:
            criteria = Criteria.where(fieldName).ne(paramValue);
            break;
        case IN:
            criteria = Criteria.where(fieldName).in((Collection<?>) paramValue);
            break;
        case NIN:
            criteria = Criteria.where(fieldName).nin((Collection<?>) paramValue);
            break;
        case ALL:
            criteria = Criteria.where(fieldName).all((Collection<?>) paramValue);
            break;
        case ONLY:
            criteria = new Criteria().andOperator(Criteria.where(fieldName).all((Collection<?>) paramValue),
                    Criteria.where(fieldName).size(((Collection<?>) paramValue).size()));
            break;
        default:
            criteria = new Criteria();
            break;
        }
    }

    return criteria;
}