Struct Statement

Source
pub struct Statement { /* private fields */ }
Expand description

A prepared statement.

Implementations§

Source§

impl Statement

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 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 iter(&mut self) -> Cursor<'_>

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

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

Read a value from a column.

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

Source

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

Reset the internal state.

Trait Implementations§

Source§

impl Clone for Statement

Source§

fn clone(&self) -> Statement

Returns a duplicate of the value. Read more
1.0.0 · Source§

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

Performs copy-assignment from source. Read more
Source§

impl Debug for Statement

Source§

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

Formats the value using the given formatter. Read more
Source§

impl Drop for Statement

Source§

fn drop(&mut self)

Executes the destructor for this type. Read more
Source§

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

Source§

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

Converts to this type from the input type.
Source§

impl<'l> From<CursorWithOwnership> for Statement

Source§

fn from(cursor: CursorWithOwnership) -> Self

Converts to this type from the input type.
Source§

impl IntoIterator for Statement

Source§

type Item = Result<Row, Error>

The type of the elements being iterated over.
Source§

type IntoIter = CursorWithOwnership

Which kind of iterator are we turning this into?
Source§

fn into_iter(self) -> Self::IntoIter

Creates an iterator from a value. Read more
Source§

impl<'l> Send for Statement

Source§

impl<'l> Sync for Statement

Auto Trait Implementations§

Blanket Implementations§

Source§

impl<T> Any for T
where T: 'static + ?Sized,

Source§

fn type_id(&self) -> TypeId

Gets the TypeId of self. Read more
Source§

impl<T> Borrow<T> for T
where T: ?Sized,

Source§

fn borrow(&self) -> &T

Immutably borrows from an owned value. Read more
Source§

impl<T> BorrowMut<T> for T
where T: ?Sized,

Source§

fn borrow_mut(&mut self) -> &mut T

Mutably borrows from an owned value. Read more
Source§

impl<T> CloneToUninit for T
where T: Clone,

Source§

unsafe fn clone_to_uninit(&self, dest: *mut u8)

🔬This is a nightly-only experimental API. (clone_to_uninit)
Performs copy-assignment from self to dest. Read more
Source§

impl<T> From<T> for T

Source§

fn from(t: T) -> T

Returns the argument unchanged.

Source§

impl<T, U> Into<U> for T
where U: From<T>,

Source§

fn into(self) -> U

Calls U::from(self).

That is, this conversion is whatever the implementation of From<T> for U chooses to do.

Source§

impl<T> ToOwned for T
where T: Clone,

Source§

type Owned = T

The resulting type after obtaining ownership.
Source§

fn to_owned(&self) -> T

Creates owned data from borrowed data, usually by cloning. Read more
Source§

fn clone_into(&self, target: &mut T)

Uses borrowed data to replace owned data, usually by cloning. Read more
Source§

impl<T, U> TryFrom<U> for T
where U: Into<T>,

Source§

type Error = Infallible

The type returned in the event of a conversion error.
Source§

fn try_from(value: U) -> Result<T, <T as TryFrom<U>>::Error>

Performs the conversion.
Source§

impl<T, U> TryInto<U> for T
where U: TryFrom<T>,

Source§

type Error = <U as TryFrom<T>>::Error

The type returned in the event of a conversion error.
Source§

fn try_into(self) -> Result<U, <U as TryFrom<T>>::Error>

Performs the conversion.