orders表的Schema
var OrderSchema = mongoose.Schema({
order_id: {
type: String,
},
uid: {
type: String,
},
trade_no: {
type: String,
},
all_price: {
type: Number,
},
all_num: {
type: Number
}
})
goods表的Schema
var GoodsSchema = mongoose.Schema({
order_id: {
type: String,
},
title: {
type: String,
},
price: {
type: Number,
},
num: {
type: Number
}
})
aggregate聚合管道的使用
OrderModel.aggregate([{
$lookup: {
from : "goods",
localField: "order_id",
foreignField: 'order_id',
as: "items"
}
}], function (err, data) {
if(err) {
console.log(err)
return
}
console.log(data)
})