PouchDB Update Batch

The bulkDocs() method is used to update an array of documents in PouchDB. To update a batch, you have to create an array of documents where, each document contains _id, _rev and the values that you want to update.

We have a database named “Second_Database” stored in PouchDB and contains 3 documents:

 { id: ‘001’,     key: ‘001’,     value: { rev: ‘4-f59034f061004dbca22da61662459a16’ },     doc:      { name: ‘Ajeet’,        age: 23,        Designation: ‘Programmer’,        _id: ‘001’,        _rev: ‘4-f59034f061004dbca22da61662459a16’ } },   { id: ‘002’,     key: ‘002’,     value: { rev: ‘1-0c0628a46e404d90870f4e892dc2d900’ },     doc:      { name: ‘Robert’,        age: 24,        Designation: ‘Teacher’,        _id: ‘002’,        _rev: ‘1-0c0628a46e404d90870f4e892dc2d900’ } },   { id: ‘003’,     key: ‘003’,     value: { rev: ‘1-1dc4fe229a61420db2b657e8fcbbfa7d’ },     doc:      { name: ‘Abdul’,        age: 25,        Designation: ‘Mechanic’,        _id: ‘003’,        _rev: ‘1-1dc4fe229a61420db2b657e8fcbbfa7d’ } } ] 

Let’s update the documents using their respective _id and _rev values:

Change the name and age of all three documents:

 //Requiring the package var PouchDB = require(‘PouchDB’); //Creating the database object var db = new PouchDB(‘Second_Database’); //Preparing the document docs = [{_id : ‘001’, _rev:’4-f59034f061004dbca22da61662459a16′, age : 21, name:  ‘Rahul’, },       {_id : ‘002’, _rev: ‘1-0c0628a46e404d90870f4e892dc2d900’, age : 26, name:  ‘Ryan’, },       {_id : ‘003’, _rev: ‘1-1dc4fe229a61420db2b657e8fcbbfa7d’, age : 19, name: ‘Reema’, }] //Updating the documents in bulk db.bulkDocs(docs, function(err, response) {    if (err) {       return console.log(err);    } else {       console.log(“Documents Updated Successfully”);    } }); 

Save the above code in a file named “Update_Batch2.js” within a folder name “PouchDB_Examples”. Open the command prompt and execute the JavaScript file using node:

Output:

Verification

You can verify that the batch is updated by using node (Read_Batch) command:

 [ { id: ‘001’,     key: ‘001’,     value: { rev: ‘5-f1b552f9901a408e98406c424f368a49’ },     doc:      { age: 21,        name: ‘Rahul’,        _id: ‘001’,        _rev: ‘5-f1b552f9901a408e98406c424f368a49’ } },   { id: ‘002’,     key: ‘002’,     value: { rev: ‘2-4ecc64cd994d4a9cb0e4376cc5636b37’ },     doc:      { age: 26,        name: ‘Ryan’,        _id: ‘002’,        _rev: ‘2-4ecc64cd994d4a9cb0e4376cc5636b37’ } },   { id: ‘003’,     key: ‘003’,     value: { rev: ‘2-01a70d54a8eb4181b17f5f6c9c2a0756’ },     doc:      { age: 19,        name: ‘Reema’,        _id: ‘003’,        _rev: ‘2-01a70d54a8eb4181b17f5f6c9c2a0756’ } } ] 

Update Batch in Remote Database

We can also update an array of documents in a database that is stored remotely on a server (CouchDB). You just have to pass the path to the database in CouchDB, which contains the document that you want to update.

Example

We have a database named “employees” in the CouchDB Server.

There are three documents in “employees” database

You can fetch these documents by using node (Read_Remote_Batch.js) command.

 [ { id: ‘001’,     key: ‘001’,     value: { rev: ‘6-bc6904f9fdcf64e8bc181e7da006db45’ },     doc:      { _id: ‘001’,        _rev: ‘6-bc6904f9fdcf64e8bc181e7da006db45’,        name: ‘Lucky’,        age: 24,        Designation: ‘Teacher’ } },   { id: ‘002’,     key: ‘002’,     value: { rev: ‘1-415437b4fd54d2af100e2eef26e3fad7’ },     doc:      { _id: ‘002’,        _rev: ‘1-415437b4fd54d2af100e2eef26e3fad7’,        name: ‘Raman’,        age: 25,        Designation: ‘Designer’ } },   { id: ‘003’,     key: ‘003’,     value: { rev: ‘1-ab07c37012e837c1654c0d6b9f22a56f’ },     doc:      { _id: ‘003’,        _rev: ‘1-ab07c37012e837c1654c0d6b9f22a56f’,        name: ‘Albert’,        age: 26,        Designation: ‘Engineer’ } } ] 

Now update all the documents name and age of “employees” database stored on CouchDB Server.

 //Requiring the package  var PouchDB = require(‘PouchDB’); //Creating the database object  var db = new PouchDB(‘http://localhost:5984/employees’);  //Preparing the document  docs = [{_id : ‘001’, _rev:’6-bc6904f9fdcf64e8bc181e7da006db45′, age : 20, name: ‘Rani’  },        {_id : ‘002’, _rev: ‘1-415437b4fd54d2af100e2eef26e3fad7’, age : 21,  name: ‘Priya’ },        {_id : ‘003’, _rev: ‘1-ab07c37012e837c1654c0d6b9f22a56f’, age : 22,  name: ‘Kanchan’}] //Inserting Document  db.bulkDocs(docs, function(err, response) {     if (err) {        return console.log(err);     } else {        console.log(+”Documents Updated Successfully”);     }  }); 

Save the above code in a file named “Update_Remote_Batch.js” within a folder name “PouchDB_Examples”. Open the command prompt and execute the JavaScript file using node:

It will update the documents in “employees” database.

Verification

You can verify that the batch is updated by using node (Read_Remote_Batch) command:

 [ { id: ‘001’,     key: ‘001’,     value: { rev: ‘7-7d47e310d011cd29c6cb1f3e6ee90b5e’ },     doc:      { _id: ‘001’,        _rev: ‘7-7d47e310d011cd29c6cb1f3e6ee90b5e’,        age: 20,        name: ‘Rani’ } },   { id: ‘002’,     key: ‘002’,     value: { rev: ‘2-6cfa4cd923a6d6cb2ad6368890b308f5’ },     doc:      { _id: ‘002’,        _rev: ‘2-6cfa4cd923a6d6cb2ad6368890b308f5’,        age: 21,        name: ‘Priya’ } },   { id: ‘003’,     key: ‘003’,     value: { rev: ‘2-f85f7aa70407e7cd2c6984ccd75ed2a2’ },     doc:      { _id: ‘003’,        _rev: ‘2-f85f7aa70407e7cd2c6984ccd75ed2a2’,        age: 22,        name: ‘Kanchan’ } } ] 

Next TopicPouchDB Delete Batch

Pouchdb Update Batch

PouchDB Update Batch

Verification

Update Batch in Remote Database

Example

Verification

Psql commands

What is PowerShell cmdlet

You may also like