Optional

Returns a cursor over optional values fetched from a prepared statement.

let statement = try db.makeSelectStatement("SELECT name FROM ...")
let names = try Optional<String>.fetchCursor(statement) // DatabaseCursor<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 dispath queue.

Returns an array of optional values fetched from a prepared statement.

let statement = try db.makeSelectStatement("SELECT name FROM ...")
let names = try Optional<String>.fetchAll(statement)  // [String?]

Returns a cursor over optional values fetched from a fetch request.

let nameColumn = Column("name")
let request = Person.select(nameColumn)
let names = try Optional<String>.fetchCursor(db, request) // DatabaseCursor<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 dispath queue.

Returns an array of optional values fetched from a fetch request.

let nameColumn = Column("name")
let request = Person.select(nameColumn)
let names = try Optional<String>.fetchAll(db, request) // [String?]

Returns a cursor over optional values fetched from an SQL query.

let names = try Optional<String>.fetchCursor(db, "SELECT name FROM ...") // DatabaseCursor<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 dispath queue.

Returns an array of optional values fetched from an SQL query.

let names = try String.fetchAll(db, "SELECT name FROM ...") // [String?]