Struct Row 

pub struct Row { /* private fields */ }

A row of data from a query.

Data can be accessed either by copying through get or try_get methods, or moving by value using the IntoIterator implementation.

// by-reference
let row = client
    .query("SELECT @P1 AS col1", &[&"test"])
    .await?
    .into_row()
    .await?
    .unwrap();

assert_eq!(Some("test"), row.get("col1"));

// ...or by-value
let row = client
    .query("SELECT @P1 AS col1", &[&"test"])
    .await?
    .into_row()
    .await?
    .unwrap();

for val in row.into_iter() {
    assert_eq!(
        Some(String::from("test")),
        String::from_sql_owned(val)?
    )
}

Implementations

impl Row

pub fn columns(&self) -> &[Column]

Columns defining the row data. Columns listed here are in the same order as the resulting data.

Example

let row = client
    .query("SELECT 1 AS foo, 2 AS bar", &[])
    .await?
    .into_row()
    .await?
    .unwrap();

assert_eq!("foo", row.columns()[0].name());
assert_eq!("bar", row.columns()[1].name());

pub fn cells(&self) -> impl Iterator<Item = (&Column, &ColumnData<'static>)>

Return an iterator over row column-value pairs.

pub fn result_index(&self) -> usize

The result set number, starting from zero and increasing if the stream has results from more than one query.

pub fn len(&self) -> usize

Returns the number of columns in the row.

Example

let row = client
    .query("SELECT 1, 2", &[])
    .await?
    .into_row()
    .await?
    .unwrap();

assert_eq!(2, row.len());

pub fn get<'a, R, I>(&'a self, idx: I) -> Option<R>

where R: FromSql<'a>, I: QueryIdx,

Retrieve a column value for a given column index, which can either be the zero-indexed position or the name of the column.

Example

let row = client
    .query("SELECT @P1 AS col1", &[&1i32])
    .await?
    .into_row()
    .await?
    .unwrap();

assert_eq!(Some(1i32), row.get(0));
assert_eq!(Some(1i32), row.get("col1"));

Panics

• The requested type conversion (SQL->Rust) is not possible.
• The given index is out of bounds (column does not exist).

Use try_get for a non-panicking version of the function.

pub fn try_get<'a, R, I>(&'a self, idx: I) -> Result<Option<R>, Error>

where R: FromSql<'a>, I: QueryIdx,

Retrieve a column’s value for a given column index.

Trait Implementations

impl Debug for Row

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

Formats the value using the given formatter.

impl IntoIterator for Row

type Item = ColumnData<'static>

The type of the elements being iterated over.

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

Which kind of iterator are we turning this into?

fn into_iter(self) -> <Row as IntoIterator>::IntoIter

Creates an iterator from a value.

impl MssqlRow for Row

fn get_value<'a, T>(&'a self, column: &str) -> MssqlResult<T>

where T: FromSql<'a>,

Get a column value by name.

fn get_opt<'a, T>(&'a self, column: &str) -> MssqlResult<Option<T>>

where T: FromSql<'a>,

Get an optional column value by name.

fn try_get_by_index<'a, T>(&'a self, index: usize) -> Option<T>

where T: FromSql<'a>,

Try to get a column value by index.