when I update a record whose model has connected fields, do i have to explicitly map those to the referenced name in the relation?

.update({
  data: {
          ...updateData,
          origin: {
            connect: {
              city: origin
            },
          },
        },
  where: {id},
}

@Davedavedave 👋 I couldn’t quite get your question, could you elaborate a bit on this?

yeah i guess i phrased it poorly, sorry. i have this case when creating a record https://www.prisma.io/docs/concepts/components/prisma-client/relation-queries#connect-an-existing-record which works fine. so I am wondering if I have to update a record of this type, do i have to update it via the same syntax

So you want to update the relation record or do you want to remove that and connect a new one?

yeah i would like to update the record to point to a different record of the same relation

Yes to add a record you can use

connect

and to remove a record you can use

disconnect

.

so in my case i have like 5 relations that could possibly get updated in my request. Which means i need to write a mapper to check if the field is present and then generate a list of entries like this

fieldname: {
  connect: {
   nameOfRelationField: value
  }
}

and append these to the provided data of update

Is there an example that you have along with your schema? I could suggest a better option if there’s one.