Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
228 views
in Technique[技术] by (71.8m points)

mysql - Node Sequelize relationship on the same level

I'm moving away from writing bare SQL statements in my node application and started using Sequelize. However, anytime I make a relationship between models they always come in nested objects as a result.

is there a way to make my one-to-one relationship appear on the same level on the resultant object.

for example, if I have a User table and User Settings table. I want one object to look like this

{
user_id:100,
name: John Doe,
preference1: true,
preference2: false,
....
}

instead, I get this

{
 user_id:100,
 name: John Doe,
 settings: {
    preference1: true,
    preference2: false,
    ....
 }
}

When I used to write JOIN statements it always appears on the same level which makes it much easier to work with (especially in 1 to one relationship like my example above)

I went through every bit of their documentation I can't seem to find anything related to this.

is there anything I can set in Sequelize to fix this?

thank you in advance!

question from:https://stackoverflow.com/questions/65649113/node-sequelize-relationship-on-the-same-level

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)
Waitting for answers

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...