Struct sqlite::Statement

source ·

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

Expand description

A prepared statement.

Implementations§

source §

impl<'l> Statement<'l>

source

pub fn bind<T: Bindable>(&mut self, value: T) -> Result<()>

Bind values to parameters.

In case of integer indices, the first parameter has index 1.

Examples

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

let query = "SELECT * FROM users WHERE name = ?";
let mut statement = connection.prepare(query)?;
statement.bind(&[(1, "Bob")][..])?;

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

let query = "SELECT * FROM users WHERE name = :name";
let mut statement = connection.prepare(query)?;
statement.bind(&[(":name", "Bob")][..])?;

let query = "SELECT * FROM users WHERE id = :id AND name = :name";
let mut statement = connection.prepare(query)?;
statement.bind::<&[(_, Value)]>(&[
    (":id", 1.into()),
    (":name", "Bob".into()),
][..])?;

source

pub fn bind_iter<T, U>(&mut self, value: T) -> Result<()>
where T: IntoIterator<Item = U>, U: Bindable,

Bind values to parameters via an iterator.

Examples

let query = "INSERT INTO users VALUES (:id, :name)";
let mut statement = connection.prepare(query)?;
statement.bind_iter::<_, (_, Value)>([
    (":name", "Bob".into()),
    (":id", 42.into()),
])?;

source

pub fn iter(&mut self) -> Cursor<'l, '_> ⓘ

Create a cursor.

source

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.

source

pub fn read<T, U>(&self, index: U) -> Result<T>
where T: ReadableWithIndex, U: ColumnIndex,

Read a value from a column.

In case of integer indices, the first column has index 0.

source

pub fn column_count(&self) -> usize

Return the number of columns.

source

pub fn column_name<T: ColumnIndex>(&self, index: T) -> Result<&str>

Return the name of a column.

In case of integer indices, the first column has index 0.

source

pub fn column_names(&self) -> &[String]

Return column names.

source

pub fn column_type<T: ColumnIndex>(&self, index: T) -> Result<Type>

Return the type of a column.

The type becomes available after taking a step. In case of integer indices, the first column has index 0.

source

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

Return the index for a named parameter if exists.

Examples

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