How to do "connect" updates on many-to-many relations?

[NexZhu]

How to do "connect" updates on many-to-many relations? (in a transactional way)

In the docs, I only find docs for one-to-one and one-to-many relations.

My prisma models:

model Category {
  id        Int                  @id
  createdAt DateTime             @default(now())
  name      String               @unique
  url       String               @unique
  stores    CategoriesOnStores[]
}

model Store {
  id         Int                  @id
  createdAt  DateTime             @default(now())
  name       String
  url        String               @unique
  categories CategoriesOnStores[]
}

model CategoriesOnStores {
  store       Store    @relation(fields: [storeId], references: [id])
  storeId     Int
  category    Category @relation(fields: [categoryId], references: [id])
  categoryId  Int
  createdAt   DateTime @default(now())

  @@id([storeId, categoryId])
}

When I tried the following code to update a Store (similar to the way described in the docs for one-to-many relations):

const data = {
  id,
  name,
  url,
  categories: {
    connect: [{id: c.id}],
  },
}
await prisma.store.upsert({
  where: {id},
  create: data,
  update: data,
})

I got the following error:

Unknown arg `id` in create.categories.connect.0.id for type CategoriesOnStoresWhereUniqueInput. Available args:

type CategoriesOnStoresWhereUniqueInput {
  storeId_categoryId?: StoreIdCategoryIdCompoundUniqueInput
}
Unknown arg `id` in update.categories.connect.0.id for type CategoriesOnStoresWhereUniqueInput. Available args:

type CategoriesOnStoresWhereUniqueInput {
  storeId_categoryId?: StoreIdCategoryIdCompoundUniqueInput
}

So how should I do it, apart from manually inserting to the relation table? Thank you for helping!

[ryands17]

Hey @NexZhu 👋

Your upsert statement needs to omit the id from create and update in the following manner:

const { id, ...upsertData } = data
await prisma.store.upsert({
  where: { id },
  create: upsertData,
  update: upsertData,
})

That should do it!

[NexZhu]

Hey @NexZhu 👋

Your upsert statement needs to omit the id from create and update in the following manner:

const { id, ...upsertData } = data
await prisma.store.upsert({
  where: { id },
  create: upsertData,
  update: upsertData,
})

That should do it!

Actually, I've tried it without the 'id' field, still with no luck:

(node:17256) UnhandledPromiseRejectionWarning: Error: 
Invalid `prisma.store.upsert()` invocation in ...

{
  where: {
    id: 1487882
  },
  create: {
    name: 'AliWuzn HappyOffice Store',
    url: 'https://www.aliexpress.com/store/1487882',
    categories: {
      connect: [
        {
          id: 21
          ~~
        }
      ]
    },
+   id: Int,
?   createdAt?: DateTime
  },
  update: {
    name: 'AliWuzn HappyOffice Store',
    url: 'https://www.aliexpress.com/store/1487882',
    categories: {
      connect: [
        {
          id: 21
          ~~
        }
      ]
    }
  }
}

Unknown arg `id` in create.categories.connect.0.id for type CategoriesOnStoresWhereUniqueInput.
Argument id for create.id is missing.
Unknown arg `id` in update.categories.connect.0.id for type CategoriesOnStoresWhereUniqueInput.

Note: Lines with + are required, lines with ? are optional.

    at Document.validate (\node_modules\@prisma\client\runtime\index.js:1:123114)
    at Object.s [as Store] (\node_modules\@prisma\client\runtime\index.js:1:82643)
    at Object.n.<computed> [as upsert] (\node_modules\@prisma\client\runtime\index.js:1:84025)
    ...

[NexZhu]

And also, I have the following code working OK so I think the problem is not with 'id', but with using "connect" updates on many-to-many relations, IDK if it's possible (or if not what the alternative is).

      const store = {
        id,
        name,
        url,
      }
      await prisma.store.upsert({
        where: {id},
        create: store,
        update: store,
      })