StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POJSON serializing Mongodb
primarykey
Id
19674311
data
AcceptedAnswerId
19674373
AnswerCount
3
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-10-30T05:09:45.743
FavoriteCount
6
LastActivityDate
2018-07-24T12:00:33.410
LastEditDate
2013-10-30T07:17:02.333
LastEditorUserId
482711
OwnerUserId
482711
ParentId
0
PostTypeId
1
Score
16
ViewCount
31678
LastEditorDisplayName
text
Body
I am using the python package pymongo to retrieve data from a mongodb database. <pre><code>>>> r = collection.find() # returns an object of class 'Cursor' </code></pre> Then I convert to a list <pre><code>>>> l = list(r) # returns a 'list' of 'dict' </code></pre> here is what print(l) returns: <pre><code>>>> [{u'date': datetime.datetime(2009, 11, 10, 10, 45), u'_id': 1, u'name': u'name1', u'value': 11},{u'date': datetime.datetime(2013, 11, 10, 10, 45), u'_id': 2, u'name': u'name2', u'value': 22}] </code></pre> Now I need to convert to JSON so that I can manipulate it. <pre><code>>>> json.dumps(l) Traceback (most recent call last): File "<stdin>", line 1, in <module> File "/usr/lib/python2.7/json/__init__.py", line 231, in dumps return _default_encoder.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/lib/python2.7/json/encoder.py", line 178, in default raise TypeError(repr(o) + " is not JSON serializable") TypeError: datetime.datetime(2009, 11, 12, 11, 14) is not JSON serializable </code></pre> I have also tried to follow <a href="http://api.mongodb.org/python/1.7/api/pymongo/json_util.html" rel="noreferrer">http://api.mongodb.org/python/1.7/api/pymongo/json_util.html</a> without success: Edit: the recent version of the link is <a href="http://api.mongodb.org/python/current/api/bson/json_util.html" rel="noreferrer">http://api.mongodb.org/python/current/api/bson/json_util.html</a> <pre><code>>>> json.dumps(l, default=json_util.default) Traceback (most recent call last): File "<stdin>", line 1, in <module> NameError: name 'json_util' is not defined </code></pre> Note: precisely I need to push this result to R using the R package rPython and its function rPython::python.get("l") Side Question: What is the u (u'Date', u'name', etc..) before each field in the list of dict?
Tags
<python><mongodb><pymongo><rpython>
Title
JSON serializing Mongodb
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USRockScience
UserOwnerUserId
1. USRockScience
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POJSON serializing Mongodb
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 POJSON serializing Mongodb
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.