鍍金池/ 問答/數(shù)據(jù)庫/ mongoose嵌套數(shù)組的外鍵關(guān)聯(lián)

mongoose嵌套數(shù)組的外鍵關(guān)聯(lián)

const CommentsSchema = new Schema({
  user: { type: Schema.Types.ObjectId, ref: 'User', require: true },
  article: { type: Schema.Types.ObjectId, ref: 'Article', require: true },
  content: { type: String, require: true },
  created_at: { type: Date, default: Date.now },
  thumbsUp: { type: Number, default: 0 },
  thumbsDown: { type: Number, default: 0 },
  isChecked: { type: Boolean, default: false },
  replies: [{
    user: { type: Schema.Types.ObjectId, ref: 'User', require: true },
    content: { type: String, require: true },
    created_at: { type: Date, default: Date.now },
    thumbsUp: { type: Number, default: 0 }
  }]
})

想要得到

{
    user: {
        
    },
    ...,
    replise: [
        user: {
            
        },
        ...
    ]
}

形式的查詢結(jié)果

請(qǐng)問如何在數(shù)組中關(guān)聯(lián)其他表進(jìn)行查詢

回答
編輯回答
替身
populate('replies.user')

自問自答了,是自己傻逼一直以為populate('replies.user')不起作用是這樣寫不對(duì),后來發(fā)現(xiàn)是數(shù)據(jù)庫字段名沒對(duì)應(yīng)

2018年2月17日 20:16