/* * (non-Javadoc) * @see de.mq.portfolio.exchangerate.support.ExchangeRateDatebaseRepository#exchangerates(java.util.Collection) */ @Override public final Collection<ExchangeRate> exchangerates( final Collection<ExchangeRate> exchangerates) { Assert.notNull(exchangerates); final Collection<ExchangeRate> rates = new HashSet<>(); rates.addAll(exchangerates); rates.addAll( exchangerates .stream() .map(er -> new ExchangeRateImpl(er.target(), er.source())) .collect(Collectors.toSet())); final Collection<ExchangeRate> results = new HashSet<>(); rates.forEach( rate -> results.addAll( mongoOperations.find( Query.query( Criteria.where(SOURCE_FIELD_NAME) .is(rate.source()) .and(TARGET_FIELD_NAME) .is(rate.target())), ExchangeRateImpl.class))); return Collections.unmodifiableCollection(results); }
private List<MaintenanceSpendBySupplier> getTruckMaintenanceSpend( Truck truck, Date from, Date to) { Query truckMaintenanceSpendListQuery = new Query(); truckMaintenanceSpendListQuery.addCriteria( Criteria.where("truckId") .is(truck.getId()) .andOperator( Criteria.where("transactionDate").gte(from), Criteria.where("transactionDate").lte(to))); /* * List<MaintenanceSpendBySupplier> maintenanceSpendList = mongoOperation.find(truckMaintenanceSpendListQuery, MaintenanceSpendBySupplier.class); System.out.println(" MaintenanceSpendBySupplierRepository - TRUCK QUERY - Start= " + to + " | To= " + to + " FOR truckId: " + truck.getId()); if (maintenanceSpendList.isEmpty()) { System.out.println("MaintenanceSpendBySupplierRepository - TRUCK QUERY - NO MATCHING RECORDS FOUND"); } for (MaintenanceSpendBySupplier maintenanceSpend : maintenanceSpendList) { System.out.println(" MaintenanceSpendBySupplierRepository - TRUCK QUERY - Date= " + maintenanceSpend.getTransactionDate() + " | Cost= " + maintenanceSpend.getMaintenanceCost() + " | Truck= " + maintenanceSpend.getTruckId() + " | Supplier" + maintenanceSpend.getSupplierId()); } System.out.println("--==--"); */ return mongoOperation.find(truckMaintenanceSpendListQuery, MaintenanceSpendBySupplier.class); }
public List<HelloWorld> getManybyName(String name) { System.out.println("DAO: Querying all data name:" + name); Query query = new Query(); query.addCriteria(Criteria.where("name").is(name)); System.out.println("DAO: Return data"); return mongoOps.find(query, HelloWorld.class, COLLECTION); }
@Override public List<MaintenanceSpendBySupplier> getMaintenanceSpendBetweenTwoDates(Date from, Date to) { Date fromDate = dateTimeFormatHelper.resetTimeAndMonthStart(from); Date toDate = dateTimeFormatHelper.resetTimeAndMonthEnd(to); Calendar calendar = Calendar.getInstance(); calendar.setTime(toDate); // Set time fields to last hour:minute:second:millisecond calendar.set(Calendar.HOUR_OF_DAY, 23); calendar.set(Calendar.MINUTE, 59); calendar.set(Calendar.SECOND, 59); calendar.set(Calendar.MILLISECOND, 999); Query maintenanceSpendListQuery = new Query(); maintenanceSpendListQuery.addCriteria( Criteria.where("transactionDate") .exists(true) .andOperator( Criteria.where("transactionDate").gte(fromDate), Criteria.where("transactionDate").lte(calendar.getTime()))); /* List<MaintenanceSpendBySupplier> maintenanceSpendList = mongoOperation.find(maintenanceSpendListQuery, MaintenanceSpendBySupplier.class); System.out.println(" MaintenanceSpendBySupplierRepository - GENERAL QUERY - Start= " + to + " | To= " + to); if (maintenanceSpendList.isEmpty()) { System.out.println("MaintenanceSpendBySupplierRepository - GENERAL QUERY - NO MATCHING RECORDS FOUND"); } for (MaintenanceSpendBySupplier maintenanceSpend : maintenanceSpendList) { System.out.println(" MaintenanceSpendBySupplierRepository - GENERAL QUERY - Date= " + maintenanceSpend.getTransactionDate() + " | Cost= " + maintenanceSpend.getMaintenanceCost() + " | Truck= " + maintenanceSpend.getTruckId() + " | Supplier" + maintenanceSpend.getSupplierId()); } System.out.println("--==--"); */ return mongoOperation.find(maintenanceSpendListQuery, MaintenanceSpendBySupplier.class); }
public PackageInfo GetTracking(String idPaquete) { Query query = new Query(); query.addCriteria(Criteria.where("_id").is(idPaquete)); List<PackageInfo> packs = mongoOperations.find(query, PackageInfo.class); if (packs.size() > 0) return packs.get(0); else return null; }
@Override public boolean userExists(String username) { Query query = new Query(Criteria.where("username").is(username)); if (mongoOperations.find(query, User.class).isEmpty()) { return false; } return true; }
private String getEntityOwnerTenant(final EntityResource entityResource) { final Class<?> collectionClass = (entityBelongsToProvider(entityResource) ? Provider.class : Application.class); final Criteria criteria = Criteria.where("_id").is(entityResource.getEntityOwner()); final TenantResource entityOwner = (TenantResource) mongoOps.find(new Query(criteria), collectionClass).get(0); return entityOwner.getTenantId(); }
/** {@link RepositoryOperations#findAll} */ public List<T> find(Iterable<QueryCriteria> queryCriterias, Sort sort) { Criteria criteria = MongoQueryUtils.getQueryFromQueryCriteria(queryCriterias); Query query = new Query(); if (criteria != null) { query.addCriteria(criteria); } return mongoOperations.find(query.with(sort), model); }
@Override public List<Compte> listerComptes(int offset, int limit, Direction direction) { final Query query = new Query(); query.skip(offset); query.limit(limit); query.with(new Sort(direction, Constantes.ChampCollectionCompte.IDCOMPTE)); return mongoOperations.find(query, Compte.class); }
/** {@link RepositoryOperations#findAll} */ public Page<T> find(Iterable<QueryCriteria> queryCriterias, Pageable pageable) { Criteria criteria = MongoQueryUtils.getQueryFromQueryCriteria(queryCriterias); Query query = new Query(); if (criteria != null) { query.addCriteria(criteria); } List<T> entities = mongoOperations.find(query.with(pageable), model); long count = count(queryCriterias); return new PageImpl<T>(entities, pageable, count); }
@Override public Collection<E> findAllAtivos() { final Query query = query(where("ativo").is(true)).addCriteria(getTypeCriteria()); return new ArrayList<>(operations.find(query, type)); }
public List<PackageInfo> GetAllPackages() { return mongoOperations.find(new Query(), PackageInfo.class); }
/** {@link RepositoryOperations#findAll} */ public List<T> findAll(Sort sort) { return mongoOperations.find(new Query().with(sort), model); }
/** {@link RepositoryOperations#findAll} */ public Page<T> findAll(Pageable pageable) { List<T> entities = mongoOperations.find(new Query().with(pageable), model); long count = count(); return new PageImpl<T>(entities, pageable, count); }
@Override public Collection<E> findAll() { final Query query = query(getTypeCriteria()); return new ArrayList<>(operations.find(query, type)); }
public List<CreditTransaction> getAllTransactionByUserId(String userId) throws UnknownHostException { Query query = new Query(); query.addCriteria(where("user_Id").is(userId)); return transactionMongoOps.find(query, CreditTransaction.class); }
public List<Article> findArticlesByAuthor(Author author) { Query query = query(where("author").is(author)); return operations.find(query, Article.class); }