SQLRequest

public struct SQLRequest<T> : FetchRequest

A FetchRequest built from raw SQL.

  • Declaration

    Swift

    public typealias RowDecoder = T
    Show on GitHub
  • sql

    Undocumented

    Declaration

    Swift

    public var sql: String
    Show on GitHub

  • Undocumented

    Declaration

    Swift

    public var arguments: StatementArguments?
    Show on GitHub

  • Undocumented

    Declaration

    Swift

    public var adapter: RowAdapter?
    Show on GitHub

  • Creates a request from an SQL string, optional arguments, and optional row adapter.

    let request = SQLRequest("SELECT * FROM player")
let request = SQLRequest("SELECT * FROM player WHERE id = ?", arguments: [1])

    Declaration

    Swift

    public init(_ sql: String, arguments: StatementArguments? = nil, adapter: RowAdapter? = nil, cached: Bool = false)

    Parameters

    sql

    An SQL query.
    arguments

    Optional statement arguments.
    adapter

    Optional RowAdapter.
    cached

    Defaults to false. If true, the request reuses a cached prepared statement.

    Return Value

    A SQLRequest

    Show on GitHub

  • Creates an SQL request from any other fetch request.

    Declaration

    Swift

    public init<Request: FetchRequest>(_ db: Database, request: Request, cached: Bool = false) throws where Request.RowDecoder == RowDecoder

    Parameters

    db

    A database connection.
    request

    A request.
    cached

    Defaults to false. If true, the request reuses a cached prepared statement.

    Return Value

    An SQLRequest

    Show on GitHub