DT
Drizzle Team•4mo ago
Zefty

Drizzle-zod insert schema list

Hi all, Using the examples from the docs 
import { createInsertSchema } from 'drizzle-zod';
const users = pgTable('users', {
  id: integer().generatedAlwaysAsIdentity().primaryKey(),
  name: text().notNull(),
  age: integer().notNull()
});
const userInsertSchema = createInsertSchema(users);
import { createInsertSchema } from 'drizzle-zod';
const users = pgTable('users', {
  id: integer().generatedAlwaysAsIdentity().primaryKey(),
  name: text().notNull(),
  age: integer().notNull()
});
const userInsertSchema = createInsertSchema(users);
The userInsertSchema is for a singular value. Is it possible to extend this so it becomes an array? This is because usually if we are inserting values into db we can insert more than one. userInsertSchema[]?
2 Replies
Zefty
ZeftyOP•4mo ago
This is not documented in the api docs but we can do this to get what I want 
createInsertSchema(users).array()
createInsertSchema(users).array()
TOSL
TOSL•4mo ago
userInsertSchema returns as a zodObject, right? So you can just do userInsertSchema.array()? so you can do like userArrayInsertSchema = userInsertSchema.array()

Did you find this page helpful?