Kotlin: Upsert data

• Primary keys should be included in the data payload in order for an update to work correctly.
• Primary keys must be natural, not surrogate. There are however, workarounds for surrogate primary keys.
• If you need to insert new data and update existing data at the same time, use Postgres triggers.
• When calling insert or update, you have to provide a serializable value in the function parameter.

Parameters

• value

  (Required)

  The value(s) you want to insert. `T` can be any serializable type.

• onConflict

  (Optional)

  Comma-separated UNIQUE column(s) to specify how duplicate rows are determined. Two rows are duplicates if all the `onConflict` columns are equal.

• defaultToNull

  (Optional)

  Make missing fields default to `null`. Otherwise, use the default value for the column. This only applies when inserting new rows, not when merging with existing rows under

• ignoreDuplicates

  (Optional)

  If `true`, duplicate rows are ignored. If `false`, duplicate rows are merged with existing rows.

• request

  (Optional)

  Additional configuration & filtering for the request.

Examples

Upsert your data

val toUpsert = Message(id = 3, message = "foo", username = "supabot")
supabase.from("messages").upsert(toUpsert)

Upserting into tables with constraints

val toUpsert = User(username = "supabot")
supabase.from("users").upsert(toUpsert, onConflict = "username")

Return the exact number of rows

val toUpsert = User(username = "supabot")
val count = supabase.from("users").upsert(toUpsert, onConflict = "username") \{
    count(Count.EXACT)
\}.count()