aggregate.js
2.87 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
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();
});
}