RowConvertible

Initializes a record from row.

For performance reasons, the row argument may be reused during the iteration of a fetch query. If you want to keep the row for later use, make sure to store a copy: self.row = row.copy().

A cursor over all records fetched from the database.

let persons = try Person.fetchCursor(db) // DatabaseCursor<Person>
while let person = try persons.next() {  // Person
    ...
}

Records are iterated in the natural ordering of the table.

If the database is modified during the cursor iteration, the remaining elements are undefined.

The cursor must be iterated in a protected dispath queue.

An array of all records fetched from the database.

let persons = try Person.fetchAll(db) // [Person]

The first found record.

let person = try Person.fetchOne(db) // Person?

Returns a cursor over records, given their primary keys.

let persons = try Person.fetchCursor(db, keys: [1, 2, 3]) // DatabaseCursor<Person>
while let person = try persons.next() {
    ...
}

Records are iterated in unspecified order.

Returns an array of records, given their primary keys.

let persons = try Person.fetchAll(db, keys: [1, 2, 3]) // [Person]

The order of records in the returned array is undefined.

Returns a single record given its primary key.

let person = try Person.fetchOne(db, key: 123) // Person?

Returns a cursor over records identified by the provided unique keys (primary key or any key with a unique index on it).

let persons = try Person.fetchCursor(db, keys: [["email": "a@example.com"], ["email": "b@example.com"]]) // DatabaseCursor<Person>
while let person = try persons.next() { // Person
    ...
}

Records are iterated in unspecified order.

Returns an array of records identified by the provided unique keys (primary key or any key with a unique index on it).

let persons = try Person.fetchAll(db, keys: [["email": "a@example.com"], ["email": "b@example.com"]]) // [Person]

The order of records in the returned array is undefined.

Returns a single record identified by a unique key (the primary key or any key with a unique index on it).

let person = try Person.fetchOne(db, key: ["name": Arthur"]) // Person?

A cursor over records fetched from a prepared statement.

let statement = try db.makeSelectStatement("SELECT * FROM persons")
let persons = try Person.fetchCursor(statement) // DatabaseCursor<Person>
while let person = try persons.next() { // Person
    ...
}

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 records fetched from a prepared statement.

let statement = try db.makeSelectStatement("SELECT * FROM persons")
let persons = try Person.fetchAll(statement) // [Person]

Returns a single record fetched from a prepared statement.

let statement = try db.makeSelectStatement("SELECT * FROM persons")
let person = try Person.fetchOne(statement) // Person?

Returns a cursor over records fetched from a fetch request.

let nameColumn = Column("firstName")
let request = Person.order(nameColumn)
let identities = try Identity.fetchCursor(db, request) // DatabaseCursor<Identity>
while let identity = try identities.next() { // Identity
    ...
}

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 records fetched from a fetch request.

let nameColumn = Column("name")
let request = Person.order(nameColumn)
let identities = try Identity.fetchAll(db, request) // [Identity]

Returns a single record fetched from a fetch request.

let nameColumn = Column("name")
let request = Person.order(nameColumn)
let identity = try Identity.fetchOne(db, request) // Identity?

Returns a cursor over records fetched from an SQL query.

let persons = try Person.fetchCursor(db, "SELECT * FROM persons") // DatabaseCursor<Person>
while let person = try persons.next() { // Person
    ...
}

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 records fetched from an SQL query.

let persons = try Person.fetchAll(db, "SELECT * FROM persons") // [Person]

Returns a single record fetched from an SQL query.

let person = try Person.fetchOne(db, "SELECT * FROM persons") // Person?