Trait rusqlite::types::ToSql

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

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 str

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 u32

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 f64

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 i8

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 u8

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

impl ToSql for String

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

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

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

impl ToSql for Vec<u8>

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

impl ToSql for i16

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

impl ToSql for f32

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

impl ToSql for i128

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

impl ToSql for bool

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<T: ToSql> ToSql for Option<T>

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 NaiveDate

Available on crate feature chrono only.

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

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<const N: usize> ToSql for [u8; N]

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

impl ToSql for u16

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

impl ToSql for isize

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

impl ToSql for i32

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

impl ToSql for Uuid

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

impl ToSql for i64

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

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

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 OffsetDateTime

Available on crate feature time only.

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

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

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

impl ToSql for [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<'_>>

Implementors

impl ToSql for ToSqlOutput<'_>

impl ToSql for rusqlite::types::Value

impl ToSql for ZeroBlob

Available on crate feature blob only.

impl ToSql for Null

impl ToSql for Array

Available on crate features array and vtab only.