TypeScript generated types make autoincrement required

[Krabba]

Hi,

For example, an ID field in my model that will autoincrement:

id                    Int                    @id @default(autoincrement())

Will give me this type in node_modules\.prisma\client\index.d.ts:

id: number

What I want to receive is:

id?: number

Should this not be optional since if you skip to provide it, it will auto increment if it's not defined in the Client API?

[austincrim]

Hey @Krabba 👋,

The model type itself will say that id is required unless it is explicitly marked as optional in your schema id Int?.

However, Prisma also generates separate types for creating or updating a model, and these types will have id marked as optional.

For this User model,

model User {
  id   Int     @id @default(autoincrement())
  name String?
}

Prisma will generate types like these:

  export type UserUncheckedCreateInput = {
    id?: number
    name?: string | null
  }

Let me know if I can clarify any further!

[Krabba]

Hi @austincrim

You can't, or I can't atleast, mark an @id field as optional with ?.
If you do that, you will get this error:

However, I wasn't aware of the GIGANTIC variety of types to choose from when using the generated types in TypeScript.
I'll look in to those and let you know if I have anything else to ask.

Cool stuff!

Thank you for your help. 🛩️

[manojmpc91]

Well the problem still exists.

The autoincrement fields are made mandatory by typescript and yes one cannot make those optional with ? either.

Does this have any solution yet?

[Krabba]

I am no longer able to, or was never able to import UncheckedCreateInput types from the node_modules folder.
Although i've located them and see that they do exist there.

I can only import my table name types from that file (which is weird), but not the others surrounding.

I'm using Prisma^4.1.1 as of now but always update to the latest version asap.

[austincrim]

Most of the generated types are under the Prisma namespace export.

import { Prisma } from '@prisma/client'

const input: Prisma.UserUncheckedCreateInput

[pablojsx]

Same issue but with uuid

[mramazzini]

You can use Prisma.userCreateInput for a user model

This wont require the id field.

You can do this for any Prisma created model.

So say you had a model FizzBuzz, the type Prisma.FizzBuzzCreateInput will be genereated.