我正在尝试使用python cgi从我的sql查询创建一个json,但是它在我的表中只返回一行,我不确定我做错了什么。这可能与我的list声明有关,但我不确定如何解决这个问题
#!/usr/bin/env python3
import cgi
import cgitb
import sys
import json
import cx_Oracle
cgitb.enable()
fs = cgi.FieldStorage()
with open("../../password.txt", 'r') as pwf:
pw=pwf.read().strip()
imagequery = """
SELECT PLACENAME_ID, COMMENT FROM PLACENAMES
"""
conn = cx_Oracle.connect(dsn="gen", user="7", password=pw)
c = conn.cursor()
c.execute(imagequery)
place_id = []
comment = []
for row in c:
place_id =row[0]
comment = row[1]
result = {}
result['place_id'] = place_id
result['comment'] = comment
sys.stdout.write("Content-Type: application/json")
sys.stdout.write("\n")
sys.stdout.write("\n")
sys.stdout.write(json.dumps(result,indent=1))
sys.stdout.write("\n")
sys.stdout.close()
结果
{
"place_id": 5326,
"comment": "Graveyard"
}
发布于 2018-06-11 02:22:17
从每个条目创建字典,并将其附加到一个数组中。然后,您的JSON将包含一个包含所有数据库条目的数组。
places=[]
for row in c:
place = {}
place['place_id'] = row[0]
place['comment'] = row[1]
places.append(place)
result = {}
result['places'] = places
https://stackoverflow.com/questions/50786175
复制相似问题