如何通过mongoose中的用户ID一次选择两个表(文档)值? [英] How to select two table (document) value at a time by user id in mongoose?

问题描述

我正在使用 NodeJs、ExpressJs 和 Mongodb 和 Mongoose.我想通过用户 id 选择两个文档的值.

I am using NodeJs, ExpressJs with Mongodb and Mongoose. I want to select two document's value by user id.

我有三个模型用户、学术和职业.我通过用户模式的 _id 与学术和职业模式建立了关系.我在这些文档中保存了一些值.现在我想通过用户 id 选择学术和职业的文档值.

I have three model User, Academic and Career. I have made a relation with Academic and Career schema by _id of User schema. I have saved some values in these documents. Now i want to select academic and career's document value by user id.

 // user model
    const userSchema = new mongoose.Schema({
        name: {type: String},
        email: {type: String},
    });
    const user = mongoose.model('User', userSchema);

    // academic model
    const academicSchema = new mongoose.Schema({
        academicLevel: {type: String},
        passYear: {type: Number},
        user: {
            type: mongoose.Schema.Types.ObjectId,
            ref: 'User'
        }
    });
    const academic = mongoose.model('Academic', academicSchema);

    // career model
    const careerSchema = new mongoose.Schema({
        jobTitle: {type: String},
        company: {type: String},
        user: {
            type: mongoose.Schema.Types.ObjectId,
            ref: 'User'
        }
    });
    const career = mongoose.model('Career', careerSchema);

文件

// user documents

_id: objectId("5d0df6a4134d4d295ca9f212")
name: "John Doe"
email: "[e-mail]"

_id: objectId("5d0e70a6c87ca528c0a79a0f")
name: "Mark Boucher"
email: "[e-mail]"


// academic documents

_id: objectId("5d60bc7188a8ef3648b8e8cf")
academicLevel: "Master"
passYear: "2018"
user: objectId("5d0e70a6c87ca528c0a79a0f")

_id: objectId("5d60d56f0cf9af32901cb2aa")
academicLevel: "Bachelor"
passYear: "2016"
user: objectId("5d0e70a6c87ca528c0a79a0f")

// career documents

_id: objectId("5d60bc1d88a8ef3648b8e8ce")
jobTitle: "Software Engineer"
company: "Daffodil Software Ltd."
user: objectId("5d0e70a6c87ca528c0a79a0f")

nodejs

router.get('/getInfoById', async (req, res) => {
    const user = await User
    .find(req.query.id)
    .select()

    res.send(user);
})

如何通过用户 ID 从两个文档(学术和职业)中获取值.谢谢.

How to get values from two documents (academic and career) by user id. Thanks.

推荐答案

对于我在文档中阅读的内容，我认为您正在寻找的内容如下:

For what I've read in the docs, I think what you are looking for is something like so:

const career = await Career.find({ user: user._id});
const academics = await Academics.find({ user: user._id});

或者如果您想同时执行两个查询:

Or if you want to execute both queries at the same time:

const careerOperation = Career.find({ user: user._id});
const academicsOperation = Academics.find({ user: user._id});

const [
    career, 
    academics
] = await Promise.all([career.exec(), academics.exec()]);

希望有所帮助！

这篇关于如何通过mongoose中的用户ID一次选择两个表(文档)值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！