我有這些“json”文件，我想插入到我的mongodb數(shù)據(jù)庫中。你知道嗎

問題是，它的格式如下：{ "channelType":"TEMPGROUP", ... } # line 1

{ "channelType":"TEMPGROUP", ... } # line 2

因此，它不是將它作為一個文檔插入數(shù)據(jù)庫，而是將每一行作為一個條目插入。最終，數(shù)據(jù)庫中3個“json”文件中的3個文檔變成了數(shù)據(jù)庫中的1189個文檔。你知道嗎

如何將“.json”的全部內(nèi)容插入到一個文檔中？你知道嗎

我的代碼是：replay_url = "http://live.ksmobile.net/live/getreplayvideos?"

userid = 969730808384462848

url2 = replay_url + urllib.parse.urlencode({'userid': userid}) + '&page_size=1000'

raw_replay_data = requests.get(url2).json()

for i in raw_replay_data['data']['video_info']:

url3 = i['msgfile']

raw_message_data = urllib.request.urlopen(url3)

for line in raw_message_data:

json_data = json.loads(line)

messages.insert_one(json_data)

print(json_data)

更新以提供更多回答信息

在消息.插入(json\ U數(shù)據(jù))給出以下錯誤：Traceback (most recent call last):

File "/media/anon/06bcf743-8b4d-409f-addc-520fc4e19299/PycharmProjects/LiveMe/venv1/lib/python3.6/site-packages/pymongo/collection.py", line 633, in _insert

blk.execute(concern, session=session)

File "/media/anon/06bcf743-8b4d-409f-addc-520fc4e19299/PycharmProjects/LiveMe/venv1/lib/python3.6/site-packages/pymongo/bulk.py", line 432, in execute

return self.execute_command(generator, write_concern, session)

File "/media/anon/06bcf743-8b4d-409f-addc-520fc4e19299/PycharmProjects/LiveMe/venv1/lib/python3.6/site-packages/pymongo/bulk.py", line 329, in execute_command

raise BulkWriteError(full_result)

pymongo.errors.BulkWriteError: batch op errors occurred

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "/media/anon/06bcf743-8b4d-409f-addc-520fc4e19299/PycharmProjects/LiveMe/import_messages_dev.py", line 43, in

messages.insert(json_data)

File "/media/anon/06bcf743-8b4d-409f-addc-520fc4e19299/PycharmProjects/LiveMe/venv1/lib/python3.6/site-packages/pymongo/collection.py", line 2941, in insert

check_keys, manipulate, write_concern)

File "/media/anon/06bcf743-8b4d-409f-addc-520fc4e19299/PycharmProjects/LiveMe/venv1/lib/python3.6/site-packages/pymongo/collection.py", line 635, in _insert

_raise_last_error(bwe.details)

File "/media/anon/06bcf743-8b4d-409f-addc-520fc4e19299/PycharmProjects/LiveMe/venv1/lib/python3.6/site-packages/pymongo/helpers.py", line 220, in _raise_last_error

_raise_last_write_error(write_errors)

File "/media/anon/06bcf743-8b4d-409f-addc-520fc4e19299/PycharmProjects/LiveMe/venv1/lib/python3.6/site-packages/pymongo/helpers.py", line 188, in _raise_last_write_error

raise DuplicateKeyError(error.get("errmsg"), 11000, error)

pymongo.errors.DuplicateKeyError: E11000 duplicate key error index: liveme.messages.$_id_ dup key: { : ObjectId('5aa2fc6f5d60126499060949') }

在消息。插入一個(json\ U數(shù)據(jù))給了我這個錯誤：Traceback (most recent call last):

File "/media/anon/06bcf743-8b4d-409f-addc-520fc4e19299/PycharmProjects/LiveMe/import_messages_dev.py", line 43, in

messages.insert_one(json_data)

File "/media/anon/06bcf743-8b4d-409f-addc-520fc4e19299/PycharmProjects/LiveMe/venv1/lib/python3.6/site-packages/pymongo/collection.py", line 676, in insert_one

common.validate_is_document_type("document", document)

File "/media/anon/06bcf743-8b4d-409f-addc-520fc4e19299/PycharmProjects/LiveMe/venv1/lib/python3.6/site-packages/pymongo/common.py", line 434, in validate_is_document_type

"collections.MutableMapping" % (option,))

TypeError: document must be an instance of dict, bson.son.SON, bson.raw_bson.RawBSONDocument, or a type that inherits from collections.MutableMapping

在消息。插入\u多個(json\ U數(shù)據(jù))給了我這個錯誤：Traceback (most recent call last):

File "/media/anon/06bcf743-8b4d-409f-addc-520fc4e19299/PycharmProjects/LiveMe/import_messages_dev.py", line 43, in

messages.insert_many(json_data)

File "/media/anon/06bcf743-8b4d-409f-addc-520fc4e19299/PycharmProjects/LiveMe/venv1/lib/python3.6/site-packages/pymongo/collection.py", line 742, in insert_many

blk.execute(self.write_concern.document, session=session)

File "/media/anon/06bcf743-8b4d-409f-addc-520fc4e19299/PycharmProjects/LiveMe/venv1/lib/python3.6/site-packages/pymongo/bulk.py", line 432, in execute

return self.execute_command(generator, write_concern, session)

File "/media/anon/06bcf743-8b4d-409f-addc-520fc4e19299/PycharmProjects/LiveMe/venv1/lib/python3.6/site-packages/pymongo/bulk.py", line 329, in execute_command

raise BulkWriteError(full_result)

pymongo.errors.BulkWriteError: batch op errors occurred

在消息.插入以及消息。插入\u多個兩者都插入一行并拋出錯誤。你知道嗎

總結

以上是生活随笔為你收集整理的python数据格式化后导入数据库_如何为数据库导入重新格式化这个json？的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。