Is there a more concise way to write this? (Need to connect relation upon creation in Prisma)

user_16196327 0
Viewed 37
model Case{
  id String @id @default(uuid())
  caseId Int @unique @default(autoincrement())
  title String
  status Status[]

}


model Status{
  id String @id @default(uuid())
  statusId Int @unique @default(autoincrement())
  title String
  caseId Int
  story Story[]
  case Case? @relation(fields: [caseId],references: [caseId], onDelete: Cascade)
}

So let's say I have two Prisma Models like this. Case is the bigger one, so that one can be created with just the title. Now, I want it so that for someone to create a status, it needs to come with the caseId. So the post body is like this

{
  "caseId": 1,
  "title": "string"
}

As such, right now my create code is like this

async create(status: CreateStatusDto) {
    const {caseId, ... rest} = status
    if(!caseId){
      throw new BadRequestException('Please Input Case Id')
    }
    return await this.prismaService.status.create({
      data: {
        ...rest,
        case: {
          connect: {
            caseId: caseId
          }
        }
      }
    })
  }

And it's not exactly pretty, so I'm looking for a better way to write it. Any suggestions?

prisma nestjs typescript
1 Answers

First of all, you could use a ValidationPipe to check if caseId is valid.

Second, you might wanna take a look at Exception Filters as they would make your code cleaner and your life easier (your exception should inform what happened, and not "ask" for the user to fix it, as you're doing).

As for Prisma, here's an example from Prisma's doc on nested writes:

const createUserAndPost = await prisma.user.create({
  data: {
    email: 'elsa@prisma.io',
    name: 'Elsa Prisma',
    posts: {
      create: [
        { title: 'How to make an omelette' },
        { title: 'How to eat an omelette' },
      ],
    },
  },
})
user_112380340
Related