MutablePersistable

The policy that handles SQLite conflicts when records are inserted or updated.

This property is optional: its default value uses the ABORT policy for both insertions and updates, and has GRDB generate regular INSERT and UPDATE queries.

If insertions are resolved with .ignore policy, the didInsert(with:for:) method is not called upon successful insertion, even if a row was actually inserted without any conflict.

See https://www.sqlite.org/lang_conflict.html

Returns the values that should be stored in the database.

Keys of the returned dictionary must match the column names of the target database table (see TableMapping.databaseTableName()).

In particular, primary key columns, if any, must be included.

struct Person : MutablePersistable {
    var id: Int64?
    var name: String?

    var persistentDictionary: [String: DatabaseValueConvertible?] {
        return ["id": id, "name": name]
    }
}

Notifies the record that it was succesfully inserted.

Do not call this method directly: it is called for you, in a protected dispatch queue, with the inserted RowID and the eventual INTEGER PRIMARY KEY column name.

This method is optional: the default implementation does nothing.

struct Person : MutablePersistable {
    var id: Int64?
    var name: String?

    mutating func didInsert(with rowID: Int64, for column: String?) {
        self.id = rowID
    }
}

Executes an INSERT statement.

This method is guaranteed to have inserted a row in the database if it returns without error.

Upon successful insertion, the didInsert(with:for:) method is called with the inserted RowID and the eventual INTEGER PRIMARY KEY column name.

This method has a default implementation, so your adopting types don’t have to implement it. Yet your types can provide their own implementation of insert(). In their implementation, it is recommended that they invoke the performInsert() method.

Executes an UPDATE statement.

This method is guaranteed to have updated a row in the database if it returns without error.

This method has a default implementation, so your adopting types don’t have to implement it. Yet your types can provide their own implementation of update(). In their implementation, it is recommended that they invoke the performUpdate() method.

Executes an INSERT or an UPDATE statement so that self is saved in the database.

If the receiver has a non-nil primary key and a matching row in the database, this method performs an update.

Otherwise, performs an insert.

This method is guaranteed to have inserted or updated a row in the database if it returns without error.

This method has a default implementation, so your adopting types don’t have to implement it. Yet your types can provide their own implementation of save(). In their implementation, it is recommended that they invoke the performSave() method.

Executes a DELETE statement.

This method has a default implementation, so your adopting types don’t have to implement it. Yet your types can provide their own implementation of delete(). In their implementation, it is recommended that they invoke the performDelete() method.

Returns true if and only if the primary key matches a row in the database.

This method has a default implementation, so your adopting types don’t have to implement it. Yet your types can provide their own implementation of exists(). In their implementation, it is recommended that they invoke the performExists() method.

Executes an UPDATE statement that updates all table columns.

Don’t invoke this method directly: it is an internal method for types that adopt MutablePersistable.

performInsert() provides the default implementation for insert(). Types that adopt MutablePersistable can invoke performInsert() in their implementation of insert(). They should not provide their own implementation of performInsert().

Don’t invoke this method directly: it is an internal method for types that adopt MutablePersistable.

performUpdate() provides the default implementation for update(). Types that adopt MutablePersistable can invoke performUpdate() in their implementation of update(). They should not provide their own implementation of performUpdate().

Don’t invoke this method directly: it is an internal method for types that adopt MutablePersistable.

performSave() provides the default implementation for save(). Types that adopt MutablePersistable can invoke performSave() in their implementation of save(). They should not provide their own implementation of performSave().

This default implementation forwards the job to update or insert.

Don’t invoke this method directly: it is an internal method for types that adopt MutablePersistable.

performDelete() provides the default implementation for deelte(). Types that adopt MutablePersistable can invoke performDelete() in their implementation of delete(). They should not provide their own implementation of performDelete().

Don’t invoke this method directly: it is an internal method for types that adopt MutablePersistable.

performExists() provides the default implementation for exists(). Types that adopt MutablePersistable can invoke performExists() in their implementation of exists(). They should not provide their own implementation of performExists().