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 cgsmcmlxxv@gmail.com
 designates 209.85.216.180 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAKrexVJR4GHoSO2N7GoYw6d4URNUXDVJcUF9o0M0iB6JupCoOA@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>
Date: Wed, 18 Jan 2012 12:44:17 +0100
Message-ID: 
 <CAKrexVJx-rt5F-Zn0kCNzFLxKKnuPY_unok-HnTg=FiY4eEF4w@mail.gmail.com>
Subject: Re: get view with a list of keys
From: CGS <cgsmcmlxxv@gmail.com>
To: user@couchdb.apache.org
Content-Type: multipart/alternative; boundary=0023544713d0b95d7f04b6cbf779

--0023544713d0b95d7f04b6cbf779
Content-Type: text/plain; charset=ISO-8859-1

...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 = $.test || {};
> $.extend($.test, {
>         fetch_data_startendkey: function(options) {
>             options = options || {};
>             $.ajax({
>                 type     : "GET",
>                 url      : "
> http://my_domain.domain_type:5984/mydatabase/_design/design_name/_list/list_function_name/view_function_name?startkey=
> "+options.startkey+"&endkey="+options.endkey+"&limit="+options.limit+"&skip="+options.skip+"&descending="+options.descending,
>                 dataType : "json",
>                 async    : false,
>                 global   : false,
>                 data     : {},
>                 error    : options.error,
>                 success  : options.success
>             });
>         }
> });
>
> 2. jQuery callback:
>
> $.test.fetch_data_startendkey({
>             startkey: "my_string",
>             endkey: "my_other_string",
>             limit: mylimit,
>             skip: myoffset,
>             descending: my_descending_boolean,
>             success : function(data, textStatus, headers) {
>                 /* do something with the predefined errors and the
> returned data if no predefined error returned */
>             },
>             error : function(code, error, reason) {
>                 /* do something with the error */
>             }
>         });
>
> 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 the
> 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 that.
> 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:
>>    JSON.stringify({ keys: [ "key1", "key2" ] });
>>
>> Can you give some more information?
>>
>> Thanks,
>>  Marcello
>>
>> 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=["key1",...], you get
>> > &key[]=["key1"]&key[]=... To solve the problem, for example, I transform
>> > the full query in a string and I attach it manually to the web address.
>> 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 double
>> > 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 already
>> >> 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=
>> >> > "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"
>> >> >  and "http%253A%252F%252Fwww.pipo.com"
>> >> >
>> >> >
>> >> > thanks for the help
>> >> > alex
>> >> > --
>> >> > Alexandre Masselot
>> >> >
>> >> > http://alexandre-masselot.blogspot.com/
>> >>
>>
>
>

--0023544713d0b95d7f04b6cbf779--