Kotlin: Update data

Perform an UPDATE on the table or view.

• update() should always be combined with a filter block to avoid updating all records.
• When calling insert or update, you have to provide a serializable value in the function parameter.
• By default, update will not return the inserted data. If you want to return the inserted data, you can use the select() method inside the request.

Parameters

• value

  (Required)

  The new value, can be either a serializable value or PostgrestUpdate DSL where you can set new values per column.

• request

  (Optional)

  Additional configuration & filtering for the request.

Examples

Updating your data

supabase.from("characters").update(
    {
       Character::name setTo "Harry"
       //or
       set("name", "Harry")
    }
) {
    filter {
        Character::id eq 1
        //or
        eq("id", 1)
    }
}

Update a record and return it

val newInstrument = supabase.from("instruments").update(
    {
       Instrument::name setTo "piano"
       //or
       set("name", "piano")
    }
) {
    select()
    filter {
        Instrument::id eq 1
        //or
        eq("id", 1)
    }
}.decodeSingle<Instrument>()

Updating JSON data

val address = Address(street = "Melrose Place", postcode = 90210)
supabase.from("users").update(
    {
       User::address setTo address
    }
) {
    filter {
        eq("address->postcode", 90210)
    }
}