Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (athena.apache.org: domain of marcello.nuccio@gmail.com
 designates 209.85.216.180 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAKrexVJx-rt5F-Zn0kCNzFLxKKnuPY_unok-HnTg=FiY4eEF4w@mail.gmail.com>
References: 
 <CAFk2N0tgoUide2nfcsKqKkDubs6AiGPeAHM5+nq+nYPAnEiMkg@mail.gmail.com>
	<CAMWZAj=L99namVCmU7w053TnEBRAw9SrpzN3h86QrfEzuBkYOQ@mail.gmail.com>
	<CAKrexV+B8wHiwi5Ae8hZx8m9dw11BzRf-U4fH_Hi=E-teGq_hw@mail.gmail.com>
	<CAMWZAjnPx9XBfb4mg3nL_0LuO_VpKwS+E42gSF36uXyXPLLMJA@mail.gmail.com>
	<CAKrexVJR4GHoSO2N7GoYw6d4URNUXDVJcUF9o0M0iB6JupCoOA@mail.gmail.com>
	<CAKrexVJx-rt5F-Zn0kCNzFLxKKnuPY_unok-HnTg=FiY4eEF4w@mail.gmail.com>
Date: Wed, 18 Jan 2012 12:56:38 +0100
Message-ID: 
 <CAMWZAjnGLu7-iZwbvBoJvUmtkCms6utFpswJE0gWUwB3OO0Qdw@mail.gmail.com>
Subject: Re: get view with a list of keys
From: Marcello Nuccio <marcello.nuccio@gmail.com>
To: user@couchdb.apache.org
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

CGS, I think we are talking of different things.

The original question was: is it possible to make a view request with
a list of keys?

My response was: yes, but you need to use POST, as documented at
http://wiki.apache.org/couchdb/HTTP_view_API#Querying_Options

Your response was: you can use a GET, simply use as many `key[]=3Dkey`
query parameters as needed to send the list of keys.

Then I've asked how do you do that, since:
1. it does not work for me.
2. it's not documented.

Your sample code does a different thing and does not respond to the
original question: is it possible to make a view request with a list
of keys?

Your sample code uses an array as start/end keys, but this is not the
same as asking for a list of keys.

Marcello

2012/1/18 CGS <cgsmcmlxxv@gmail.com>:
> ...and, yes, it is cache-able because if I repeat the request (with the
> exact same parameters), the browser reports "304 Not Modified".
>
> CGS
>
>
>
> On Wed, Jan 18, 2012 at 12:34 PM, CGS <cgsmcmlxxv@gmail.com> wrote:
>
>>
>> Here is an example (I used list function, but it works with pure map
>> function nevertheless):
>>
>> 1. jQuery plugin:
>>
>> $.test =3D $.test || {};
>> $.extend($.test, {
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 fetch_data_startendkey: function(options) {
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 options =3D options || {};
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 $.ajax({
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 type =C2=A0 =C2=
=A0 : "GET",
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 url =C2=A0 =C2=
=A0 =C2=A0: "
>> http://my_domain.domain_type:5984/mydatabase/_design/design_name/_list/l=
ist_function_name/view_function_name?startkey=3D
>> "+options.startkey+"&endkey=3D"+options.endkey+"&limit=3D"+options.limit=
+"&skip=3D"+options.skip+"&descending=3D"+options.descending,
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 dataType : "json=
",
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 async =C2=A0 =C2=
=A0: false,
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 global =C2=A0 : =
false,
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 data =C2=A0 =C2=
=A0 : {},
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 error =C2=A0 =C2=
=A0: options.error,
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 success =C2=A0: =
options.success
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 });
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 }
>> });
>>
>> 2. jQuery callback:
>>
>> $.test.fetch_data_startendkey({
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 startkey: "my_string",
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 endkey: "my_other_string",
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 limit: mylimit,
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 skip: myoffset,
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 descending: my_descending_bool=
ean,
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 success : function(data, textS=
tatus, headers) {
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 /* do something =
with the predefined errors and the
>> returned data if no predefined error returned */
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 },
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 error : function(code, error, =
reason) {
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 /* do something =
with the error */
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 }
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 });
>>
>> where "my_*string" is the list transformed in string (e.g.,
>> "[\""+key1+"\",\""+key2+...+"\"]", whatever method used to get that
>> string), mylimit and myoffset are integers and so on. No manual encoding
>> needed (handled by the browser).
>>
>> 3. The request in log shows no difference from the direct request from t=
he
>> address bar.
>>
>> This works for me without any problem for my CouchDB 1.1.0. I know the
>> method can be improved to be more robust, but I have no time now for tha=
t.
>> Nevertheless, GET method works and it doesn't require manual encoding.
>>
>> CGS
>>
>> PS: I hope I don't have typos and neither I omitted something as I am
>> quite tired now. If I did, please, let me know.
>>
>>
>>
>>
>>
>> On Wed, Jan 18, 2012 at 12:01 PM, Marcello Nuccio <
>> marcello.nuccio@gmail.com> wrote:
>>
>>> I'm not sure to follow...
>>>
>>> 1. are you sure the GET does work? When I try, the key[] parameters are
>>> ignored.
>>>
>>> 2. IMHO the advantage of GET is cache-ability. Building a JSON is quite
>>> easy:
>>> =C2=A0 =C2=A0JSON.stringify({ keys: [ "key1", "key2" ] });
>>>
>>> Can you give some more information?
>>>
>>> Thanks,
>>> =C2=A0Marcello
>>>
>>> 2012/1/18 CGS <cgsmcmlxxv@gmail.com>:
>>> > The problem with POST method is that you need to do the encoding
>>> manually,
>>> > while with GET method instead of &key=3D["key1",...], you get
>>> > &key[]=3D["key1"]&key[]=3D... To solve the problem, for example, I tr=
ansform
>>> > the full query in a string and I attach it manually to the web addres=
s.
>>> In
>>> > that way, the browser takes care of encoding for me and I avoid the
>>> mess. I
>>> > use this method under jQuery AJAX (don't forget to add \" for the dou=
ble
>>> > quota required in the query).
>>> >
>>> > Hope it will help.
>>> >
>>> > CGS
>>> >
>>> >
>>> >
>>> >
>>> >
>>> > On Wed, Jan 18, 2012 at 11:29 AM, Marcello Nuccio <
>>> marcello.nuccio@gmail.com
>>> >> wrote:
>>> >
>>> >> Yes, but you need to do a POST, not a GET:
>>> >>
>>> >> http://wiki.apache.org/couchdb/HTTP_view_API#Querying_Options
>>> >>
>>> >> put the following JSON in the body:
>>> >> {"keys": ["key1", "key2", ...]}
>>> >>
>>> >> Marcello
>>> >>
>>> >> 2012/1/18 Alexandre Masselot <alexandre.masselot@gmail.com>:
>>> >> > Hello,
>>> >> >
>>> >> > I'm using view with a simple map that extract a couple of values (=
we
>>> >> store
>>> >> > millions of web page info in couchdb and I need to access rapidly =
a
>>> md5
>>> >> > field to know whether we should treat a crawled page or if we alre=
ady
>>> >> know
>>> >> > it).
>>> >> >
>>> >> > It's fine to get the view output for one page
>>> >> > http://127.0.0.1:5984/honbot/_design/projections/_view/md5?key=3D
>>> >> > "http%253A%252F%252Fwww.gesunde-maenner.ch%252Fhtml%252F"
>>> >> >
>>> >> >
>>> >> > For saving, we use bulk_docs to save doc per 1000 slices and that
>>> goes
>>> >> much
>>> >> > faster.
>>> >> >
>>> >> > My question is: is it possible to make a view request list above, =
but
>>> >> with
>>> >> > a list of key?
>>> >> > Let's say
>>> >> > "http%253A%252F%252Fwww.gesunde-maenner.ch%252Fhtml%252F"
>>> >> > =C2=A0and "http%253A%252F%252Fwww.pipo.com"
>>> >> >
>>> >> >
>>> >> > thanks for the help
>>> >> > alex
>>> >> > --
>>> >> > Alexandre Masselot
>>> >> >
>>> >> > http://alexandre-masselot.blogspot.com/
>>> >>
>>>
>>
>>