Struct ExecuteResult 

pub struct ExecuteResult { /* private fields */ }

A result from a query execution, listing the number of affected rows.

If executing multiple queries, the resulting counts will be come separately, marking the rows affected for each query.

Example

let result = client
    .execute(
        "INSERT INTO #Test (id) VALUES (@P1); INSERT INTO #Test (id) VALUES (@P2, @P3)",
        &[&1i32, &2i32, &3i32],
    )
    .await?;

assert_eq!(&[1, 2], result.rows_affected());

Implementations

impl<'a> ExecuteResult

pub fn rows_affected(&self) -> &[u64]

The rows affected by each INSERT, UPDATE, DELETE, MERGE or other non-SELECT statement, in execution order, including those run by procedures and triggers. SELECTs and variable assignments (SET @v = .., SELECT @v = ..) are left out, and statements under SET NOCOUNT ON report nothing. This is what SqlClient’s ExecuteNonQuery counts.

pub fn total(self) -> u64

The sum of rows_affected: SqlClient’s ExecuteNonQuery result, except that it is 0 rather than -1 when no statement reported a count.

Example

let rows_affected = client
    .execute(
        "INSERT INTO #Test (id) VALUES (@P1); INSERT INTO #Test (id) VALUES (@P2, @P3)",
        &[&1i32, &2i32, &3i32],
    )
    .await?;

assert_eq!(3, rows_affected.total());

Trait Implementations

impl Debug for ExecuteResult

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

Formats the value using the given formatter.

impl IntoIterator for ExecuteResult

type Item = u64

The type of the elements being iterated over.

type IntoIter = IntoIter<<ExecuteResult as IntoIterator>::Item>

Which kind of iterator are we turning this into?

fn into_iter(self) -> Self::IntoIter

Creates an iterator from a value.