Struct Statement 

pub struct Statement(/* private fields */);

Prepared statement for querying a core database connection public API for extensions Statements can be manually closed.

Implementations

impl Statement

pub fn bind_at(&self, idx: NonZeroUsize, arg: Value)

Bind a value to a parameter in the prepared statement.

 let stmt = conn.prepare_stmt("select * from users where name = ?");
 stmt.bind_at(1, Value::from_text("test".into()));

pub fn step(&self) -> StepResult

Execute the statement and return the next row

 while stmt.step() == StepResult::Row {
     let row = stmt.get_row();
     println!("row: {:?}", row);
 }

pub fn get_row(&mut self) -> &[Value]

 while stmt.step() == StepResult::Row {
    let row = stmt.get_row();
    println!("row: {:?}", row);

pub fn get_column_names(&self) -> Vec<String>

Get the result column names for the prepared statement

pub fn close(self)

Close the statement and clean up resources.

Trait Implementations

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.

fn pin_drop(self: Pin<&mut Self>)

🔬This is a nightly-only experimental API. (pin_ergonomics)

Execute the destructor for this type, but different to Drop::drop, it requires self to be pinned.