Z
Zod•7mo ago
𓆩panda𓆪

panda - how would i go about validating a datab...

how would i go about validating a database column that is typed as JSON and can have any amount of values in it: 
// These work
{
  "foo": 1,
  "bar": 3
}
{
  "foo": 1
}
// This does not work
{
  "bang": "1233"
}
// These work
{
  "foo": 1,
  "bar": 3
}
{
  "foo": 1
}
// This does not work
{
  "bang": "1233"
}
Solution:
they keys will always be strings and the values will always be numbers, so im assuming i would just do z.record(z.number)?
Jump to solution
4 Replies
Scott Trinh
Scott Trinh•7mo ago
If it's truly dynamic, you can use z.any or z.unknown to type that property. Or if you know roughly that it'll be a JSON object, but don't know the shape, maybe z.record(z.unknown) (Which is Record<string, unknown>) is a slightly easier type to deal with downstream, but that'll break if it ends up being other valid JSON values like an array, null, or a bare JSON primitive like number or string, etc.
Solution
𓆩panda𓆪
𓆩panda𓆪•7mo ago
they keys will always be strings and the values will always be numbers, so im assuming i would just do z.record(z.number)?
Scott Trinh
Scott Trinh•7mo ago
ahh, yep!
𓆩panda𓆪
𓆩panda𓆪•7mo ago
awesome, thanks so much!
Want results from more Discord servers?
Add your server
More Posts
addamsson - Is there a way to fine-tune error m...Is there a way to fine-tune error messages in Zod to include the path (or the last element of the paaddamsson - I have the following code:tsimpor...I have the following code: ```ts import { z } from "zod"; const Address = z.object({ street: z.janglad - Quick question, .pick allows non exis...Quick question, `.pick` allows non existing keys. Is this supposed to be the case and am I missing sYamereee - 👋 Hello Zod Wizards! A Question wh...👋 Hello Zod Wizards! A Question when using coerce with my API responses, I have a schema here Notaddamsson - Hi everyone! 👋 I have a small prob...Hi everyone! 👋 I have a small problem with Zod. In my code: ```ts z .string() .superRefine(David Tejada - Hi. I have the following functio...Hi. I have the following function which I have simplified for the example. The type Storage is inferKas.st - Hi everyone, I have a schema with an e...Hi everyone, I have a schema with an enum: ```javascript const schema = z.object({ foo: z.enum(["fkiqaps - hey guys, am I doing something wrong? ...hey guys, am I doing something wrong? why does the infered type has optional mark?janglad - deepPartial has been depreciated rece...`deepPartial` has been depreciated recently (https://github.com/colinhacks/zod/commit/edc3a67e77d339zerokelvin - Why is MySchema.parse making optio...Why is `MySchema.parse` making optional all of the properties of my schema? How do I stop it from do