时间戳

首页 > 解决方案 > 使用python将JSON存储在数据库中

python - 使用python将JSON存储在数据库中

问题描述

我在使用非 ASCII 字符将 JSON 存储到数据库时遇到问题。这是我到目前为止所拥有的。我正在使用 python 请求库。

getJSON = requests.get('https://jsonapi.com/jsonfile')
storeDB = requests.post(
                'http://databaseAPI/Database/item', 
                data='{"payload": %s}' % (getJSON.text), 
                headers={'Content-Type': 'application/json'}
            )

但由于我的 JSON 包含非 ASCII 字符，因此出现此错误。我该如何解决？

错误 -

Traceback (most recent call last):
  File "addKonvo.py", line 134, in <module>
    headers={'Content-Type': 'application/json'}
  File "/usr/local/lib/python3.7/site-packages/requests/api.py", line 119, in post
    return request('post', url, data=data, json=json, **kwargs)
  File "/usr/local/lib/python3.7/site-packages/requests/api.py", line 61, in request
    return session.request(method=method, url=url, **kwargs)
  File "/usr/local/lib/python3.7/site-packages/requests/sessions.py", line 530, in request
    resp = self.send(prep, **send_kwargs)
  File "/usr/local/lib/python3.7/site-packages/requests/sessions.py", line 643, in send
    r = adapter.send(request, **kwargs)
  File "/usr/local/lib/python3.7/site-packages/requests/adapters.py", line 449, in send
    timeout=timeout
  File "/usr/local/lib/python3.7/site-packages/urllib3/connectionpool.py", line 672, in urlopen
    chunked=chunked,
  File "/usr/local/lib/python3.7/site-packages/urllib3/connectionpool.py", line 387, in _make_request
    conn.request(method, url, **httplib_request_kw)
  File "/usr/local/Cellar/python/3.7.7/Frameworks/Python.framework/Versions/3.7/lib/python3.7/http/client.py", line 1252, in request
    self._send_request(method, url, body, headers, encode_chunked)
  File "/usr/local/Cellar/python/3.7.7/Frameworks/Python.framework/Versions/3.7/lib/python3.7/http/client.py", line 1297, in _send_request
    body = _encode(body, 'body')
  File "/usr/local/Cellar/python/3.7.7/Frameworks/Python.framework/Versions/3.7/lib/python3.7/http/client.py", line 170, in _encode
    (name.title(), data[err.start:err.end], name)) from None
UnicodeEncodeError: 'latin-1' codec can't encode character '\u20ac' in position 505: Body ('€') is not valid Latin-1. Use body.encode('utf-8') if you want to send it encoded in UTF-8.```

标签： pythonpython-3.xdjango

解决方案

you need to encode the data in UTF-8 format using getJSON.text.encode('utf8')

推荐阅读