Is there a way to create or connect a relationship in a single mutation? Example: with a

type Product { name: String!, category: [ProductCategory!]! }

and

type ProductCategory { name: String! @unique }

I’d like to do

mutation { createProduct( data: { name: "New product", category: { createOrConnect: { name: "Category A" } } }) }

and make sure the same mutation works when creating “New Product 2” without checking if “Category A” exists. I’ve tried defining both create and connect but that doesn’t work. Thanks!

This doesn't exist in the Prisma API, there is an

upsert

operation though which does the same thing without a relation. Note that the code snippet you showed also can not work:

mutation {
  createProduct(
    data: {
      name: "New product"
      category: { createOrConnect: { name: "Category A" } }
    }
  )
}

In order to

connect

, you'd need to provide a

unique

property as well (e.g.

id

).

In

ProductCategory

type

name

is unique so this would theoretically work.

I was looking for something similar for making a seeder. Post the link to the FR when you’ve made it and I’ll give it a thumbs up!

I actually found this feature request https://github.com/prisma/prisma/issues/2194 which looks very similar