hey all I m new to back end and I m trying to build a follow Prisma #orm-help

hey all. I’m new to back end and I’m trying to bui...

Filippo Barcellos

03/04/2021, 10:54 PM

hey all. I’m new to back end and I’m trying to build a follow unfollow with prisma and I can’t make it work. my schema

Copy code

model User {
  id         Int     @id @default(autoincrement())
  email      String  @unique
  password   String
  username   String
  bio        String?
  image      String?
  posts      Post[]
  followedBy User[]  @relation("UserFollows")
  following  User[]  @relation("UserFollows")
}

I'm trying to update like this but is not working. I'm pretty sure I messed up somewhere

Copy code

await prisma.user.update({
      where: {
        id: userLogged,
      },
      data: {
        following: {
          id: //user to be followed
        },
      },
    });

Eddy Nguyen

03/04/2021, 10:56 PM

I think this needs a

connect

object in the latest versions of Prisma: https://www.prisma.io/docs/concepts/components/prisma-client/relation-queries#connect-an-existing-record

Copy code

await prisma.user.update({
      where: {
        id: userLogged,
      },
      data: {
        following: {
          connect: { id }
        },
      },
    });

Eddy Nguyen

03/04/2021, 10:58 PM

Are you using TypeScript 🙂 ? It’ll give you type support which would make it easier to figure out the shape of the argument

Filippo Barcellos

03/04/2021, 11:07 PM

No, just plain js 😂

Filippo Barcellos

03/04/2021, 11:08 PM

I tried using the

connect

object but it doesn't find following as a argument in my schema

Eddy Nguyen

03/04/2021, 11:19 PM

That’s odd, I’ve set up a codesandbox here: https://codesandbox.io/s/recursing-sutherland-zirfp ( Using nestjs template b/c I couldn’t find a Node.js TS template - but anyways ) Here’s the schema that is similar to yours: https://codesandbox.io/s/recursing-sutherland-zirfp?file=/prisma/schema.prisma Here’s a file that calls prisma client and generated type looks correct ( No TS error ): https://codesandbox.io/s/recursing-sutherland-zirfp?file=/src/main.ts

Eddy Nguyen

03/04/2021, 11:21 PM

Not sure what would be the problem in your case 🤔 . Here are some things you could try: • Check Prisma version and try bumping to the latest ( v2.18 ) • Run

yarn prisma generate

and try running the query again • Check that the user records exist Otherwise, I’m out of ideas 😅 Hopefully someone else in the channel can help!

Ryan

03/05/2021, 7:46 AM

@Filippo Barcellos 👋 Yes as Eddy mentioned, just a connect is required. Could you share the exact query you’re using and also if the

id

you’re passing to connect exists in the database?

Filippo Barcellos

03/05/2021, 1:17 PM

Thanks Eddy and Ryan. I was messing up with my migrations so it was not a prisma problem. Follow this same schema structure how could I create a query that returns only users that are not follow by me? Thanks again

Ryan

03/05/2021, 1:38 PM

@Filippo Barcellos E.g if you want user’s that do not follow the user with

id

1, you can do the following:

Copy code

await prisma.user.findMany({
      where: { AND: [{ following: { none: { id: 1 } } }, { id: { not: 1 } }] },
})

Filippo Barcellos

03/05/2021, 3:53 PM

@Ryan awesome. Thanks for your help!

💯 1

5 Views

Open in Slack

Previous Next