Prisma•2y ago

is it possible to have a connect clause within a createMany operation?

i need to do a

createMany: { data : { item: connect [ ...

createMany: { data : { item: connect [ ...

as I have many hundreds of thousands of records

RaphaelEtim•7/29/24, 4:08 AM

Hi @toasty

Prisma Client does not support the operation with nested writes, which includes the operation for relations. You can refer to the documentation for more details. Instead, you can modify the payload to pass in the foreign key id directly instead of using . You can take a look at this Github Discussion and this other discussion

GitHub

createMany() & relations : is connect possible? · prisma prisma · D...

Question As stated in the the documentation, it is not possible to CREATE relations with createMany(). The documentation does not state the behaviour for connecting to existing records. The same pa...

GitHub

CreateMany while connecting to many · prisma prisma · Discussion #2...

Question Assuming I have a schema like this (Simplified for explanation): model Post { title String categories Category[] id String @id @default(uuid()) } model Category { name String @unique posts...

Relation queries (Concepts) | Prisma Documentation

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