实现接口，获取服务器上位于docker中的Mysql数据

1. 服务器

from flask import Flask, request, jsonify
import pymysql

app = Flask(__name__)

# 配置数据库连接信息
db_config = {
    'host': '', # mysql容器的IP地址
    'port': 3306, # mysql容器的端口（不是映射到服务器主机的端口！）
    'user': 'root', 
    'password': '123456',
    'database': 'ClickShield', # 数据库名字
}


# 创建数据库连接
def get_db_connection():
    connection = pymysql.connect(
        host=db_config['host'],
        port=db_config['port'],
        user=db_config['user'],
        password=db_config['password'],
        database=db_config['database'],
        cursorclass=pymysql.cursors.DictCursor
    )
    return connection


@app.route('/xxx/<string:infor>', methods=['GET'])  
def get_fingerprint(package_name):
    try:
        connection = get_db_connection()
        if connection is None:
            print("无法连接到数据库")
            return jsonify({"error": "无法连接到数据库"}), 500
        with connection.cursor() as cursor:
            # 查询 appID
            cursor.execute("SELECT * FROM data WHERE xx = %s", (infor,))  ##一定注意！当数据表data中xx是int类型是，要改成SELECT * FROM data WHERE xx = '%s'   单引号！！！
            app = cursor.fetchone()

            if not app:
                return jsonify({"error": "Package name not found"}), 404
            return jsonify({
                "w1": data['word1'],
                "w2": data['word2']
            })

    except Exception as e:
        return jsonify({"error": str(e)}), 500

    finally:
        connection.close()


if __name__ == '__main__':
    app.run(host='服务器IP地址', port=自定义)

2. 本地客户端

import json
import requests

res = requests.get("http://服务器IP地址:自定义的端口/xxx/要携带的infor信息")
print(res.text)