Trait ToSql 

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

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

Required Methods

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

Converts Rust value to SQLite value

Dyn Compatibility

This trait is dyn compatible.

In older versions of Rust, dyn compatibility was called "object safety".

Implementations on Foreign Types

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

Available on crate feature jiff only.

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

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

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

Available on crate feature url only.

Serialize Url to text.

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

impl ToSql for UtcDateTime

Available on crate feature time only.

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

impl ToSql for Uuid

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

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 Vec<u8>

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

impl ToSql for [u8]

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<T: ToSql + ?Sized> ToSql for Arc<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 + ToOwned + ?Sized> ToSql for Cow<'_, T>

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

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

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

impl<T> ToSql for &T

where T: ToSql + ?Sized,

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

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

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

Implementors

impl ToSql for Array

Available on crate features array and vtab only.

impl ToSql for Null

impl ToSql for SqlFnArg

Available on crate feature functions only.

impl ToSql for ToSqlOutput<'_>

impl ToSql for rusqlite::types::Value

impl ToSql for ZeroBlob

Available on crate feature blob only.