try {
Template helloTemplate = configuration.getTemplate("answer.ftl");
// Not necessary yet to understand this. It's just to prove that you
// are able to run a command on a mongod server
AggregationOutput output =
collection.aggregate(
new BasicDBObject("$group",
new BasicDBObject("_id", "$value")
.append("count", new BasicDBObject("$sum", 1)))
,
new BasicDBObject("$match", new BasicDBObject("count",
new BasicDBObject("$lte", 2))),
new BasicDBObject("$sort", new BasicDBObject("_id", 1))
);
int answer = 0;
for (DBObject doc : output.results()) {
answer += (Double) doc.get("_id");
}
Map<String, String> answerMap = new HashMap<String, String>();
answerMap.put("answer", Integer.toString(answer));