Struct rusqlite::Row

source ·
pub struct Row<'stmt> { /* private fields */ }
Expand description

A single result row of a query.

Implementations§

source§

impl<'stmt> Row<'stmt>

source

pub fn get_unwrap<I: RowIndex, T: FromSql>(&self, idx: I) -> T

Get the value of a particular column of the result row.

§Panics

Panics if calling row.get(idx) would return an error, including:

  • If the underlying SQLite column type is not a valid type as a source for T
  • If the underlying SQLite integral value is outside the range representable by T
  • If idx is outside the range of columns in the returned query
source

pub fn get<I: RowIndex, T: FromSql>(&self, idx: I) -> Result<T>

Get the value of a particular column of the result row.

§Failure

Returns an Error::InvalidColumnType if the underlying SQLite column type is not a valid type as a source for T.

Returns an Error::InvalidColumnIndex if idx is outside the valid column range for this row.

Returns an Error::InvalidColumnName if idx is not a valid column name for this row.

If the result type is i128 (which requires the i128_blob feature to be enabled), and the underlying SQLite column is a blob whose size is not 16 bytes, Error::InvalidColumnType will also be returned.

source

pub fn get_ref<I: RowIndex>(&self, idx: I) -> Result<ValueRef<'_>>

Get the value of a particular column of the result row as a ValueRef, allowing data to be read out of a row without copying.

This ValueRef is valid only as long as this Row, which is enforced by it’s lifetime. This means that while this method is completely safe, it can be somewhat difficult to use, and most callers will be better served by get or get_unwrap.

§Failure

Returns an Error::InvalidColumnIndex if idx is outside the valid column range for this row.

Returns an Error::InvalidColumnName if idx is not a valid column name for this row.

source

pub fn get_ref_unwrap<I: RowIndex>(&self, idx: I) -> ValueRef<'_>

Get the value of a particular column of the result row as a ValueRef, allowing data to be read out of a row without copying.

This ValueRef is valid only as long as this Row, which is enforced by it’s lifetime. This means that while this method is completely safe, it can be difficult to use, and most callers will be better served by get or get_unwrap.

§Panics

Panics if calling row.get_ref(idx) would return an error, including:

  • If idx is outside the range of columns in the returned query.
  • If idx is not a valid column name for this row.

Trait Implementations§

source§

impl<'stmt> AsRef<Statement<'stmt>> for Row<'stmt>

source§

fn as_ref(&self) -> &Statement<'stmt>

Converts this type into a shared reference of the (usually inferred) input type.
source§

impl<'stmt> Debug for Row<'stmt>

Debug Row like an ordered Map<Result<&str>, Result<(Type, ValueRef)>> with column name as key except that for Type::Blob only its size is printed (not its content).

source§

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

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

impl<'a> TryFrom<&'a Row<'a>> for ()

§

type Error = Error

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

fn try_from(row: &'a Row<'a>) -> Result<Self>

Performs the conversion.
source§

impl<'a, A, B, C, D, E, F, G, H, I, J, K, L, M, N, O, P> TryFrom<&'a Row<'a>> for (A, B, C, D, E, F, G, H, I, J, K, L, M, N, O, P)
where A: FromSql, B: FromSql, C: FromSql, D: FromSql, E: FromSql, F: FromSql, G: FromSql, H: FromSql, I: FromSql, J: FromSql, K: FromSql, L: FromSql, M: FromSql, N: FromSql, O: FromSql, P: FromSql,

§

type Error = Error

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

fn try_from(row: &'a Row<'a>) -> Result<Self>

Performs the conversion.
source§

impl<'a, B, C, D, E, F, G, H, I, J, K, L, M, N, O, P> TryFrom<&'a Row<'a>> for (B, C, D, E, F, G, H, I, J, K, L, M, N, O, P)
where B: FromSql, C: FromSql, D: FromSql, E: FromSql, F: FromSql, G: FromSql, H: FromSql, I: FromSql, J: FromSql, K: FromSql, L: FromSql, M: FromSql, N: FromSql, O: FromSql, P: FromSql,

§

type Error = Error

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

fn try_from(row: &'a Row<'a>) -> Result<Self>

Performs the conversion.
source§

impl<'a, C, D, E, F, G, H, I, J, K, L, M, N, O, P> TryFrom<&'a Row<'a>> for (C, D, E, F, G, H, I, J, K, L, M, N, O, P)
where C: FromSql, D: FromSql, E: FromSql, F: FromSql, G: FromSql, H: FromSql, I: FromSql, J: FromSql, K: FromSql, L: FromSql, M: FromSql, N: FromSql, O: FromSql, P: FromSql,

§

type Error = Error

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

fn try_from(row: &'a Row<'a>) -> Result<Self>

Performs the conversion.
source§

impl<'a, D, E, F, G, H, I, J, K, L, M, N, O, P> TryFrom<&'a Row<'a>> for (D, E, F, G, H, I, J, K, L, M, N, O, P)
where D: FromSql, E: FromSql, F: FromSql, G: FromSql, H: FromSql, I: FromSql, J: FromSql, K: FromSql, L: FromSql, M: FromSql, N: FromSql, O: FromSql, P: FromSql,

§

type Error = Error

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

fn try_from(row: &'a Row<'a>) -> Result<Self>

Performs the conversion.
source§

impl<'a, E, F, G, H, I, J, K, L, M, N, O, P> TryFrom<&'a Row<'a>> for (E, F, G, H, I, J, K, L, M, N, O, P)
where E: FromSql, F: FromSql, G: FromSql, H: FromSql, I: FromSql, J: FromSql, K: FromSql, L: FromSql, M: FromSql, N: FromSql, O: FromSql, P: FromSql,

§

type Error = Error

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

fn try_from(row: &'a Row<'a>) -> Result<Self>

Performs the conversion.
source§

impl<'a, F, G, H, I, J, K, L, M, N, O, P> TryFrom<&'a Row<'a>> for (F, G, H, I, J, K, L, M, N, O, P)
where F: FromSql, G: FromSql, H: FromSql, I: FromSql, J: FromSql, K: FromSql, L: FromSql, M: FromSql, N: FromSql, O: FromSql, P: FromSql,

§

type Error = Error

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

fn try_from(row: &'a Row<'a>) -> Result<Self>

Performs the conversion.
source§

impl<'a, G, H, I, J, K, L, M, N, O, P> TryFrom<&'a Row<'a>> for (G, H, I, J, K, L, M, N, O, P)
where G: FromSql, H: FromSql, I: FromSql, J: FromSql, K: FromSql, L: FromSql, M: FromSql, N: FromSql, O: FromSql, P: FromSql,

§

type Error = Error

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

fn try_from(row: &'a Row<'a>) -> Result<Self>

Performs the conversion.
source§

impl<'a, H, I, J, K, L, M, N, O, P> TryFrom<&'a Row<'a>> for (H, I, J, K, L, M, N, O, P)
where H: FromSql, I: FromSql, J: FromSql, K: FromSql, L: FromSql, M: FromSql, N: FromSql, O: FromSql, P: FromSql,

§

type Error = Error

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

fn try_from(row: &'a Row<'a>) -> Result<Self>

Performs the conversion.
source§

impl<'a, I, J, K, L, M, N, O, P> TryFrom<&'a Row<'a>> for (I, J, K, L, M, N, O, P)
where I: FromSql, J: FromSql, K: FromSql, L: FromSql, M: FromSql, N: FromSql, O: FromSql, P: FromSql,

§

type Error = Error

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

fn try_from(row: &'a Row<'a>) -> Result<Self>

Performs the conversion.
source§

impl<'a, J, K, L, M, N, O, P> TryFrom<&'a Row<'a>> for (J, K, L, M, N, O, P)
where J: FromSql, K: FromSql, L: FromSql, M: FromSql, N: FromSql, O: FromSql, P: FromSql,

§

type Error = Error

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

fn try_from(row: &'a Row<'a>) -> Result<Self>

Performs the conversion.
source§

impl<'a, K, L, M, N, O, P> TryFrom<&'a Row<'a>> for (K, L, M, N, O, P)
where K: FromSql, L: FromSql, M: FromSql, N: FromSql, O: FromSql, P: FromSql,

§

type Error = Error

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

fn try_from(row: &'a Row<'a>) -> Result<Self>

Performs the conversion.
source§

impl<'a, L, M, N, O, P> TryFrom<&'a Row<'a>> for (L, M, N, O, P)
where L: FromSql, M: FromSql, N: FromSql, O: FromSql, P: FromSql,

§

type Error = Error

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

fn try_from(row: &'a Row<'a>) -> Result<Self>

Performs the conversion.
source§

impl<'a, M, N, O, P> TryFrom<&'a Row<'a>> for (M, N, O, P)
where M: FromSql, N: FromSql, O: FromSql, P: FromSql,

§

type Error = Error

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

fn try_from(row: &'a Row<'a>) -> Result<Self>

Performs the conversion.
source§

impl<'a, N, O, P> TryFrom<&'a Row<'a>> for (N, O, P)
where N: FromSql, O: FromSql, P: FromSql,

§

type Error = Error

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

fn try_from(row: &'a Row<'a>) -> Result<Self>

Performs the conversion.
source§

impl<'a, O, P> TryFrom<&'a Row<'a>> for (O, P)
where O: FromSql, P: FromSql,

§

type Error = Error

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

fn try_from(row: &'a Row<'a>) -> Result<Self>

Performs the conversion.
source§

impl<'a, P> TryFrom<&'a Row<'a>> for (P,)
where P: FromSql,

§

type Error = Error

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

fn try_from(row: &'a Row<'a>) -> Result<Self>

Performs the conversion.

Auto Trait Implementations§

§

impl<'stmt> Freeze for Row<'stmt>

§

impl<'stmt> !RefUnwindSafe for Row<'stmt>

§

impl<'stmt> !Send for Row<'stmt>

§

impl<'stmt> !Sync for Row<'stmt>

§

impl<'stmt> Unpin for Row<'stmt>

§

impl<'stmt> !UnwindSafe for Row<'stmt>

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> 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, U> TryFrom<U> for T
where U: Into<T>,

§

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>,

§

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.