egg.js java 生产数据_egg学习笔记第三十天：eggjs中使用mongoose实现表关联查询

实现order表与order_item表关联查询

①model下新建order.js文件，键入：

module.exports = app => {

const mongoose = app.mongoose; // 引入建立连接的mongoose

const Schema = mongoose.Schema;

// 数据库表映射

const OrderSchema = new Schema({

order_id: { type: String },

uid: { type: Number },

trade_no: { type: String },

all_price: { type: Number },

all_num: { type: Number }

});

return mongoose.model("Order", OrderSchema, "order");

};

②新建一个router规则：访问/order执行order controller下的index方法。

"use strict";

/**

* @param {Egg.Application} app - egg application

*/

module.exports = app => {

const { router, controller } = app;

router.get("/", controller.home.index);

router.get("/findFood", controller.home.findFood);

router.get("/addFood", controller.home.addFood);

router.get("/editFood", controller.home.editFood);

router.get("/deleteFood", controller.home.deleteFood);

router.get("/order", controller.order.index);

};

③order controller下键入：实现order表与order_item表关联查询，以order_id为纽带，利用aggregate $lookup $match实现表关联及匹配。

"use strict";

const Controller = require("egg").Controller;

class OrderController extends Controller {

async index() {

let { ctx } = this;

// 实现关联查询

// 1.先拿到order表的数据

// let orderResult = await this.ctx.model.Order.find({});

let orderResult = await this.ctx.model.Order.aggregate([

{

$lookup: {

from: "order_item",

localField: "order_id",

foreignField: "order_id",

as: "items"

}

},

{

$match: { all_price: { $gte: 90 } }

}

]);

ctx.body = orderResult;

}

}

module.exports = OrderController;

④访问/order可得关联查询出来的数据。