can i do a nested `connectOrCreate` from within an...
# orm-helpj
Jaye
10/25/2021, 3:27 PMcan i do a nested
connectOrCreateupsertr
Ryan
10/26/2021, 4:57 AM@Jaye 👋
Could you share your query and models?
j
Jaye
10/26/2021, 12:58 PMi get:
Copy code
Unknown arg `creator` in create.creator for type WorkflowUncheckedCreateInput. Did you mean `createdAt`?Jaye
10/26/2021, 1:24 PMquery:
Copy code
const newData = {
answers,
type: WorkflowType.Historic,
creator: {
connectOrCreate: {
create: {
email: creatorEmail,
},
where: {
email: creatorEmail,
},
},
},
}
const id = deterministicId(newData)
await db.workflow.upsert({
where: {
id,
},
update: newData,
create: {
id,
...newData,
},
}) Copy code
model Workflow {
id String @id @default(cuid())
// ...
createdAt DateTime @default(now())
createdBy String
creator User? @relation(name: "creator", fields: [createdBy], references: [email])
}
model User {
id String @id @default(cuid())
// ...
email String? @unique
createdWorkflows Workflow[] @relation("creator")
}r
Ryan
10/27/2021, 10:45 AMWorks fine for me with the above schema and data:
Copy code
const creatorEmail = 'email'
const newData = {
creator: {
connectOrCreate: {
create: {
email: creatorEmail,
},
where: {
email: creatorEmail,
},
},
},
}
const id = 'some-random-id'
await prisma.workflow.upsert({
where: {
id,
},
update: newData,
create: {
id,
...newData,
},
})215 Views