SelectStatement

public final class SelectStatement : Statement
extension SelectStatement: _RowLayout

A subclass of Statement that fetches database rows.

You create SelectStatement with the Database.makeSelectStatement() method:

try dbQueue.read { db in
    let statement = try db.makeSelectStatement(sql: "SELECT COUNT(*) FROM player WHERE score > ?")
    let moreThanTwentyCount = try Int.fetchOne(statement, arguments: [20])!
    let moreThanThirtyCount = try Int.fetchOne(statement, arguments: [30])!
}
Show on GitHub

  • The number of columns in the resulting rows.

    Declaration

    Swift

    public var columnCount: Int { get }
    Show on GitHub

  • The column names, ordered from left to right.

    Declaration

    Swift

    public lazy var columnNames: [String] { get set }
    Show on GitHub

  • Returns the index of the leftmost column named name, in a case-insensitive way.

    Declaration

    Swift

    public func index(ofColumn name: String) -> Int?
    Show on GitHub