core/io.github.octaviusframework.db.core.builder/DatabaseOnConflictClauseBuilder/doUpdate

doUpdate

open override fun doUpdate(setExpression: String, whereCondition: String?)

Defines the DO UPDATE action using a raw SET expression. Use EXCLUDED to reference the values that were attempted to insert.

doUpdate("tribute_amount = EXCLUDED.tribute_amount")

open override fun doUpdate(vararg setPairs: Pair<String, String>, whereCondition: String?)

Defines the DO UPDATE action using column-value pairs.

doUpdate(
    "tribute_amount" to "EXCLUDED.tribute_amount",
    "last_collected_at" to "NOW()"
)

open override fun doUpdate(setMap: Map<String, String>, whereCondition: String?)

Defines the DO UPDATE action using a map. Useful when the update columns are determined at runtime, e.g., when only non-null fields of a patch request should be updated.