Planetscale pushing to an Array with Prisma?

So apparently you can't push items to array in mySQL? docs

const userId = ctx.userId
const status = await ctx.prisma.post.update({
        where: {
          id: input.postId,
        },
        data: {
          likedBy: {
            push: userId
          },
        },

const userId = ctx.userId
const status = await ctx.prisma.post.update({
        where: {
          id: input.postId,
        },
        data: {
          likedBy: {
            push: userId
          },
        },

This does not work. Any ideas?

Solution

Glad you figured that out,
For anyone stumbling across this, here is the relevant Prisma docs: https://www.prisma.io/docs/concepts/components/prisma-client/relation-queries#connect-an-existing-record
Feel free to mark one of these as the solution

Prisma

Relation queries (Concepts)

Prisma Client provides convenient queries for working with relations, such as a fluent API, nested writes (transactions), nested reads and relation filters.

Jump to solution

KingKoraiOP•4/17/23, 6:58 PM

I figured it out

It was very hard to find, prisma docs could be better

Solution

Sinverted•4/17/23, 7:04 PM

Prisma

Relation queries (Concepts)

Prisma Client provides convenient queries for working with relations, such as a fluent API, nested writes (transactions), nested reads and relation filters.