python - Facebook 将不正确的数据传递给数据库

Question

我需要帮助构建一个应用程序，让我使用 python3 将 facebook 公共(public)数据存储在数据库中，结果来自 Facebook 的所有数据都变成了奇怪的字符串 而不是 python 输出中显示的值

我的代码

host = "https://graph.facebook.com/v3.0"
path = "/me"
params = urllib.parse.urlencode({
"access_token": ACCESS_TOKEN
})

url = "{host}{path}?{params}".format(host = host, path = path, params = 
params)
print(url)
resp = urllib.request.urlopen(url).read()

print(resp)

    params = urllib.parse.urlencode({
"fields": 'name',
"access_token": ACCESS_TOKEN
})
url = "{host}{path}?{params}".format(host = host, path = path, params = 
params)
uName = urllib.request.urlopen(url).read()
pprint.pprint(uName)


params = urllib.parse.urlencode({
"fields": 'id',
"access_token": ACCESS_TOKEN
})
url = "{host}{path}?{params}".format(host = host, path = path, params = 
params)
uId = urllib.request.urlopen(url).read()
pprint.pprint(uId)


cur.execute(""
"
insert into COMPANY(ID, NAME, AGE, ADDRESS, SALARY, STRING) VALUES( % s, % 
s, % s, % s, % s, % s)
""
", (temp_id,uName,age,address,salary,uId,))
conn.commit() conn.close()

Answer 1

请注意，在您的 python 输出中，uName 实际上是二进制数据(b'stuff' 表示二进制)，并且实际上是 JSON。

你需要解码它才能得到文本

uName = uName.decode('utf-8')

然后，如果需要，decode the json .