SelectionRequest

public protocol SelectionRequest

The protocol for all requests that can refine their selection.

  • select(_:) Default implementation

    Creates a request with a new set of selected columns.

    // SELECT id, email FROM player
    var request = Player.all()
    request = request.select([Column("id"), Column("email")])
    

    Any previous selection is replaced:

    // SELECT email FROM player
    request
        .select([Column("id")])
        .select([Column("email")])
    

    Default Implementation

    Creates a request with a new set of selected columns.

    // SELECT id, email FROM player
    var request = Player.all()
    request = request.select(Column("id"), Column("email"))
    

    Any previous selection is replaced:

    // SELECT email FROM player
    request
        .select(Column("id"))
        .select(Column("email"))
    

    Declaration

    Swift

    func select(_ selection: [SQLSelectable]) -> Self
  • select(sql:arguments:) Extension method

    Creates a request with a new set of selected columns.

    // SELECT id, email FROM player
    var request = Player.all()
    request = request.select(sql: "id, email")
    

    Any previous selection is replaced:

    // SELECT email FROM player
    request
        .select(sql: "id")
        .select(sql: "email")
    

    Declaration

    Swift

    public func select(sql: String, arguments: StatementArguments? = nil) -> Self