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["countries"].update(
    \{
       Country::name setTo "Australia"
       //or
       set("name", "Australia")
    \}
) \{
   Country::id eq 1
   //or
   eq("id", 1)
\}

Update a record and return it

val newCountry = supabase.postgrest["countries"].update(
    \{
       Country::name setTo "Australia"
       //or
       set("name", "Australia")
    \}
) \{
   Country::id eq 1
   //or
   eq("id", 1)
\}.decodeSingle<Country>()

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