Struct Statement

pub struct Statement { /* private fields */ }

A prepared statement.

Implementations

impl Statement

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()),
][..])?;

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()),
])?;

pub fn column_count(&self) -> usize

Return the number of columns.

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.

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

Return column names.

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.

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

Create a cursor.

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 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);

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.

pub fn reset(&mut self) -> Result<()>

Reset the internal state.

Trait Implementations

impl Clone for Statement

fn clone(&self) -> Statement

Returns a duplicate of the value.

const fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for Statement

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Drop for Statement

fn drop(&mut self)

Executes the destructor for this type.

impl<'m> From<&'m mut Statement> for Cursor<'m>

fn from(statement: &'m mut Statement) -> Self

Converts to this type from the input type.

impl<'l> From<CursorWithOwnership> for Statement

fn from(cursor: CursorWithOwnership) -> Self

Converts to this type from the input type.

impl IntoIterator for Statement

type Item = Result<Row, Error>

The type of the elements being iterated over.

type IntoIter = CursorWithOwnership

Which kind of iterator are we turning this into?

fn into_iter(self) -> Self::IntoIter

Creates an iterator from a value.

impl<'l> Send for Statement

impl<'l> Sync for Statement