CouchDB 创建视图
我们的"员工"数据库中有两名员工。
假设雇员1和雇员2:
现在,打开Fauxton并转到所有文档,您将看到一个名为New View的块。
单击新视图并填写必填字段:
现在创建了视图。您可以按照以下命令进行验证并获得查看结果:
使用以下代码将文件创建为" app.js":
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');
});
执行以下代码:
打开本地浏览器: localhost: 3000
列出数据库
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');
});
创建一个文件夹" view",然后在其中创建文件" index.ejs"它,具有以下代码:
现在在" app.js"文件中进行更改:
获取视图结果
单击全部,然后单击API URL复制URL。
现在转到app.js并使用以下内容更改代码:
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');
});
现在启动服务器,您将看到以下结果:
查看文档详细信息
使用以下代码编辑" app.js":
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');
});
输出: