Instance Methodgrdb 7.1.0GRDB

fetchAll(_:)

Returns an array of fetched values.

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

Parameters

db

A database connection.

Returns

An array of values.

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)
        .select(Column("score"), as: Int.self)

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

    let scores = try request.fetchAll(db)
}

Values are decoded from the leftmost column.