Record

Creates a Record.

Creates a Record from a row.

The name of a database table.

This table name is required by the insert, update, save, delete, and exists methods.

class Player : Record {
    override class var databaseTableName: String {
        return "player"
    }
}

The implementation of the base class Record raises a fatal error.

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

The default request selection.

Unless this method is overriden, requests select all columns:

// SELECT * FROM player
try Player.fetchAll(db)

You can override this property and provide an explicit list of columns:

class RestrictedPlayer : Record {
    override static var databaseSelection: [SQLSelectable] {
        return [Column("id"), Column("name")]
    }
}

// SELECT id, name FROM player
try RestrictedPlayer.fetchAll(db)

You can also add extra columns such as the rowid column:

class ExtendedPlayer : Player {
    override static var databaseSelection: [SQLSelectable] {
        return [AllColumns(), Column.rowID]
    }
}

// SELECT *, rowid FROM player
try ExtendedPlayer.fetchAll(db)

Defines the values persisted in the database.

Store in the container argument all values that should be stored in the columns of the database table (see Record.databaseTableName()).

Primary key columns, if any, must be included.

class Player : Record {
    var id: Int64?
    var name: String?

    override func encode(to container: inout PersistenceContainer) {
        container["id"] = id
        container["name"] = name
    }
}

The implementation of the base class Record does not store any value in the container.

Notifies the record that it was successfully 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.

The implementation of the base Record class does nothing.

class Player : Record {
    var id: Int64?
    var name: String?

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

Returns a copy of self, initialized from all values encoded in the encode(to:) method.

The eventual primary key is copied, as well as the hasDatabaseChanges flag.

A boolean that indicates whether the record has changes that have not been saved.

This flag is purely informative, and does not prevent insert(), update(), and save() from performing their database queries.

A record is edited if has been changed since last database synchronization (fetch, update, insert). Comparison is performed between values (values stored in the encode(to:) method, and values loaded from the database). Property setters do not trigger this flag.

You can rely on the Record base class to compute this flag for you, or you may set it to true or false when you know better. Setting it to false does not prevent it from turning true on subsequent modifications of the record.

A dictionary of changes that have not been saved.

Its keys are column names, and values the old values that have been changed since last fetching or saving of the record.

Unless the record has actually been fetched or saved, the old values are nil.

See hasDatabaseChanges for more information.

Executes an INSERT statement.

On success, this method sets the hasDatabaseChanges flag to false.

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

Records whose primary key is declared as “INTEGER PRIMARY KEY” have their id automatically set after successful insertion, if it was nil before the insertion.

Executes an UPDATE statement.

On success, this method sets the hasDatabaseChanges flag to false.

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

If the record has been changed, executes an UPDATE statement so that those changes and only those changes are saved in the database.

On success, this method sets the hasDatabaseChanges flag to false.

This method is guaranteed to have saved the eventual changes in the database if it returns without error.

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

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

Otherwise, performs an insert.

On success, this method sets the hasDatabaseChanges flag to false.

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

You can’t override this method. Instead, override insert(_:) or update(_:columns:).

Executes a DELETE statement.

On success, this method sets the hasDatabaseChanges flag to true.