notNull() is still letting field be optional

I am performing the following for SQLite:

export const products = sqliteTable("products", {
  id: integer("id").primaryKey({ autoIncrement: false }).notNull(),
  name: text("name").notNull(),
  description: text("description"),
});

export const products = sqliteTable("products", {
  id: integer("id").primaryKey({ autoIncrement: false }).notNull(),
  name: text("name").notNull(),
  description: text("description"),
});

export const products = sqliteTable("products", {
  id: integer("id").primaryKey({ autoIncrement: false }).notNull(),
  name: text("name").notNull(),
  description: text("description"),
});

export const products = sqliteTable("products", {
  id: integer("id").primaryKey({ autoIncrement: false }).notNull(),
  name: text("name").notNull(),
  description: text("description"),
});

However, when I perform:

export type NewProduct = typeof products.$inferInsert;

export type NewProduct = typeof products.$inferInsert;

export type NewProduct = typeof products.$inferInsert;

export type NewProduct = typeof products.$inferInsert;

It says that

id

id

is optional (this is what it shows when i hover over

NewProduct

NewProduct

NewProduct

NewProduct)

type NewProduct = {
    name: string;
    id?: number | undefined; <---- SHOULD JUST BE NUMBER
    description?: string | null | undefined;
}

type NewProduct = {
    name: string;
    id?: number | undefined; <---- SHOULD JUST BE NUMBER
    description?: string | null | undefined;
}

type NewProduct = {
    name: string;
    id?: number | undefined; <---- SHOULD JUST BE NUMBER
    description?: string | null | undefined;
}

type NewProduct = {
    name: string;
    id?: number | undefined; <---- SHOULD JUST BE NUMBER
    description?: string | null | undefined;
}

How can I fix this?

notNull() is still letting field be optional

Similar Threads

Similar Threads

Similar Threads