Question about 'connect' behaviour.

ORM

Hi all!
I had a question about the connect behaviour. all examples show you can use connect via an unique id. However, if I would do the following, will it only go through if the board belongs to the authenticated user.id and otherwise throw a p2025 error?

  const task = await prisma.task.create({
    data: {
      title: body.title,
      description: body.description,
      order: nextOrder,
      column: {
        connect: {
          id: body.columnId,
          board: {
            id: boardId,
            userId: user.id,
          },
        },
      },
    },
  })

  const task = await prisma.task.create({
    data: {
      title: body.title,
      description: body.description,
      order: nextOrder,
      column: {
        connect: {
          id: body.columnId,
          board: {
            id: boardId,
            userId: user.id,
          },
        },
      },
    },
  })

I am trying to figure out if this query is safe, contingent on user.id being the authenticated user.

Prisma•3mo ago•

1 reply

Racusthor

Question about 'connect' behaviour.

ORM

  const task = await prisma.task.create({
    data: {
      title: body.title,
      description: body.description,
      order: nextOrder,
      column: {
        connect: {
          id: body.columnId,
          board: {
            id: boardId,
            userId: user.id,
          },
        },
      },
    },
  })

  const task = await prisma.task.create({
    data: {
      title: body.title,
      description: body.description,
      order: nextOrder,
      column: {
        connect: {
          id: body.columnId,
          board: {
            id: boardId,
            userId: user.id,
          },
        },
      },
    },
  })

I am trying to figure out if this query is safe, contingent on user.id being the authenticated user.

Question about 'connect' behaviour.

Similar Threads

Question about 'connect' behaviour.

Similar Threads

Similar Threads

Similar Threads