Baptiste Marchand Posts - Answer Overflow

Baptiste Marchand

•Created by Baptiste Marchand on 8/22/2024 in #help-and-questions

Native types for enums

Hi, I would like to add a native type to an enum field. Like that :

enum Role {
  USER
  ADMIN
}
model User {
  role Role @db.VarChar(191)
}

enum Role {
  USER
  ADMIN
}
model User {
  role Role @db.VarChar(191)
}

But when I do a prisma generate I get the following error : Attribute not known: "@db.VarChar". Are native types supported for enums?

5 replies

PPrisma

•Created by Baptiste Marchand on 6/6/2024 in #help-and-questions

Adding fields to a templated `select`

Hi, Let's say I have a getUser function, which takes a select as its argument :

const getUser = async <T extends Prisma.UserSelect>(select: T) => {
  return await prisma.user.findFirst({select})
}

const getUser = async <T extends Prisma.UserSelect>(select: T) => {
  return await prisma.user.findFirst({select})
}

Now I want to add a log that says which user I'm getting, so I try this :

const getUser = async <T extends Prisma.UserSelect>(select: T) => {
  const user = await prisma.user.findFirst({
    select: {...select, id: true},
  })
  console.log(`Getting user ${user.id}`)
  return user
}

const getUser = async <T extends Prisma.UserSelect>(select: T) => {
  const user = await prisma.user.findFirst({
    select: {...select, id: true},
  })
  console.log(`Getting user ${user.id}`)
  return user
}

But now I have the following TypeScript error:

Type 'T & { id: true; }' is not assignable to type 'T & { id: true; }'. Two different types with this name exist, but they are unrelated.

So I found the workaround of creating a variable for the select :

const getUser = async <T extends Prisma.UserSelect>(select: T) => {
  const selectWithId = {...select, id: true}
  const user = await prisma.user.findFirst({select: selectWithId})
  console.log(`Getting user ${user.id}`)
  return user
}

const getUser = async <T extends Prisma.UserSelect>(select: T) => {
  const selectWithId = {...select, id: true}
  const user = await prisma.user.findFirst({select: selectWithId})
  console.log(`Getting user ${user.id}`)
  return user
}

That gets rid of the previous error, but I still have an error on the user.id : Property 'id' does not exist on type GIANT_TYPESCRIPT_TYPE. Is there a workaround for this? Adding fields to a templated select is a use-case that came up a few times already in my codebase so I'm trying to find a proper solution (right now we just slap an any on there). Thank you

5 replies

Gaming

Programming