Instance Methodgrdb 7.1.0GRDB
fetchAll(_:)
Returns an array of fetched values.
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.