错误psycopg2.programmingerror：can can Adapt Type＆＃x27; dict;来自Pokejson

Question

无法插入SQL表中的前100个口袋妖怪来自Pokeapi

import psycopg2
import json
import myutils
import requests
conn=psycopg2.connect(                                                                                                                          
    host='host',database='database',
    user='user',password='password',
    connect_timeout=3)
cur=conn.cursor()
sql='DROP TABLE IF EXISTS pokeapi;'
cur.execute(sql)
conn.commit()
print(sql)
sql = 'CREATE TABLE IF NOT EXISTS pokeapi (id SERIAL,body JSONB);'
cur.execute(sql)
conn.commit()
print(sql)   
for i in range(1,101):
    url='https://pokeapi.co/api/v2/pokemon/%s' % (str(i))                                                                                       
    response = requests.get(url)
    text = response.text
    js = json.loads(text)
    stuff = js.get('forms', None)
    sql='INSERT INTO pokeapi VALUES (%s)'
    cur.execute(sql,(stuff,))
    conn.commit()
    print(sql)

错误

psycopg2.ProgrammingError: can't adapt type 'dict' 

这是我注意到JSON结构的

"species":{"name":"bulbasaur","url":"https://pokeapi.co/api/v2/pokemon-species/1/"}

Answer 1

您必须适应python dict dict to json 在传递时，范围。

from psycopg2.extras import Json

#...
cur.execute(sql,(Json(stuff),))