Instance Methodgrdb 7.4.0GRDB
none
Returns an empty request that fetches no row.
func none() -> Self
Returns an empty request that fetches no row.
func none() -> Self
import GRDB
A toolkit for SQLite databases, with a focus on application development
protocol FilteredRequest
A request that can filter database rows.
func all() -> Self
Returns self
: a request that fetches all rows from this request.
func filter(_ predicate: some SQLSpecificExpressible) -> Self
Filters the fetched rows with a boolean SQL expression.
func filter(id: RowDecoder.ID) -> Self
Filters by primary key.
func filter(ids: some Collection<RowDecoder.ID>) -> Self
Filters by primary key.
func filter(key: some DatabaseValueConvertible) -> Self
Filters by primary key.
func filter(key: [String : (any DatabaseValueConvertible)?]?) -> Self
Filters by primary or unique key.
func filter<Keys>(keys: Keys) -> Self where Keys : Collection, Keys.Element : DatabaseValueConvertible
Filters by primary key.
func filter(keys: [[String : (any DatabaseValueConvertible)?]]) -> Self
Filters by primary or unique key.
func filter(literal sqlLiteral: SQL) -> Self
Filters the fetched rows with an SQL
literal.
func filter(sql: String, arguments: StatementArguments = StatementArguments()) -> Self
Filters the fetched rows with an SQL string.
func filterWhenConnected(_ predicate: @escaping (Database) throws -> any SQLExpressible) -> Self
Filters the fetched rows with a boolean SQL expression.
func matching(_ pattern: FTS3Pattern?) -> Self
Filters rows that match an FTS3
full-text pattern.
func matching(_ pattern: FTS5Pattern?) -> Self
Filters rows that match an FTS5
full-text pattern.