I m wondering how to do a self relation in a proper way usin Prisma #prisma-whats-new

I'm wondering how to do a self relation in a prope...

atito

02/15/2018, 6:25 AM

I'm wondering how to do a self relation in a proper way using prisma. For example making followers/following system. It can be something like that

Copy code

type User {
  id: ID! @unique
  followers: [User!]!
  following: [User!]!
}

But I believe that is not efficient or how prisma will deal with something like that? thanks in advance

andre

02/15/2018, 8:53 AM

You are on the right track! 🙂 I would add relation names though:

Copy code

followers: [User!]! @relation(name: "UserFollowers")
  follows: [User!]! @relation(name: "UserFollows")

and you have to update to

prisma@beta

. There was a problem with self-relations: https://github.com/graphcool/prisma/issues/1609

andre

02/15/2018, 8:54 AM

Also, this issue provides an example how the actual

follow

and

unfollow

mutation can look like.

atito

02/15/2018, 5:00 PM

Thanks @andre I'll take a look

andre

02/15/2018, 5:09 PM

Sure thing 🙂 You're welcome.

atito

02/15/2018, 5:42 PM

I tried what you did in the comments but it still doesn't work. what I did .. - add relation names -

npm i -g prisma@beta

and

prisma local upgrade

prisma deploy

Now updateUser follower working but updateUser following not working

atito

02/15/2018, 5:43 PM

prisma version

prisma/1.3.0-beta.1 (darwin-x64) node-v8.4.0

prisma vluster list

Copy code

name        version     endpoint
──────────  ──────────  ─────────────────────────────
local       1.3-beta-9  <http://localhost:4466/cluster>
prisma-eu1  1.2.3       <https://eu1.prisma.sh/cluster>
prisma-us1  1.2.3       <https://us1.prisma.sh/cluster>

and I'm using local cluster

andre

02/15/2018, 5:44 PM

Do you get an error message?

atito

02/15/2018, 8:46 PM

Yes, Internal server error with request id

atito

02/15/2018, 9:07 PM

It works fine now Here's what I did. - I went to mysql docker containers and checked the tables and for some reasons I don't know the table that represents the relation UserFollowing wasn't exist - Tried to deploy again and that didn't help. - Tried to remove the cluster and init again and didn't help too. - Tried to kill the containers and remove them and deploy again and that didn't help - Finally I changed the service name in

prisma.yml

and that creates everything from scratch and it worked Anyway, thank you very much @andre for following up with me

👍 1

fast parrot 1

3 Views

Open in Slack

Previous Next