Example usage for com.mongodb.client.model Filters eq

List of usage examples for com.mongodb.client.model Filters eq

Introduction

In this page you can find the example usage for com.mongodb.client.model Filters eq.

Prototype

public static <TItem> Bson eq(final String fieldName, @Nullable final TItem value) 

Source Link

Document

Creates a filter that matches all documents where the value of the field name equals the specified value.

Usage

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;
}