Sequelize with GraphQL Nested include returns null Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Data science time! April 2019 and salary with experience The Ask Question Wizard is Live!What must I return in a GraphQL Mutation with Sequelize?Sequelize on GraphQL update not return anythingSequelize inside GraphQL doesn't join junction tableGraphQL nested mutation + SequelizeGraphQL and graphql-sequelize-schema-generatorHow to return the result from a raw query (Sequelize) to GraphQLSequelize and Graphql reverse lookupgraphql with sequelize join foreign keyGraphQL/Sequelize : SQL aliasGraphql mutation sequelize not returning data
Why is ArcGIS Pro not symbolizing my entire range of values?
A journey... into the MIND
How is an IPA symbol that lacks a name (e.g. ɲ) called?
Weaponising the Grasp-at-a-Distance spell
Who's this lady in the war room?
How to mute a string and play another at the same time
Raising a bilingual kid. When should we introduce the majority language?
Married in secret, can marital status in passport be changed at a later date?
Compiling and throwing simple dynamic exceptions at runtime for JVM
Are there any AGPL-style licences that require source code modifications to be public?
Lights are flickering on and off after accidentally bumping into light switch
Why does BitLocker not use RSA?
Is there a way to convert Wolfram Language expression to string?
Putting Ant-Man on house arrest
Protagonist's race is hidden - should I reveal it?
Does GDPR cover the collection of data by websites that crawl the web and resell user data
What were wait-states, and why was it only an issue for PCs?
A German immigrant ancestor has a "Registration Affidavit of Alien Enemy" on file. What does that mean exactly?
Is "ein Herz wie das meine" an antiquated or colloquial use of the possesive pronoun?
Why does my GNOME settings mention "Moto C Plus"?
Does traveling In The United States require a passport or can I use my green card if not a US citizen?
Can gravitational waves pass through a black hole?
2 sample t test for sample sizes - 30,000 and 150,000
How to leave only the following strings?
Sequelize with GraphQL Nested include returns null
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)
Data science time! April 2019 and salary with experience
The Ask Question Wizard is Live!What must I return in a GraphQL Mutation with Sequelize?Sequelize on GraphQL update not return anythingSequelize inside GraphQL doesn't join junction tableGraphQL nested mutation + SequelizeGraphQL and graphql-sequelize-schema-generatorHow to return the result from a raw query (Sequelize) to GraphQLSequelize and Graphql reverse lookupgraphql with sequelize join foreign keyGraphQL/Sequelize : SQL aliasGraphql mutation sequelize not returning data
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I have this typedef for Client:
type Client
c_id: ID!
fname: String!
lname: String!
gender: Gender!
birthdate: Date!
date_added: Date!
last_opened: Date!
p_id: Int!
no_of_sessions: Int
sessions: [Session]!
and this one for Session:
type Session
session_id: ID!
session_name: String!
date_of_session: Date!
c_id: Int!
I meant to do a nested include where the sessions returned are based on the client ID and return something like this:
"getClient":
"fname": "Jake",
"lname": "Finn",
"sessions": [
"session_name":"session 1"
,
"session_name":"session 2"
,
]
I've created aliases for the association of each model:
//Client Association
Client.hasMany(models.Session,
as: 'sessions',
foreignKey: 'c_id'
);
//Session Association
Session.belongsTo(models.Client,
as: 'client',
foreignKey: 'c_id',
onDelete: 'CASCADE',
onUpdate: 'CASCADE'
);
And this is my resolver:
getClient: ( c_id ) =>
models.Client.findOne(
raw: true,
include: [
model: models.Session,
as: 'sessions',
attributes: [],
required: false,
where: c_id ,
],
where: c_id
)
But the results come out as:
"getClient":
"fname": "Jake",
"lname": "Finn",
"sessions": null
I want to be able to figure out why the nested include returns null as a result. I'm using sql as my database.
mysql graphql sequelize.js
asked Mar 22 at 13:58
discothequeliondiscothequelion
12
add a comment |
I have this typedef for Client:
type Client
c_id: ID!
fname: String!
lname: String!
gender: Gender!
birthdate: Date!
date_added: Date!
last_opened: Date!
p_id: Int!
no_of_sessions: Int
sessions: [Session]!
and this one for Session:
type Session
session_id: ID!
session_name: String!
date_of_session: Date!
c_id: Int!
I meant to do a nested include where the sessions returned are based on the client ID and return something like this:
"getClient":
"fname": "Jake",
"lname": "Finn",
"sessions": [
"session_name":"session 1"
,
"session_name":"session 2"
,
]
I've created aliases for the association of each model:
//Client Association
Client.hasMany(models.Session,
as: 'sessions',
foreignKey: 'c_id'
);
//Session Association
Session.belongsTo(models.Client,
as: 'client',
foreignKey: 'c_id',
onDelete: 'CASCADE',
onUpdate: 'CASCADE'
);
And this is my resolver:
getClient: ( c_id ) =>
models.Client.findOne(
raw: true,
include: [
model: models.Session,
as: 'sessions',
attributes: [],
required: false,
where: c_id ,
],
where: c_id
)
But the results come out as:
"getClient":
"fname": "Jake",
"lname": "Finn",
"sessions": null
I want to be able to figure out why the nested include returns null as a result. I'm using sql as my database.
mysql graphql sequelize.js
asked Mar 22 at 13:58
discothequeliondiscothequelion
12
add a comment |
I have this typedef for Client:
type Client
c_id: ID!
fname: String!
lname: String!
gender: Gender!
birthdate: Date!
date_added: Date!
last_opened: Date!
p_id: Int!
no_of_sessions: Int
sessions: [Session]!
and this one for Session:
type Session
session_id: ID!
session_name: String!
date_of_session: Date!
c_id: Int!
I meant to do a nested include where the sessions returned are based on the client ID and return something like this:
"getClient":
"fname": "Jake",
"lname": "Finn",
"sessions": [
"session_name":"session 1"
,
"session_name":"session 2"
,
]
I've created aliases for the association of each model:
//Client Association
Client.hasMany(models.Session,
as: 'sessions',
foreignKey: 'c_id'
);
//Session Association
Session.belongsTo(models.Client,
as: 'client',
foreignKey: 'c_id',
onDelete: 'CASCADE',
onUpdate: 'CASCADE'
);
And this is my resolver:
getClient: ( c_id ) =>
models.Client.findOne(
raw: true,
include: [
model: models.Session,
as: 'sessions',
attributes: [],
required: false,
where: c_id ,
],
where: c_id
)
But the results come out as:
"getClient":
"fname": "Jake",
"lname": "Finn",
"sessions": null
I want to be able to figure out why the nested include returns null as a result. I'm using sql as my database.
mysql graphql sequelize.js
asked Mar 22 at 13:58
discothequeliondiscothequelion
12
I have this typedef for Client:
type Client
c_id: ID!
fname: String!
lname: String!
gender: Gender!
birthdate: Date!
date_added: Date!
last_opened: Date!
p_id: Int!
no_of_sessions: Int
sessions: [Session]!
and this one for Session:
type Session
session_id: ID!
session_name: String!
date_of_session: Date!
c_id: Int!
I meant to do a nested include where the sessions returned are based on the client ID and return something like this:
"getClient":
"fname": "Jake",
"lname": "Finn",
"sessions": [
"session_name":"session 1"
,
"session_name":"session 2"
,
]
I've created aliases for the association of each model:
//Client Association
Client.hasMany(models.Session,
as: 'sessions',
foreignKey: 'c_id'
);
//Session Association
Session.belongsTo(models.Client,
as: 'client',
foreignKey: 'c_id',
onDelete: 'CASCADE',
onUpdate: 'CASCADE'
);
And this is my resolver:
getClient: ( c_id ) =>
models.Client.findOne(
raw: true,
include: [
model: models.Session,
as: 'sessions',
attributes: [],
required: false,
where: c_id ,
],
where: c_id
)
But the results come out as:
"getClient":
"fname": "Jake",
"lname": "Finn",
"sessions": null
I want to be able to figure out why the nested include returns null as a result. I'm using sql as my database.
mysql graphql sequelize.js
mysql graphql sequelize.js
asked Mar 22 at 13:58
discothequeliondiscothequelion
12
asked Mar 22 at 13:58
discothequeliondiscothequelion
12
asked Mar 22 at 13:58
discothequeliondiscothequelion
12
asked Mar 22 at 13:58
discothequeliondiscothequelion
12
asked Mar 22 at 13:58
discothequeliondiscothequelion
12
12
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55301245%2fsequelize-with-graphql-nested-include-returns-null%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55301245%2fsequelize-with-graphql-nested-include-returns-null%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
