Python Flask REST API MySQL获取光标键和值

from flask import Flask, jsonify
import mysql.connector

app = Flask(__name__)

# MySQL数据库连接配置
config = {
    'user': 'your_username',
    'password': 'your_password',
    'host': 'your_host',
    'database': 'your_database'
}

# 获取光标键和值的API端点
@app.route('/api/cursor', methods=['GET'])
def get_cursor_keys_values():
    try:
        # 连接到MySQL数据库
        conn = mysql.connector.connect(**config)
        cursor = conn.cursor()

        # 执行SQL查询
        cursor.execute("SELECT * FROM your_table")

        # 获取光标键和值
        keys = [desc[0] for desc in cursor.description]
        values = cursor.fetchall()

        # 关闭光标和数据库连接
        cursor.close()
        conn.close()

        # 构造响应数据
        response = {
            'keys': keys,
            'values': values
        }

        return jsonify(response), 200

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

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