猫鼬填充文档

Mongoose populate documents

本文关键字：文档 填充      更新时间：2023-09-26

我在mongoose中得到了3个数据库模型，看起来像这样:

//profile.js
var ProfileSchema   = new Schema({
    username:    { type: String, required: true },                   
    password:    { type: String, required: true },                   
    matches:    [{ type: Schema.Types.ObjectId, ref: 'Match' }]
});
//match.js
var MatchSchema   = new Schema({ 
    scores:     [{ type: Schema.Types.ObjectId, ref: 'Score',  required: true }],
});
//score.js
var ScoreSchema   = new Schema({
    score:       {type: Number, required: true},
    achivement: [{type: String, required: true}],
});

我尝试用

填充配置文件
Profile.findOne({ _id: mongoose.Types.ObjectId(profile_id) })
            .populate('matches')
            .populate('matches.scores')
            .exec(function(err, profile) {
                if (err) {...}
                if (profile) {
                   console.log(profile);
                }
            });

比赛被填充，但我没有得到比赛的分数来填充。这是不支持在猫鼬或我做错了什么?Populate给了我这个:

{
    user_token: "539b07397c045fc00efc8b84"
    username: "username002"
    sex: 0
    country: "SE"
    friends: []
    -matches: [
        -{
            __v: 1
            _id: "539eddf9eac17bb8185b950c"
            -scores: [
                "539ee1c876f274701e17c068"
                "539ee1c876f274701e17c069"
                "539ee1c876f274701e17c06a"
            ]
        }
    ]
}

但是我想在match数组中填充分数数组。我可以这样做吗?

是的，你是对的。我尝试使用链接填充，我得到相同的输出。

对于您的查询，请使用async.js，然后用下面提到的方法填充。

有关的更多详细信息，请查看此代码片段。这是一个工作，测试，样本代码根据您的查询。为了更好地理解下面的代码和提供的代码片段的链接，请仔细阅读注释的代码。

//Find the profile and populate all matches related to that profile
Profile.findOne({
    _id: mongoose.Types.ObjectId(profile_id)
})
.populate('matches')
.exec(function(err, profile) {
    if (err) throw err;
    //We got the profile and populated matches in Array Form
    if (profile) {
        // Now there are multiple Matches
        // We want to fetch score of each Match
        // for that particular profile
        // For each match related to that profile
        async.forEach(profile.matches, function(match) {
            console.log(match, 'match')
            // For each match related to that profile
            // Populate score achieved by that person
            Match.find({
                _id:match.id
            })
            .populate('scores', 'score')
            .exec(function (err, score) {
                if (err) throw err;
                // here is score of all the matches
                // played by the person whose profile id
                // is passed
                console.log(score);
            })
        })
    }
});

Profile.findOne({ _id: mongoose.Types.ObjectId(profile_id) })
        .populate('matches.scores')
        .exec(function(err, profile) {
            if (err) {...}
            if (profile) {
               console.log(profile);
            }
        });
相关文章：