Prisma•2mo ago

prisma validation

what's the best approach for validating data before creation if prisma currently can't validate nested writes?

2 Replies

You opted for speed from this bot. Let's conjure up an answer right now! Based on the knowledge sources provided, Prisma currently does not have built-in support for validating nested writes. However, there are a few approaches you can consider for validating data before creation, including nested data: 1. Custom Validation Function: You can create a custom validation function that validates your data before passing it to Prisma. This approach is flexible and allows you to use any validation library of your choice. The Prisma documentation on custom validation provides an example using Superstruct:

import { assert, object, string, size, refine } from 'superstruct'
import isEmail from 'isemail'

const Signup = object({
  email: refine(string(), 'email', (v) => isEmail.validate(v)),
  password: size(string(), 7, 30),
  firstName: size(string(), 2, 50),
  lastName: size(string(), 2, 50),
})

async function signup(input: Signup): Promise<User> {
  assert(input, Signup)
  return prisma.user.create({
    data: input.user,
  })
}

import { assert, object, string, size, refine } from 'superstruct'
import isEmail from 'isemail'

const Signup = object({
  email: refine(string(), 'email', (v) => isEmail.validate(v)),
  password: size(string(), 7, 30),
  firstName: size(string(), 2, 50),
  lastName: size(string(), 2, 50),
})

async function signup(input: Signup): Promise<User> {
  assert(input, Signup)
  return prisma.user.create({
    data: input.user,
  })
}

2. Prisma Client Extensions: While Prisma Client extensions don't currently support nested operations, they can be used for top-level validations. You can implement validations for the main model and handle nested data separately. The Prisma documentation on custom validation shows an example using Zod:

const prisma = new PrismaClient().$extends({
  query: {
    product: {
      create({ args, query }) {
        args.data = ProductCreateInput.parse(args.data)
        return query(args)
      },
      // ... other methods
    },
  },
})

const prisma = new PrismaClient().$extends({
  query: {
    product: {
      create({ args, query }) {
        args.data = ProductCreateInput.parse(args.data)
        return query(args)
      },
      // ... other methods
    },
  },
})

3. Third-party Middleware: For a more comprehensive solution that can handle nested writes, you might consider using a third-party middleware. One such solution is mentioned in the knowledge sources: prisma-validation-middleware is a middleware that validates data when creating or updating records, including when doing so through a relation. It supports using various validation libraries like Zod or Superstruct. This approach allows you to validate nested data structures before they reach Prisma, providing a workaround for the current limitation of Prisma's nested write validation. In conclusion, while Prisma doesn't currently support built-in validation for nested writes, you can use custom validation functions, Prisma Client extensions (for top-level validations), or third-party middleware solutions to validate your data before creation. The best approach depends on your specific use case and the complexity of your data structures. 🤔 Alright, thanks for letting us know that there's still some help needed. A team member will reply to you shortly. In the meantime, please let us know any additional info, questions, or which parts of the answer may need clarification.

Nurul•2mo ago

Hey 👋 I would recommend using libraries like Zod, Joi etc to create custom validation schemas for your data. One possible solution is also to use Prisma Client extensions as mentioned by bot: https://www.prisma.io/docs/orm/prisma-client/queries/custom-validation#input-validation-with-prisma-client-extensions Does these solution doesn't work for you?

Gaming

Programming

prisma validation

Did you find this page helpful?