On Conflict

Definition

The onConflict methods allows you to add the ON CONFLICT clause to the query.

Available methods

1. onConflict()

• It does not receive parameters.

Method hierarchy

The values method can be used right after the following methods or objects:

• select, values

and the subsequent methods that can be called are:

• doNothing, targetColumn, targetConstraint

and once the action for the conflict is defined, the next available methods that can be called are:

• returning, execute

Possible actions to take

There are 5 possible actions to take when the ON CONFLICT clause is invoked

• Do Nothing
• Target Column - Do Nothing
• Target Constraint - Do Nothing
• Target Column - Do Update
• Target Constraint - Do Update