Trait diesel::deserialize::FromSql

source ·

pub trait FromSql<A, DB: Backend>: Sized {
    // Required method
    fn from_sql(bytes: RawValue<'_, DB>) -> Result<Self>;

    // Provided method
    fn from_nullable_sql(bytes: Option<RawValue<'_, DB>>) -> Result<Self> { ... }
}

Expand description

Deserialize a single field of a given SQL type.

When possible, implementations of this trait should prefer to use an existing implementation, rather than reading from bytes. (For example, if you are implementing this for an enum which is represented as an integer in the database, prefer i32::from_sql(bytes) (or the explicit form <i32 as FromSql<Integer, DB>>::from_sql(bytes)) over reading from bytes directly)

Types which implement this trait should also have #[derive(FromSqlRow)]

Backend specific details

For PostgreSQL, the bytes will be sent using the binary protocol, not text.
For SQLite, the actual type of DB::RawValue is private API. All implementations of this trait must be written in terms of an existing primitive.
For MySQL, the value of bytes will depend on the return value of type_metadata for the given SQL type. See MysqlType for details.
For third party backends, consult that backend’s documentation.

Examples

Most implementations of this trait will be defined in terms of an existing implementation.

#[repr(i32)]
#[derive(Debug, Clone, Copy, FromSqlRow)]
pub enum MyEnum {
    A = 1,
    B = 2,
}

impl<DB> FromSql<Integer, DB> for MyEnum
where
    DB: Backend,
    i32: FromSql<Integer, DB>,
{
    fn from_sql(bytes: backend::RawValue<DB>) -> deserialize::Result<Self> {
        match i32::from_sql(bytes)? {
            1 => Ok(MyEnum::A),
            2 => Ok(MyEnum::B),
            x => Err(format!("Unrecognized variant {}", x).into()),
        }
    }
}

Required Methods§

source

fn from_sql(bytes: RawValue<'_, DB>) -> Result<Self>

See the trait documentation.

Provided Methods§

source

fn from_nullable_sql(bytes: Option<RawValue<'_, DB>>) -> Result<Self>

A specialized variant of from_sql for handling null values.

The default implementation returns an UnexpectedNullError for an encountered null value and calls Self::from_sql otherwise

If your custom type supports null values you need to provide a custom implementation.

Trait diesel::deserialize::FromSql

Required Methods§

fn from_sql(bytes: RawValue<'_, DB>) -> Result<Self>

Provided Methods§

fn from_nullable_sql(bytes: Option<RawValue<'_, DB>>) -> Result<Self>

Implementations on Foreign Types§

impl FromSql<Inet, Pg> for IpNetwork

fn from_sql(value: PgValue<'_>) -> Result<Self>

impl FromSql<Integer, Pg> for i32

fn from_sql(value: PgValue<'_>) -> Result<Self>

impl FromSql<Timestamptz, Sqlite> for OffsetDateTime

fn from_sql(value: RawValue<'_, Sqlite>) -> Result<Self>

fn from_sql(value: PgValue<'_>) -> Result<Self>

impl FromSql<Time, Mysql> for NaiveTime

fn from_sql(bytes: MysqlValue<'_>) -> Result<Self>

impl FromSql<Integer, Mysql> for i32

fn from_sql(value: MysqlValue<'_>) -> Result<Self>

impl FromSql<Cidr, Pg> for IpNet

fn from_sql(value: PgValue<'_>) -> Result<Self>

impl<T0, T1, T2, T3, T4, T5, ST0, ST1, ST2, ST3, ST4, ST5> FromSql<Record<(ST0, ST1, ST2, ST3, ST4, ST5)>, Pg> for (T0, T1, T2, T3, T4, T5)where T0: FromSql<ST0, Pg>, T1: FromSql<ST1, Pg>, T2: FromSql<ST2, Pg>, T3: FromSql<ST3, Pg>, T4: FromSql<ST4, Pg>, T5: FromSql<ST5, Pg>,

fn from_sql(value: PgValue<'_>) -> Result<Self>

impl FromSql<Jsonb, Pg> for Value

fn from_sql(value: PgValue<'_>) -> Result<Self>

fn from_sql(value: PgValue<'_>) -> Result<Self>

impl FromSql<Binary, Mysql> for *const [u8]

fn from_sql(value: MysqlValue<'_>) -> Result<Self>

fn from_sql(value: PgValue<'_>) -> Result<Self>

fn from_sql(value: PgValue<'_>) -> Result<Self>

impl FromSql<Double, Sqlite> for f64

fn from_sql(value: SqliteValue<'_, '_, '_>) -> Result<Self>

impl<T, ST> FromSql<Array<ST>, Pg> for Vec<T>where T: FromSql<ST, Pg>,

fn from_sql(value: PgValue<'_>) -> Result<Self>

impl FromSql<Timestamptz, Pg> for OffsetDateTime

fn from_sql(bytes: PgValue<'_>) -> Result<Self>

impl FromSql<Double, Mysql> for f64

fn from_sql(value: MysqlValue<'_>) -> Result<Self>

fn from_sql(value: PgValue<'_>) -> Result<Self>

impl FromSql<Time, Mysql> for NaiveTime

fn from_sql(bytes: MysqlValue<'_>) -> Result<Self>

fn from_sql(value: PgValue<'_>) -> Result<Self>

fn from_sql(value: PgValue<'_>) -> Result<Self>

impl FromSql<Inet, Pg> for IpNet

fn from_sql(value: PgValue<'_>) -> Result<Self>

impl FromSql<Timestamptz, Sqlite> for PrimitiveDateTime

fn from_sql(value: RawValue<'_, Sqlite>) -> Result<Self>

impl FromSql<Double, Pg> for f64

fn from_sql(value: PgValue<'_>) -> Result<Self>

impl FromSql<Json, Mysql> for Value

fn from_sql(value: MysqlValue<'_>) -> Result<Self>

fn from_sql(value: PgValue<'_>) -> Result<Self>

impl FromSql<Timestamptz, Sqlite> for DateTime<Local>

fn from_sql(value: RawValue<'_, Sqlite>) -> Result<Self>

fn from_sql(value: PgValue<'_>) -> Result<Self>

fn from_sql(value: PgValue<'_>) -> Result<Self>

fn from_sql(value: PgValue<'_>) -> Result<Self>

impl FromSql<Integer, Sqlite> for i32

fn from_sql(value: SqliteValue<'_, '_, '_>) -> Result<Self>

impl FromSql<Timestamptz, Sqlite> for NaiveDateTime

fn from_sql(value: RawValue<'_, Sqlite>) -> Result<Self>

impl FromSql<TinyInt, Mysql> for i8

fn from_sql(value: MysqlValue<'_>) -> Result<Self>

impl FromSql<Time, Pg> for NaiveTime

fn from_sql(bytes: PgValue<'_>) -> Result<Self>

impl FromSql<Binary, Sqlite> for *const [u8]

fn from_sql(bytes: SqliteValue<'_, '_, '_>) -> Result<Self>

impl FromSql<Json, Pg> for Value

fn from_sql(value: PgValue<'_>) -> Result<Self>

impl<T, ST, DB> FromSql<Nullable<ST>, DB> for Option<T>where T: FromSql<ST, DB>, DB: Backend, ST: SqlType<IsNull = NotNull>,

fn from_sql(bytes: RawValue<'_, DB>) -> Result<Self>

fn from_nullable_sql(bytes: Option<RawValue<'_, DB>>) -> Result<Self>

impl FromSql<Timestamp, Pg> for NaiveDateTime

fn from_sql(bytes: PgValue<'_>) -> Result<Self>

impl FromSql<Timestamptz, Pg> for NaiveDateTime

fn from_sql(bytes: PgValue<'_>) -> Result<Self>

impl FromSql<Timestamp, Sqlite> for PrimitiveDateTime

fn from_sql(value: RawValue<'_, Sqlite>) -> Result<Self>

impl<T0, T1, ST0, ST1> FromSql<Record<(ST0, ST1)>, Pg> for (T0, T1)where T0: FromSql<ST0, Pg>, T1: FromSql<ST1, Pg>,

fn from_sql(value: PgValue<'_>) -> Result<Self>

impl FromSql<Bool, Sqlite> for bool

fn from_sql(value: SqliteValue<'_, '_, '_>) -> Result<Self>