Example usage for com.mongodb BasicDBObjectBuilder get

Introduction

In this page you can find the example usage for com.mongodb BasicDBObjectBuilder get.

Prototype

public DBObject get()

Source Link

Document

Gets the top level document.

Usage

From source file:com.examples.aggregation.AggregationExample.java

License:Open Source License

public Iterator<DBObject> sumPrices() {
    BasicDBObjectBuilder builder = new BasicDBObjectBuilder();
    builder.push("$group");
    builder.add("_id", "$manufacturer");
    builder.push("sum_prices");
    builder.add("$sum", "$price");
    builder.pop();//from   w w w  .  ja va  2  s.co m
    builder.pop();

    return col.aggregate(builder.get()).results().iterator();
}

From source file:com.examples.aggregation.AggregationExample.java

License:Open Source License

public Iterator<DBObject> averagePrices() {
    BasicDBObjectBuilder builder = new BasicDBObjectBuilder();
    builder.push("$group");
    builder.add("_id", "$category");
    builder.push("sum_prices");
    builder.add("$avg", "$price");
    builder.pop();//ww  w .  jav  a2  s  .  co m
    builder.pop();

    return col.aggregate(builder.get()).results().iterator();
}

From source file:com.examples.aggregation.AggregationExample.java

License:Open Source License

public Iterator<DBObject> addToSet() {
    BasicDBObjectBuilder builder = new BasicDBObjectBuilder();
    builder.push("$group");
    builder.push("_id");
    builder.add("maker", "$manufacturer");
    builder.pop();//  w  w w .  j  a  v  a 2 s  .  c o m
    builder.push("categories");
    builder.add("$addToSet", "$category");
    builder.pop();
    builder.pop();

    return col.aggregate(builder.get()).results().iterator();
}

From source file:com.examples.aggregation.AggregationExample.java

License:Open Source License

public Iterator<DBObject> push() {
    BasicDBObjectBuilder builder = new BasicDBObjectBuilder();
    builder.push("$group");
    builder.push("_id");
    builder.add("maker", "$manufacturer");
    builder.pop();//from w w  w  .  j  a  v  a  2s. co  m
    builder.push("categories");
    builder.add("$push", "$category");
    builder.pop();
    builder.pop();

    return col.aggregate(builder.get()).results().iterator();
}

From source file:com.examples.aggregation.AggregationExample.java

License:Open Source License

public Iterator<DBObject> maxPrice() {
    BasicDBObjectBuilder builder = new BasicDBObjectBuilder();
    builder.push("$group");
    builder.push("_id");
    builder.add("maker", "$manufacturer");
    builder.pop();//from   w  w  w  . java2s  .  co  m
    builder.push("maxprice");
    builder.add("$max", "$price");
    builder.pop();
    builder.pop();

    return col.aggregate(builder.get()).results().iterator();
}

From source file:com.examples.aggregation.AggregationExample.java

License:Open Source License

public Iterator<DBObject> doubleGroupStages() {
    BasicDBObjectBuilder group_1 = new BasicDBObjectBuilder();
    group_1.push("$group");
    group_1.push("_id");
    group_1.add("class_id", "$class_id");
    group_1.add("student_id", "$student_id");
    group_1.pop();//from w w  w  .  j av  a 2s  .  c  o m
    group_1.push("average");
    group_1.add("$avg", "$score");
    group_1.pop();
    group_1.pop();

    BasicDBObjectBuilder group_2 = new BasicDBObjectBuilder();
    group_2.push("$group");
    group_2.add("_id", "$_id.class_id");
    group_2.push("average");
    group_2.add("$avg", "$average");
    group_2.pop();
    group_2.pop();

    return col.aggregate(group_1.get(), group_2.get()).results().iterator();
}

From source file:com.examples.aggregation.AggregationExample.java

License:Open Source License

public Iterator<DBObject> project() {
    BasicDBObjectBuilder builder = new BasicDBObjectBuilder();
    builder.push("$project");
    builder.add("_id", 0);
    builder.push("maker");
    builder.add("$toLower", "$manufacturer");
    builder.pop();//  w w w  .j a  v a2s.c  o  m
    builder.push("details");
    builder.add("category", "$category");
    builder.push("price");
    builder.add("$multiply", new Object[] { "$price", 10 });
    builder.pop();
    builder.pop();
    builder.add("item", "$name");
    builder.pop();

    return col.aggregate(builder.get()).results().iterator();
}

From source file:com.examples.aggregation.AggregationExample.java

License:Open Source License

public Iterator<DBObject> match() {
    BasicDBObjectBuilder match = buildMatchDBObject();
    BasicDBObjectBuilder group = new BasicDBObjectBuilder();
    group.push("$group");
    group.add("_id", "$city");
    group.push("population");
    group.add("$sum", "$pop");
    group.pop();/*  www.j  a va2 s . c om*/
    group.push("zip_codes");
    group.add("$addToSet", "$_id");
    group.pop();
    group.pop();

    return col.aggregate(match.get(), group.get()).results().iterator();
}

From source file:com.examples.aggregation.AggregationExample.java

License:Open Source License

public Iterator<DBObject> sort() {
    BasicDBObjectBuilder match = buildMatchDBObject();

    BasicDBObjectBuilder group = new BasicDBObjectBuilder();
    group.push("$group");
    group.add("_id", "$city");
    group.push("population");
    group.add("$sum", "$pop");
    group.pop();//www  . java  2  s  .  com
    group.pop();

    BasicDBObjectBuilder project = new BasicDBObjectBuilder();
    project.push("$project");
    project.add("_id", 0);
    project.add("city", "$_id");
    project.add("population", 1);
    project.pop();

    BasicDBObjectBuilder sort = new BasicDBObjectBuilder();
    sort.push("$sort");
    sort.add("population", -1);
    sort.pop();

    return col.aggregate(match.get(), group.get(), project.get(), sort.get()).results().iterator();
}

From source file:com.examples.aggregation.AggregationExample.java

License:Open Source License

public Iterator<DBObject> limitAndSkip() {
    BasicDBObjectBuilder match = buildMatchDBObject();

    BasicDBObjectBuilder group = new BasicDBObjectBuilder();
    group.push("$group");
    group.add("_id", "$city");
    group.push("population");
    group.add("$sum", "$pop");
    group.pop();/* ww  w  . ja  va 2 s .  c  om*/
    group.pop();

    BasicDBObjectBuilder project = new BasicDBObjectBuilder();
    project.push("$project");
    project.add("_id", 0);
    project.add("city", "$_id");
    project.add("population", 1);
    project.pop();

    BasicDBObjectBuilder sort = new BasicDBObjectBuilder();
    sort.push("$sort");
    sort.add("population", -1);
    sort.pop();

    BasicDBObject skip = new BasicDBObject("$skip", 10);
    BasicDBObject limit = new BasicDBObject("$limit", 5);

    return col.aggregate(match.get(), group.get(), project.get(), sort.get(), skip, limit).results().iterator();
}