Zod•12mo ago

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•12mo 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

★𝖕𝖆𝖓𝖉𝖆☆•12mo 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•12mo ago

ahh, yep!

★𝖕𝖆𝖓𝖉𝖆☆OP•12mo ago

awesome, thanks so much!

Gaming

Programming

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