Restful Pagination

# Page-based pagination
@app.route('/users')
def list_users():
    page = request.args.get('page', 1, type=int)
    limit = min(request.args.get('limit', 20, type=int), 100)
    offset = (page - 1) * limit

    total = db.count_users()
    total_pages = (total + limit - 1) // limit

    users = db.get_users(limit=limit, offset=offset)

    return jsonify({
        "data": [u.to_dict() for u in users],
        "pagination": {
            "page": page,
            "limit": limit,
            "total": total,
            "total_pages": total_pages,
            "has_next": page < total_pages,
            "has_prev": page > 1
        }
    })

# Cursor-based pagination
@app.route('/orders')
def list_orders():
    cursor = request.args.get('cursor')
    limit = min(request.args.get('limit', 20, type=int), 100)

    if cursor:
        cursor_id = decode_cursor(cursor)
        orders = db.execute(
            "SELECT * FROM orders WHERE id > ? ORDER BY id LIMIT ?",
            [cursor_id, limit + 1]
        )
    else:
        orders = db.execute(
            "SELECT * FROM orders ORDER BY id LIMIT ?",
            [limit + 1]
        )

    has_more = len(orders) > limit
    orders = orders[:limit]
    next_cursor = encode_cursor(orders[-1]['id']) if has_more else None

    return jsonify({
        "data": orders,
        "pagination": {
            "next_cursor": next_cursor,
            "has_more": has_more
        }
    })

app.get('/api/users', (req, res) => {
  const page = parseInt(req.query.page) || 1;
  const limit = Math.min(parseInt(req.query.limit) || 20, 100);
  const offset = (page - 1) * limit;

  const { users, total } = db.getUsers(limit, offset);

  res.json({
    data: users,
    pagination: {
      page,
      limit,
      total,
      totalPages: Math.ceil(total / limit),
      hasNext: page * limit < total,
      hasPrev: page > 1
    }
  });
});