Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of markjreed@gmail.com designates
 74.125.82.54 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type:content-transfer-encoding;
        b=E1DPrSzUxhp/52MaLRnSb4bpBGl4dkuvbX5nRNDEKfwQXETHtYRNLWXCyERXVHRcBJ
         +hQl4J58VLTcLXevZCUUmfCGdfubVJXdRNT4xDYHyXDFOA6RDkRmKTBWqzUlPuv1jDsH
         FtscJBtRo4ZNB0ZeGAP6wiNaIPVqMvtNsnOC8=
MIME-Version: 1.0
In-Reply-To: <75870F91-1092-4F46-991C-AA976D2F712F@gmail.com>
References: <1366718319.20101116140122@surfulater.com>
	<AANLkTi=6KLGdJOQLnDTaYG9bmiUzzsT72Ph=OeoSk_Bk@mail.gmail.com>
	<75870F91-1092-4F46-991C-AA976D2F712F@gmail.com>
Date: Tue, 16 Nov 2010 09:17:58 -0500
Message-ID: <AANLkTikny56m7SaKjNLm8iBG+NipHG9oQY-Gi8DxBvrk@mail.gmail.com>
Subject: Re: Bulk Updates in CouchDB
From: "Mark J. Reed" <markjreed@gmail.com>
To: user@couchdb.apache.org
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

On Tue, Nov 16, 2010 at 8:37 AM, Karel Mina=C5=99=C3=ADk <karel.minarik@gma=
il.com> wrote:
> Hmm, could you explain a bit how it should work? (Because the way I
> understand it, you have to iterate over _all_ the docs and check `if
> doc.value =3D=3D xxx` in the client code? That'd be impossible for large =
data
> sets.)

Given /mydb/_design/mydd with the following (I'm not bothering with
quotation marks, so this isn't copy/pasteable):

views: { foo: { map: function(doc) { emit(doc.value, doc._rev) } } }

Then you fetch this:

/mydb/_design/mydd/_view/foo?key=3D"xxx"

Which will include the doc id's and revisions of all the matching
docs. Then you use that result to build up a request like this:

{ docs:  [ { _id: someid, _rev: itsrev, _deleted: true }, { _id:
someotherid, ...} ] }

Which you then post to /mydb/_bulk_docs, and then all the matching
docs are deleted, with only two HTTP round-trips.

For selective updating, you can use an update handler to modify a
document "in-place" without first fetching and then storing the whole
thing, but then you can't do that in bulk.

--=20
Mark J. Reed <markjreed@gmail.com>