Prisma ORM update explicit many to many relations

#javascript #node #mysql

I was struggling to find this in docs. So, when you have explicit many to many relationship, lets say you have post that has multiple tags. And you want to edit that post and pass up new tags or edit/remove existing ones. This is the way to do it:

const response: jobs = await prisma.posts.update({
            data: {
                ...data,
                users: { connect: { id: session.user.id } },
                posts_tags: {
                    deleteMany: {},
                    create: tags.map((tag) => ({
                        tags: { connect: { id: tag } },
                    })),
                },
            },
            where: {
                slug: postSlug,
            },
        });

So first you pass up deleteMany: {}, which will delete all connections between post and tags. Then you are assigning/connecting new ones.

Top comments (5)

Yash Shah • Mar 7 '22

I also did the same thing, If someone finds a better approach then please provide it by comment.

Leandro Ferreira de Jesus • Dec 8 '22

Tnaks a lot bro!

Jesus Guzman • Apr 1 '23

Here is what worked for me

return await ctx.prisma.product.update({
        where: {
          id: input.id,
        },
        data: {
          categories: {
            create: [
              {
                category: {
                  create: {
                    name: input.name,
                  },
                },
              },
            ],
          },
        },
      });