Ignore certain fields for @updatedAt

[SuperManito]

Problem

For example, I have a status field and an update_time field, and when I change the status value, I expect that the value of the update_time field will not be automatically updated.

model envs {
  id          Int         @id @default(autoincrement())
  update_time DateTime    @default(now()) @updatedAt
  value       String      @default("")
  status      Int      @default(1)
}

Suggested solution

@updatedAtIgnoreFields(['status'])

[marcus13371337]

Pro-tip: you can manually opt-out from updatedAt is updating by providing prisma with the previous value.

I.e:

const env = await prisma.envs.findFirst({})

const envUpdated = await prisma.envs.update({
    where: {
       id: env.id
    },
    data: {
        status: "new status",
        update_time: env.update_time
    }
})

// envUpdated.update_time should be the same as env.update_time

[Druue]

Hey @SuperManito, can you clarify please:

@updatedAt triggers whenever the model is updated at all. Are you asking for a way to have the @updatedAt attribute to only be used when certain values are affected in .update queries? (i.e. a feature request? the way this is working in your issue is currently intended)

[SuperManito]

My project uses a unified prisma encapsulation operation method and has multiple data models. It is difficult for me to find another way to solve this requirement.

[SuperManito]

It is difficult to solve this problem using a where statement because it is too cumbersome to customize.

[erikmusd]

Pro-tip: you can manually opt-out from updatedAt is updating by providing prisma with the previous value.

I.e:

const env = await prisma.envs.findFirst({})

const envUpdated = await prisma.envs.update({
    where: {
       id: env.id
    },
    data: {
        status: "new status",
        update_time: env.update_time
    }
})

// envUpdated.update_time should be the same as env.update_time

Though would this fire off 2 separate queries? Finding then later updating, or is Prisma smart enough to combine into single call? I'm not familiar with Prisma internals.