使用解析器翻页

from flask import Flask, request, jsonify

app = Flask(__name__)

# 模拟数据
data = list(range(100))

@app.route('/data', methods=['GET'])
def get_data():
    page = int(request.args.get('page', 1))
    per_page = int(request.args.get('per_page', 10))
    
    start = (page - 1) * per_page
    end = start + per_page
    
    paginated_data = data[start:end]
    
    return jsonify(paginated_data)

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

def validate_pagination_params(page, per_page):
    if page < 1:
        page = 1
    if per_page < 1:
        per_page = 10
    return page, per_page

@app.route('/data', methods=['GET'])
def get_data():
    page = int(request.args.get('page', 1))
    per_page = int(request.args.get('per_page', 10))
    
    page, per_page = validate_pagination_params(page, per_page)
    
    start = (page - 1) * per_page
    end = start + per_page
    
    paginated_data = data[start:end]
    
    return jsonify(paginated_data)

# 假设使用SQLAlchemy进行数据库操作
from sqlalchemy import create_engine, Table, MetaData

engine = create_engine('sqlite:///example.db')
metadata = MetaData(bind=engine)
data_table = Table('data', metadata, autoload=True)

@app.route('/data', methods=['GET'])
def get_data():
    page = int(request.args.get('page', 1))
    per_page = int(request.args.get('per_page', 10))
    
    query = data_table.select().limit(per_page).offset((page - 1) * per_page)
    result = engine.execute(query)
    
    paginated_data = [row for row in result]
    
    return jsonify(paginated_data)