2 replies

Drizzle-zod createInsertSchema types

if I have a schema :

export const listings = pgTable("listings", {
  id: serial("id").primaryKey(),
  ...
  squareFeet: integer("sq_ft").notNull(),
  description: text("description").notNull(),
  ...
});

export const listings = pgTable("listings", {
  id: serial("id").primaryKey(),
  ...
  squareFeet: integer("sq_ft").notNull(),
  description: text("description").notNull(),
  ...
});

it seems like text and varchar column types get inferred as ZodString which I'd expect. However, integer, serial, dates, etc are just inferred as ZodAny. Is this expected? Do i just need to do some base checks in refine to make sure integers,booleans etc are correct?

Docs lead me to believe i should be able to apply a refine to the id field like

{ id: (schema) => schema.id.positive(), }

{ id: (schema) => schema.id.positive(), }

however I am getting an error positive does not exist on type 'ZodAny' where I'm assuming id should be of type ZodNumber

Drizzle Team•3y ago•

2 replies

space marine

Drizzle-zod createInsertSchema types

if I have a schema :

export const listings = pgTable("listings", {
  id: serial("id").primaryKey(),
  ...
  squareFeet: integer("sq_ft").notNull(),
  description: text("description").notNull(),
  ...
});

export const listings = pgTable("listings", {
  id: serial("id").primaryKey(),
  ...
  squareFeet: integer("sq_ft").notNull(),
  description: text("description").notNull(),
  ...
});

{ id: (schema) => schema.id.positive(), }

{ id: (schema) => schema.id.positive(), }

however I am getting an error positive does not exist on type 'ZodAny' where I'm assuming id should be of type ZodNumber

Drizzle-zod createInsertSchema types

Similar Threads

Drizzle-zod createInsertSchema types

Similar Threads

Similar Threads

Similar Threads