CODEWITHSUNDEEP
javascriptdatabaseprismamutationprisma2
Kayote
Kayote

Reputation: 15647

Update multiple tables in one query

I couldn't find any relevant info on Prisma docs, nor on SO on this question.

My relevant schema looks like this:

model User {
  id             Int       @default(autoincrement()) @id
  createdAt      DateTime  @default(now())
  updatedAt      DateTime  @updatedAt
  firstName      String?
  lastName       String?
  email          String    @unique
  hashedPassword String?
  role           String    @default("user")
  sessions       Session[]
  profile        Profile?
}

model Profile {
  id                 Int       @default(autoincrement()) @id
  aboutMe            String?
  location           String?
  profession         String?
  user               User      @relation(fields:[userId], references: [id])
  userId             Int
}

I want to update multiple columns in both tables however, have been unable to get the mutation to work in Prisma. So, this is what my mutation looks like at the moment:

 ...
  const {aboutMe, location, profession, firstName, lastName } = inputs;
  const profile = await db.user.update({
    where: { id: ctx.session!.userId },
    data: {
      profile: {
        update: {
          aboutMe,
          location,
          profession,
        },
      },
    },
  });
  const user = await db.user.update({
    where: { id: ctx.session!.userId },
    data: {
      firstName,
      lastName,
    },
  });
...

As you can see, I have two mutations, is it possible the update multiple tables with a single mutation?

Thank you.

Upvotes: 2

Views: 2965

Answers (2)

Felipe
Felipe

Reputation: 424

To those ones looking for a different approach mainly to update a one-to-many relation here is the solution I use following Prisma docs:

await prisma.$transaction([
      prisma.userAccount.update({
        where: {
          id: isCodeStillValid.userId,
        },
        data: {
          password: hashPwd,
        },
      }),

      prisma.resetPassword.update({
        where: {
          code,
        },
        data: {
          concluded: true,
        },
      }),
    ]);

Upvotes: 0

Ryan
Ryan

Reputation: 6347

This should work:

const profile = await db.user.update({
    where: { id: u.id },
    data: {
      firstName: 'name',
      lastName: 'name',
      profile: {
        update: {
          aboutMe: 'aboutMe',
          location: 'aboutMe',
          profession: 'aboutMe',
        },
      },
    },
    include: { profile: true },
  })

Upvotes: 4

Related Questions