Converting functions from JS client to Python client - Equivelant to upsert

[simondpalmer]

I have a working prisma-client-js that has the following function to update my database:

const result = await prisma.lotAnalysis.update({
    where: {
      userId_lotId: {
        userId: user_id,
        lotId: lot_id,
      } 
    },
    data: {
      results: {
        upsert: {
          create: {
            isComplete: True,
          },
        update: {
          isComplete: True,
        }
      }
      }
      }
  });

Which works however I am migrating this and other functions over to a python backend using prisma-client-py.
So I have convert it as follows:

upload = db.lotanalysis.update(
        where = {
            'userId_lotId': {
                'userId': user_id,
                'lotId': lot_id,
                    } 
                },
    data= {
      'results': {
          'upsert': {
          'create': {
            'isComplete': True
          },
        'update': {
          'isComplete': True
        }
      } 
      }
      }
    )

It works but creates a new record in the database.
How do I update my unique record using the unique field @@id([userId, lotId])
My schema for LotAnalysis looks like below:

model LotAnalysis {
  role      UserRole

  // Relation Fields
  userId    String
  lotId     Int     @unique @default(autoincrement())
  price     Float?
  results   LotResult?
  user      User   @relation(fields: [userId], references: [id])
  lot       Lot @relation(fields: [lotId], references: [id])

  @@id([userId, lotId])
}

model LotResult {
  id     Int     @id @default(autoincrement())
  createdAt  DateTime @default(now())
  isComplete Boolean?   @default(false)
  sides      Json?
  codeReview Json?
  setbacks   Json?

  analysisId    Int? @unique// relation scalar field
  lot      LotAnalysis? @relation(fields: [analysisId], references: [lotId]) // relation field
}

[nettrino]

I also run into this @RobertCraigie apologies if its somewhere in the docs and I've missed it

[nettrino]

for composite keys like @@id([field1, field2], name="name") (likewise for @@unique) constraints you can use the name to do a where clause

            where={
                "<name>": {
                    "field1": <val>,
                    "field2":<val> ,
                }