Jvwer Posts - Answer Overflow

Jvwer

•Created by Jvwer on 11/19/2024 in #help-and-questions

FindUnique/Update using unique index on sub field

Hi, I need some help with generating a schema where I can query indexed sub fields. I've looked for solutions but I couldn't really find a thread matching my problem. Let me sketch an example. (I'm working with Prisma ORM with MongoDB)

model Comment {
  id              String    @id @default(auto()) @map("_id") @db.ObjectId
  content         String
  replies         Reply[]
  ...

  @@unique([replies.id], map: "replies_id_1")
  @@map("comments")
}

type Reply {
  id      String @db.ObjectId
  content String
  ...
}

model Comment {
  id              String    @id @default(auto()) @map("_id") @db.ObjectId
  content         String
  replies         Reply[]
  ...

  @@unique([replies.id], map: "replies_id_1")
  @@map("comments")
}

type Reply {
  id      String @db.ObjectId
  content String
  ...
}

This schema will generate fine and put an index on _id and replies.id that works as intended (there can only be one reply on all existing comments with a specific id). I would like to use this unique index when querying the comments model. However there is no key/type for this to be passed as an argument for findUnique or update. the closest filter with the same result is this:

prisma.comment.findMany({
  where: { replies: { some: { id } } },
});

prisma.comment.findMany({
  where: { replies: { some: { id } } },
});

However this only works on ###Many operations. How can I add this 'self-made' index available for unique filtering?

4 replies

Gaming

Programming