Statement

A prepared statement.

This struct is a reference-counted wrapper around a sqlite3_stmt* pointer. Instances of this struct are typically returned by Database.prepare().

struct Statement {

import std.meta : allSatisfy;;

import std.traits : isIntegral, isSomeChar, isBoolean, isFloatingPoint, isSomeString, isStaticArray, isDynamicArray, isIterable;;

import std.traits : isIntegral, isSomeChar, isBoolean, isFloatingPoint, isSomeString, isStaticArray, isDynamicArray, isIterable;;

import std.traits : isIntegral, isSomeChar, isBoolean, isFloatingPoint, isSomeString, isStaticArray, isDynamicArray, isIterable;;

import std.traits : isIntegral, isSomeChar, isBoolean, isFloatingPoint, isSomeString, isStaticArray, isDynamicArray, isIterable;;

import std.traits : isIntegral, isSomeChar, isBoolean, isFloatingPoint, isSomeString, isStaticArray, isDynamicArray, isIterable;;

import std.traits : isIntegral, isSomeChar, isBoolean, isFloatingPoint, isSomeString, isStaticArray, isDynamicArray, isIterable;;

import std.traits : isIntegral, isSomeChar, isBoolean, isFloatingPoint, isSomeString, isStaticArray, isDynamicArray, isIterable;;

import std.traits : isIntegral, isSomeChar, isBoolean, isFloatingPoint, isSomeString, isStaticArray, isDynamicArray, isIterable;;

import std.typecons : RefCounted, RefCountedAutoInitialize;;

import std.typecons : RefCounted, RefCountedAutoInitialize;;

inout(sqlite3_stmt)* handle();

void finalize();

bool empty();

void bind(int index, T value);

void bind(string name, T value);

void bindAll(Args args);

void clearBindings();

ResultRange execute();

void reset();

void inject(Args args);

void inject(T obj);

void inject(T obj);

int parameterCount();

string parameterName(int index);

int parameterIndex(string name);

}

Constructors

this this(Database db, string sql): Undocumented in source.

Members

Functions

bind void bind(int index, T value): Binds values to parameters of this statement, using parameter index.
bind void bind(string name, T value): Binds values to parameters of this statement, using parameter names.
bindAll void bindAll(Args args): Binds all the arguments at once in order.
clearBindings void clearBindings(): Clears the bindings.
empty bool empty(): Tells whether the statement is empty (no SQL statement).
execute ResultRange execute(): Executes the statement and return a (possibly empty) range of results.
finalize void finalize(): Explicitly finalizes the prepared statement.
handle inout(sqlite3_stmt)* handle(): Gets the SQLite internal handle of the statement.
inject void inject(Args args): Binds arguments, executes and resets the statement, in one call.
inject void inject(T obj): Binds the fields of a struct in order, executes and resets the statement, in one call.
inject void inject(T obj): Binds iterable values in order, executes and resets the statement, in one call.
parameterCount int parameterCount(): Gets the count of bind parameters.
parameterIndex int parameterIndex(string name): Gets the index of a bind parameter.
parameterName string parameterName(int index): Gets the name of the bind parameter at the given index.
reset void reset(): Resets a this statement before a new execution.
waitForUnlockNotify auto waitForUnlockNotify(): Setup and waits for unlock notify using the provided IUnlockNotifyHandler

Meta

Source

See Implementation

d2sqlite3 statement functions

literal

structs

Statement