Hey all how can I update many records where I have the userI Prisma #orm-help

Hey all how can I update many records where I have...

10/27/2021, 3:44 PM

Hey all how can I update many records where I have the userId + default = true, schema shared in the thread. thanks in advance

10/27/2021, 3:44 PM

Copy code

model Address {
  id             String        @id @default(uuid())
  createdAt      DateTime      @default(now())
  updatedAt      DateTime      @updatedAt
  type           AddressType
  lineOne        String
  lineTwo        String?
  lineThree      String?
  city           String
  state          String
  postalCode     String
  country        String
  notes          String?
  default        Boolean       @default(false)
  userId         String?
  user           User?         @relation(fields: [userId], references: [id])
  organizationId String?
  organization   Organization? @relation(fields: [organizationId], references: [id])

  @@index([id, userId])
  @@index([id, userId, default])
  @@index([id, organizationId])
  @@index([id, organizationId, default])
}

10/27/2021, 3:45 PM

Use case: I want to update address records where I have either the userId or organizationId and default

10/27/2021, 3:45 PM

Copy code

await this.prisma.address.update({
          where: {
            userId: createPayload.userId,
            default: true
          }
        })

Austin Zentz

10/27/2021, 3:49 PM

Do you want to make the same update to all of the records?

Austin Zentz

10/27/2021, 3:50 PM

Like, change the city/state/postalCode to the same exact values for all of the addresses you're updating?

Austin Zentz

10/27/2021, 3:51 PM

in that case, updateMany would probably work

10/27/2021, 3:58 PM

i just want to update the users default address in this case, however in another case

10/27/2021, 4:00 PM

updateMany works 👍, but let's say I want to update an individual address with only the

userId

and the

default

status how can i achieve that

Austin Zentz

10/27/2021, 4:01 PM

i'd probably do two queries -- first a query with a findOne, to get the address. and then do a subsequent update now that you have the address and ID

Austin Zentz

10/27/2021, 4:02 PM

alternatively, if it's unique you could query the user and include the defaultAddress relation, but taht's still a query to find and a follow-up query to update, so it's not necessarily any better.

✅ 1

10/27/2021, 4:10 PM

thanks @Austin Zentz

👍 1

3 Views

Open in Slack

Previous Next