SQLRequest

public struct SQLRequest : Request

A Request built from raw SQL.

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

    let request = SQLRequest("SELECT * FROM persons")
let request = SQLRequest("SELECT * FROM persons 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

  • A tuple that contains a prepared statement that is ready to be executed, and an eventual row adapter.

    Declaration

    Swift

    public func prepare(_ db: Database) throws -> (SelectStatement, RowAdapter?)
    Show on GitHub