Mailing-List: contact couchdb-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: couchdb-user@incubator.apache.org
Received-SPF: pass (athena.apache.org: domain of paul.joseph.davis@gmail.com
 designates 74.125.92.146 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version
         :content-type:content-transfer-encoding:content-disposition
         :references;
        b=mbzmViLREe1fzQyvq0bu6lnDymEKg6CKS07XKqnlJLNZrJ3hpiagr2y5jC1GWGnqvL
         G+H5yiz9bAFp6TmxvAl7dI3Qmix9qLPN0LDiIM0KDD14Rk6MAsktQRHzlF20UFbsIagx
         1JBdLzG49fmA8LVdRzV/tigcNFgLY2nugeunk=
Message-ID: <e2111bbb0810041340h638aeadch26a0a1d0f5be0429@mail.gmail.com>
Date: Sat, 4 Oct 2008 16:40:01 -0400
From: "Paul Davis" <paul.joseph.davis@gmail.com>
To: couchdb-user@incubator.apache.org
Subject: Re: Bulk Delete
In-Reply-To: <9E9A480C-EC26-427F-A00C-340B03F4E48A@me.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <9E9A480C-EC26-427F-A00C-340B03F4E48A@me.com>

You should be able to do that via:

1. Define view that emits id and rev's of bad docs: emit(doc._id, doc._rev)
2. Get list of bad docs from view
3. Use _bulk_docs with the _deleted=true member to delete the docs

See: http://wiki.apache.org/couchdb/HttpDocumentApi

Paul

On Sat, Oct 4, 2008 at 4:28 PM, Niket Patel <nexneo@me.com> wrote:
> Hello,
>
> Due to bug(infinite loop) in application code, I have end up with
> thousands(20K) of documents in just few hours.
> I want to delete all documents with particular attribute value.
> is that possible with single API call?
> or replication is possible with view(subset of documents) so I replicate
> good docs to other db and delete original and replicate again?
>
> Thanks
>