Kotlin: Update data

• 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.

Examples

Updating your data

supabase.postgrest["characters"].update(
    {
       Character::name setTo "Han Solo"
       //or
       set("name", "Han Solo")
    }
) {
   Character::id eq 1
   //or
   eq("id", 1)
}

Update a record and return it

val newCharacter = supabase.postgrest["characters"].update(
    {
       Character::name setTo "Han Solo"
       //or
       set("name", "Han Solo")
    }
) {
   Character::id eq 1
   //or
   eq("id", 1)
}.decodeSingle<Character>()

Updating JSON data

val address = Address(street = "Melrose Place", postcode = 90210)
supabase.postgrest["users"].update(
    {
       User::address setTo address
    }
) {
   User::id eq 1
   //or
   eq("address->postcode", 90210)
}.decodeSingle<Country>()