如何在貓鼬中填充來自其他集合的資料？-有解無憂

我想將 busNumber 從 bus Bus 表填充到行程表。這是巴士模型

const busSchema = new mongoose.Schema(
  {
    busNumber: {
      type: String,
      unique: true,
      required: true,
    },
    seats: {
      type: Number,
    },
  },
  {
    timestamps: true,
  }
);

現在我想在行程表中顯示公交車號而不是 bus._id。我知道如何排除資料，但不知道如何包含來自其他集合的資料。這是我包含巴士模型的路線模型

const routeSchema = new mongoose.Schema({
  location:{
    type: mongoose.Schema.Types.ObjectId,
    ref: 'Location',
    required: true
  },
  duration: {
    type: Number,
    required: true,
  },
  Bus:{
    type: mongoose.Schema.Types.ObjectId,
    ref:"Bus",
    required: true
  },
  date: {
    type:String,
    required: true
  },
},
{
  timestamps: true,
});

這是查詢：

router.get("/trips", async (req, res) => {
  if ((!req.query.departure && !req.query.arrival) || !req.query.date) {
    return res.send({
      error: "Please enter the data to get the trip",
    });
  }
  const { departure, arrival, date } = req.query;

  const locations = await Location.find({
    "departureLocation.name": departure,
    "arrivalLocation.name": arrival,
  });

  const ids = locations.map(location => location._id);
  const routes = await Route.find({
    $and: [{ location: { $in: ids } }, { date }],
  }).select(['-busId', '-location', '-_id', '-createdAt', '-updatedAt', '-__v']);

  return !routes ? res.status(404).send() : res.status(200).send(routes);
});

這是我得到的結果https://i.stack.imgur.com/AwK5N.png

如何使用 populate() 函式從貓鼬中的另一個集合中獲取資料

uj5u.com熱心網友回復：

將此代碼用于您的填充總線鍵

 router.get("/trips", async (req, res) => {
      if ((!req.query.departure && !req.query.arrival) || !req.query.date) {
        return res.send({
          error: "Please enter the data to get the trip",
        });
      }
      const { departure, arrival, date } = req.query;
    
      const locations = await Location.find({
        "departureLocation.name": departure,
        "arrivalLocation.name": arrival,
      });
    
      const ids = locations.map(location => location._id);
      const routes = await Route.find({
        $and: [{ location: { $in: ids } }, { date }],
      }).populate("Bus").select(['-busId', '-location', '-_id', '-createdAt', '-updatedAt', '-__v']);
    
      return !routes ? res.status(404).send() : res.status(200).send(routes);
    });

轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/481697.html

標籤：节点.js mongodb 表示猫鼬猫鼬人口

上一篇：我不能在我的節點專案中使用env檔案變數值

下一篇：返回列表