1 files changed, 103 insertions, 0 deletions
diff --git a/common/src/main/webapp/usageguide/appserver/node_modules/mongoose/examples/aggregate/aggregate.js b/common/src/main/webapp/usageguide/appserver/node_modules/mongoose/examples/aggregate/aggregate.js
new file mode 100644
index 0000000..793c8cb
--- /dev/null
+++ b/common/src/main/webapp/usageguide/appserver/node_modules/mongoose/examples/aggregate/aggregate.js
@@ -0,0 +1,103 @@
+
+// import async to make control flow simplier
+var async = require('async');
+
+// import the rest of the normal stuff
+var mongoose = require('../../lib');
+
+require('./person.js')();
+
+var Person = mongoose.model('Person');
+
+// define some dummy data
+var data = [
+  {
+    name: 'bill',
+    age: 25,
+    birthday: new Date().setFullYear((new Date().getFullYear() - 25)),
+    gender: 'Male',
+    likes: ['movies', 'games', 'dogs']
+  },
+  {
+    name: 'mary',
+    age: 30,
+    birthday: new Date().setFullYear((new Date().getFullYear() - 30)),
+    gender: 'Female',
+    likes: ['movies', 'birds', 'cats']
+  },
+  {
+    name: 'bob',
+    age: 21,
+    birthday: new Date().setFullYear((new Date().getFullYear() - 21)),
+    gender: 'Male',
+    likes: ['tv', 'games', 'rabbits']
+  },
+  {
+    name: 'lilly',
+    age: 26,
+    birthday: new Date().setFullYear((new Date().getFullYear() - 26)),
+    gender: 'Female',
+    likes: ['books', 'cats', 'dogs']
+  },
+  {
+    name: 'alucard',
+    age: 1000,
+    birthday: new Date().setFullYear((new Date().getFullYear() - 1000)),
+    gender: 'Male',
+    likes: ['glasses', 'wine', 'the night']
+  }
+];
+
+
+mongoose.connect('mongodb://localhost/persons', function(err) {
+  if (err) throw err;
+
+  // create all of the dummy people
+  async.each(data, function(item, cb) {
+    Person.create(item, cb);
+  }, function(err) {
+    if (err) {
+      // handle error
+    }
+
+    // run an aggregate query that will get all of the people who like a given
+    // item. To see the full documentation on ways to use the aggregate
+    // framework, see http://docs.mongodb.org/manual/core/aggregation/
+    Person.aggregate(
+      // select the fields we want to deal with
+      {$project: {name: 1, likes: 1}},
+      // unwind 'likes', which will create a document for each like
+      {$unwind: '$likes'},
+      // group everything by the like and then add each name with that like to
+      // the set for the like
+      {$group: {
+        _id: {likes: '$likes'},
+        likers: {$addToSet: '$name'}
+      }},
+      function(err, result) {
+        if (err) throw err;
+        console.log(result);
+         /* [
+         { _id: { likes: 'the night' }, likers: [ 'alucard' ] },
+         { _id: { likes: 'wine' }, likers: [ 'alucard' ] },
+         { _id: { likes: 'books' }, likers: [ 'lilly' ] },
+         { _id: { likes: 'glasses' }, likers: [ 'alucard' ] },
+         { _id: { likes: 'birds' }, likers: [ 'mary' ] },
+         { _id: { likes: 'rabbits' }, likers: [ 'bob' ] },
+         { _id: { likes: 'cats' }, likers: [ 'lilly', 'mary' ] },
+         { _id: { likes: 'dogs' }, likers: [ 'lilly', 'bill' ] },
+         { _id: { likes: 'tv' }, likers: [ 'bob' ] },
+         { _id: { likes: 'games' }, likers: [ 'bob', 'bill' ] },
+         { _id: { likes: 'movies' }, likers: [ 'mary', 'bill' ] }
+         ] */
+
+        cleanup();
+      });
+  });
+});
+
+function cleanup() {
+  Person.remove(function() {
+    mongoose.disconnect();
+  });
+}