Hello I can t seem to find an answer on my question so I ll Prisma #orm-help

Hello I can't seem to find an answer on my questio...

Gustav Walter

05/30/2021, 11:55 AM

Hello I can't seem to find an answer on my question so I'll give it a shot here: I'm trying to fetch some data from a product table using:

Copy code

const response = await prisma.product.findUnique({
          where: {
            name: name,
          },
        });

and it's complaining about the name type when I try to build, please look at the attached image. Now it's complaining about the type, the name was originally a string but I changed it to any, but I still can't seem to get it to work. My model for the product table is:

Copy code

model Product {
  id         Int         @id @default(autoincrement())
  name       String      @unique
  price      Int
  orderItems OrderItem[]
}

and the error message is: Type error: Type '{ name: any; }' is not assignable to type 'ProductWhereUniqueInput'. I'm assuming it has something to do with the @unique part in the table and the type around it. If anyone know how to solve this, feel free to contact me! 🙂 Thanks //Gustav

Тоше

05/30/2021, 11:59 AM

is name a custom field from your resolver, had similar errors when using graphql nexus.

Gustav Walter

05/30/2021, 12:02 PM

Copy code

orders.map(async (name: any) => {
        const response = await   prisma.product.findUnique({
          where: {
            name: name,
          },
        });

        if (response?.id) {
          await prisma.orderItem.create({
            data: {
              amount: bodyData.order.length,
              productId: response.id,
              orderId: order.id,
            },
          });
        }
      });

Gustav Walter

05/30/2021, 12:03 PM

It's inside a map function.

Lars Ivar Igesund

05/30/2021, 1:31 PM

Did you regenerate after changing the model? This kind of stuff usually works in prisma 1 at least. Try looking at your ProductWhereUniqueInput type - it should show name there in addition to id

Ryan

05/31/2021, 6:53 AM

@Gustav Walter 👋 Could you setup a sample reproduction repo so that I can check?

8 Views

Open in Slack

Previous Next