Drizzle Team•5w ago

ZOD - how to createUpdateSchema?

What is the current workaround or alternative for the createUpdateSchema, similar to the createSelectSchema & createInsertSchema?

2 Replies

eXecuteye•5w ago

i use this:

const updateSchema = createInsertSchema(tableName).pick({ name: true, ... }).partial()

const updateSchema = createInsertSchema(tableName).pick({ name: true, ... }).partial()

Kevin•5w ago

I have gone with

const updateMemberSchema = createInsertSchema(member, {
  id: z.string().optional(),
});

const updateMemberSchema = createInsertSchema(member, {
  id: z.string().optional(),
});

so basically making the primary key optional. Your version is valid as well, but I see it uncomfortable since for every new subset of columns you want to update youd have to create a new type

Gaming

Programming

ZOD - how to createUpdateSchema?