如何在特定情况下在 Sequelize 中获取关联元素 [英] How to get associated elements in Sequelize for specific case

问题描述

我有用户、项目和任务的模型

用户和任务具有多对多关联

Projects 和 Tasks 有关联一对多(每个 Project 有很多 Tasks)

接收指定用户的任务时，我想为每个任务获取关联的项目.

任何人都可以帮助找到解决方法.

我的代码如下:

//从数据库接收用户const user = await User.findOne({where: {id: request.userId}})//接收用户相关的任务const 任务 = 等待 user.getTasks(//在这里我尝试添加以下代码，但它不起作用包括:{模型:项目，如:'项目'})response.status(201).json( 任务)

任何帮助将不胜感激

解决方案

我已经解决了问题.下面是正确的代码.

<预><代码>const user = await User.findByPk( request.userId )if(!user) 返回const 任务 = 等待 user.getTasks({ 包括: [{ 模型:项目，如:'项目'}] })

I have models for Users, Projects and Tasks

Users and Tasks has association Many-to-Many

Projects and Tasks has association One-to-Many (each Project has many Tasks)

When receiving Tasks for specified User, I want to get associated Project for each task.

May anybody help to find solution how yo to this.

My code is below:

        // receiving of user from database
        const user = await User.findOne({where: {id: request.userId}})
        
        // receiving of tasks related to user
        const tasks = await user.getTasks(
        
                // here i've tried to add following code, but it does not works
                include: { model: Project, as: 'project' }

        )
        
        response.status(201).json( tasks )

Any help would be thankful

解决方案

I have fixed problem. Correct code below.

        const user = await User.findByPk( request.userId )
        
        if(!user) return
    
        const tasks = await user.getTasks(
            { include: [
                { model: Project, as: 'project' }
            ] }
        )

这篇关于如何在特定情况下在 Sequelize 中获取关联元素的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！