/// Types that adopt DatabaseValueConvertible can be initialized from /// database values. /// /// The protocol comes with built-in methods that allow to fetch cursors, /// arrays, or single values: /// /// try String.fetchCursor(db, sql: "SELECT name FROM ...", arguments:...) // Cursor of String /// try String.fetchAll(db, sql: "SELECT name FROM ...", arguments:...) // [String] /// try String.fetchOne(db, sql: "SELECT name FROM ...", arguments:...) // String? /// /// let statement = try db.makeSelectStatement(sql: "SELECT name FROM ...") /// try String.fetchCursor(statement, arguments:...) // Cursor of String /// try String.fetchAll(statement, arguments:...) // [String] /// try String.fetchOne(statement, arguments:...) // String? /// /// DatabaseValueConvertible is adopted by Bool, Int, String, etc. public protocol DatabaseValueConvertible: SQLExpressible { /// Returns a value that can be stored in the database. var databaseValue: DatabaseValue { get } /// Returns a value initialized from *dbValue*, if possible. static func fromDatabaseValue(_ dbValue: DatabaseValue) -> Self? } extension DatabaseValueConvertible { /// :nodoc: public var sqlExpression: SQLExpression { databaseValue } } /// A cursor of database values extracted from a single column. /// For example: /// /// try dbQueue.read { db in /// let urls: DatabaseValueCursor = try URL.fetchCursor(db, sql: "SELECT url FROM link") /// while let url = urls.next() { // URL /// print(url) /// } /// } public final class DatabaseValueCursor: Cursor { @usableFromInline let _statement: SelectStatement @usableFromInline let _sqliteStatement: SQLiteStatement @usableFromInline let _columnIndex: Int32 @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.decode(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 urls: NullableDatabaseValueCursor = try Optional.fetchCursor(db, sql: "SELECT url FROM link") /// while let url = urls.next() { // URL? /// print(url) /// } /// } public final class NullableDatabaseValueCursor: Cursor { @usableFromInline let _statement: SelectStatement @usableFromInline let _sqliteStatement: SQLiteStatement @usableFromInline let _columnIndex: Int32 @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.decodeIfPresent(from: _sqliteStatement, atUncheckedIndex: _columnIndex) case let code: try _statement.didFail(withResultCode: code) } } } /// DatabaseValueConvertible comes with built-in methods that allow to fetch /// cursors, arrays, or single values: /// /// try String.fetchCursor(db, sql: "SELECT name FROM ...", arguments:...) // Cursor of String /// try String.fetchAll(db, sql: "SELECT name FROM ...", arguments:...) // [String] /// try String.fetchOne(db, sql: "SELECT name FROM ...", arguments:...) // String? /// /// let statement = try db.makeSelectStatement(sql: "SELECT name FROM ...") /// try String.fetchCursor(statement, arguments:...) // Cursor of String /// try String.fetchAll(statement, arguments:...) // [String] /// try String.fetchOne(statement, arguments:...) // String /// /// DatabaseValueConvertible is adopted by Bool, Int, String, etc. extension DatabaseValueConvertible { // 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 -> DatabaseValueCursor { try DatabaseValueCursor(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. /// - 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. /// /// The result is nil if the query returns no row, or if no value can be /// extracted from the first row. /// /// 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 NullableDatabaseValueCursor(statement: statement, arguments: arguments, adapter: adapter) return try cursor.next() ?? nil } } extension DatabaseValueConvertible where Self: 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 /// /// - parameters: /// - statement: The statement to run. /// - arguments: Optional statement arguments. /// - adapter: Optional RowAdapter /// - returns: A set. /// - throws: A DatabaseError is thrown whenever an SQLite error occurs. public static func fetchSet( _ statement: SelectStatement, arguments: StatementArguments? = nil, adapter: RowAdapter? = nil) throws -> Set { try Set(fetchCursor(statement, arguments: arguments, adapter: adapter)) } } extension DatabaseValueConvertible { // 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 name.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 -> DatabaseValueCursor { try fetchCursor(db, SQLRequest(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. /// - 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(sql: sql, arguments: arguments, adapter: adapter)) } /// Returns a single value fetched from an SQL query. /// /// The result is nil if the query returns no row, or if no value can be /// extracted from the first row. /// /// 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(sql: sql, arguments: arguments, adapter: adapter)) } } extension DatabaseValueConvertible where Self: Hashable { /// Returns a set of values fetched from an SQL query. /// /// let names = try String.fetchSet(db, sql: "SELECT name FROM ...") // Set /// /// - parameters: /// - db: A database connection. /// - sql: An SQL query. /// - arguments: Statement arguments. /// - adapter: Optional RowAdapter /// - returns: A set. /// - 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 { try fetchSet(db, SQLRequest(sql: sql, arguments: arguments, adapter: adapter)) } } extension DatabaseValueConvertible { // 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 name.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(_ db: Database, _ request: R) throws -> DatabaseValueCursor { 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. /// - throws: A DatabaseError is thrown whenever an SQLite error occurs. public static func fetchAll(_ 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. /// /// The result is nil if the query returns no row, or if no value can be /// extracted from the first row. /// /// 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(_ 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: 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 /// /// - parameters: /// - db: A database connection. /// - request: A FetchRequest. /// - returns: A set. /// - throws: A DatabaseError is thrown whenever an SQLite error occurs. public static func fetchSet(_ db: Database, _ request: R) throws -> Set { let request = try request.makePreparedRequest(db, forSingleResult: false) return try fetchSet(request.statement, adapter: request.adapter) } } extension FetchRequest where RowDecoder: DatabaseValueConvertible { // 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 -> DatabaseValueCursor { 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 & Hashable { /// A set of fetched values. /// /// let request: ... // Some FetchRequest that fetches String /// let strings = try request.fetchSet(db) // Set /// /// - 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 { 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.fetchCursor(db, sql: "SELECT name FROM ...", arguments:...) // Cursor of String? /// try Optional.fetchAll(db, sql: "SELECT name FROM ...", arguments:...) // [String?] /// /// let statement = try db.makeSelectStatement(sql: "SELECT name FROM ...") /// try Optional.fetchCursor(statement, arguments:...) // Cursor of String? /// try Optional.fetchAll(statement, arguments:...) // [String?] /// /// DatabaseValueConvertible is adopted by Bool, Int, String, etc. extension Optional where Wrapped: DatabaseValueConvertible { // 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.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 -> NullableDatabaseValueCursor { try NullableDatabaseValueCursor(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.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 & 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.fetchSet(statement) // Set /// /// - 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 { try Set(fetchCursor(statement, arguments: arguments, adapter: adapter)) } } extension Optional where Wrapped: DatabaseValueConvertible { // MARK: Fetching From SQL /// Returns a cursor over optional values fetched from an SQL query. /// /// let names = try Optional.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 -> NullableDatabaseValueCursor { try fetchCursor(db, SQLRequest(sql: sql, arguments: arguments, adapter: adapter)) } /// Returns an array of optional 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 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(sql: sql, arguments: arguments, adapter: adapter)) } } extension Optional where Wrapped: DatabaseValueConvertible & Hashable { /// Returns a set of optional values fetched from an SQL query. /// /// let names = try String.fetchSet(db, sql: "SELECT name FROM ...") // Set /// /// - 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 { try fetchSet(db, SQLRequest(sql: sql, arguments: arguments, adapter: adapter)) } } extension Optional where Wrapped: DatabaseValueConvertible { // 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.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(_ db: Database, _ request: R) throws -> NullableDatabaseValueCursor { 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.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(_ 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 & Hashable { /// Returns a set of optional values fetched from a fetch request. /// /// let request = Player.select(Column("name")) /// let names = try Optional.fetchSet(db, request) // Set /// /// - 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(_ db: Database, _ request: R) throws -> Set { let request = try request.makePreparedRequest(db, forSingleResult: false) return try fetchSet(request.statement, adapter: request.adapter) } } extension FetchRequest where RowDecoder: _OptionalProtocol, RowDecoder.Wrapped: DatabaseValueConvertible { // MARK: Fetching Optional values /// A cursor over fetched optional values. /// /// let request: ... // Some FetchRequest that fetches Optional /// 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 -> NullableDatabaseValueCursor { try Optional.fetchCursor(db, self) } /// An array of fetched optional values. /// /// let request: ... // Some FetchRequest that fetches Optional /// 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.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 & Hashable { /// A set of fetched optional values. /// /// let request: ... // Some FetchRequest that fetches Optional /// let strings = try request.fetchSet(db) // Set /// /// - 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 { try Optional.fetchSet(db, self) } }