InsertMode enum Null safety
Enumeration of different insert behaviors. See the documentation on the individual fields for details.
- insert → const InsertMode
INSERT INTOstatement. When a row with the same primary or unique key already exists, the insert statement will fail and an exception will be thrown. If the exception is caught, previous statements made in the same transaction will NOT be reverted.
- replace → const InsertMode
Identical to InsertMode.insertOrReplace, included for the sake of completeness.
- insertOrReplace → const InsertMode
Like insert, but if a row with the same primary or unique key already exists, it will be deleted and re-created with the row being inserted.
- insertOrRollback → const InsertMode
Similar to InsertMode.insertOrAbort, but it will revert the surrounding transaction if a constraint is violated, even if the thrown exception is caught.
- insertOrAbort → const InsertMode
Identical to insert, included for the sake of completeness.
- insertOrFail → const InsertMode
Like insert, but if multiple values are inserted with the same insert statement and one of them fails, the others will still be completed.
- insertOrIgnore → const InsertMode
Like insert, but failures will be ignored.