将外键作为混合类型将一个字段从一个集合复制到mongodb中的另一个字段 [英] Copy a field from one collection to another in mongodb with foreign key as mixed type
问题描述
Although i have found a similar question on stackOverFlow MongoDB copy a field to another collection with a foreign key
我想将字段name从userdetails集合复制到user集合，其中userDetails中的userId等于user中的_id.
I want to copy a field name from userdetails collection to user collection where userId in userDetails equals _id in user.
用户集合
{
"_id" : ObjectId("5b97743bbff66e0be66283cc"),
"username" : "mmi_superadmin",
"accId" : "acc1"
}
{
"_id" : "c21d580ea3ca5c7a1664bd5feb57f0c8",
"username" : "client",
"accId" : "acc1"
}
userDetail 集合
{
"_id" : ObjectId("5b97743bbff66e0be66283cd"),
"userId" : "5b97743bbff66e0be66283cc",
"name" : "mmi_superadmin"
}
{
"_id" : "5bab8a60ef86bf90f1795c44",
"userId" : "c21d580ea3ca5c7a1664bd5feb57f0c8",
"name" : "RAHUL KUMAR TIWARI"
}
这是我的查询:
db.userDetails.find().forEach(
function(x) {
db.user.update( {_id :x.userId}, {$set: {name:x.name}});
}
);
此查询部分有效.它仅更新_id为字符串类型的user文档. _id为ObjectId的用户文档不会更新.
This query is partially working. It only updates user documents where _id is of type string. User document with _id as ObjectId are not getting updated.
推荐答案
请检查您的文档_id(因为在您的示例中某些_id不是有效的文档_id，例如c21d580ea3ca5c7a1664bd5feb57f0c8不是mongo _id)，并使用以下查询:
Please check your documents _id's (because in your example some _id's is not valid documents _id's. for example c21d580ea3ca5c7a1664bd5feb57f0c8 not a mongo _id) and use this query:
let usersIds = [];
db.user.find({"_id": {$type: 7}}).forEach(doc => {
usersIds.push(doc._id + '')
db.userDetail.find({
userId: {
$in: usersIds
}
}).forEach(doc => {
db.user.update(
{
"_id": ObjectId(doc.userId)
},
{
$set: {
"name": doc.name
}
},
{
multi: false,
upsert: false
}
)
})
})
如果您有任何疑问，请随时提问
if you have any question feel free to ask
这篇关于将外键作为混合类型将一个字段从一个集合复制到mongodb中的另一个字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
