将数据从mySQL传递到Flask中的接口

from flask import Flask, jsonify
import pymysql

app = Flask(__name__)

# MySQL连接配置
mysql_host = 'localhost'
mysql_port = 3306
mysql_user = 'username'
mysql_password = 'password'
mysql_db = 'database_name'

# 连接到MySQL数据库
conn = pymysql.connect(host=mysql_host, port=mysql_port, user=mysql_user, password=mysql_password, db=mysql_db)

# 定义Flask路由
@app.route('/data', methods=['GET'])
def get_data():
    # 执行SQL查询
    cursor = conn.cursor()
    cursor.execute('SELECT * FROM table_name')
    
    # 获取查询结果
    data = cursor.fetchall()
    
    # 转换数据为JSON格式
    json_data = jsonify(data)
    
    return json_data

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