现实情景说明:
teacher和student是两张表,通过teacherId关联,一对多的关系,为方便显示信息,希望在student表中添加教师姓名,实现方式如下:
首先在student表中增加一列
然后创建student表的游标,通过游标中teacherId在teacher表中查找teacherName,对游标更新并保存。
db.student.update({}, {$set: {teacherName:""}}, {multi: 1})
var studentCursor = db.student.find();
studentCursor.forEach( item => {
var teacherCursor = db.teacher.find( {teacherId: item.teacherId} );
var teacherDocument = teacherCursor.hasNext()? teacherCursor.next() : null
if(teacherDocument){
var teacherName = teacherDocument.teacherName
item.teacherName = teacherName
db.student.save(item);
}
})