Instance Methodgrdb 7.4.0GRDB

fetchAll(_:)

Returns an array of fetched records.

FetchableRecord.swift:770
func fetchAll(_ db: Database) throws -> [RowDecoder]

Parameters

db

A database connection.

Returns

An array of records.

Throws

A DatabaseError whenever an SQLite error occurs.

For example:

try dbQueue.read { db in
    let lastName = "O'Reilly"

    // Query interface request
    let request = Player.filter(Column("lastName") == lastName)

    // SQL request
    let request: SQLRequest<Player> = """
        SELECT * FROM player WHERE lastName = \(lastName)
        """

    let players = try request.fetchAll(db)
}