SelectStatement
public final class SelectStatement : Statement, AuthorizedStatement
A subclass of Statement that fetches database rows.
You create SelectStatement with the Database.makeSelectStatement() method:
try dbQueue.inDatabase { db in
let statement = try db.makeSelectStatement("SELECT COUNT(*) FROM players WHERE score > ?")
let moreThanTwentyCount = try Int.fetchOne(statement, arguments: [20])!
let moreThanThirtyCount = try Int.fetchOne(statement, arguments: [30])!
}
-
Undocumented
Declaration
Swift
public var selectionInfo: DatabaseRegion
-
The database region that the statement looks into.
Declaration
Swift
public private(set) var fetchedRegion: DatabaseRegion
-
The number of columns in the resulting rows.
Declaration
Swift
public var columnCount: Int
-
The column names, ordered from left to right.
Declaration
Swift
public lazy var columnNames: [String] =
-
Returns the index of the leftmost column named
name
, in a case-insensitive way.Declaration
Swift
public func index(ofColumn name: String) -> Int?
-
Declaration
Swift
public var layoutColumns: [(Int, String)]
-
Declaration
Swift
public func layoutIndex(ofColumn name: String) -> Int?