rusqlite::types

Trait ToSql

pub trait ToSql {
    // Required method
    fn to_sql(&self) -> Result<ToSqlOutput<'_>>;
}

Expand description

A trait for types that can be converted into SQLite values. Returns Error::ToSqlConversionFailure if the conversion fails.

Required Methods§

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

Converts Rust value to SQLite value

Implementations on Foreign Types§

impl ToSql for Value

Available on crate feature serde_json only.

Serialize JSON Value to text:

JSON	SQLite
Null	NULL
Bool	‘true’ / ‘false’
Number	INT or REAL except u64
_	TEXT

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for bool

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for f32

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for f64

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for i8

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for i16

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for i32

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for i64

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for i128

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for isize

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for str

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for u8

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for u16

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for u32

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for u64

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for usize

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for String

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for Vec<u8>

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for DateTime<FixedOffset>

Available on crate feature chrono only.

Date and time with time zone => RFC3339 timestamp (“YYYY-MM-DD HH:MM:SS.SSS[+-]HH:MM”).

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for DateTime<Local>

Available on crate feature chrono only.

Local time => UTC RFC3339 timestamp (“YYYY-MM-DD HH:MM:SS.SSS+00:00”).

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for DateTime<Utc>

Available on crate feature chrono only.

UTC time => UTC RFC3339 timestamp (“YYYY-MM-DD HH:MM:SS.SSS+00:00”).

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for NaiveDate

Available on crate feature chrono only.

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

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for NaiveDateTime

Available on crate feature chrono only.

ISO 8601 combined date and time without timezone => “YYYY-MM-DD HH:MM:SS.SSS”

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for NaiveTime

Available on crate feature chrono only.

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

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for Date

Available on crate feature jiff only.

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

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for DateTime

Available on crate feature jiff only.

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

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for Time

Available on crate feature jiff only.

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

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for Timestamp

Available on crate feature jiff only.

UTC time => UTC RFC3339 timestamp (“YYYY-MM-DDTHH:MM:SS.SSSZ”).

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for Date

Available on crate feature time only.

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

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for OffsetDateTime

Available on crate feature time only.

OffsetDatetime => RFC3339 format (“YYYY-MM-DD HH:MM:SS.SSS[+-]HH:MM”)

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for PrimitiveDateTime

Available on crate feature time only.

ISO 8601 combined date and time without timezone => “YYYY-MM-DD HH:MM:SS.SSS”

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for Time

Available on crate feature time only.

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

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for Url

Available on crate feature url only.

Serialize Url to text.

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for Uuid

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for NonZeroI8

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for NonZeroI16

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for NonZeroI32

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for NonZeroI64

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for NonZeroI128

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for NonZeroIsize

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for NonZeroU8

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for NonZeroU16

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for NonZeroU32

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for NonZeroU64

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for NonZeroUsize

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl ToSql for [u8]

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl<T> ToSql for &T
where T: ToSql + ?Sized,

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl<T: ToSql + ToOwned + ?Sized> ToSql for Cow<'_, T>

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl<T: ToSql + ?Sized> ToSql for Box<T>

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl<T: ToSql + ?Sized> ToSql for Rc<T>

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl<T: ToSql + ?Sized> ToSql for Arc<T>

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

impl<T: ToSql> ToSql for Option<T>

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

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

fn to_sql(&self) -> Result<ToSqlOutput<'_>>

Implementors§

impl ToSql for ToSqlOutput<'_>

impl ToSql for rusqlite::types::Value

impl ToSql for ZeroBlob

Available on crate feature blob only.

impl ToSql for SqlFnArg

Available on crate feature functions only.

impl ToSql for Null

impl ToSql for Array

Available on crate features array and vtab only.