CouchDB Create View

There are two employees in our “employees” database.

Let’s suppose employee1 and employee2:

Now, Open Fauxton and go to all documents where you see a block named New View.

Click on new view and fill the required fields:

View is created now. You can verify it and get view result by follow the following commands:

Create a file as “app.js”, having the following code:

 const express = require(‘express’); const bodyParser = require(‘body-parser’); const path = require(‘path’); const NodeCouchdb = require(‘node-couchdb’); const app = express(); app.set(‘view engine’, ‘ejs’); app.set(‘views’, path.join(__dirname, ‘views’)); app.use (bodyParser.json()); app.use(bodyParser.urlencoded({extended: false})); app.get(‘/’, function(req,res){  res.send(‘Working……..’); }); app.listen(3000, function(){  console.log(‘Server is started om Port 3000’); }); 

Execute the following code:

Open the local browser: localhost:3000

List Databases

 const express = require(‘express’); const bodyParser = require(‘body-parser’); const path = require(‘path’); const NodeCouchdb = require(‘node-couchdb’);  const couch = NodeCouchdb({ auth:{ user: ‘ajeet’ password: ‘12345’ } }); couch.listDatabases().then(function(dbs){ console.log(dbs); });  const app = express(); app.set(‘view engine’, ‘ejs’); app.set(‘views’, path.join(__dirname, ‘views’)); app.use (bodyParser.json()); app.use(bodyParser.urlencoded({extended: false})); app.get(‘/’, function(req,res){  res.send(‘Working……..’); }); app.listen(3000, function(){  console.log(‘Server is started on Port 3000’); }); 

Create a folder “view” and then create a file “index.ejs” within it, having the following code:

Now change in the “app.js” file:

Get View Result

Click on all and then click on API URL to copy the url.

Now go to app.js and change the code with the following:

 const express = require(‘express’); const bodyParser = require(‘body-parser’); const path = require(‘path’); const NodeCouchdb = require(‘node-couchdb’);  const couch = new NodeCouchdb({ auth:{ user:”ajeet”, password:”12345″ } });  const dbName =’employees’; const viewUrl = ‘_design/all_employees/_view/all’;  couch.listDatabases().then(function(dbs){ console.log(dbs); });   const app = express(); app.set(‘view engine’, ‘ejs’); app.set(‘views’, path.join(__dirname, ‘views’)); app.use (bodyParser.json()); app.use(bodyParser.urlencoded({extended: false})); app.get(‘/’, function(req,res){  couch.get(dbName, viewUrl).then( function(data, headers, status){ console.log(data); res.render(‘index’,{ customer:data  }); }, function(err){ res.send(err); }); });  app.listen(3000, function(){  console.log(‘Server is started on Port 3000’); }); 

Now start server and you will see the following result:

To see the documents details

Edit “app.js” with the following code:

 const express = require(‘express’); const bodyParser = require(‘body-parser’); const path = require(‘path’); const NodeCouchdb = require(‘node-couchdb’);  const couch = new NodeCouchdb({ auth:{ user:”ajeet”, password:”12345″ } });  const dbName =’employees’; const viewUrl = ‘_design/all_employees/_view/all’; couch.listDatabases().then(function(dbs){ console.log(dbs); });  const app = express(); app.set(‘view engine’, ‘ejs’); app.set(‘views’, path.join(__dirname, ‘views’)); app.use (bodyParser.json()); app.use(bodyParser.urlencoded({extended: false})); app.get(‘/’, function(req,res){  couch.get(dbName, viewUrl).then( function(data, headers, status){ console.log(data.data.rows); res.render(‘index’,{ customer:data  }); }, function(err){ res.send(err); }); }); app.listen(3000, function(){  console.log(‘Server is started on Port 3000’); }); 

Output:

Next TopicJava CouchDB Connectivity

CouchDB Create View

CouchDB Create View

List Databases

Get View Result

To see the documents details

State variable analysis: Examples with explanation

C++ Deque

You may also like