Visual Studio中MongoDB数据库未创建及state.db报错问题
数据库未创建
以下为错误报告
state.db is not a function
TypeError: state.db is not a function
at Object.module.exports.get (C:\Users\sainupangad\Desktop\newproject\config\connection.js:28:18)
at Object.addProduct (C:\Users\sainupangad\Desktop\newproject\helpers\product-helpers.js:8:12)
at C:\Users\sainupangad\Desktop\newproject\routes\admin.js:51:17
at Layer.handle [as handle_request] (C:\Users\sainupangad\Desktop\newproject\node_modules\express\lib\router\layer.js:95:5)
at next (C:\Users\sainupangad\Desktop\newproject\node_modules\express\lib\router\route.js:137:13)
at Route.dispatch (C:\Users\sainupangad\Desktop\newproject\node_modules\express\lib\router\route.js:112:3)
at Layer.handle [as handle_request] (C:\Users\sainupangad\Desktop\newproject\node_modules\express\lib\router\layer.js:95:5)
at C:\Users\sainupangad\Desktop\newproject\node_modules\express\lib\router\index.js:281:22
at Function.process_params (C:\Users\sainupangad\Desktop\newproject\node_modules\express\lib\router\index.js:335:12)
at next (C:\Users\sainupangad\Desktop\newproject\node_modules\express\lib\router\index.js:275:10)
以下为我的代码
var MongoClient = require('mongodb').MongoClient; const state = { db: null } module.exports.connect = function (done) { const url = 'mongodb://localhost:27017' const dbname = 'shoping' MongoClient.connect(url, (err, data) => { if (err) return done(err) state.db = data.db(dbname) done() }) } module.exports.get = function () { return state.db() }
- 赋值逻辑:
connect方法内执行state.db = data.db(dbname)时,拿到的已经是MongoDB的数据库连接实例,是一个普通对象,不是可调用的函数。 - 取数逻辑:
get方法中写了return state.db(),额外把已经初始化好的db实例当函数执行,直接触发state.db is not a function的类型错误。 - 版本兼容:当前安装的MongoDB驱动如果是v3.0+版本,
MongoClient.connect的回调返回值是MongoClient客户端实例,不是旧版可直接调用.db()的data对象,原有连接逻辑也会获取不到正确的db实例。
- 删除
get方法中对state.db的多余调用括号,直接返回实例本身 - 适配新版MongoClient的回调返回值,从客户端实例上获取目标数据库连接
- 启动应用时必须先执行
connect方法完成数据库初始化,避免路由触发时state.db仍为null
修复后的完整连接代码:
var MongoClient = require('mongodb').MongoClient; const state = { db: null } module.exports.connect = function (done) { const url = 'mongodb://localhost:27017' const dbname = 'shoping' MongoClient.connect(url, (err, client) => { if (err) return done(err) state.db = client.db(dbname) done() }) } module.exports.get = function () { return state.db }
内容的提问来源于stack exchange,提问作者sainupangad

