Trait sqlx::Row

pub trait Row: 'static + Sealed + Send + Sync + Unpin {
    type Database: Database;
    pub fn columns(&self) -> &[<Self::Database as Database>::Column];
    pub fn try_get_raw<I>(
        &self, 
        index: I
    ) -> Result<<Self::Database as HasValueRef<'_>>::ValueRef, Error>
    where
        I: ColumnIndex<Self>;

    pub fn is_empty(&self) -> bool { ... }
    pub fn len(&self) -> usize { ... }
    pub fn column<I>(&self, index: I) -> &<Self::Database as Database>::Column
    where
        I: ColumnIndex<Self>,
    { ... }
    pub fn try_column<I>(
        &self, 
        index: I
    ) -> Result<&<Self::Database as Database>::Column, Error>
    where
        I: ColumnIndex<Self>,
    { ... }
    pub fn get<'r, T, I>(&'r self, index: I) -> T
    where
        T: Decode<'r, Self::Database> + Type<Self::Database>,
        I: ColumnIndex<Self>,
    { ... }
    pub fn get_unchecked<'r, T, I>(&'r self, index: I) -> T
    where
        T: Decode<'r, Self::Database>,
        I: ColumnIndex<Self>,
    { ... }
    pub fn try_get<'r, T, I>(&'r self, index: I) -> Result<T, Error>
    where
        T: Decode<'r, Self::Database> + Type<Self::Database>,
        I: ColumnIndex<Self>,
    { ... }
    pub fn try_get_unchecked<'r, T, I>(&'r self, index: I) -> Result<T, Error>
    where
        T: Decode<'r, Self::Database>,
        I: ColumnIndex<Self>,
    { ... }
}

Represents a single row from the database.

This trait is sealed and cannot be implemented for types outside of SQLx.

Associated Types

type Database: Database

Loading content...

Required methods

pub fn columns(&self) -> &[<Self::Database as Database>::Column]

Gets all columns in this statement.

pub fn try_get_raw<I>(
    &self,
    index: I
) -> Result<<Self::Database as HasValueRef<'_>>::ValueRef, Error> where
    I: ColumnIndex<Self>, 

Index into the database row and decode a single value.

Errors

• ColumnNotFound if the column by the given name was not found.
• ColumnIndexOutOfBounds if the usize index was greater than the number of columns in the row.

Loading content...

Provided methods

pub fn is_empty(&self) -> bool

Returns true if this row has no columns.

pub fn len(&self) -> usize

Returns the number of columns in this row.

pub fn column<I>(&self, index: I) -> &<Self::Database as Database>::Column where
    I: ColumnIndex<Self>, 

Gets the column information at index.

A string index can be used to access a column by name and a usize index can be used to access a column by position.

Panics

Panics if index is out of bounds. See try_column for a non-panicking version.

pub fn try_column<I>(
    &self,
    index: I
) -> Result<&<Self::Database as Database>::Column, Error> where
    I: ColumnIndex<Self>, 

Gets the column information at index or None if out of bounds.

pub fn get<'r, T, I>(&'r self, index: I) -> T where
    T: Decode<'r, Self::Database> + Type<Self::Database>,
    I: ColumnIndex<Self>, 

Index into the database row and decode a single value.

A string index can be used to access a column by name and a usize index can be used to access a column by position.

Panics

Panics if the column does not exist or its value cannot be decoded into the requested type. See try_get for a non-panicking version.

pub fn get_unchecked<'r, T, I>(&'r self, index: I) -> T where
    T: Decode<'r, Self::Database>,
    I: ColumnIndex<Self>, 

Index into the database row and decode a single value.

Unlike get, this method does not check that the type being returned from the database is compatible with the Rust type and blindly tries to decode the value.

Panics

Panics if the column does not exist or its value cannot be decoded into the requested type. See try_get_unchecked for a non-panicking version.

pub fn try_get<'r, T, I>(&'r self, index: I) -> Result<T, Error> where
    T: Decode<'r, Self::Database> + Type<Self::Database>,
    I: ColumnIndex<Self>, 

Index into the database row and decode a single value.

A string index can be used to access a column by name and a usize index can be used to access a column by position.

Errors

• ColumnNotFound if the column by the given name was not found.
• ColumnIndexOutOfBounds if the usize index was greater than the number of columns in the row.
• ColumnDecode if the value could not be decoded into the requested type.

pub fn try_get_unchecked<'r, T, I>(&'r self, index: I) -> Result<T, Error> where
    T: Decode<'r, Self::Database>,
    I: ColumnIndex<Self>, 

Index into the database row and decode a single value.

Unlike try_get, this method does not check that the type being returned from the database is compatible with the Rust type and blindly tries to decode the value.

Errors

• ColumnNotFound if the column by the given name was not found.
• ColumnIndexOutOfBounds if the usize index was greater than the number of columns in the row.
• ColumnDecode if the value could not be decoded into the requested type.

Loading content...

Implementors

impl Row for AnyRow

type Database = Any

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

pub fn try_get_raw<I>(
    &self,
    index: I
) -> Result<<<AnyRow as Row>::Database as HasValueRef<'_>>::ValueRef, Error> where
    I: ColumnIndex<AnyRow>, 

impl Row for MssqlRow

type Database = Mssql

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

pub fn try_get_raw<I>(&self, index: I) -> Result<MssqlValueRef<'_>, Error> where
    I: ColumnIndex<MssqlRow>, 

impl Row for MySqlRow

type Database = MySql

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

pub fn try_get_raw<I>(&self, index: I) -> Result<MySqlValueRef<'_>, Error> where
    I: ColumnIndex<MySqlRow>, 

impl Row for PgRow

type Database = Postgres

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

pub fn try_get_raw<I>(&self, index: I) -> Result<PgValueRef<'_>, Error> where
    I: ColumnIndex<PgRow>, 

impl Row for SqliteRow

type Database = Sqlite

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

pub fn try_get_raw<I>(&self, index: I) -> Result<SqliteValueRef<'_>, Error> where
    I: ColumnIndex<SqliteRow>, 

Loading content...