Upsert records

Use upsert to update or create records depending on whether it already exists or not.

The examples use the following prisma schema:


model Post {
  id        String   @id @default(cuid())
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
  published Boolean
  title     String
  content   String?
  views     Int      @default(0)
}

Upsert a record

Use UpsertOne to query for a document, define what to write when creating the document, and what to update if the document already exists.


post, err := client.Post.UpsertOne(
  // query
  db.Post.ID.Equals("upsert"),
).Create(
  // set these fields if document doesn't exist already
  db.Post.Published.Set(true),
  db.Post.Title.Set("title"),
  db.Post.ID.Set("upsert"),
).Update(
  // update these fields if document already exists
  db.Post.Title.Set("new-title"),
  db.Post.Views.Increment(1),
).Exec(ctx)