I have a string like this:
document = '{ time : 14/09/19 16:00:00,
global : { full:190 , defects: 7 , btp: 6 , total: 202 } ,
domains : [ { domain : "A" , full:7 , defects: 2 , btp: 0 , total: 9 },
{ domain : "B" , full:0 , defects: 0 , btp: 0 , total: 0 },
{ domain : "C" , full:6 , defects: 0 , btp: 0 , total: 6 },
{ domain : "D" , full:26 , defects: 0 , btp: 2 , total: 28 },
{ domain : "E" , full:0 , defects: 0 , btp: 0 , total: 0 },
{ domain : "F" , full:4 , defects: 0 , btp: 2 , total: 6 },
{ domain : "G" , full:0 , defects: 0 , btp: 0 , total: 0 },
{ domain : "H" , full:21 , defects: 0 , btp: 1 , total: 22 },
{ domain : "I" , full:32 , defects: 0 , btp: 0 , total: 32 },
] }'
When I try to insert this into a mongoDB collection, I get the following error:
TypeError: 'str' object does not support item assignment
I am clueless about how to convert a string to BSON, in order to execute the insert with it.
I looked in the bson_util module, but no luck.
解决方案
It's not the BSON part that matters here. The MongoDB driver will take care of that. Your job is convert JSON to a valid python data structure:
import json
data = json.loads(document)
collection.insert(data);