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>()