SelectStatement

public final class SelectStatement : Statement

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 persons WHERE age > ?")
    let moreThanTwentyCount = try Int.fetchOne(statement, arguments: [20])!
    let moreThanThirtyCount = try Int.fetchOne(statement, arguments: [30])!
}

  • The number of columns in the resulting rows.

    Declaration

    Swift

    public lazy var columnCount: Int =
    Show on GitHub

  • The column names, ordered from left to right.

    Declaration

    Swift

    public lazy var columnNames: [String] =
    Show on GitHub