brickyang / egg-mongo-native Goto Github PK

hi

在使用过程中，我想通过.insert()给数据库插入ISODate类型的数据。

.insert(Time: {ISODate("2018-10-01T00:00:00")})

不知有没有人尝试过插入ISODate的数据类型？

Here is my config
exports.mongo = { client: { host: '127.0.0.1', port: '27017', name: 'test', user: 'root', password: 'root', options: {} } };
and I use it like app.mongo.insertOne('name', '123123');

for my mongoDB
I have a database = test
in the test database i have a collection which named test also

the error is show when i call app.mongo.insertOne('name', '123123');
2018-09-18 15:15:24,693 ERROR 44536 nodejs.TypeError: Cannot read property '_id' of undefined

Is that clear for my issue

DeprecationWarning: collection.count is deprecated, and will be removed in a future version. Use collection.countDocuments or collection.estimatedDocumentCount instead

是否考虑内部替换 count 方法，或者暴露 countDocuments 方法？

controller层测试调用

配置文件代码

但是控制台输出的是undefind(告知我未定义对象？)
请问是哪里出问题了

config.mongo支持URI模式，如：
mongodb://user:password@localhost:27017/myproject
mongodb://localhost:27017,localhost:27018/myproject?replicaSet=foo

@brickyang

需要一个完整的示例

当config.js 配置为

exports.mongo = {
  clients: {
    db1: {
      host: 'host',
      port: 'port',
      name: 'db1',
      user: 'user',
      password: 'password',
      options: {},
    },
    db2: {
      host: 'host',
      port: 'port',
      name: 'db2',
      user: 'user',
      password: 'password',
      options: {},
    },
  },
};

时，app.mongo理应为Map<string, Mongo>，而node_modules中的index.d.ts已经定义为Mongo。导致ts一直无法通过。即使在app的index.d.ts覆盖app.mongo的定义也不生效。

//我app的index.d.ts
declare module 'egg' {
  interface Application {
    mongo: Map<string, MongoDB>;
  }
  interface Context {
    [key: string]: any;
    multipart: () => Promise<any>;
    // mongo部分
    session: ISession|null;
  }
}

findAndModify 是一个特殊且有着无可替代功能的"原子操作"。

依赖环境如下

package.json

"dependencies": {
    "egg": "^2.15.1",
    "egg-mongo-native": "^3.5.0",
    "egg-scripts": "^2.11.0"
  }

配置选项如下

plugin.js

exports.mongo = {
  enable: true,
  package: 'egg-mongo-native',
};


config.default.js
exports.mongo = {
    client: {
      host: 'localhost',
      port: '27017',
      name: 'example',
    },
  };

无法创建 mongo 数据库连接对象，然后导致 find 方法不是函数。调试时，mongo 数据类型为 object 不是 MongoDB 类型。

请问，问题出在哪里了？

在schedule里面调用ctx.service.XXX.getList()， 在getList()里面调用app.mongo.db.collection('tablename')报：TypeError: Cannot read property 'collection' of undefined

由于使用了 ^3.3.0 版本，新版本 release 后 ci 跑测试失败。
配置格式为

  // config.unittest.ts
  config.mongo = {
    client: {
      host: 'xxxxx.com.cn',
      port: '12450',
      name: 'xxxxx',
      user: 'xxxx',
      password: 'pwd',
      options: {},
    },
  };

错误信息为：

MongoError: not authorized on admin to execute command { getParameter: 1, featureCompatibilityVersion: 1 }
      at /node_modules/[email protected]@mongodb-core/lib/connection/pool.js:581:63
      at authenticateStragglers (node_modules/[email protected]@mongodb-core/lib/connection/pool.js:504:16)
      at Connection.messageHandler (node_modules/[email protected]@mongodb-core/lib/connection/pool.js:540:5)
      at emitMessageHandler (node_modules/[email protected]@mongodb-core/lib/connection/connection.js:310:10)
      at Socket.<anonymous> (node_modules/[email protected]@mongodb-core/lib/connection/connection.js:453:17)
      at addChunk (_stream_readable.js:263:12)
      at readableAddChunk (_stream_readable.js:250:11)
      at Socket.Readable.push (_stream_readable.js:208:10)
      at TCP.onread (net.js:607:20)

随后锁定版本为 3.3.0 则恢复正常。
是否新 release 引入了不兼容元素？

exports.mongo = {
enable: true,
package: 'egg-mongo',
};

->

exports.mongo = {
enable: true,
package: 'egg-mongo-native',
};

change_stream不支持吗

按照redeme里安装和配置插件后,找不到find()方法

console.log(app.config.mongo);
输出为空对象
{}

// plugin.js
'use strict';
exports.jwt = {
  enable: true,
  package: 'egg-jwt',
};

exports.mongo = {
  enable: true,
  package: 'egg-mongo-native',
};

//config.default.js
'use strict';

module.exports = appInfo => {
  const config = (exports = {});

  // use for cookie sign key, should change to your own and keep security
  config.keys = appInfo.name + '_117580';

  // add your config here
  config.middleware = [];

  return config;
};

exports.jwt = {
  secret: 'WOAIKEKE1314',
};

exports.mongo = {
  client: {
    host: 'localhost',
    port: '27017',
    name: 'fund',
  },
};

报错

 ERROR 16000 [-/127.0.0.1/-/20ms POST /api/add] nodejs.TypeError: app.mongo.find is not a function
    at MongoDBController.add (D:\html\node\app\controller\mongodb.js:20:40)

lib/mongo.js
Object.keys(options).forEach(key => (uriOp +=${key}=${options[key]}&)); url += uriOp.slice(0, -1);
处理下才正常使用

https://eggjs.org/zh-cn/advanced/plugin.html#%E5%8A%A8%E6%80%81%E5%88%9B%E5%BB%BA%E5%AE%9E%E4%BE%8B

调用方法：
var args = [{ $match: {} },{$group: {_id: "max", max_value: {$max: "$id"}}}]; const [result] = await app.mongo.aggregate("member", {args});

报错信息：
TypeError: Cannot read property '$out' of undefined
at Collection.aggregate (E:\workspace\projects\demo\egg-example\node_modules_mongodb@3.0.4@mongodb\lib\collection.js:2455:66)
at MongoDB.aggregate (E:\workspace\projects\demo\egg-example\node_modules_egg-mongo-native@3.0.0@egg-mongo-native\lib\mongo.js:530:8)

Mongo 4.X 开始支持 跨collection transactions 事务支持.
egg-mongo-native也支持一下呗。

I think, the "findOne" method is very important
but I can't find it,did I miss it?

this is my code and error

I found a bug that for @types/mongodb v0.3.17 that the Condition type has a required field $where, which doesn't make any sense.

I was trying to do a $pull operation on mongodb, but it asks me to add a $where clause inside the $pull, otherwise the ts will throw error and not compiling the code.

And this bug is fixed in v0.3.19, so please update it :)

我只会在koa中require来引入第三方模块，但是没有接触过这种插件类型的第三方模块，请问如何做才能用require使用该模块?

RT