从Flask中的mysql解析json以从记录中获取字段

debugcn 发表于 Dev

Jsumner5

请记住，我是不熟悉烧瓶和Python的人，我感谢任何人提供的任何帮助。我正在寻找访问JSON响应的字段之一（只是该字段而不是整个响应），我应该如何解析响应。下方附有回应图片，谢谢。

这是我的主线

from flask import Flask,render_template,request
from Qhandler import Qhandler
from MakePlayer import MakePlayer
app = Flask(__name__)

@app.route('/createplayer',methods=['GET','POST'] )
def showCreatePlayer():
    if request.method == 'POST':
        MakePlayer(request.form['playername'],request.form['playerteam'],request.form['playerrole'], request.form['playerpos'])
        return "created player: <br>"+request.form['playername']+" "+request.form['playerteam']+" "+request.form['playerrole']+" "+request.form['playerpos']

    return render_template("createPlayer.html")

@app.route('/sucess')
def success():
    return "success"

@app.route('/showplayers')
def showPlayers():
    Q = Qhandler()
    return Q.displayQuery(""" select * from Player""")

if __name__ == '__main__':
    app.run(debug=True)

这是我的查询处理程序

from flask import Flask, jsonify, json
from flaskext.mysql import MySQL

class Qhandler(object):
    #global mysql
    global cursor
    global connection
    global mysql
    # database connection
    app = Flask(__name__)

    mysql = MySQL()
    app.config['MYSQL_DATABASE_USER'] = 'root'
    app.config['MYSQL_DATABASE_PASSWORD'] = 'root'
    app.config['MYSQL_DATABASE_DB'] = 'Optimizer'
    app.config['MYSQL_DATABASE_HOST'] = 'localhost'
    mysql.init_app(app)



    def ins(self,query):
        try:
            connection=mysql.connect()
            cursor = connection.cursor()
            cursor.execute(query)
            connection.commit()

        except:
            print "error running query"

        finally:
            #cursor.close()
            connection.close()

    def displayQuery(self,query):
        try:
            connection = mysql.connect()
            cursor = connection.cursor()
            cursor.execute(query)
            fetchedData = cursor.fetchall()
            fetchedData = jsonify(fetchedData)
            #fetchedData = json.dumps(fetchedData)
            #record = json.loads(fetchedData)
            #print "the resonse is here:"
            return fetchedData

        except:
            print "error running query"

        finally:
            #cursor.close()
            connection.close()

当前的响应是

结果截图

Jsumner5

使用“ fetchedData = json.dumps（fetchedData）”代替“ fetchedData = jsonify（fetchedData）”，然后创建一个json解码器并解析响应，请参阅以下内容：

def displayQuery(self,query):
        try:
            connection = mysql.connect()
            cursor = connection.cursor()
            cursor.execute(query)
            fetchedData = cursor.fetchall()
            fetchedData = json.dumps(fetchedData)
            #create a json decoder
            d = json.JSONDecoder()
            fieldPlayerName = d.decode(fetchedData)
            #parse the json that is returned ( fieldPlayerName[0][1])
            print "should print the field with the player name",fieldPlayerName[0][1]
            return fieldPlayerName[0][1]

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。