fetchOne(_:_:)
Returns a single record fetched from a fetch request.
static func fetchOne(_ db: Database, _ request: some FetchRequest) throws -> Self?
Parameters
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)
}