egg.js连接和使用Mongodb

Cnpm i egg-momgo-native  --save

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

config.mongo = {
client: {
host:\"127.0.0.1\",
port:\"27017\",
name:\"test\",
user:\"\",
password:\"\",
options:{},
}
}

var result = await this.app.mongo.find(\'users\')

npm i egg-mongoose --save

exports.mongoose = {
  enable: true,
  package: \'egg-mongoose\',
};
//config中配置mongose连接mongodb数据库
Mongodb://eggadmin:123456@localhost:27017 //有用户名密码的情况
exports.mongoose = {
client: {
url: \'mongodb://127.0.0.1/eggxiaomi\',
options: {
useNewUrlParser: true,
},
}
};

module.exports = app => {
const mongoose = app.mongoose;
const Schema = mongoose.Schema;
const OrderSchema = new Schema({
order_id: { type: String },
uid: { type: String },
trade_no: { type: String },
all_price: { type: Number },
all_num: { type: Number },
});
return mongoose.model(\'Order\', OrderSchema,\'order\');  //返回model
}

Let addResult=this.ctx.request.body;
Let  admin=new this.ctx.model.Order(addResult);
admin.save();

await this.ctx.model.Admin.updateOne({\"_id\":id},{
mobile,email,role_id})

Let id=this.ctx.request.query.id;
Let result=await this.ctx.model.Admin.find({\"_id\":id});

await this.ctx.model[model].deleteOne({\"_id\":id}); 

Mongoose 预定义模式修饰符，可以对我们增加的数据进行一些格式
Lowercase uppercase trim 
Set()//建议使用mongoose，增加数据时匹配
Sn:{
Type:string
Trim:true  //是否去掉空格
index:1 //索引
set(parmas){
if(parmas.indexOf(\'http://\')==0){
return \'http://\'+parmas
}
return parmas
}

Required
Max
Min
Enum 枚举类型
Match 增加的数据必须符合match正则
Maxlength 最大值
Minlength 最小值
Name:{
Type:string
Required:true,
Min:0,
Max:150,
Enum:[0,1,2,3], 枚举类型
Match:/sn(.*)/i  //必须sn开头
}
自定义方法
validate:function(desc){
return desc.length>=10;
}

var result=await this.ctx.model.Admin.aggregate([{
$lookup:{
from:\'role\',
localField:\'role_id\',
foreignField:\'_id\',
as:\'role\'
} 
},
{
$match:{\'role_id\':10} 
}
])

db.order.aggregate([
{    
    $project:{ trade_no:1, all_price:1 }
},
{
    $match:{\"all_price\":{$gte:90}}
},
{
    $sort:{\"all_price\":-1}
},
{
    $skip:1
}

])