I have a schema that looks like this:

model User {
  id          Int       @id @default(autoincrement())
  createdAt   DateTime  @default(now())
  username    String    @unique
  password    String
  userUUID    UserUUID?
}

model UserUUID {
  id     String @id @default(uuid())
  user   User   @relation(fields: [userId], references: [id])
  userId Int    @unique
}

I want to add an entry to UserUUID if one is not present for the provided username, how can i achieve that? I tried with the following but it complains about not being able to uniquely identify a user.

await prisma.userUUID.upsert({
        where: {
            user: {
                username: username.toLowerCase()
            }
        },
        update: {},
        create: {
            user: {
                connect: {
                    username: username.toLowerCase()
                }
            }
        }            
    });

Anyone knows how i can acheive this? Reason for having a UserUUID is that it should not always be present for every user, only users that have activated that feature.

@Halvor 👋 The code you specified above works for me. Could you check if the

username

passed is correct and present in the database?

@Ryan Mhm, it shows an error in VSCode with the Prisma plugin. I can double check if i am i am able to run it.

In this case,

upsert

will only work for the field in the same model. It cannot reference the

@unique

fields in another model.

@Ryan I am confused, will it add a row to the UserUUID table? I get that it cannot change username or any other properties of User table.

It will add a new row to the UserUUID table as you’re using

create

.

Thx for help :-)