回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我正在制作一个需要返回json的API</p>
<p>下面是我的观点.py</p>
<pre><code>from flask.json import jsonify
from team2_project import app
from team2_project import cursor
import json
from flask import jsonify
@app.route('/')
def index():
sql = ("SELECT * FROM Clients_002")
cursor.execute(sql)
formulas = cursor.fetchall()
return str(formulas)
</code></pre>
<p><strong>init</strong>.py</p>
<pre><code>from flask import Flask
import pymysql
pymysql.install_as_MySQLdb
import pymysql.cursors
app = Flask(__name__)
connection = pymysql.connect(host='',
user='',
password='',
db='',
cursorclass=pymysql.cursors.DictCursor)
cursor = connection.cursor(pymysql.cursors.DictCursor)
import team2_project.views
</code></pre>
<p>我的函数返回:</p>
<pre><code>[{"clientCompID_002": 1, "clientCompName_002": "Telus", "clientCity_002": "Halifax", "clientCompPassword_002": "002", "moneyOwed_002": "100"}, {"clientCompID_002": 2, "clientCompName_002": "Bell", "clientCity_002": "Dartmouth", "clientCompPassword_002": "002", "moneyOwed_002": "10"}, {"clientCompID_002": 3, "clientCompName_002": "Purple Cow", "clientCity_002": "Bedford", "clientCompPassword_002": "002", "moneyOwed_002": "120"}, {"clientCompID_002": 4, "clientCompName_002": "Apple", "clientCity_002": "Toronto", "clientCompPassword_002": "002", "moneyOwed_002": "1210"}, {"clientCompID_002": 5, "clientCompName_002": "Sowo", "clientCity_002": "Montreal", "clientCompPassword_002": "002", "moneyOwed_002": "1110"}]
</code></pre>
<p>如何在json中使用缩进输出它?我尝试了jsonify(),但是它返回与str()相同的结果。似乎无法摆脱方括号</p>
<p>谢谢</p>