Static Methodgrdb 7.4.0GRDB

fetchOne(_:_:)

Returns a single record fetched from a fetch request.

FetchableRecord.swift:650
static func fetchOne(_ db: Database, _ request: some FetchRequest) throws -> Self?

Parameters

db

A database connection.

request

a fetch request.

Returns

An optional record.

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) LIMIT 1
        """

    let player = try Player.fetchOne(db, request)
}