Documentation
Walkthrough
Update

Update records

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?
 
    comments Comment[]
}
 
model Comment {
    id        String   @id @default(cuid())
    createdAt DateTime @default(now())
    content   String
 
    post   Post?   @relation(fields: [postID], references: [id])
    postID String?
}

Update a record

To update a record, just query for a field using FindUnique or FindMany, and then just chain it by invoking .Update().

updated, err := client.Post.FindMany(
    db.Post.Title.Equals("what up"),
).Update(
    db.Post.Content.Set("new content"),
    db.Post.Title.Set("new title"),
).Exec(ctx)

Update relations

Required relation

You can set relations in the same way as when creating records.

updated, err := client.Comment.FindUnique(
    db.Comment.ID.Equals("id"),
).Update(
    db.Comment.Post.Link(
        db.Post.ID.Equals(postID),
    ),
).Exec(ctx)

Optional relation

For optional relations, you can also unlink the relation, so the foreign key value is set to NULL:

updated, err := client.Comment.FindUnique(
    db.Comment.ID.Equals("id"),
).Update(
    db.Comment.Post.Unlink(),
).Exec(ctx)
CreateDelete