Statement

The raw SQLite statement, suitable for the SQLite C API.

The SQL query

The statement arguments.

Throws a DatabaseError of code SQLITE_ERROR if arguments don’t fill all statement arguments.

For example:

let statement = try db.makeUpdateArgument(sql: """
    INSERT INTO player (id, name) VALUES (?, ?)
    """)

// OK
statement.validateArguments([1, "Arthur"])

// Throws
statement.validateArguments([1])

See also setArguments(_:)

Set arguments without any validation. Trades safety for performance.

Only call this method if you are sure input arguments match all expected arguments of the statement.

For example:

let statement = try db.makeUpdateArgument(sql: """
    INSERT INTO player (id, name) VALUES (?, ?)
    """)

// OK
statement.setUncheckedArguments([1, "Arthur"])

// OK
let arguments: StatementArguments = ... // some untrusted arguments
try statement.validateArguments(arguments)
statement.setUncheckedArguments(arguments)

// NOT OK
statement.setUncheckedArguments([1])

Set the statement arguments, or throws a DatabaseError of code SQLITE_ERROR if arguments don’t fill all statement arguments.

For example:

let statement = try db.makeUpdateArgument(sql: """
    INSERT INTO player (id, name) VALUES (?, ?)
    """)

// OK
try statement.setArguments([1, "Arthur"])

// Throws an error
try statement.setArguments([1])