您好,我正在处理联机APIOpenAQ,因此我想从OpenAQ获取数据,并将结果存储在我的数据库中(Postgres)。我从OpenAQ读取数据,但无法将数据存储在Postgres中
注意:我在Postgres中直接使用数据库
import openaq
import psycopg2
conn = psycopg2.connect(user="postgres",
password="root",
host="localhost",
database="xyz")
cursor = conn.cursor()
print("Connected")
api = openaq.OpenAQ()
status, resp = api.parameters()
result = resp["results"]
print(result)
for i in range(len(result)):
# print(result[i])
res = json.dumps(result[i])
cursor.execute("INSERT INTO openaq_api_data (openaq) VALUES ('" "data," + res + "')")
错误:
DETAIL: Token "data" is invalid.
CONTEXT: JSON data, line 1: data...
目前没有回答
相关问题 更多 >
编程相关推荐