如何从数据库中获取大量数据，并在一次请求中通过http进行传输？

from flask import Flask, jsonify, request
import mysql.connector

app = Flask(__name__)

@app.route('/get_data', methods=['GET'])
def get_data():
    page = request.args.get('page', default=1, type=int)
    page_size = request.args.get('page_size', default=100, type=int)
    offset = (page - 1) * page_size

    # 连接数据库
    connection = mysql.connector.connect(
        host='localhost',
        user='username',
        password='password',
        database='database_name'
    )
    cursor = connection.cursor()

    # 查询数据
    query = "SELECT * FROM table_name LIMIT %s OFFSET %s"
    cursor.execute(query, (page_size, offset))
    data = cursor.fetchall()

    # 关闭数据库连接
    cursor.close()
    connection.close()

    # 转换数据为JSON格式并返回
    return jsonify({'data': data})

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