Sequelize, how structuring return value inside single object

Asked Jul 08 '18 at 09:20

Active Jul 08 '18 at 09:20

Viewed 92 times

Sorry for my bad English. I have used fastify for my javascript framework and Postgresql as my database and sequelize as my ORM. But problem occured when i have multiple models.

This is my Code :

    // Extract Db
    const { student} = this.models
    return student.findById(id, {
        include: [
            { all: true },
        ],
        limit: 1,
    })

The result is :

// Result
{
    id: 1,
    name: "my beastiful name",
    class: "...",
    ...

    // School Object
    school: {
        id: 23,
        name: "My School name",
        ...
    }
}

But what i want is :

// Result
{
    // Student Object
    student: {
        id: 1,
        name: "my beastiful name",
        class: "...",
        ...
    },

    // School Object
    school: {
        id: 23,
        name: "My School name",
        ...
    }
}

Should i use multiple "find" to achive this result.

asked Jul 08 '18 at 09:20

zName

Is your school table separate then student table ? – Priyank Jul 09 '18 at 05:15
y. school table separate with student table. but associated. By the way, school and student table is just an alias or example. – zName Jul 09 '18 at 06:13
In that case you will get the school object in side the student is it okay for you ? – Priyank Jul 09 '18 at 07:25

Sequelize, how structuring return value inside single object

0 Answers0