How can I "undelete" a set of documents in CouchDB?

Posted by radicand on Stack Overflow See other posts from Stack Overflow or by radicand
Published on 2012-06-25T17:22:20Z Indexed on 2012/06/26 3:16 UTC
Read the original article Hit count: 101

Filed under:

couchdb

I have a large set of documents in a CouchDB database that were just accidentally bulk deleted using _deleted:true. I also have a backup for this set of data that includes their last known good revision and metadata. I need to maintain the same _id, so simple restore with a new _id is not an option.

Compaction has not been run and I can access any of these documents via the &rev= url parameter as well as their attachments (which are needed).

What I need to do is "restore" these documents to the revision I have on file. Surprisingly, I have come up empty with any queries on how to achieve this. Tips or hacks appreciated.

Related posts about couchdb

How-to index arrays (tags) in CouchDB using couchdb-lucene

as seen on Stack Overflow - Search for 'Stack Overflow'
The setup: I have a project that is using CouchDB. The documents will have a field called "tags". This "tags" field is an array of strings (e.g., "tags":["tag1","tag2","etc"]). I am using couchdb-lucene as my search provider. The question: What function can be used to get couchdb-lucene to index… >>> More
CouchDB crashes at startup when path to config file has space(s)

as seen on Server Fault - Search for 'Server Fault'
I'm hoping to run CouchDB as a per-user Launch Agent on OS X. I'm using the coucdbx-core folder from the CouchDB Server.app as the base of my CouchDB deployment. I'd like each user to have their own couch instance (on a different port), necessitating separate config files for each instance. The logical… >>> More
How to remove all Couchdb versions in Ubuntu 10.04 (server)? ( after multiple installs )

as seen on Server Fault - Search for 'Server Fault'
Hi all, I have done multiple installs of CouchDB using sudo aptitude install couchdb sudo ap-get install couchdb and more recently based on the instructions found at L http://wiki.apache.org/couchdb/Installing_on_Ubuntu May I know how do I uninstall or remove all the above installations? Best… >>> More
How can I proxy couchDB as a sub-diectory with lighttpd?

as seen on Server Fault - Search for 'Server Fault'
I have a sub-directory on my web server (lighttpd) that I want to point at a CouchDB instance running on the same machine. I tried using mod_proxy but it sends along the whole request, like a proxy should, I know! So: // What happens: Lighttpd: http://localhost/couchdb/some_request | V CouchDB:… >>> More
Map/Reduce on an array of hashes in CouchDB

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello everyone, I am looking for a map/reduce function to calculate the status in a Design Document. Below you can see an example document from my current database. { "_id": "0238f1414f2f95a47266ca43709a6591", "_rev": "22-24a741981b4de71f33cc70c7e5744442", "status": "retrieved image urls"… >>> More

Developer IT