擅长:python、mysql、java
<p>像这样将表转换为JSON,它要求您使用<code>json</code>模块。这是通过在<code>petl</code>模块源代码中查找创建的。在</p>
<pre><code>from bottle import route, request, response, template,run
import petl as etl
import json
@route('/loc')
def abc():
response.headers['Access-Control-Allow-Origin']='*'
response.headers['Content-type']='application/json'
post = request.query.postcode
locationTable = etl.fromcsv('clinic_locations.csv')
abcd = etl.search(locationTable, 'Postcode', post)
abcd = json.JSONEncoder().encode(list(etl.dicts(abcd))) #Here's where the magic happens.
return abcd
</code></pre>
<p>如果您最终使用此答案,请确保您的数据库已过滤掉所有<code><script></code>标记,否则恶意用户可能会将JavaScript插入数据库,并使您的API端点运行任意JavaScript(也称为XSS攻击)。在</p>