Got a bit of noob question I m running mutations that add ne Prisma #orm-help

Got a bit of noob question: I'm running mutations ...

rem

01/21/2019, 4:57 PM

Got a bit of noob question: I'm running mutations that add nested data via

{ create: { ... }

{ connect: { ... } }

and I can see the records in my postgres database (in the tables starting with _), but when I query across data relations, it never comes back - nothing more complicated than this example: https://www.prisma.io/docs/prisma-graphql-api/reference/queries-qwe1/#querying-data-across-relations

marcus

01/21/2019, 5:04 PM

No nothing needs to be enabled specifically. Can you share an example?

rem

01/21/2019, 5:05 PM

I'll get some gists together - one sec

rem

01/21/2019, 5:08 PM

This is (sort of/mostly) the source I'm using https://gist.github.com/remy/f7c253cf48b42937db684d33722f5bb0

rem

01/21/2019, 5:09 PM

The mutation on createUser works fine, and the resolver runs, and when I check the raw postgres database, I can see the records for

user

and

accountSubscription

and

_AccountSubscriptionToUser

rem

01/21/2019, 5:10 PM

but when I try to query it out, via the playground, if I ask for the

accountSubscription

, it just gives me that error (that it's null) - like prisma hasn't resolved the nested data.

rem

01/21/2019, 5:21 PM

Manually query gets me the data too, but I'm not sure how Prisma does this internally:

select A.state from backend$dev."User" as U, backend$dev."_AccountSubscriptionToUser" as AU, backend$dev."AccountSubscription" as A where AU."B"=U.id and U.id='cjr6jbaro00060718tpo1gp86' and AU."A"=A.id;

rem

01/21/2019, 5:22 PM

That query returns the joined row.

rem

01/21/2019, 5:47 PM

To add to this, I have a custom resolver for the

query { user }

request:

module.exports = (parent, { id }, ctx) => ctx.prisma.user({ id });

Harshit

01/22/2019, 8:59 AM

Are you resolving the accountSubscription on User?

rem

01/22/2019, 11:21 AM

I'm having to in code, yes. If I don't include a resolver for the

accountSubscription

then it Prisma doesn't do it for me.

Harshit

01/22/2019, 11:22 AM

Yes right now, you have to resolve in the fields. We are going to solve this problem soon with updates to the client

rem

01/22/2019, 12:03 PM

sounds good, cheers.

2 Views

Open in Slack

Previous Next