SQLRequest
public struct SQLRequest<T> : FetchRequest
A FetchRequest built from raw SQL.
-
Declaration
Swift
public typealias RowDecoder = T
-
Undocumented
Declaration
Swift
public var sql: String
-
Undocumented
Declaration
Swift
public var arguments: StatementArguments?
-
Undocumented
Declaration
Swift
public var adapter: RowAdapter?
-
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
-
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