mirror of
https://github.com/groue/GRDB.swift
synced 2026-11-22 04:00:39 +00:00
807 lines
31 KiB
Swift
807 lines
31 KiB
Swift
/// The `StatementColumnConvertible` protocol grants access to the low-level C
|
|
/// interface that extracts values from query results:
|
|
/// https://www.sqlite.org/c3ref/column_blob.html. It can bring performance
|
|
/// improvements.
|
|
///
|
|
/// To use it, have a value type adopt both `StatementColumnConvertible` and
|
|
/// `DatabaseValueConvertible`. GRDB will then automatically apply the
|
|
/// optimization whenever direct access to SQLite is possible:
|
|
///
|
|
/// let rows = Row.fetchCursor(db, sql: "SELECT ...")
|
|
/// while let row = try rows.next() {
|
|
/// let int: Int = row[0] // there
|
|
/// }
|
|
/// let ints = Int.fetchAll(db, sql: "SELECT ...") // there
|
|
/// struct Player {
|
|
/// init(row: Row) {
|
|
/// name = row["name"] // there
|
|
/// score = row["score"] // there
|
|
/// }
|
|
/// }
|
|
///
|
|
/// `StatementColumnConvertible` is already adopted by all Swift integer types,
|
|
/// `Float`, `Double`, `String`, and `Bool`.
|
|
public protocol StatementColumnConvertible {
|
|
|
|
/// Initializes a value from a raw SQLite statement pointer.
|
|
///
|
|
/// For example, here is the how Int64 adopts StatementColumnConvertible:
|
|
///
|
|
/// extension Int64: StatementColumnConvertible {
|
|
/// init(sqliteStatement: SQLiteStatement, index: Int32) {
|
|
/// self = sqlite3_column_int64(sqliteStatement, index)
|
|
/// }
|
|
/// }
|
|
///
|
|
/// This initializer is never called for NULL database values: don't perform
|
|
/// any extra check.
|
|
///
|
|
/// See https://www.sqlite.org/c3ref/column_blob.html for more information.
|
|
///
|
|
/// - parameters:
|
|
/// - sqliteStatement: A pointer to an SQLite statement.
|
|
/// - index: The column index.
|
|
init(sqliteStatement: SQLiteStatement, index: Int32)
|
|
}
|
|
|
|
/// A cursor of database values extracted from a single column.
|
|
/// For example:
|
|
///
|
|
/// try dbQueue.read { db in
|
|
/// let names: ColumnCursor<String> = try String.fetchCursor(db, sql: "SELECT name FROM player")
|
|
/// while let name = names.next() { // String
|
|
/// print(name)
|
|
/// }
|
|
/// }
|
|
public final class FastDatabaseValueCursor<Value: DatabaseValueConvertible & StatementColumnConvertible> : Cursor {
|
|
@usableFromInline let _statement: SelectStatement
|
|
@usableFromInline let _columnIndex: Int32
|
|
@usableFromInline let _sqliteStatement: SQLiteStatement
|
|
@usableFromInline var _done = false
|
|
|
|
init(statement: SelectStatement, arguments: StatementArguments? = nil, adapter: RowAdapter? = nil) throws {
|
|
_statement = statement
|
|
_sqliteStatement = statement.sqliteStatement
|
|
if let adapter = adapter {
|
|
// adapter may redefine the index of the leftmost column
|
|
_columnIndex = try Int32(adapter.baseColumnIndex(atIndex: 0, layout: statement))
|
|
} else {
|
|
_columnIndex = 0
|
|
}
|
|
_statement.reset(withArguments: arguments)
|
|
|
|
// Assume cursor is created for iteration
|
|
try statement.database.selectStatementWillExecute(statement)
|
|
}
|
|
|
|
deinit {
|
|
// Statement reset fails when sqlite3_step has previously failed.
|
|
// Just ignore reset error.
|
|
try? _statement.reset()
|
|
}
|
|
|
|
@inlinable
|
|
public func next() throws -> Value? {
|
|
if _done {
|
|
// make sure this instance never yields a value again, even if the
|
|
// statement is reset by another cursor.
|
|
return nil
|
|
}
|
|
switch sqlite3_step(_sqliteStatement) {
|
|
case SQLITE_DONE:
|
|
_done = true
|
|
return nil
|
|
case SQLITE_ROW:
|
|
return Value.fastDecode(from: _sqliteStatement, atUncheckedIndex: _columnIndex)
|
|
case let code:
|
|
try _statement.didFail(withResultCode: code)
|
|
}
|
|
}
|
|
}
|
|
|
|
/// A cursor of optional database values extracted from a single column.
|
|
/// For example:
|
|
///
|
|
/// try dbQueue.read { db in
|
|
/// let emails: FastNullableDatabaseValueCursor<String> =
|
|
/// try Optional<String>.fetchCursor(db, sql: "SELECT email FROM player")
|
|
/// while let email = emails.next() { // String?
|
|
/// print(email ?? "<NULL>")
|
|
/// }
|
|
/// }
|
|
public final class FastNullableDatabaseValueCursor<Value>: Cursor
|
|
where Value: DatabaseValueConvertible & StatementColumnConvertible
|
|
{
|
|
@usableFromInline let _statement: SelectStatement
|
|
@usableFromInline let _columnIndex: Int32
|
|
@usableFromInline let _sqliteStatement: SQLiteStatement
|
|
@usableFromInline var _done = false
|
|
|
|
init(statement: SelectStatement, arguments: StatementArguments? = nil, adapter: RowAdapter? = nil) throws {
|
|
_statement = statement
|
|
_sqliteStatement = statement.sqliteStatement
|
|
if let adapter = adapter {
|
|
// adapter may redefine the index of the leftmost column
|
|
_columnIndex = try Int32(adapter.baseColumnIndex(atIndex: 0, layout: statement))
|
|
} else {
|
|
_columnIndex = 0
|
|
}
|
|
_statement.reset(withArguments: arguments)
|
|
|
|
// Assume cursor is created for iteration
|
|
try statement.database.selectStatementWillExecute(statement)
|
|
}
|
|
|
|
deinit {
|
|
// Statement reset fails when sqlite3_step has previously failed.
|
|
// Just ignore reset error.
|
|
try? _statement.reset()
|
|
}
|
|
|
|
@inlinable
|
|
public func next() throws -> Value?? {
|
|
if _done {
|
|
// make sure this instance never yields a value again, even if the
|
|
// statement is reset by another cursor.
|
|
return nil
|
|
}
|
|
switch sqlite3_step(_sqliteStatement) {
|
|
case SQLITE_DONE:
|
|
_done = true
|
|
return nil
|
|
case SQLITE_ROW:
|
|
return Value.fastDecodeIfPresent(from: _sqliteStatement, atUncheckedIndex: _columnIndex)
|
|
case let code:
|
|
try _statement.didFail(withResultCode: code)
|
|
}
|
|
}
|
|
}
|
|
|
|
/// Types that adopt both DatabaseValueConvertible and
|
|
/// StatementColumnConvertible can be efficiently initialized from
|
|
/// database values.
|
|
///
|
|
/// See DatabaseValueConvertible for more information.
|
|
extension DatabaseValueConvertible where Self: StatementColumnConvertible {
|
|
|
|
|
|
// MARK: Fetching From SelectStatement
|
|
|
|
/// Returns a cursor over values fetched from a prepared statement.
|
|
///
|
|
/// let statement = try db.makeSelectStatement(sql: "SELECT name FROM ...")
|
|
/// let names = try String.fetchCursor(statement) // Cursor of String
|
|
/// while let name = try names.next() { // String
|
|
/// ...
|
|
/// }
|
|
///
|
|
/// If the database is modified during the cursor iteration, the remaining
|
|
/// elements are undefined.
|
|
///
|
|
/// The cursor must be iterated in a protected dispatch queue.
|
|
///
|
|
/// - parameters:
|
|
/// - statement: The statement to run.
|
|
/// - arguments: Optional statement arguments.
|
|
/// - adapter: Optional RowAdapter
|
|
/// - returns: A cursor over fetched values.
|
|
/// - throws: A DatabaseError is thrown whenever an SQLite error occurs.
|
|
public static func fetchCursor(
|
|
_ statement: SelectStatement,
|
|
arguments: StatementArguments? = nil,
|
|
adapter: RowAdapter? = nil)
|
|
throws -> FastDatabaseValueCursor<Self>
|
|
{
|
|
try FastDatabaseValueCursor(statement: statement, arguments: arguments, adapter: adapter)
|
|
}
|
|
|
|
/// Returns an array of values fetched from a prepared statement.
|
|
///
|
|
/// let statement = try db.makeSelectStatement(sql: "SELECT name FROM ...")
|
|
/// let names = try String.fetchAll(statement) // [String]
|
|
///
|
|
/// - parameters:
|
|
/// - statement: The statement to run.
|
|
/// - arguments: Optional statement arguments.
|
|
/// - adapter: Optional RowAdapter
|
|
/// - returns: An array of values.
|
|
/// - throws: A DatabaseError is thrown whenever an SQLite error occurs.
|
|
public static func fetchAll(
|
|
_ statement: SelectStatement,
|
|
arguments: StatementArguments? = nil,
|
|
adapter: RowAdapter? = nil)
|
|
throws -> [Self]
|
|
{
|
|
try Array(fetchCursor(statement, arguments: arguments, adapter: adapter))
|
|
}
|
|
|
|
/// Returns a single value fetched from a prepared statement.
|
|
///
|
|
/// let statement = try db.makeSelectStatement(sql: "SELECT name FROM ...")
|
|
/// let name = try String.fetchOne(statement) // String?
|
|
///
|
|
/// - parameters:
|
|
/// - statement: The statement to run.
|
|
/// - arguments: Optional statement arguments.
|
|
/// - adapter: Optional RowAdapter
|
|
/// - returns: An optional value.
|
|
/// - throws: A DatabaseError is thrown whenever an SQLite error occurs.
|
|
public static func fetchOne(
|
|
_ statement: SelectStatement,
|
|
arguments: StatementArguments? = nil,
|
|
adapter: RowAdapter? = nil)
|
|
throws -> Self?
|
|
{
|
|
// fetchOne returns nil if there is no row, or if there is a row with a null value
|
|
let cursor = try FastNullableDatabaseValueCursor<Self>(
|
|
statement: statement,
|
|
arguments: arguments,
|
|
adapter: adapter)
|
|
return try cursor.next() ?? nil
|
|
}
|
|
}
|
|
|
|
extension DatabaseValueConvertible where Self: StatementColumnConvertible & Hashable {
|
|
/// Returns a set of values fetched from a prepared statement.
|
|
///
|
|
/// let statement = try db.makeSelectStatement(sql: "SELECT name FROM ...")
|
|
/// let names = try String.fetchSet(statement) // Set<String>
|
|
///
|
|
/// - parameters:
|
|
/// - statement: The statement to run.
|
|
/// - arguments: Optional statement arguments.
|
|
/// - adapter: Optional RowAdapter
|
|
/// - returns: A set of values.
|
|
/// - throws: A DatabaseError is thrown whenever an SQLite error occurs.
|
|
public static func fetchSet(
|
|
_ statement: SelectStatement,
|
|
arguments: StatementArguments? = nil,
|
|
adapter: RowAdapter? = nil)
|
|
throws -> Set<Self>
|
|
{
|
|
try Set(fetchCursor(statement, arguments: arguments, adapter: adapter))
|
|
}
|
|
}
|
|
|
|
extension DatabaseValueConvertible where Self: StatementColumnConvertible {
|
|
|
|
// MARK: Fetching From SQL
|
|
|
|
/// Returns a cursor over values fetched from an SQL query.
|
|
///
|
|
/// let names = try String.fetchCursor(db, sql: "SELECT name FROM ...") // Cursor of String
|
|
/// while let name = try names.next() { // String
|
|
/// ...
|
|
/// }
|
|
///
|
|
/// If the database is modified during the cursor iteration, the remaining
|
|
/// elements are undefined.
|
|
///
|
|
/// The cursor must be iterated in a protected dispatch queue.
|
|
///
|
|
/// - parameters:
|
|
/// - db: A database connection.
|
|
/// - sql: An SQL query.
|
|
/// - arguments: Statement arguments.
|
|
/// - adapter: Optional RowAdapter
|
|
/// - returns: A cursor over fetched values.
|
|
/// - throws: A DatabaseError is thrown whenever an SQLite error occurs.
|
|
public static func fetchCursor(
|
|
_ db: Database,
|
|
sql: String,
|
|
arguments: StatementArguments = StatementArguments(),
|
|
adapter: RowAdapter? = nil)
|
|
throws -> FastDatabaseValueCursor<Self>
|
|
{
|
|
try fetchCursor(db, SQLRequest<Void>(sql: sql, arguments: arguments, adapter: adapter))
|
|
}
|
|
|
|
/// Returns an array of values fetched from an SQL query.
|
|
///
|
|
/// let names = try String.fetchAll(db, sql: "SELECT name FROM ...") // [String]
|
|
///
|
|
/// - parameters:
|
|
/// - db: A database connection.
|
|
/// - sql: An SQL query.
|
|
/// - arguments: Statement arguments.
|
|
/// - adapter: Optional RowAdapter
|
|
/// - returns: An array of values.
|
|
/// - throws: A DatabaseError is thrown whenever an SQLite error occurs.
|
|
public static func fetchAll(
|
|
_ db: Database,
|
|
sql: String,
|
|
arguments: StatementArguments = StatementArguments(),
|
|
adapter: RowAdapter? = nil)
|
|
throws -> [Self]
|
|
{
|
|
try fetchAll(db, SQLRequest<Void>(sql: sql, arguments: arguments, adapter: adapter))
|
|
}
|
|
|
|
/// Returns a single value fetched from an SQL query.
|
|
///
|
|
/// let name = try String.fetchOne(db, sql: "SELECT name FROM ...") // String?
|
|
///
|
|
/// - parameters:
|
|
/// - db: A database connection.
|
|
/// - sql: An SQL query.
|
|
/// - arguments: Statement arguments.
|
|
/// - adapter: Optional RowAdapter
|
|
/// - returns: An optional value.
|
|
/// - throws: A DatabaseError is thrown whenever an SQLite error occurs.
|
|
public static func fetchOne(
|
|
_ db: Database,
|
|
sql: String,
|
|
arguments: StatementArguments = StatementArguments(),
|
|
adapter: RowAdapter? = nil)
|
|
throws -> Self?
|
|
{
|
|
try fetchOne(db, SQLRequest<Void>(sql: sql, arguments: arguments, adapter: adapter))
|
|
}
|
|
}
|
|
|
|
extension DatabaseValueConvertible where Self: StatementColumnConvertible & Hashable {
|
|
/// Returns a set of values fetched from an SQL query.
|
|
///
|
|
/// let names = try String.fetchSet(db, sql: "SELECT name FROM ...") // Set<String>
|
|
///
|
|
/// - parameters:
|
|
/// - db: A database connection.
|
|
/// - sql: An SQL query.
|
|
/// - arguments: Statement arguments.
|
|
/// - adapter: Optional RowAdapter
|
|
/// - returns: A set of values.
|
|
/// - throws: A DatabaseError is thrown whenever an SQLite error occurs.
|
|
public static func fetchSet(
|
|
_ db: Database,
|
|
sql: String,
|
|
arguments: StatementArguments = StatementArguments(),
|
|
adapter: RowAdapter? = nil)
|
|
throws -> Set<Self>
|
|
{
|
|
try fetchSet(db, SQLRequest<Void>(sql: sql, arguments: arguments, adapter: adapter))
|
|
}
|
|
}
|
|
|
|
extension DatabaseValueConvertible where Self: StatementColumnConvertible {
|
|
|
|
// MARK: Fetching From FetchRequest
|
|
|
|
/// Returns a cursor over values fetched from a fetch request.
|
|
///
|
|
/// let request = Player.select(Column("name"))
|
|
/// let names = try String.fetchCursor(db, request) // Cursor of String
|
|
/// while let name = try names.next() { // String
|
|
/// ...
|
|
/// }
|
|
///
|
|
/// If the database is modified during the cursor iteration, the remaining
|
|
/// elements are undefined.
|
|
///
|
|
/// The cursor must be iterated in a protected dispatch queue.
|
|
///
|
|
/// - parameters:
|
|
/// - db: A database connection.
|
|
/// - request: A FetchRequest.
|
|
/// - returns: A cursor over fetched values.
|
|
/// - throws: A DatabaseError is thrown whenever an SQLite error occurs.
|
|
public static func fetchCursor<R: FetchRequest>(_ db: Database, _ request: R)
|
|
throws -> FastDatabaseValueCursor<Self>
|
|
{
|
|
let request = try request.makePreparedRequest(db, forSingleResult: false)
|
|
return try fetchCursor(request.statement, adapter: request.adapter)
|
|
}
|
|
|
|
/// Returns an array of values fetched from a fetch request.
|
|
///
|
|
/// let request = Player.select(Column("name"))
|
|
/// let names = try String.fetchAll(db, request) // [String]
|
|
///
|
|
/// - parameters:
|
|
/// - db: A database connection.
|
|
/// - request: A FetchRequest.
|
|
/// - returns: An array of values.
|
|
/// - throws: A DatabaseError is thrown whenever an SQLite error occurs.
|
|
public static func fetchAll<R: FetchRequest>(_ db: Database, _ request: R) throws -> [Self] {
|
|
let request = try request.makePreparedRequest(db, forSingleResult: false)
|
|
return try fetchAll(request.statement, adapter: request.adapter)
|
|
}
|
|
|
|
/// Returns a single value fetched from a fetch request.
|
|
///
|
|
/// let request = Player.filter(key: 1).select(Column("name"))
|
|
/// let name = try String.fetchOne(db, request) // String?
|
|
///
|
|
/// - parameters:
|
|
/// - db: A database connection.
|
|
/// - request: A FetchRequest.
|
|
/// - returns: An optional value.
|
|
/// - throws: A DatabaseError is thrown whenever an SQLite error occurs.
|
|
public static func fetchOne<R: FetchRequest>(_ db: Database, _ request: R) throws -> Self? {
|
|
let request = try request.makePreparedRequest(db, forSingleResult: true)
|
|
return try fetchOne(request.statement, adapter: request.adapter)
|
|
}
|
|
}
|
|
|
|
extension DatabaseValueConvertible where Self: StatementColumnConvertible & Hashable {
|
|
/// Returns a set of values fetched from a fetch request.
|
|
///
|
|
/// let request = Player.select(Column("name"))
|
|
/// let names = try String.fetchSet(db, request) // Set<String>
|
|
///
|
|
/// - parameters:
|
|
/// - db: A database connection.
|
|
/// - request: A FetchRequest.
|
|
/// - returns: A set of values.
|
|
/// - throws: A DatabaseError is thrown whenever an SQLite error occurs.
|
|
public static func fetchSet<R: FetchRequest>(_ db: Database, _ request: R) throws -> Set<Self> {
|
|
let request = try request.makePreparedRequest(db, forSingleResult: false)
|
|
return try fetchSet(request.statement, adapter: request.adapter)
|
|
}
|
|
}
|
|
|
|
extension FetchRequest where RowDecoder: DatabaseValueConvertible & StatementColumnConvertible {
|
|
|
|
// MARK: Fetching Values
|
|
|
|
/// A cursor over fetched values.
|
|
///
|
|
/// let request: ... // Some FetchRequest that fetches String
|
|
/// let strings = try request.fetchCursor(db) // Cursor of String
|
|
/// while let string = try strings.next() { // String
|
|
/// ...
|
|
/// }
|
|
///
|
|
/// If the database is modified during the cursor iteration, the remaining
|
|
/// elements are undefined.
|
|
///
|
|
/// The cursor must be iterated in a protected dispatch queue.
|
|
///
|
|
/// - parameter db: A database connection.
|
|
/// - returns: A cursor over fetched values.
|
|
/// - throws: A DatabaseError is thrown whenever an SQLite error occurs.
|
|
public func fetchCursor(_ db: Database) throws -> FastDatabaseValueCursor<RowDecoder> {
|
|
try RowDecoder.fetchCursor(db, self)
|
|
}
|
|
|
|
/// An array of fetched values.
|
|
///
|
|
/// let request: ... // Some FetchRequest that fetches String
|
|
/// let strings = try request.fetchAll(db) // [String]
|
|
///
|
|
/// - parameter db: A database connection.
|
|
/// - returns: An array of values.
|
|
/// - throws: A DatabaseError is thrown whenever an SQLite error occurs.
|
|
public func fetchAll(_ db: Database) throws -> [RowDecoder] {
|
|
try RowDecoder.fetchAll(db, self)
|
|
}
|
|
|
|
/// The first fetched value.
|
|
///
|
|
/// The result is nil if the request returns no row, or if no value can be
|
|
/// extracted from the first row.
|
|
///
|
|
/// let request: ... // Some FetchRequest that fetches String
|
|
/// let string = try request.fetchOne(db) // String?
|
|
///
|
|
/// - parameter db: A database connection.
|
|
/// - returns: An optional value.
|
|
/// - throws: A DatabaseError is thrown whenever an SQLite error occurs.
|
|
public func fetchOne(_ db: Database) throws -> RowDecoder? {
|
|
try RowDecoder.fetchOne(db, self)
|
|
}
|
|
}
|
|
|
|
extension FetchRequest where RowDecoder: DatabaseValueConvertible & StatementColumnConvertible & Hashable {
|
|
/// A set of fetched values.
|
|
///
|
|
/// let request: ... // Some FetchRequest that fetches String
|
|
/// let strings = try request.fetchSet(db) // Set<String>
|
|
///
|
|
/// - parameter db: A database connection.
|
|
/// - returns: An array of values.
|
|
/// - throws: A DatabaseError is thrown whenever an SQLite error occurs.
|
|
public func fetchSet(_ db: Database) throws -> Set<RowDecoder> {
|
|
try RowDecoder.fetchSet(db, self)
|
|
}
|
|
}
|
|
|
|
/// Swift's Optional comes with built-in methods that allow to fetch cursors
|
|
/// and arrays of optional DatabaseValueConvertible:
|
|
///
|
|
/// try Optional<String>.fetchCursor(db, sql: "SELECT name FROM ...", arguments:...) // Cursor of String?
|
|
/// try Optional<String>.fetchAll(db, sql: "SELECT name FROM ...", arguments:...) // [String?]
|
|
///
|
|
/// let statement = try db.makeSelectStatement(sql: "SELECT name FROM ...")
|
|
/// try Optional<String>.fetchCursor(statement, arguments:...) // Cursor of String?
|
|
/// try Optional<String>.fetchAll(statement, arguments:...) // [String?]
|
|
///
|
|
/// DatabaseValueConvertible is adopted by Bool, Int, String, etc.
|
|
extension Optional where Wrapped: DatabaseValueConvertible & StatementColumnConvertible {
|
|
|
|
// MARK: Fetching From SelectStatement
|
|
|
|
/// Returns a cursor over optional values fetched from a prepared statement.
|
|
///
|
|
/// let statement = try db.makeSelectStatement(sql: "SELECT name FROM ...")
|
|
/// let names = try Optional<String>.fetchCursor(statement) // Cursor of String?
|
|
/// while let name = try names.next() { // String?
|
|
/// ...
|
|
/// }
|
|
///
|
|
/// If the database is modified during the cursor iteration, the remaining
|
|
/// elements are undefined.
|
|
///
|
|
/// The cursor must be iterated in a protected dispatch queue.
|
|
///
|
|
/// - parameters:
|
|
/// - statement: The statement to run.
|
|
/// - arguments: Optional statement arguments.
|
|
/// - adapter: Optional RowAdapter
|
|
/// - returns: A cursor over fetched optional values.
|
|
/// - throws: A DatabaseError is thrown whenever an SQLite error occurs.
|
|
public static func fetchCursor(
|
|
_ statement: SelectStatement,
|
|
arguments: StatementArguments? = nil,
|
|
adapter: RowAdapter? = nil)
|
|
throws -> FastNullableDatabaseValueCursor<Wrapped>
|
|
{
|
|
try FastNullableDatabaseValueCursor(statement: statement, arguments: arguments, adapter: adapter)
|
|
}
|
|
|
|
/// Returns an array of optional values fetched from a prepared statement.
|
|
///
|
|
/// let statement = try db.makeSelectStatement(sql: "SELECT name FROM ...")
|
|
/// let names = try Optional<String>.fetchAll(statement) // [String?]
|
|
///
|
|
/// - parameters:
|
|
/// - statement: The statement to run.
|
|
/// - arguments: Optional statement arguments.
|
|
/// - adapter: Optional RowAdapter
|
|
/// - returns: An array of optional values.
|
|
/// - throws: A DatabaseError is thrown whenever an SQLite error occurs.
|
|
public static func fetchAll(
|
|
_ statement: SelectStatement,
|
|
arguments: StatementArguments? = nil,
|
|
adapter: RowAdapter? = nil)
|
|
throws -> [Wrapped?]
|
|
{
|
|
try Array(fetchCursor(statement, arguments: arguments, adapter: adapter))
|
|
}
|
|
}
|
|
|
|
extension Optional where Wrapped: DatabaseValueConvertible & StatementColumnConvertible & Hashable {
|
|
/// Returns a set of optional values fetched from a prepared statement.
|
|
///
|
|
/// let statement = try db.makeSelectStatement(sql: "SELECT name FROM ...")
|
|
/// let names = try Optional<String>.fetchSet(statement) // Set<String?>
|
|
///
|
|
/// - parameters:
|
|
/// - statement: The statement to run.
|
|
/// - arguments: Optional statement arguments.
|
|
/// - adapter: Optional RowAdapter
|
|
/// - returns: A set of optional values.
|
|
/// - throws: A DatabaseError is thrown whenever an SQLite error occurs.
|
|
public static func fetchSet(
|
|
_ statement: SelectStatement,
|
|
arguments: StatementArguments? = nil,
|
|
adapter: RowAdapter? = nil)
|
|
throws -> Set<Wrapped?>
|
|
{
|
|
try Set(fetchCursor(statement, arguments: arguments, adapter: adapter))
|
|
}
|
|
}
|
|
|
|
extension Optional where Wrapped: DatabaseValueConvertible & StatementColumnConvertible {
|
|
|
|
// MARK: Fetching From SQL
|
|
|
|
/// Returns a cursor over optional values fetched from an SQL query.
|
|
///
|
|
/// let names = try Optional<String>.fetchCursor(db, sql: "SELECT name FROM ...") // Cursor of String?
|
|
/// while let name = try names.next() { // String?
|
|
/// ...
|
|
/// }
|
|
///
|
|
/// If the database is modified during the cursor iteration, the remaining
|
|
/// elements are undefined.
|
|
///
|
|
/// The cursor must be iterated in a protected dispatch queue.
|
|
///
|
|
/// - parameters:
|
|
/// - db: A database connection.
|
|
/// - sql: An SQL query.
|
|
/// - arguments: Statement arguments.
|
|
/// - adapter: Optional RowAdapter
|
|
/// - returns: A cursor over fetched optional values.
|
|
/// - throws: A DatabaseError is thrown whenever an SQLite error occurs.
|
|
public static func fetchCursor(
|
|
_ db: Database,
|
|
sql: String,
|
|
arguments: StatementArguments = StatementArguments(),
|
|
adapter: RowAdapter? = nil)
|
|
throws -> FastNullableDatabaseValueCursor<Wrapped>
|
|
{
|
|
try fetchCursor(db, SQLRequest<Void>(sql: sql, arguments: arguments, adapter: adapter))
|
|
}
|
|
|
|
/// Returns an array of optional values fetched from an SQL query.
|
|
///
|
|
/// let names = try Optional<String>.fetchAll(db, sql: "SELECT name FROM ...") // [String?]
|
|
///
|
|
/// - parameters:
|
|
/// - db: A database connection.
|
|
/// - sql: An SQL query.
|
|
/// - arguments: Statement arguments.
|
|
/// - adapter: Optional RowAdapter
|
|
/// - returns: An array of optional values.
|
|
/// - throws: A DatabaseError is thrown whenever an SQLite error occurs.
|
|
public static func fetchAll(
|
|
_ db: Database,
|
|
sql: String,
|
|
arguments: StatementArguments = StatementArguments(),
|
|
adapter: RowAdapter? = nil)
|
|
throws -> [Wrapped?]
|
|
{
|
|
try fetchAll(db, SQLRequest<Void>(sql: sql, arguments: arguments, adapter: adapter))
|
|
}
|
|
}
|
|
|
|
extension Optional where Wrapped: DatabaseValueConvertible & StatementColumnConvertible & Hashable {
|
|
/// Returns a set of optional values fetched from an SQL query.
|
|
///
|
|
/// let names = try Optional<String>.fetchSet(db, sql: "SELECT name FROM ...") // Set<String?>
|
|
///
|
|
/// - parameters:
|
|
/// - db: A database connection.
|
|
/// - sql: An SQL query.
|
|
/// - arguments: Statement arguments.
|
|
/// - adapter: Optional RowAdapter
|
|
/// - returns: A set of optional values.
|
|
/// - throws: A DatabaseError is thrown whenever an SQLite error occurs.
|
|
public static func fetchSet(
|
|
_ db: Database,
|
|
sql: String,
|
|
arguments: StatementArguments = StatementArguments(),
|
|
adapter: RowAdapter? = nil)
|
|
throws -> Set<Wrapped?>
|
|
{
|
|
try fetchSet(db, SQLRequest<Void>(sql: sql, arguments: arguments, adapter: adapter))
|
|
}
|
|
}
|
|
|
|
extension Optional where Wrapped: DatabaseValueConvertible & StatementColumnConvertible {
|
|
|
|
// MARK: Fetching From FetchRequest
|
|
|
|
/// Returns a cursor over optional values fetched from a fetch request.
|
|
///
|
|
/// let request = Player.select(Column("name"))
|
|
/// let names = try Optional<String>.fetchCursor(db, request) // Cursor of String?
|
|
/// while let name = try names.next() { // String?
|
|
/// ...
|
|
/// }
|
|
///
|
|
/// If the database is modified during the cursor iteration, the remaining
|
|
/// elements are undefined.
|
|
///
|
|
/// The cursor must be iterated in a protected dispatch queue.
|
|
///
|
|
/// - parameters:
|
|
/// - db: A database connection.
|
|
/// - request: A FetchRequest.
|
|
/// - returns: A cursor over fetched optional values.
|
|
/// - throws: A DatabaseError is thrown whenever an SQLite error occurs.
|
|
public static func fetchCursor<R: FetchRequest>(_ db: Database, _ request: R)
|
|
throws -> FastNullableDatabaseValueCursor<Wrapped>
|
|
{
|
|
let request = try request.makePreparedRequest(db, forSingleResult: false)
|
|
return try fetchCursor(request.statement, adapter: request.adapter)
|
|
}
|
|
|
|
/// Returns an array of optional values fetched from a fetch request.
|
|
///
|
|
/// let request = Player.select(Column("name"))
|
|
/// let names = try Optional<String>.fetchAll(db, request) // [String?]
|
|
///
|
|
/// - parameters:
|
|
/// - db: A database connection.
|
|
/// - request: A FetchRequest.
|
|
/// - returns: An array of optional values.
|
|
/// - throws: A DatabaseError is thrown whenever an SQLite error occurs.
|
|
public static func fetchAll<R: FetchRequest>(_ db: Database, _ request: R) throws -> [Wrapped?] {
|
|
let request = try request.makePreparedRequest(db, forSingleResult: false)
|
|
return try fetchAll(request.statement, adapter: request.adapter)
|
|
}
|
|
}
|
|
|
|
extension Optional where Wrapped: DatabaseValueConvertible & StatementColumnConvertible & Hashable {
|
|
/// Returns a set of optional values fetched from a fetch request.
|
|
///
|
|
/// let request = Player.select(Column("name"))
|
|
/// let names = try Optional<String>.fetchSet(db, request) // Set<String?>
|
|
///
|
|
/// - parameters:
|
|
/// - db: A database connection.
|
|
/// - request: A FetchRequest.
|
|
/// - returns: A set of optional values.
|
|
/// - throws: A DatabaseError is thrown whenever an SQLite error occurs.
|
|
public static func fetchSet<R: FetchRequest>(_ db: Database, _ request: R) throws -> Set<Wrapped?> {
|
|
let request = try request.makePreparedRequest(db, forSingleResult: false)
|
|
return try fetchSet(request.statement, adapter: request.adapter)
|
|
}
|
|
}
|
|
|
|
extension FetchRequest
|
|
where
|
|
RowDecoder: _OptionalProtocol,
|
|
RowDecoder.Wrapped: DatabaseValueConvertible & StatementColumnConvertible
|
|
{
|
|
|
|
// MARK: Fetching Optional values
|
|
|
|
/// A cursor over fetched optional values.
|
|
///
|
|
/// let request: ... // Some FetchRequest that fetches Optional<String>
|
|
/// let strings = try request.fetchCursor(db) // Cursor of String?
|
|
/// while let string = try strings.next() { // String?
|
|
/// ...
|
|
/// }
|
|
///
|
|
/// If the database is modified during the cursor iteration, the remaining
|
|
/// elements are undefined.
|
|
///
|
|
/// The cursor must be iterated in a protected dispatch queue.
|
|
///
|
|
/// - parameter db: A database connection.
|
|
/// - returns: A cursor over fetched values.
|
|
/// - throws: A DatabaseError is thrown whenever an SQLite error occurs.
|
|
public func fetchCursor(_ db: Database) throws -> FastNullableDatabaseValueCursor<RowDecoder.Wrapped> {
|
|
try Optional<RowDecoder.Wrapped>.fetchCursor(db, self)
|
|
}
|
|
|
|
/// An array of fetched optional values.
|
|
///
|
|
/// let request: ... // Some FetchRequest that fetches Optional<String>
|
|
/// let strings = try request.fetchAll(db) // [String?]
|
|
///
|
|
/// - parameter db: A database connection.
|
|
/// - returns: An array of values.
|
|
/// - throws: A DatabaseError is thrown whenever an SQLite error occurs.
|
|
public func fetchAll(_ db: Database) throws -> [RowDecoder.Wrapped?] {
|
|
try Optional<RowDecoder.Wrapped>.fetchAll(db, self)
|
|
}
|
|
|
|
/// The first fetched value.
|
|
///
|
|
/// The result is nil if the request returns no row, or if no value can be
|
|
/// extracted from the first row.
|
|
///
|
|
/// let request: ... // Some FetchRequest that fetches String?
|
|
/// let string = try request.fetchOne(db) // String?
|
|
///
|
|
/// - parameter db: A database connection.
|
|
/// - returns: An optional value.
|
|
/// - throws: A DatabaseError is thrown whenever an SQLite error occurs.
|
|
public func fetchOne(_ db: Database) throws -> RowDecoder.Wrapped? {
|
|
try RowDecoder.Wrapped.fetchOne(db, self)
|
|
}
|
|
}
|
|
|
|
extension FetchRequest
|
|
where
|
|
RowDecoder: _OptionalProtocol,
|
|
RowDecoder.Wrapped: DatabaseValueConvertible & StatementColumnConvertible & Hashable
|
|
{
|
|
/// A set of fetched optional values.
|
|
///
|
|
/// let request: ... // Some FetchRequest that fetches Optional<String>
|
|
/// let strings = try request.fetchSet(db) // Set<String?>
|
|
///
|
|
/// - parameter db: A database connection.
|
|
/// - returns: A set of values.
|
|
/// - throws: A DatabaseError is thrown whenever an SQLite error occurs.
|
|
public func fetchSet(_ db: Database) throws -> Set<RowDecoder.Wrapped?> {
|
|
try Optional<RowDecoder.Wrapped>.fetchSet(db, self)
|
|
}
|
|
}
|