how to write mongodb query in python for db.collection.group()

Question

I am working on a MongoDB query

db.BH.group({
"key": {
    "AccountId": true,
},
"initial": {
    "count": 0
},
"reduce": function(obj, prev) {
    if (true != null) if (true instanceof Array) prev.count += true.length;
    else prev.count++;
},
"cond":     
    {"$or":[{"Url":{"$regex":"(google)"}},{"Url":{"$regex":"(facebook)"}}]} 
});

The query is working fine in MongoDB Shell(Robomongo).

I have written the same query for python.

db.BH.group({
"key": {
    "AccountId": True,
},
"initial": {
    "count": 0
},
"reduce": "function(obj, prev) {"
    "if (true != null) if (true instanceof Array) prev.count += true.length;"
    "else prev.count++;"
"}",
"cond": {"$or":[{"Url":{"$regex":"(google)"}},{"Url":{"$regex":"(facebook)"}}]} 
})

But error is coming for the query.

TypeError: group() takes at least 5 arguments (2 given)

I tried to solve the error from the method given in the below website(URL)

http://blog.pythonisito.com/2012/05/aggregation-in-mongodb-part-1.html

But the same error persists.

wdberkeley · Accepted Answer · 2015-03-16 14:36:33Z

1

The syntax of group is different in PyMongo. Each of the keys key, initial, etc. in the argument object in Javascript is a keyword argument in Python:

db.BH.group(key = , initial = , reduce = , cond = )

answered Mar 16, 2015 at 14:36

wdberkeley

11.7k1 gold badge30 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

abhyuday Over a year ago

I corrected the syntax but still getting the error TypeError: group() takes at least 5 arguments (4 given) @wdberkeley

thegreenogre · Accepted Answer · 2015-04-09 09:56:37Z

0

group(key, condition, initial, reduce, finalize=None, **kwargs)

You are missing the last parameter "finalize" for the group operation. Using finalize=None should solve the problem.

db.BH.group({
    {
        "AccountId": True,
    },
    {"$or":[{"Url":{"$regex":"(google)"}},{"Url":{"$regex":"(facebook)"}}]}, 
    {
        "count": 0
    },
    "function(obj, prev) {"
        "if (true != null) if (true instanceof Array) prev.count += true.length;"
        "else prev.count++;"
    "}",
    None
})

answered Apr 9, 2015 at 9:56

thegreenogre

1,57911 silver badges22 bronze badges

Collectives™ on Stack Overflow

how to write mongodb query in python for db.collection.group()

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related