Theo's Typesafe Cult•2y ago

Spot the Prisma relation error?

Hey guys, I'm trying to add a @relation in prisma but I'm forced to create use an array of elements for the model (one to many) and I want a one to one relationship here.

model OrderDetail {
    id        String @id @default(cuid())
    orderId   String
    address   String
    city      String
    country   String
    postalCode String
    phone     String
    createdAt DateTime @default(now())
    updatedAt DateTime @updatedAt
    order     Order   @relation(fields: [orderId], references: [id], onDelete: Cascade)
}

model Order {
    id          String   @id @default(cuid())
    createdAt   DateTime @default(now())
    updatedAt   DateTime @updatedAt
    user        User     @relation(fields: [userId], references: [id], onDelete: Cascade)
    userId      String   
    orderItems  OrderItem[]
    orderDetails OrderDetail[] // don't want this to be an array
}

model OrderDetail {
    id        String @id @default(cuid())
    orderId   String
    address   String
    city      String
    country   String
    postalCode String
    phone     String
    createdAt DateTime @default(now())
    updatedAt DateTime @updatedAt
    order     Order   @relation(fields: [orderId], references: [id], onDelete: Cascade)
}

model Order {
    id          String   @id @default(cuid())
    createdAt   DateTime @default(now())
    updatedAt   DateTime @updatedAt
    user        User     @relation(fields: [userId], references: [id], onDelete: Cascade)
    userId      String   
    orderItems  OrderItem[]
    orderDetails OrderDetail[] // don't want this to be an array
}

More info in the SO question: https://stackoverflow.com/questions/74167803/why-prisma-forces-me-to-have-an-array-in-a-relationship?noredirect=1#comment130948143_74167803 or even more in the repo :). https://github.com/esponges/t3-ecommerce

0 Replies

No replies yetBe the first to reply to this messageJoin

Gaming

Programming

Spot the Prisma relation error?