summaryrefslogtreecommitdiff
path: root/jstests/group1.js
blob: c4147c0d89a5eb4ac5b5f0797f7494356e628983 (plain)
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
t = db.group1;
t.drop();

t.save( { n : 1 , a : 1 } );
t.save( { n : 2 , a : 1 } );
t.save( { n : 3 , a : 2 } );
t.save( { n : 4 , a : 2 } );
t.save( { n : 5 , a : 2 } );

var p = { key : { a : true } , 
    reduce : function(obj,prev) { prev.count++; },
          initial: { count: 0 }
        };

res = t.group( p );

assert( res.length == 2 , "A" );
assert( res[0].a == 1 , "B" );
assert( res[0].count == 2 , "C" );
assert( res[1].a == 2 , "D" );
assert( res[1].count == 3 , "E" );

assert.eq( res , t.groupcmd( p ) , "ZZ" );

ret = t.groupcmd( { key : {} , reduce : p.reduce , initial : p.initial } );
assert.eq( 1 , ret.length , "ZZ 2" );
assert.eq( 5 , ret[0].count , "ZZ 3" );

ret = t.groupcmd( { key : {} , reduce : function(obj,prev){ prev.sum += obj.n } , initial : { sum : 0 } } );
assert.eq( 1 , ret.length , "ZZ 4" );
assert.eq( 15 , ret[0].sum , "ZZ 5" );

t.drop();

t.save( { "a" : 2 } );
t.save( { "b" : 5 } );
t.save( { "a" : 1 } );
t.save( { "a" : 2 } );

c = {key: {a:1}, cond: {}, initial: {"count": 0}, reduce: function(obj, prev) { prev.count++; } };

assert.eq( t.group( c ) , t.groupcmd( c ) , "ZZZZ" );


t.drop();

t.save( { name : { first : "a" , last : "A" } } );
t.save( { name : { first : "b" , last : "B" } } );
t.save( { name : { first : "a" , last : "A" } } );


p = { key : { 'name.first' : true } , 
      reduce : function(obj,prev) { prev.count++; },
      initial: { count: 0 }
    };

res = t.group( p );
assert.eq( 2 , res.length , "Z1" );
assert.eq( "a" , res[0]['name.first'] , "Z2" )
assert.eq( "b" , res[1]['name.first'] , "Z3" )
assert.eq( 2 , res[0].count , "Z4" )
assert.eq( 1 , res[1].count , "Z5" )