Trait FromSql

pub trait FromSql: Sized {
    // Required method
    fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>;
}

A trait for types that can be created from a SQLite value.

Required Methods

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

Converts SQLite value into Rust value.

Dyn Compatibility

This trait is not dyn compatible.

In older versions of Rust, dyn compatibility was called "object safety", so this trait is not object safe.

Implementations on Foreign Types

impl FromSql for Value

Available on crate feature serde_json only.

Deserialize SQLite value to JSON Value:

SQLite	JSON
NULL	Null
‘null’	Null
‘true’	Bool
1	Number
0.1	Number
‘“text”’	String
‘text’	Error
‘[0, 1]’	Array
‘{“x”: 1}’	Object

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for bool

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for f32

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for f64

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for i8

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for i16

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for i32

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for i64

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for i128

Available on crate feature i128_blob only.

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for isize

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for u8

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for u16

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for u32

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for u64

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for usize

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for Box<str>

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for Box<[u8]>

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for Rc<str>

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for Rc<[u8]>

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for String

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for Arc<str>

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for Arc<[u8]>

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for Vec<u8>

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for DateTime<FixedOffset>

Available on crate feature chrono only.

RFC3339 (“YYYY-MM-DD HH:MM:SS.SSS[+-]HH:MM”) into DateTime<FixedOffset>.

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for DateTime<Local>

Available on crate feature chrono only.

RFC3339 (“YYYY-MM-DD HH:MM:SS.SSS[+-]HH:MM”) into DateTime<Local>.

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for DateTime<Utc>

Available on crate feature chrono only.

RFC3339 (“YYYY-MM-DD HH:MM:SS.SSS[+-]HH:MM”) into DateTime<Utc>.

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for NaiveDate

Available on crate feature chrono only.

“YYYY-MM-DD” => ISO 8601 calendar date without timezone.

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for NaiveDateTime

Available on crate feature chrono only.

“YYYY-MM-DD HH:MM:SS”/“YYYY-MM-DD HH:MM:SS.SSS” => ISO 8601 combined date and time without timezone. (“YYYY-MM-DDTHH:MM:SS”/“YYYY-MM-DDTHH:MM:SS.SSS” also supported)

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for NaiveTime

Available on crate feature chrono only.

“HH:MM”/“HH:MM:SS”/“HH:MM:SS.SSS” => ISO 8601 time without timezone.

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for Date

Available on crate feature jiff only.

“YYYY-MM-DD” => Gregorian calendar date.

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for DateTime

Available on crate feature jiff only.

“YYYY-MM-DDTHH:MM:SS.SSS” => Gregorian datetime.

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for Time

Available on crate feature jiff only.

“HH:MM:SS.SSS” => time.

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for Timestamp

Available on crate feature jiff only.

RFC3339 (“YYYY-MM-DD HH:MM:SS.SSS[+-]HH:MM”) into Timestamp.

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for Date

Available on crate feature time only.

“YYYY-MM-DD” => ISO 8601 calendar date without timezone.

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for OffsetDateTime

Available on crate feature time only.

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for PrimitiveDateTime

Available on crate feature time only.

YYYY-MM-DD HH:MM YYYY-MM-DDTHH:MM YYYY-MM-DD HH:MM:SS YYYY-MM-DDTHH:MM:SS YYYY-MM-DD HH:MM:SS.SSS YYYY-MM-DDTHH:MM:SS.SSS => ISO 8601 combined date and time with timezone

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for Time

Available on crate feature time only.

“HH:MM”/“HH:MM:SS”/“HH:MM:SS.SSS” => ISO 8601 time without timezone.

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for Url

Available on crate feature url only.

Deserialize text to Url.

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for Uuid

Available on crate feature uuid only.

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for NonZeroI8

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for NonZeroI16

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for NonZeroI32

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for NonZeroI64

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for NonZeroI128

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for NonZeroIsize

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for NonZeroU8

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for NonZeroU16

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for NonZeroU32

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for NonZeroU64

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl FromSql for NonZeroUsize

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl<T> FromSql for Cow<'_, T>

where T: ToOwned + ?Sized, T::Owned: FromSql,

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl<T: FromSql> FromSql for Option<T>

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

impl<const N: usize> FromSql for [u8; N]

fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self>

Implementors

impl FromSql for rusqlite::types::Value