Scalar lists

The examples use the following prisma schema:

model Post {
    id    String @id @default(cuid())
    title String
    tags  String[]
}

Querying records by array fields

Note: This only works with postgres.

post, err := client.Post.FindFirst(
    // whether the list contains a single field
    db.Post.Tags.Has("coffee"),
    // or
    // whether the tag contains coffee _and_ juice
    db.Post.Tags.HasEvery([]string{"coffee", "juice"}),
    // or
    // whether the tag contains coffee or tea
    db.Post.Tags.HasSome([]string{"coffee", "tea"}),
    // or
    db.Post.Tags.IsEmpty(false),
).Exec(ctx)

Writing to array fields

Set the field regardless of the previous value:

post, err := client.Post.FindUnique(
    db.Post.ID.Equals("123"),
).Update(
    db.Post.Tags.Set([]string{"a", "b", "c"}),
).Exec(ctx)

Add items to an existing list (postgres only):

post, err := client.Post.FindUnique(
    db.Post.ID.Equals("123"),
).Update(
    db.Post.Tags.Push([]string{"a", "b"}),
).Exec(ctx)

Notes

NULL values in scalar lists may need extra consideration (opens in a new tab).

Mocks Help