[mongodb] filtering using where not working.

[bn-piar]

model User {
  id           String   @id @default(auto()) @map("_id") @db.ObjectId
  email        String   @unique /// @encrypted
  emailHash    String?  @unique /// @encryption:hash(email)
  password     String /// @encrypted
  passwordHash String? /// @encryption:hash(password)
  name         String?
  role         UserRole @default(Client)
  createdAt    DateTime @default(now())
  updatedAt    DateTime @default(now()) @updatedAt
}

enum UserRole {
  Admin
  Client
  Sale
}

Hi. I added a document to db with field { email: "hehe" }, however this does not work const user = await prisma.user.findUnique({ where: { email: "hehe" } });

Any clues?

[franky47]

Could you try enabling debugging printouts, to see what comes up?

Edit: also, you should never store passwords in an accessible state (plain text or encrypted). See the disclaimer. One day I might make a Prisma middleware that does this the right way transparently.