@Override public List<HmilyTransaction> listAllByDelay(final Date date) { Query query = new Query(); query.addCriteria(Criteria.where("lastTime").lt(date)); final List<MongoAdapter> mongoBeans = template.find(query, MongoAdapter.class, collectionName); if (CollectionUtils.isNotEmpty(mongoBeans)) { return mongoBeans.stream().map(this::buildByCache).collect(Collectors.toList()); } return Collections.emptyList(); }
@Override public List<MythTransaction> listAllByDelay(final Date date) { Query query = new Query(); query.addCriteria(Criteria.where("lastTime").lt(date)) .addCriteria(Criteria.where("status").is(MythStatusEnum.BEGIN.getCode())); final List<MongoAdapter> mongoBeans = template.find(query, MongoAdapter.class, collectionName); if (CollectionUtils.isNotEmpty(mongoBeans)) { return mongoBeans.stream().map(this::buildByCache).collect(Collectors.toList()); } return Collections.emptyList(); }
@Override public List<TransactionRecover> listAllByDelay(final Date date) { Query query = new Query(); query.addCriteria(new Criteria("status") .in(TransactionStatusEnum.BEGIN.getCode(), TransactionStatusEnum.FAILURE.getCode(), TransactionStatusEnum.ROLLBACK.getCode())) .addCriteria(Criteria.where("lastTime").lt(date)); final List<MongoAdapter> mongoBeans = template.find(query, MongoAdapter.class, collectionName); if (CollectionUtils.isNotEmpty(mongoBeans)) { return mongoBeans.stream().map(this::buildByCache).collect(Collectors.toList()); } return null; }
baseQuery.addCriteria(new Criteria("retriedCount").lt(query.getRetry()));
baseQuery.addCriteria(new Criteria("retriedCount").lt(query.getRetry()));
@Override public List<PersonEntity> findByParams(Map params) { Query query = new Query(); Iterator<String> iterator = params.keySet().iterator(); while (iterator.hasNext()) { String key = iterator.next(); query.addCriteria(Criteria.where(key).lt(params.get(key))); } List<PersonEntity> list = mongoTemplate.find(query, PersonEntity.class); return list; }
@Override public List<PersonEntity> findWithPageByParams(Map params) { Query query = new Query(); MongoDBPageable pageable = new MongoDBPageable(2); Iterator<String> iterator = params.keySet().iterator(); while (iterator.hasNext()) { String key = iterator.next(); query.addCriteria(Criteria.where(key).lt(params.get(key))); } Long allcount = mongoTemplate.count(query, PersonEntity.class); List<PersonEntity> list = mongoTemplate.find(query.with(pageable), PersonEntity.class); Page<PersonEntity> page = new PageImpl<PersonEntity>(list, pageable, allcount); return page.getContent(); } }
private Criteria solutionDateBeforeCriterion(Date solutionDate) { return Criteria.where(PROPERTY_COANSYS_SOLUTION_DATE).lt(solutionDate); }
@Override public void cleanExpiredNotifications() { DateTime time = new DateTime(); DateTime cleanTime = time.minusDays(timeToRemoveNotificationInDays); Date cleanDate = new Date(cleanTime.getMillis()); Query query = new Query(Criteria.where(QUERY_PARAM_CREATION_TIMESTAMP).lt(cleanDate)); mongoTemplate.remove(query, mongoCollectionName); }
/** * Query for entities modified later than provided date * * @param date * @return */ public static Query findModifiedLaterThan(final Date date) { return Query.query(Criteria.where(Modifiable.LAST_MODIFIED).lt(date)); }
@Override @Scheduled(initialDelay = 30000, fixedRate = 3600000) public void deleteOldActivityLogs() { // Only stores the activity from the last 7 days final long tsToCompare = System.currentTimeMillis() - 7 * 24 * 60 * 60 * 1000; final Criteria criteria = Criteria.where("timestamp").lt(tsToCompare); doDelete(new Query(criteria)); }
@Scheduled(initialDelay = 30000, fixedRate = 600000) public void deleteOldPerformanceLogs() { // Only stores the performance from the last day final long tsToCompare = System.currentTimeMillis() - 24 * 60 * 60 * 1000; final Criteria criteria = Criteria.where("timestamp").lt(tsToCompare); doDelete(new Query(criteria)); }
/** * Finds files with provided project and uploaded later than provided time period * * @param period * @param project * @return */ public static Query findModifiedLaterThanPeriod(final Duration period, final String project) { Query query = Query.query(Criteria.where(Modifiable.UPLOADED).lt(Date.from(Instant.now().minusSeconds(period.getSeconds())))); return query.addCriteria(Criteria.where(METADATA).is(project)); }
@Override public void expireBidsOlderThan(Date lastLogin) { mongoOperations.remove(Query.query(Criteria.where(Modifiable.LAST_MODIFIED).lt(lastLogin)), UserCreationBid.class); }
private Criteria precedingByModificationDateAndIdCriterion(Date date, String id) { Criteria criteria = new Criteria() .orOperator( Criteria.where(PROPERTY_MODIFICATION_DATE).lt(date), new Criteria().andOperator( Criteria.where(PROPERTY_MODIFICATION_DATE).is(date), Criteria.where(F_ID).lt(id) ) ); return criteria; }
@Override public void expireUsersLoggedOlderThan(Date lastLogin) { mongoOperations.updateMulti(query(where(MetaInfo.LAST_LOGIN_PATH).lt(lastLogin)), update(IS_EXPIRED, true), User.class); }
@Override public Page<User> findByTypeAndLastSynchronizedBefore(UserType type, Date lastSynchronized, Pageable pageable) { Query q = query(where("type").is(type).and(MetaInfo.SYNCHRONIZATION_DATE).lt(lastSynchronized)).with(pageable); long count = mongoOperations.count(q, User.class); return new PageImpl<>(mongoOperations.find(q, User.class), pageable, count); }
@Override public void addCondition(Criteria criteria, FilterCondition filter, CriteriaHolder criteriaHolder) { /* Validate only numbers & dates */ this.validate(criteriaHolder, filter.getValue(), filter.isNegative(), INCORRECT_FILTER_PARAMETERS); Object valueToFind = ObjectId.isValid(filter.getValue()) ? new ObjectId(filter.getValue()) : this.castValue(criteriaHolder, filter.getValue(), INCORRECT_FILTER_PARAMETERS); criteria.lt(valueToFind); }