Struct Statement

pub struct Statement { /* private fields */ }

A cached prepared statement.

Implementations

impl Statement

pub fn finalize(&mut self)

Finalize the cached statement.

pub async fn execute(&mut self, params: impl IntoParams) -> Result<usize>

Execute queries on the statement, check [Connection::execute] for usage.

pub async fn query(&mut self, params: impl IntoParams) -> Result<Rows>

Execute a query on the statement, check [Connection::query] for usage.

pub async fn run(&mut self, params: impl IntoParams) -> Result<()>

Run a query on the statement.

The execute() method returns an error if the query returns rows, which makes it unsuitable for running any type of SQL queries. Similarly, the query() method only works on SQL statements that return rows. Therefore, the run() method is provided to execute any type of SQL statement.

Note: This is an extension to the Rusqlite API.

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

Interrupt the statement.

pub async fn query_row(&mut self, params: impl IntoParams) -> Result<Row>

Execute a query that returns the first Row.

Errors

• Returns QueryReturnedNoRows if no rows were returned.

pub fn reset(&mut self)

Reset the state of this prepared statement.

pub fn parameter_count(&self) -> usize

Fetch the amount of parameters in the prepared statement.

pub fn parameter_name(&self, idx: i32) -> Option<&str>

Fetch the parameter name at the provided index.

pub fn column_count(&self) -> usize

Fetch the number of columns for the prepared statement.

pub fn columns(&self) -> Vec<Column<'_>>

Fetch the list of columns for the prepared statement.