Struct sqlite::Statement

pub struct Statement<'l> { /* private fields */ }

A prepared statement.

Implementations

impl<'l> Statement<'l>

pub fn bind<T: Bindable>(self, i: usize, value: T) -> Result<Self>

Bind a value to a parameter by index.

The first parameter has index 1.

pub fn bind_by_name<T: Bindable>(self, name: &str, value: T) -> Result<Self>

Bind a value to a parameter by name.

Examples

let mut statement = connection.prepare("SELECT * FROM users WHERE name = :name")?;
statement.bind_by_name(":name", "Bob")?;

pub fn column_count(&self) -> usize

Return the number of columns.

pub fn column_name(&self, i: usize) -> &str

Return the name of a column.

The first column has index 0.

pub fn column_names(&self) -> Vec<&str>

Return column names.

pub fn column_type(&self, i: usize) -> Type

Return the type of a column.

The first column has index 0. The type becomes available after taking a step.

pub fn next(&mut self) -> Result<State>

Advance to the next state.

The function should be called multiple times until State::Done is reached in order to evaluate the statement entirely.

pub fn parameter_index(&self, parameter: &str) -> Result<Option<usize>>

Return the index for a named parameter if exists.

Examples

let statement = connection.prepare("SELECT * FROM users WHERE name = :name")?;
assert_eq!(statement.parameter_index(":name")?.unwrap(), 1);
assert_eq!(statement.parameter_index(":asdf")?, None);

pub fn read<T: Readable>(&self, i: usize) -> Result<T>

Read a value from a column.

The first column has index 0.

pub fn reset(self) -> Result<Self>

Reset the statement.

pub fn into_cursor(self) -> Cursor<'l>

Upgrade to a cursor.

pub fn as_raw(&self) -> *mut sqlite3_stmt

Return the raw pointer.

Trait Implementations

impl<'l> Drop for Statement<'l>

fn drop(&mut self)

Executes the destructor for this type.