chat-server/qq-imsvr/node_modules/mongoose/examples/aggregate/aggregate.js

// 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) {
    
    // 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();
  });
}