如何用pymsql存储API中的JSON？Chatbot Dialogflow与python

Question

我有点问题。我用python和mysql制作chatbot dialogflow。聊天机器人必须连接到mysql。我的数据库中有两个表，inbox和outbox。表inbox包含用户输入，表outbox包含来自API的响应（比如omdbapi.com）。如何使用pymsql for chatbot存储来自dialoglow的用户输入和来自API的json数据？这是密码。代码正常，但缺少与数据库的连接。如果你能帮我完成任务，我将不胜感激。谢谢

from flask import Flask, request, jsonify
import os
import dialogflow
import requests
import json
from db_con import *

app = Flask(__name__)

if __name__ == "__main__":
    app.run()

@app.route('/get_movie_detail', methods=['POST'])
def get_movie_detail():
        data = request.get_json(silent=True)
        movie = data['queryResult']['parameters']['movie']
        api_key = os.getenv('OMDB_API_KEY')
        movie_detail = requests.get('http://www.omdbapi.com/?t={0}&apikey={1}'.format(movie, api_key)).content
        movie_detail = json.loads(movie_detail)
        response =  """
            Title : {0}
            Released: {1}
            Actors: {2}
            Plot: {3}
            Runtime: {4}
            Genre: {5}
        """.format(movie_detail['Title'], movie_detail['Released'], movie_detail['Actors'], movie_detail['Plot'], movie_detail['Runtime'], movie_detail['Genre'])

        reply = {
            "fulfillmentText": response,
        }
        return jsonify(reply)