DT
Drizzle Teamfranek.stodulski

[postgres][zod] createInsertSchema

Hey! Trying to make my Sveltekit form schema. Here is my example: 
export const userAccessesFormSchema = createInsertSchema(usersTable, {
  id: z.string().min(1),
  hasDatabase: z.boolean(),
  hasMsaa: z.boolean(),
  hasMsap: z.boolean()
}).pick({
  id: true,
  hasDatabase: true,
  hasMsaa: true,
  hasMsap: true
});
export const userAccessesFormSchema = createInsertSchema(usersTable, {
  id: z.string().min(1),
  hasDatabase: z.boolean(),
  hasMsaa: z.boolean(),
  hasMsap: z.boolean()
}).pick({
  id: true,
  hasDatabase: true,
  hasMsaa: true,
  hasMsap: true
});
User has many other fields, but in this case I wan't to use only these to update this user with data. Why am I getting rest of the fields in the result? I don't want to check them..Am I doing something wrong? Based on this: https://orm.drizzle.team/docs/zod Basically I need to take few fields from my User schema, make them fully required so I won't have to check after safeParse() if the value is undefined...
Drizzle ORM - drizzle-zod
Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.
No description
F
franek.stodulski•15d ago
Like it..
No description
Want results from more Discord servers?
Add your server
More Posts
Use schema definition as normal typesI want to use my schema definition as a normal type. Basically what .select().from() returns - plainWhat is a recommended way to execute migration on CI ?Build facilities for migration assume it happens during app execution I don't sure it a good idea anStruggling when changing tables relationships or columnsI find myself getting errors such as quite regularly [cause]: [ResponseError: SQLite error: no suchHow can I get rid of the buffer object returned when using Magical sql operator?This is and example of how I execute the query: ```ts const id = 69; await db.execute(sql`select * f