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: