Is there a way to limit the number of records for a user using Prisma?

Question

The simplest example I can give, is a User that can create multiple Posts. A one-to-many relationship where multiple posts can be tied to a single user.

But what if I want the User to only be able to have a max of 10 Posts? Ideally there'd be some kind of query I can run when creating a new Post, and if the limit has been reached, to reject creating that Post (or possibly replace a Post).

I'm kind of stumped on this. And I'm not sure if there is a way I can model this to create the desired outcome.

Otherwise, the only real solution I see is to fetch all Posts for a User, and count them before trying to create a new Post. But that would require two calls to the db instead of one which is the problem I am trying to avoid.

Answer 1

You can achieve it with interactive transaction, here's my example code:

const createPost = async (post, userId) => {
  return prisma.$transaction(async (prisma) => {
    // 1. Count current total user posts
    const currentPostCount = await prisma.posts.count({
      where: {
        user_id: userId,
      },
    })

    // 2. Check if user can create posts
    if (currentPostCount >= 10) {
      throw new Error(`User ${userId} has reached maximum posts}`)
    }

    // TODO
    // 3. Create your posts here
    await prisma.posts.create({
      data: post
    })
  })
}