How do I turn MongoDB query into a JSON?

Question

for p in db.collection.find({"test_set":"abc"}):     posts.append(p) thejson = json.dumps({'results':posts}) return  HttpResponse(thejson, mimetype="application/javascript") 

In my Django/Python code, I can't return a JSON from a mongo query because of "ObjectID". The error says that "ObjectID" is not serializable.

What do I have to do? A hacky way would be to loop through:

for p in posts:     p['_id'] = "" 

Answer 1

The json module won't work due to things like the ObjectID.

Luckily PyMongo provides json_util which ...

... allow[s] for specialized encoding and decoding of BSON documents into Mongo Extended JSON's Strict mode. This lets you encode / decode BSON documents to JSON even when they use special BSON types.

Answer 2

Here is a simple sample, using pymongo 2.2.1

import os import sys import json import pymongo from bson import BSON from bson import json_util  if __name__ == '__main__':   try:     connection = pymongo.Connection('mongodb://localhost:27017')     database = connection['mongotest']   except:     print('Error: Unable to Connect')     connection = None    if connection is not None:     database["test"].insert({'name': 'foo'})     doc = database["test"].find_one({'name': 'foo'})     return json.dumps(doc, sort_keys=True, indent=4, default=json_util.default)