在python flask中使用游标实现postgres查询分页

from flask import Flask, request, jsonify
import psycopg2

app = Flask(__name__)

conn = psycopg2.connect(database="your_database", user="your_username", password="your_password", host="your_host", port="your_port")
cur = conn.cursor()

@app.route('/query', methods=['GET'])
def query_data():
    page = request.args.get('page', default=1, type=int)  # 获取页码，默认为1
    per_page = request.args.get('per_page', default=10, type=int)  # 获取每页显示的记录数，默认为10

    offset = (page - 1) * per_page  # 计算偏移量

    cur.execute("SELECT * FROM your_table OFFSET %s LIMIT %s", (offset, per_page))
    rows = cur.fetchall()

    result = []
    for row in rows:
        result.append({
            'column1': row[0],
            'column2': row[1],
            # 添加其他列...
        })

    return jsonify(result)

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