List of usage examples for com.mongodb.client.model Filters eq
public static <TItem> Bson eq(final String fieldName, @Nullable final TItem value)
From source file:com.avbravo.ejbjmoordb.mongodb.repository.Repository.java
/** * Crea un filtro para filtrar entre fechas * * @param startname//w ww. java 2s .com * @param datestart * @param endname * @param datelimit * * @return */ public List<T> filterBetweenDatePagination(String secondaryfield, Integer secondaryfieldvalue, String fieldnamestart, Date datestartvalue, String fieldlimitname, Date datelimitvalue, Integer pageNumber, Integer rowsForPage, Document... docSort) { list = new ArrayList<>(); try { Document sortQuery = new Document(); if (docSort.length != 0) { sortQuery = docSort[0]; } Bson filter = Filters.and(Filters.eq(secondaryfield, secondaryfieldvalue), Filters.gte(fieldnamestart, datestartvalue), Filters.lte(fieldlimitname, datelimitvalue)); list = filtersPagination(filter, pageNumber, rowsForPage, sortQuery); } catch (Exception e) { Logger.getLogger(Repository.class.getName() + "filterBetweenDatePagination()").log(Level.SEVERE, null, e); exception = new Exception("filterBetweenDatePagination ", e); } return list; }
From source file:com.avbravo.ejbjmoordb.mongodb.repository.Repository.java
/** * crea un filtro con paginacion de fechas and otro atributo * * @param primarykeyfield/*from w w w.jav a 2 s. c om*/ * @param primarykeyvalue * @param fieldnamestart * @param datestartvalue * @param pageNumber * @param rowsForPage * @param docSort * @return */ public List<T> filterDayWithoutHour(String secondaryfield, String secondaryfieldvalue, String fielddate, Date datevalue, Document... docSort) { list = new ArrayList<>(); try { Document sortQuery = new Document(); if (docSort.length != 0) { sortQuery = docSort[0]; } Bson filter = Filters.and(Filters.eq(secondaryfield, secondaryfieldvalue), Filters.gte(fielddate, datevalue), Filters.lte(fielddate, datevalue)); list = filters(filter, sortQuery); } catch (Exception e) { Logger.getLogger(Repository.class.getName() + "filterBetweenDatePagination()").log(Level.SEVERE, null, e); exception = new Exception("filterBetweenDatePagination ", e); } return list; }
From source file:com.avbravo.ejbjmoordb.mongodb.repository.Repository.java
/** * * @param primarykeyfield//from w w w. j a v a 2s. c o m * @param primarykeyvalue * @param fieldnamestart * @param datestartvalue * @param pageNumber * @param rowsForPage * @param docSort * @return */ public List<T> filterDayWithoutHour(String secondaryfield, Integer secondaryfieldvalue, String fielddate, Date datevalue, Document... docSort) { list = new ArrayList<>(); try { Document sortQuery = new Document(); if (docSort.length != 0) { sortQuery = docSort[0]; } Bson filter = Filters.and(Filters.eq(secondaryfield, secondaryfieldvalue), Filters.gte(fielddate, datevalue), Filters.lte(fielddate, datevalue)); list = filters(filter, sortQuery); } catch (Exception e) { Logger.getLogger(Repository.class.getName() + "filterDayWithoutHourPagination()").log(Level.SEVERE, null, e); exception = new Exception("filterDayWithoutHourPagination ", e); } return list; }
From source file:com.avbravo.ejbjmoordb.mongodb.repository.Repository.java
/** * crea un filtro con paginacion de fechas and otro atributo * * @param primarykeyfield/*from ww w .j av a 2s .c o m*/ * @param primarykeyvalue * @param fieldnamestart * @param datestartvalue * @param pageNumber * @param rowsForPage * @param docSort * @return */ public List<T> filterDayWithoutHourPagination(String secondaryfield, String secondaryfieldvalue, String fielddate, Date datevalue, Integer pageNumber, Integer rowsForPage, Document... docSort) { list = new ArrayList<>(); try { Document sortQuery = new Document(); if (docSort.length != 0) { sortQuery = docSort[0]; } Bson filter = Filters.and(Filters.eq(secondaryfield, secondaryfieldvalue), Filters.gte(fielddate, datevalue), Filters.lte(fielddate, datevalue)); list = filtersPagination(filter, pageNumber, rowsForPage, sortQuery); } catch (Exception e) { Logger.getLogger(Repository.class.getName() + "filterBetweenDatePagination()").log(Level.SEVERE, null, e); exception = new Exception("filterBetweenDatePagination ", e); } return list; }
From source file:com.avbravo.ejbjmoordb.mongodb.repository.Repository.java
/** * * @param primarykeyfield//from ww w . jav a 2 s.c om * @param primarykeyvalue * @param fieldnamestart * @param datestartvalue * @param pageNumber * @param rowsForPage * @param docSort * @return */ public List<T> filterDayWithoutHourPagination(String secondaryfield, Integer secondaryfieldvalue, String fielddate, Date datevalue, Integer pageNumber, Integer rowsForPage, Document... docSort) { list = new ArrayList<>(); try { Document sortQuery = new Document(); if (docSort.length != 0) { sortQuery = docSort[0]; } Bson filter = Filters.and(Filters.eq(secondaryfield, secondaryfieldvalue), Filters.gte(fielddate, datevalue), Filters.lte(fielddate, datevalue)); list = filtersPagination(filter, pageNumber, rowsForPage, sortQuery); } catch (Exception e) { Logger.getLogger(Repository.class.getName() + "filterDayWithoutHourPagination()").log(Level.SEVERE, null, e); exception = new Exception("filterDayWithoutHourPagination ", e); } return list; }
From source file:com.avbravo.ejbjmoordb.mongodb.repository.Repository.java
/** * Devuelve true si no hay registros con la condicion fechay hora de inicio y fin y el filtro que se pasa como parametro * * @param filter//from w w w .j a v a2 s . c om * @param namefieldOfStart * @param valueStart * @param namefieldOfEnd * @param valueEnd * @return */ public Boolean isAvailableBetweenDateHour(Bson filter, String namefieldOfStart, Date valueStart, String namefieldOfEnd, Date valueEnd) { try { //Vehiculos en viajes Integer count = count(); if (count.equals(0)) { return true; } //inicio Bson b = Filters.and(Filters.gt(namefieldOfStart, valueStart), Filters.lt(namefieldOfStart, valueEnd), Filters.gt(namefieldOfEnd, valueStart), Filters.gt(namefieldOfEnd, valueEnd)); Bson c_e_f_g_h_l = Filters.or(Filters.eq(namefieldOfStart, valueStart), Filters.eq(namefieldOfStart, valueEnd), Filters.eq(namefieldOfEnd, valueStart), Filters.eq(namefieldOfEnd, valueEnd)); Bson j = Filters.and(Filters.lt(namefieldOfStart, valueStart), Filters.lt(namefieldOfStart, valueEnd), Filters.gt(namefieldOfEnd, valueStart), Filters.eq(namefieldOfEnd, valueEnd)); Bson d = Filters.and(Filters.gt(namefieldOfStart, valueStart), Filters.lt(namefieldOfStart, valueEnd), Filters.gt(namefieldOfEnd, valueStart), Filters.lt(namefieldOfEnd, valueEnd)); Bson i = Filters.and(Filters.lt(namefieldOfStart, valueStart), Filters.lt(namefieldOfStart, valueEnd), Filters.gt(namefieldOfEnd, valueStart), Filters.gt(namefieldOfEnd, valueEnd)); Bson k = Filters.and(Filters.lt(namefieldOfStart, valueStart), Filters.lt(namefieldOfStart, valueEnd), Filters.gt(namefieldOfEnd, valueStart), Filters.lt(namefieldOfEnd, valueEnd)); Bson _filter = Filters.and(filter, or(b, c_e_f_g_h_l, d, i, j, k)); List<T> list = findBy(_filter); if (list.isEmpty()) { return true; } } catch (Exception e) { Logger.getLogger(Repository.class.getName() + "isAvailableBetweenDate()").log(Level.SEVERE, null, e); exception = new Exception("isAvailableBetweenDate() ", e); } return false; }
From source file:com.avbravo.ejbjmoordb.mongodb.repository.Repository.java
/** * Devuelve una lista de los elementos que estan en ese rango de fechas y que cumplan la condicion del filtro que se * pasa como parametro/*from w w w .j a v a 2 s . c o m*/ * * @param filter * @param namefieldOfStart * @param valueStart * @param namefieldOfEnd * @param valueEnd * @return Devuelve una lista de los elementos que estan en ese rango de fechas y que cumplan la condicion del filtro que se * pasa como parametro */ public List<T> notAvailableBetweenDateHour(Bson filter, String namefieldOfStart, Date valueStart, String namefieldOfEnd, Date valueEnd) { try { //Vehiculos en viajes list = new ArrayList<>(); Integer count = count(); if (count.equals(0)) { return list; } //inicio Bson b = Filters.and(Filters.gt(namefieldOfStart, valueStart), Filters.lt(namefieldOfStart, valueEnd), Filters.gt(namefieldOfEnd, valueStart), Filters.gt(namefieldOfEnd, valueEnd)); Bson c_e_f_g_h_l = Filters.or(Filters.eq(namefieldOfStart, valueStart), Filters.eq(namefieldOfStart, valueEnd), Filters.eq(namefieldOfEnd, valueStart), Filters.eq(namefieldOfEnd, valueEnd)); Bson j = Filters.and(Filters.lt(namefieldOfStart, valueStart), Filters.lt(namefieldOfStart, valueEnd), Filters.gt(namefieldOfEnd, valueStart), Filters.eq(namefieldOfEnd, valueEnd)); Bson d = Filters.and(Filters.gt(namefieldOfStart, valueStart), Filters.lt(namefieldOfStart, valueEnd), Filters.gt(namefieldOfEnd, valueStart), Filters.lt(namefieldOfEnd, valueEnd)); Bson i = Filters.and(Filters.lt(namefieldOfStart, valueStart), Filters.lt(namefieldOfStart, valueEnd), Filters.gt(namefieldOfEnd, valueStart), Filters.gt(namefieldOfEnd, valueEnd)); Bson k = Filters.and(Filters.lt(namefieldOfStart, valueStart), Filters.lt(namefieldOfStart, valueEnd), Filters.gt(namefieldOfEnd, valueStart), Filters.lt(namefieldOfEnd, valueEnd)); Bson _filter = Filters.and(filter, or(b, c_e_f_g_h_l, d, i, j, k)); list = findBy(_filter); } catch (Exception e) { Logger.getLogger(Repository.class.getName() + "isAvailableBetweenDate()").log(Level.SEVERE, null, e); exception = new Exception("isAvailableBetweenDate() ", e); } return list; }
From source file:com.avbravo.jmoordbdianna.mongodb.facade.AbstractFacade.java
/** * implementa replaceOne//from ww w .j ava 2 s .c o m * * @param key * @param value * @param docUpdate * @return */ public Integer replaceOne(String key, String value, Document docUpdate) { Integer documentosModificados = 0; try { UpdateResult updateResult = getMongoDatabase().getCollection(collection) .replaceOne(Filters.eq(key, value), docUpdate); return (int) updateResult.getModifiedCount(); } catch (Exception e) { Logger.getLogger(AbstractFacade.class.getName() + "replaceOne()").log(Level.SEVERE, null, e); exception = new Exception("replaceOne() ", e); } return 0; }
From source file:com.cognifide.aet.vs.metadata.MetadataDAOMongoDBImpl.java
License:Apache License
@Override public Suite getSuite(DBKey dbKey, String correlationId) throws StorageException { Suite suite = null;/*from w w w .j a v a2 s. c o m*/ MongoCollection<Document> metadata = getMetadataCollection(dbKey); LOGGER.debug("Fetching suite with correlationId: {} ", correlationId); final FindIterable<Document> found = metadata.find(Filters.eq(CORRELATION_ID_PARAM_NAME, correlationId)) .sort(Sorts.descending(SUITE_VERSION_PARAM_NAME)).limit(1); final Document result = found.first(); if (result != null) { suite = GSON.fromJson(result.toJson(), SUITE_TYPE); } return suite; }
From source file:com.cognifide.aet.vs.metadata.MetadataDAOMongoDBImpl.java
License:Apache License
@Override public Suite getLatestRun(DBKey dbKey, String name) throws StorageException { Suite suite = null;//from ww w . j a v a 2s .c o m MongoCollection<Document> metadata = getMetadataCollection(dbKey); LOGGER.debug("Fetching latest suite run for company: `{}`, project: `{}`, name `{}`.", dbKey.getCompany(), dbKey.getProject(), name); final FindIterable<Document> found = metadata.find(Filters.eq("name", name)) .sort(Sorts.descending(SUITE_VERSION_PARAM_NAME)).limit(1); final Document result = found.first(); if (result != null) { suite = GSON.fromJson(result.toJson(), SUITE_TYPE); } return suite; }