serialize mongodb query object in django to parse it to template

Question

I want to serialize mogodb object which is returned by django ORM to json so that I can pass it to template directly.

Here is my mongodb document :firm

{
    "_id" : ObjectId("52d983139dbc7913f25c9e05"),
    "type" : "R",
    "users" : [{    "name" : "praveen",
                    "pwd" : "hola",
                    "draft_items" : [
                     {
                         "name" : "DICLOP",
                         "manu" : "RANBAXY",
                     }
             }],


}

I tried this but I only get key not the value :

>>> from bson.json_util import dumps
>>> x = firm.objects.get()
>>> dumps(x)
["id", "name", "type", "users"]

I also tried

    >>> from bson import json_util
    >>> import json

    >>> json.dumps(x,default=json_util.default)

    Traceback (most recent call last):
  File "<console>", line 1, in <module>
  File "/usr/lib/python2.7/json/__init__.py", line 238, in dumps
    **kw).encode(obj)
  File "/usr/lib/python2.7/json/encoder.py", line 201, in encode
    chunks = self.iterencode(o, _one_shot=True)
  File "/usr/lib/python2.7/json/encoder.py", line 264, in iterencode
    return _iterencode(o, 0)
  File "/usr/local/lib/python2.7/dist-packages/pymongo-2.6.3-py2.7-linux-i686.egg/bson/json_util.py", line 220, in default
    raise TypeError("%r is not JSON serializable" % obj)
TypeError: <firm: firm object> is not JSON serializable

use link for your solution. It should help you.

Aks
– Aks

2014-01-20 09:01:19 +00:00
Commented Jan 20, 2014 at 9:01 — Aks
– Aks, Commented Jan 20, 2014 at 9:01

zweite · Accepted Answer · 2017-03-12 15:56:51Z

2

you can use dir() to see obj property. you can use to_json func for serialize mongodb object

>>> x = firm.objects.get(_id=ObjectId("52d983139dbc7913f25c9e05"))
>>> print x.to_json()

edited Mar 12, 2017 at 15:56

answered Mar 12, 2017 at 15:35

zweite

213 bronze badges

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

Comments

Ross · Accepted Answer · 2014-01-20 12:40:53Z

0

You should use to_json either on the queryset or the document eg:

MyDoc.objects().to_json()
myDoc.to_json()

answered Jan 20, 2014 at 12:40

Ross

18.1k2 gold badges59 silver badges76 bronze badges

1 Comment

Praveen Singh Yadav Over a year ago

Thanks for mongoengine. when I try projection like following firm.objects(__raw__={'_id': x}).only('wholesalers'), I get result but when I try firm.objects(__raw__={'_id':x}).only('wholesalers').to_json() it gives a blank dict '[{"wholesalers": [{}]}]'

Collectives™ on Stack Overflow

serialize mongodb query object in django to parse it to template

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related