From mongodb docs You can $project the results to exclude the _id – is this what you mean? http://docs.mongodb.org/manual/reference/aggregation/#pipeline Note The _id field is always included by default. You may explicitly exclude _id as follows: db.article.aggregate( { $project : { _id : 0 , title : 1 , author : 1 }} ); From you’re … Read more
You just need to store an instance of datetime.datetime. Inserting from the python shell: >>> c.test.test.insert({‘date’: datetime.datetime.utcnow()}) ObjectId(‘4e8b388367d5bd2de0000000′) >>> c.test.test.find_one() {u’date’: datetime.datetime(2011, 10, 4, 16, 46, 59, 786000), u’_id’: ObjectId(‘4e8b388367d5bd2de0000000’)} Querying in the mongo shell: > db.test.findOne() { “_id” : ObjectId(“4e8b388367d5bd2de0000000”), “date” : ISODate(“2011-10-04T16:46:59.786Z”) }
It’s actually as simple as len(list(cursor)) Note that it will however consume the cursor.
Please try something like this: client = MongoClient(“mongodb://user_name:user_password@SERVER_IP/prod-db”) db = client[‘prod-db’]
You have to make the distinct call on the cursor returned from a find instead of on the collection: tags = db.mycoll.find({“category”: “movie”}).distinct(“tags”)
As specified in this question, indexed access will ignore the limit. And count() does not obey limit or skip by default as explained the manual. You can pass with_limit_and_skip=True to make count() work with limit. print db_data.count(with_limit_and_skip=True) Or you can iterate the cursor to see limit in effect. for data in db.myusers.find().limit(2): print data
db.users.deleteMany({‘_id’:{‘$in’:inactive_users}})
This is because you didn’t specify any update operator. For example to $set the id value use: db.collection.update_one({“_id”:”key1″}, {“$set”: {“id”:”key1″}}, upsert=True) Note that in the Mongo shell, this will simply replace the document with the new document.
EDIT: While this was true in 2014, modern versions of pymongo and MongoDB have changed this behaviour. Buyer beware: .count() is the correct way to find the number of results that are returned in the query. The count() method does not exhaust the iterator for your cursor, so you can safely do a .count() check … Read more
Dates are stored in their timestamp format. If you want everything that belongs to a specific month, query for the start and the end of the month. var start = new Date(2010, 11, 1); var end = new Date(2010, 11, 30); db.posts.find({created_on: {$gte: start, $lt: end}}); //taken from http://cookbook.mongodb.org/patterns/date_range/