fetchAll(_:_:)

Published Mar 22, 2025

Returns an array of records fetched from a fetch request.

static func fetchAll(_ db: Database, _ request: some FetchRequest) throws -> [Self]

Mangled symbol

s4GRDB15FetchableRecordPAAE8fetchAllySayxGAA8DatabaseC_qd__tKAA12FetchRequestRd__lFZ What are these?

FNV24 hash: ATC7

Parameters

db: A database connection.
request: a fetch request.

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 Player.fetchAll(db, request)
}