在Express路由器中使用mongoDB [英] Using mongoDB in Express routers

查看：150 发布时间：2017/10/6 20:31:53 node.js mongodb express npm

本文介绍了在Express路由器中使用mongoDB的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我正在学习如何使用node / express和mongodb，而且我有点混淆连接工作。

I am just learning how to use node/express and mongodb, and I am a little confused about pooling connections works.

我现在的策略是在路由器级别拥有数据库连接，因此每个路由都有自己的连接。我的一条路线的代码如下所示：

My strategy right now is to have the database connections at the router level, so each route has its own connection. My code for one of my routes looks like this:

var express = require('express');
var router = express.Router();

var config = require('../config.json');

var url = config.db.URI;

var MongoClient = require('mongodb').MongoClient
    , assert = require('assert');

var db;

// Connect to database
router.all('*', function(req, res, next) {
    console.log('Connecting to db');
    MongoClient.connect(url, function(err, database) {
        assert.equal(null, err);
        db = database;
    });
    next();
});

// GET admin list page
router.get('/', function(req, res, next) {
    res.render('lists/index');
    var coll = db.collection('lists');
    coll.find().each(function(err, obj) {
        console.log(obj);
    });
    next();
});

router.get('/new', function(req, res, next) {
    res.render('lists/new');
    next();
});

router.all('*', function(req, res, next) {
    console.log('Closing database');
    //db.close();
});

module.exports = router;

我正在测试这个视图与我的数据库的交互方式，包括我的http请求的两个router.all函数。在我看来，任何时候都要求这个路由器中的一个页面，服务器应该连接到数据库，允许相应的http请求函数来访问数据库（在这种情况下只是将其内容打印到控制台），然后在最后关闭它一旦http请求完成。然而，这种情况并非如此。正如你可以看到的，我已经注释掉了db.close函数，因为它抛出一个错误，说发送后不能设置头文件。我认为这意味着我不太明白快速路线管道，事情并不按照我期望的顺序执行。

I am testing how this view interacts with my database with the two router.all functions wrapping my http requests. In my mind, any time a page in this router is requested, the server should connect to the database, allow the corresponding http request function to access the database (in this case just printing its contents to console), then close it at then end once the http request is done. However, this is not the case. As you can see I've commented out the db.close function as it throws an error saying "Can't set headers once they are sent" with it. I assume this means that I don't quite understand the Express route "pipeline" and things are not executing in the order I expect them too.

是否有不同的路由器方法我应该使用？也许路由器？或者我以错误的方式接近这个，我应该把数据库连接到别的地方吗？

Is there a different router method I should be using? Maybe router.use? Or am I approaching this in the wrong way, should I put my database connection somewhere else?

我正在使用这个，作为一个参考，有什么好的做法，只要pooling去，但他们似乎关闭连接？如果我没有关闭连接，我只看到我的mongodb连接数上升了，我不认为是一件好事。只是你必须在连接的数量和长度之间找到平衡？

I am using this as a reference somewhat on what is good practice as far as pooling goes, but they don't seem to close the connection? If I don't close the connection I just see my number of mongodb connections go up and up, which I don't think is a good thing. Is it just that you have to find a balance between the number and length of connections?

在Express路由器中使用mongoDB [英] Using mongoDB in Express routers

问题描述

推荐答案

相关文章

其他开发最新文章

热门教程

热门工具

登录关闭

在Express路由器中使用mongoDB [英] Using mongoDB in Express routers

问题描述

推荐答案

相关文章

其他开发最新文章

热门教程

热门工具

登录 关闭

登录关闭