代码之家 › 专栏 › 技术社区 › rumi

MongoDB嵌套聚合未找到内部集合

mongodb

rumi · 技术社区 · 7 年前

我不熟悉Stack和MongoDB。我根据其他帖子调整了代码,但不知道哪里出错了。我有三个系列。微生物与活动(1到M)和活动与生物活动(1到M)相关。我想以数组的形式展示从微生物到生物活动的鸟巢。

Microbe collection
{"_id": 1, item: "abc", species: 12, quantity: 2},
{"_id": 2, item: "jkl", species: 20, quantity: 1},
{"_id": 3}

Activities collection
{"_id": 1, code: "MON1003", item: "abc", type: "Monitor", repeat: 120, size: "27", resolution: "1920x1080"},
{"_id": 2, code: "MON1012", item: "abc", type: "Monitor", repeat: 85, size: "23", resolution: "1280x800"},
{"_id": 3, code: "MON1031", item: "jkl", type: "Monitor", repeat: 60, size: "21", resolution: "1920x1080"}


Bio-Activities collection
{"_id": 1, code: "MON1003", description: "bio 1", quantity: 120},
{"_id": 2, code: "MON1003", description: "bio 2", quantity: 80},
{"_id": 3, code: "MON1012", description: "bio 3", quantity: 60},
{"_id": 4, code: "MON1012", description: "bio 4", quantity: 70},
{"_id": 5, code: "MON1012", description: "bio 5", quantity: 170},
{"_id": 6, code: "MON1031", description: "bio 6", quantity: 270}

这是我的代码:

db.microbe.aggregate([ 
{ 
$lookup: 
{ 
from: "activities", 
localField: "item", 
foreignField: "item", 
as: "activities" 
} 
},{
$lookup: 
{ 
    from: "bioactivities", 
    localField: "code", 
    foreignField: "code", 
    as: "bioactivities" 
}
},{
    $unwind: "$activities"
},{
$group: {
    _id: "$_id",
    item: {$first: "$item"},
    species: {$first: "$species"},
    quantity: {$first: "$quantity"},
    activities: {$push: {
        id: "$activities._id",
        code: "$activities.code",
        item: "$activities.item",
        type: "$activities.type",
        repeat: "$activities.repeat",               
        size: "$activities.size",
        bioactivities: "$bioactivities"
    }
    }
}
}
]).pretty()

但我得到的输出显示了空的“生物活性”。我哪里出错了?

    {
    "_id" : 2,
    "item" : "jkl",
    "species" : 20,
            "quantity" : 1,
            "activities" : [
                    {
                    "id" : 3,
                    "code" : "MON1031",
                    "item" : "jkl",
                    "type" : "Monitor",
                    "repeat" : 60,
                    "size" : "21",
                    "bioactivities" : [ ]
            }
    ]
    }
    {
            "_id" : 1,
            "item" : "abc",
            "species" : 12,
            "quantity" : 2,
            "activities" : [
            {
                    "id" : 1,
                    "code" : "MON1003",
                    "item" : "abc",
                    "type" : "Monitor",
                    "repeat" : 120,
                    "size" : "27",
                    "bioactivities" : [ ]
            },
            {
                    "id" : 2,
                    "code" : "MON1012",
                    "item" : "abc",
                    "type" : "Monitor",
                    "repeat" : 85,
                    "size" : "23",
                    "bioactivities" : [ ]
            }
    ]
    }

谢谢

2 回复 | 直到 7 年前

Anirudh Bagri 7 年前

我认为你忽略了这个愚蠢的错误。在你的第二个 $lookup , localField 应该是 "activities.code" 这样地,

{
$lookup: 
{ 
    from: "bioactivities", 
    localField: "activities.code", 
    foreignField: "code", 
    as: "bioactivities" 
}
}

这将为您提供如下输出:

{
    "_id" : 2.0,
    "item" : "jkl",
    "species" : 20.0,
    "quantity" : 1.0,
    "activities" : [ 
        {
            "id" : 3.0,
            "code" : "MON1031",
            "item" : "jkl",
            "type" : "Monitor",
            "repeat" : 60.0,
            "size" : "21",
            "bioactivities" : [ 
                {
                    "_id" : 6.0,
                    "code" : "MON1031",
                    "description" : "bio 6",
                    "quantity" : 270.0
                }
            ]
        }
    ]
}

我希望这就是你想要的。

rumi 7 年前

知道了。引用Mongo的视频,“秩序确实重要”。解决方案:在查找“生物活性”之前,我应该先释放我的“活动”。这是代码。

    db.microbe.aggregate([ 
    { 
    $lookup: 
    { 
        from: "activities", 
        localField: "item", 
        foreignField: "item", 
        as: "activities" 
    } 
    },{
        $unwind: "$activities"
    },{
        $lookup: 
    { 
        from: "bioactivities", 
        localField: "activities.code",  
        foreignField: "code", 
        as: "bioactivities" 
    }
    },{
        $group: {
            _id: "$_id",
            item: {$first: "$item"},
            species: {$first: "$species"},
            quantity: {$first: "$quantity"},
            activities: {$push: {
                 id: "$activities._id",
                 code: "$activities.code",
                 item: "$activities.item",
                 type: "$activities.type",
                 repeat: "$activities.repeat",              
                 size: "$activities.size",
                 bioactivities: "$bioactivities"
            }
       }
    }
    }
    ]).pretty()