Trait diesel::types::ToSql

pub trait ToSql<A, DB: Backend + HasSqlType<A>> {
    fn to_sql<W: Write>(
        &self, 
        out: &mut W
    ) -> Result<IsNull, Box<Error + Send + Sync>>;
}

Serializes a single value to be sent to the database. The output will be included as a bind parameter, and is expected to be the binary format, not text.

Required Methods

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

Implementations on Foreign Types

impl<DB: Backend> ToSql<Float, DB> for f32

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<DB: Backend> ToSql<Double, DB> for f64

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<DB: Backend> ToSql<SmallInt, DB> for i16

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<DB: Backend> ToSql<Integer, DB> for i32

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<DB: Backend> ToSql<BigInt, DB> for i64

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<T, ST, DB> ToSql<Nullable<ST>, DB> for Option<T> where
    T: ToSql<ST, DB>,
    DB: Backend + HasSqlType<ST>,
    ST: NotNull, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a, DB> ToSql<Nullable<Bool>, DB> for bool where
    DB: Backend + HasSqlType<Bool>,
    bool: ToSql<Bool, DB>, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a, DB> ToSql<Nullable<SmallInt>, DB> for i16 where
    DB: Backend + HasSqlType<SmallInt>,
    i16: ToSql<SmallInt, DB>, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a, DB> ToSql<Nullable<Integer>, DB> for i32 where
    DB: Backend + HasSqlType<Integer>,
    i32: ToSql<Integer, DB>, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a, DB> ToSql<Nullable<BigInt>, DB> for i64 where
    DB: Backend + HasSqlType<BigInt>,
    i64: ToSql<BigInt, DB>, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a, DB> ToSql<Nullable<Float>, DB> for f32 where
    DB: Backend + HasSqlType<Float>,
    f32: ToSql<Float, DB>, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a, DB> ToSql<Nullable<Double>, DB> for f64 where
    DB: Backend + HasSqlType<Double>,
    f64: ToSql<Double, DB>, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a, DB> ToSql<Nullable<Text>, DB> for String where
    DB: Backend + HasSqlType<Text>,
    String: ToSql<Text, DB>, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a, DB> ToSql<Nullable<Binary>, DB> for Vec<u8> where
    DB: Backend + HasSqlType<Binary>,
    Vec<u8>: ToSql<Binary, DB>, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a, DB> ToSql<Nullable<Text>, DB> for &'a str where
    DB: Backend + HasSqlType<Text>,
    &'a str: ToSql<Text, DB>, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a, DB> ToSql<Nullable<Binary>, DB> for &'a [u8] where
    DB: Backend + HasSqlType<Binary>,
    &'a [u8]: ToSql<Binary, DB>, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a, DB: Backend> ToSql<Text, DB> for &'a str

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<DB> ToSql<Text, DB> for String where
    DB: Backend,
    &'a str: ToSql<Text, DB>, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<DB> ToSql<Binary, DB> for Vec<u8> where
    DB: Backend,
    &'a [u8]: ToSql<Binary, DB>, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a, DB: Backend> ToSql<Binary, DB> for &'a [u8]

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a, T: ?Sized, ST, DB> ToSql<ST, DB> for Cow<'a, T> where
    T: 'a + ToOwned + ToSql<ST, DB>,
    DB: Backend + HasSqlType<ST>,
    T::Owned: ToSql<ST, DB>, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a, A, T, DB> ToSql<A, DB> for &'a T where
    DB: Backend + HasSqlType<A>,
    T: ToSql<A, DB>, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a, ST, T> ToSql<Array<ST>, Pg> for &'a [T] where
    Pg: HasSqlType<ST>,
    T: ToSql<ST, Pg>, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<ST, T> ToSql<Array<ST>, Pg> for Vec<T> where
    Pg: HasSqlType<ST>,
    &'a [T]: ToSql<Array<ST>, Pg>, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a, DB> ToSql<Nullable<Timestamp>, DB> for SystemTime where
    DB: Backend + HasSqlType<Timestamp>,
    SystemTime: ToSql<Timestamp, DB>, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl ToSql<Timestamp, Pg> for SystemTime

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a, DB> ToSql<Nullable<Date>, DB> for NaiveDate where
    DB: Backend + HasSqlType<Date>,
    NaiveDate: ToSql<Date, DB>, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a, DB> ToSql<Nullable<Time>, DB> for NaiveTime where
    DB: Backend + HasSqlType<Time>,
    NaiveTime: ToSql<Time, DB>, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a, DB> ToSql<Nullable<Timestamp>, DB> for NaiveDateTime where
    DB: Backend + HasSqlType<Timestamp>,
    NaiveDateTime: ToSql<Timestamp, DB>, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a, DB> ToSql<Nullable<Timestamptz>, DB> for DateTime<UTC> where
    DB: Backend + HasSqlType<Timestamptz>,
    DateTime<UTC>: ToSql<Timestamptz, DB>, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a, DB> ToSql<Nullable<Timestamptz>, DB> for DateTime<FixedOffset> where
    DB: Backend + HasSqlType<Timestamptz>,
    DateTime<FixedOffset>: ToSql<Timestamptz, DB>, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a, DB> ToSql<Nullable<Timestamptz>, DB> for DateTime<Local> where
    DB: Backend + HasSqlType<Timestamptz>,
    DateTime<Local>: ToSql<Timestamptz, DB>, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl ToSql<Timestamp, Pg> for NaiveDateTime

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl ToSql<Timestamptz, Pg> for NaiveDateTime

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<TZ: TimeZone> ToSql<Timestamptz, Pg> for DateTime<TZ>

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl ToSql<Time, Pg> for NaiveTime

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl ToSql<Date, Pg> for NaiveDate

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a, DB> ToSql<Nullable<Oid>, DB> for u32 where
    DB: Backend + HasSqlType<Oid>,
    u32: ToSql<Oid, DB>, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl ToSql<Oid, Pg> for u32

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl ToSql<Bool, Pg> for bool

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a, DB> ToSql<Nullable<Uuid>, DB> for Uuid where
    DB: Backend + HasSqlType<Uuid>,
    Uuid: ToSql<Uuid, DB>, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl ToSql<Uuid, Pg> for Uuid

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a, DB> ToSql<Nullable<Date>, DB> for String where
    DB: Backend + HasSqlType<Date>,
    String: ToSql<Date, DB>, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a, DB> ToSql<Nullable<Date>, DB> for &'a str where
    DB: Backend + HasSqlType<Date>,
    &'a str: ToSql<Date, DB>, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a, DB> ToSql<Nullable<Time>, DB> for String where
    DB: Backend + HasSqlType<Time>,
    String: ToSql<Time, DB>, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a, DB> ToSql<Nullable<Time>, DB> for &'a str where
    DB: Backend + HasSqlType<Time>,
    &'a str: ToSql<Time, DB>, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a, DB> ToSql<Nullable<Timestamp>, DB> for String where
    DB: Backend + HasSqlType<Timestamp>,
    String: ToSql<Timestamp, DB>, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a, DB> ToSql<Nullable<Timestamp>, DB> for &'a str where
    DB: Backend + HasSqlType<Timestamp>,
    &'a str: ToSql<Timestamp, DB>, 

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a> ToSql<Date, Sqlite> for &'a str

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl ToSql<Date, Sqlite> for String

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a> ToSql<Time, Sqlite> for &'a str

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl ToSql<Time, Sqlite> for String

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl<'a> ToSql<Timestamp, Sqlite> for &'a str

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl ToSql<Timestamp, Sqlite> for String

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

impl ToSql<Bool, Sqlite> for bool

fn to_sql<W: Write>(
    &self,
    out: &mut W
) -> Result<IsNull, Box<Error + Send + Sync>>

Implementors

• impl<'a, DB> ToSql<Nullable<Date>, DB> for PgDate where
    DB: Backend + HasSqlType<Date>,
    PgDate: ToSql<Date, DB>, 
• impl<'a, DB> ToSql<Nullable<Time>, DB> for PgTime where
    DB: Backend + HasSqlType<Time>,
    PgTime: ToSql<Time, DB>, 
• impl<'a, DB> ToSql<Nullable<Timestamp>, DB> for PgTimestamp where
    DB: Backend + HasSqlType<Timestamp>,
    PgTimestamp: ToSql<Timestamp, DB>, 
• impl<'a, DB> ToSql<Nullable<Timestamptz>, DB> for PgTimestamp where
    DB: Backend + HasSqlType<Timestamptz>,
    PgTimestamp: ToSql<Timestamptz, DB>, 
• impl<'a, DB> ToSql<Nullable<Interval>, DB> for PgInterval where
    DB: Backend + HasSqlType<Interval>,
    PgInterval: ToSql<Interval, DB>, 
• impl ToSql<Timestamp, Pg> for PgTimestamp
• impl ToSql<Timestamptz, Pg> for PgTimestamp
• impl ToSql<Date, Pg> for PgDate
• impl ToSql<Time, Pg> for PgTime
• impl ToSql<Interval, Pg> for PgInterval
• impl ToSql<Numeric, Pg> for PgNumeric
• impl<'a, DB> ToSql<Nullable<Numeric>, DB> for PgNumeric where
    DB: Backend + HasSqlType<Numeric>,
    PgNumeric: ToSql<Numeric, DB>,