public static <T> QueryBuilder<T> create(Class<T> entityType) { return new QueryBuilder<T>(entityType); }
@Override public QuotaUsageVO doInTransaction(final TransactionStatus status) { List<QuotaUsageVO> quotaUsageEntries = new ArrayList<>(); Filter filter = new Filter(QuotaUsageVO.class, "startDate", false, 0L, 1L); QueryBuilder<QuotaUsageVO> qb = QueryBuilder.create(QuotaUsageVO.class); qb.and(qb.entity().getAccountId(), SearchCriteria.Op.EQ, accountId); qb.and(qb.entity().getDomainId(), SearchCriteria.Op.EQ, domainId); qb.and(qb.entity().getStartDate(), SearchCriteria.Op.LT, beforeThis); quotaUsageEntries = search(qb.create(), filter); return !quotaUsageEntries.isEmpty() ? quotaUsageEntries.get(0) : null; } });
QueryBuilder qb = new QueryBuilder(); for (int x=0; x<2;x++) { qb.or(new BasicDBObject("this","that")); } QueryBuilder qb2 = new QueryBuilder(); qb2.and(qb.get()); QueryBuilder qb3 = new QueryBuilder(); for (int x=0; x<2;x++) { qb3.or(new BasicDBObject("something", "else")); } qb2.and(qb3.get()); System.out.println(qb2.get());
BasicDBObject document = new BasicDBObject(); Pattern regex = Pattern.compile("^((?!Salt).)*$"); QueryBuilder queryBuilder = new QueryBuilder(); queryBuilder.and( new QueryBuilder().put("contract").notEquals("none").get(), new QueryBuilder().put("contract").notEquals(null).get(), new QueryBuilder().put("contract").regex(regex).get() ); document.putAll(queryBuilder.get()); DBCursor cursor = getDbCollection().find(document);
QueryBuilder queryBuidlerType = QueryBuilder.start("working").is(1); DBObject or1 = QueryBuilder.start().or(QueryBuilder.start("user").exists(true).get(), QueryBuilder.start("parent").exists(true).get()).get(); DBObject or2 = QueryBuilder.start().or(QueryBuilder.start("car.id").is(mId).and("car.model").is("mModel").get(), QueryBuilder.start("car.matched.id").is(mId).and("car.matched.model").is("mModel").get()).get(); queryBuidlerType.and(or1, or2); DBObject queryType = queryBuidlerType.get();
helper = new DaoMaster.DevOpenHelper(this, "your database", null); db = helper.getWritableDatabase(); daoMaster = new DaoMaster(db); daoSession = daoMaster.newSession(); boxDao= daoSession.getBoxDao(); QueryBuilder queryBuilder = boxDao.queryBuilder() .where(BoxDao.Properties.Date.eq("something to compare")); List<Box> list = queryBuilder.list();
@Override public QuotaBalanceVO doInTransaction(final TransactionStatus status) { List<QuotaBalanceVO> quotaBalanceEntries = new ArrayList<>(); Filter filter = new Filter(QuotaBalanceVO.class, "updatedOn", true, 0L, 1L); QueryBuilder<QuotaBalanceVO> qb = QueryBuilder.create(QuotaBalanceVO.class); qb.and(qb.entity().getAccountId(), SearchCriteria.Op.EQ, accountId); qb.and(qb.entity().getDomainId(), SearchCriteria.Op.EQ, domainId); qb.and(qb.entity().getCreditsId(), SearchCriteria.Op.EQ, 0); qb.and(qb.entity().getUpdatedOn(), SearchCriteria.Op.GT, afterThis); quotaBalanceEntries = search(qb.create(), filter); return quotaBalanceEntries.size() > 0 ? quotaBalanceEntries.get(0) : null; } });
QueryBuilder builder = QueryBuilder.start(); builder.and("objectKey").regex(Pattern.compile("box")); builder.and("cache_version_string").is("08/03/15_11:05:09"); BasicDBObject query = (BasicDBObject)builder.get(); Bson projection = Projections.exclude( "_id", "obectdata", "lasModified", "productCode" ); MongoCursor<Document> cursor = collection.find(query).projection(projection).iterator(); while (cursor.hasNext()) { Document doc = cursor.next(); System.out.println(doc.toJson()); }
@Override public QuotaBalanceVO doInTransaction(final TransactionStatus status) { List<QuotaBalanceVO> quotaBalanceEntries = new ArrayList<>(); Filter filter = new Filter(QuotaBalanceVO.class, "updatedOn", false, 0L, 1L); QueryBuilder<QuotaBalanceVO> qb = QueryBuilder.create(QuotaBalanceVO.class); qb.and(qb.entity().getAccountId(), SearchCriteria.Op.EQ, accountId); qb.and(qb.entity().getDomainId(), SearchCriteria.Op.EQ, domainId); qb.and(qb.entity().getCreditsId(), SearchCriteria.Op.EQ, 0); qb.and(qb.entity().getUpdatedOn(), SearchCriteria.Op.LT, beforeThis); quotaBalanceEntries = search(qb.create(), filter); return !quotaBalanceEntries.isEmpty() ? quotaBalanceEntries.get(0) : null; } });
public static <T> QueryBuilder<T> create(final Class<T> entityType) { return new QueryBuilder<>(entityType); } }
@Override public List<QuotaCreditsVO> doInTransaction(final TransactionStatus status) { if ((startDate != null) && (endDate != null) && startDate.before(endDate)) { Filter filter = new Filter(QuotaCreditsVO.class, "updatedOn", true, 0L, Long.MAX_VALUE); QueryBuilder<QuotaCreditsVO> qb = QueryBuilder.create(QuotaCreditsVO.class); qb.and(qb.entity().getAccountId(), SearchCriteria.Op.EQ, accountId); qb.and(qb.entity().getDomainId(), SearchCriteria.Op.EQ, domainId); qb.and(qb.entity().getUpdatedOn(), SearchCriteria.Op.BETWEEN, startDate, endDate); return search(qb.create(), filter); } else { return Collections.<QuotaCreditsVO> emptyList(); } } });
@Override public List<QuotaBalanceVO> doInTransaction(final TransactionStatus status) { if ((lastbalancedate != null) && (beforeThis != null) && lastbalancedate.before(beforeThis)) { Filter filter = new Filter(QuotaBalanceVO.class, "updatedOn", true, 0L, Long.MAX_VALUE); QueryBuilder<QuotaBalanceVO> qb = QueryBuilder.create(QuotaBalanceVO.class); qb.and(qb.entity().getAccountId(), SearchCriteria.Op.EQ, accountId); qb.and(qb.entity().getDomainId(), SearchCriteria.Op.EQ, domainId); qb.and(qb.entity().getCreditsId(), SearchCriteria.Op.GT, 0); qb.and(qb.entity().getUpdatedOn(), SearchCriteria.Op.BETWEEN, lastbalancedate, beforeThis); return search(qb.create(), filter); } else { return new ArrayList<QuotaBalanceVO>(); } } });
@Override public List<QuotaBalanceVO> doInTransaction(final TransactionStatus status) { List<QuotaBalanceVO> quotaUsageRecords = null; QueryBuilder<QuotaBalanceVO> qb = QueryBuilder.create(QuotaBalanceVO.class); if (accountId != null) { qb.and(qb.entity().getAccountId(), SearchCriteria.Op.EQ, accountId); } if (domainId != null) { qb.and(qb.entity().getDomainId(), SearchCriteria.Op.EQ, domainId); } if ((startDate != null) && (endDate != null) && startDate.before(endDate)) { qb.and(qb.entity().getUpdatedOn(), SearchCriteria.Op.BETWEEN, startDate, endDate); } else { return Collections.<QuotaBalanceVO> emptyList(); } quotaUsageRecords = listBy(qb.create()); if (quotaUsageRecords.size() == 0) { quotaUsageRecords.addAll(lastQuotaBalanceVO(accountId, domainId, startDate)); } return quotaUsageRecords; } });