esponges Posts - Answer Overflow

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

1 replies

TTCTheo's Typesafe Cult

•Created by esponges on 10/21/2022 in #questions

TRPC mutation example with relationships

Hey, I'm building an e-commerce site as a side project but I'm not sure how to make use of the mutation method with relationships. Have anyone seen an example that handles these cases? This would be step where the user has entered his details in a form and I already have the Product(s) in the cart global state. My prisma schema is something like this:

model OrderItem {
    id        String @id @default(cuid())
    quantity  Int
    createdAt DateTime @default(now())
    updatedAt DateTime @updatedAt
    orderId   String
    order     Order   @relation(fields: [orderId], references: [id], onDelete: Cascade)
    productId String
    product   Product @relation(fields: [productId], references: [id], onDelete: Cascade)
}

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[] // can't get not to be an array??
}

model OrderItem {
    id        String @id @default(cuid())
    quantity  Int
    createdAt DateTime @default(now())
    updatedAt DateTime @updatedAt
    orderId   String
    order     Order   @relation(fields: [orderId], references: [id], onDelete: Cascade)
    productId String
    product   Product @relation(fields: [productId], references: [id], onDelete: Cascade)
}

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[] // can't get not to be an array??
}

I don't have any type errors like this but I'm wondering if I'm in the right direction. The source is here in case if you want to see the rest of the code https://github.com/esponges/t3-ecommerce

1 replies

TTCTheo's Typesafe Cult

•Created by esponges on 10/6/2022 in #questions

Why I'm getting this TRPCClient error when navigating?

5 replies

Gaming

Programming