Trait diesel::serialize::ToSql

source ·

pub trait ToSql<A, DB: Backend>: Debug {
    fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, DB>) -> Result;
}

Expand description

Serializes a single value to be sent to the database.

The output is sent as a bind parameter, and the data must be written in the expected format for the given backend.

When possible, implementations of this trait should prefer using an existing implementation, rather than writing to out directly. (For example, if you are implementing this for an enum, which is represented as an integer in the database, you should use i32::to_sql(x, out) instead of writing to out yourself.)

Any types which implement this trait should also #[derive(AsExpression)].

Backend specific details

For PostgreSQL, the bytes will be sent using the binary protocol, not text.
For SQLite, all implementations should be written in terms of an existing ToSql implementation.
For MySQL, the expected bytes will depend on the return value of type_metadata for the given SQL type. See MysqlType for details.
For third party backends, consult that backend’s documentation.

Examples

Most implementations of this trait will be defined in terms of an existing implementation.

#[repr(i32)]
#[derive(Debug, Clone, Copy, AsExpression)]
#[diesel(sql_type = Integer)]
pub enum MyEnum {
    A = 1,
    B = 2,
}

impl<DB> ToSql<Integer, DB> for MyEnum
where
    DB: Backend,
    i32: ToSql<Integer, DB>,
{
    fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, DB>) -> serialize::Result {
        match self {
            MyEnum::A => 1.to_sql(out),
            MyEnum::B => 2.to_sql(out),
        }
    }
}

Using temporary values as part of the ToSql implemenation requires additional work.

Backends using RawBytesBindCollector as BindCollector copy the serialized values as part of Write implementation. This includes the Mysql and the Pg backend provided by diesel. This means existing ToSql implemenations can be used even with temporary values. For these it is required to call Output::reborrow to shorten the lifetime of the Output type correspondenly.

#[repr(i32)]
#[derive(Debug, Clone, Copy, AsExpression)]
#[diesel(sql_type = Integer)]
pub enum MyEnum {
    A = 1,
    B = 2,
}

impl ToSql<Integer, diesel::pg::Pg> for MyEnum
where
    i32: ToSql<Integer, diesel::pg::Pg>,
{
    fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, diesel::pg::Pg>) -> serialize::Result {
        let v = *self as i32;
        <i32 as ToSql<Integer, diesel::pg::Pg>>::to_sql(&v, &mut out.reborrow())
    }
}

For any other backend the Output::set_value method provides a way to set the output value directly. Checkout the documentation of the corresponding BindCollector::Buffer type for provided From<T> implementations for a list of accepted types. For the Sqlite backend see SqliteBindValue.

#[repr(i32)]
#[derive(Debug, Clone, Copy, AsExpression)]
#[diesel(sql_type = Integer)]
pub enum MyEnum {
    A = 1,
    B = 2,
}

impl ToSql<Integer, diesel::sqlite::Sqlite> for MyEnum
where
    i32: ToSql<Integer, diesel::sqlite::Sqlite>,
{
    fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, diesel::sqlite::Sqlite>) -> serialize::Result {
        out.set_value(*self as i32);
        Ok(IsNull::No)
    }
}

Required Methods§

source

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, DB>) -> Result

See the trait documentation.

Trait diesel::serialize::ToSql

Backend specific details

Examples

Required Methods§

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, DB>) -> Result

Implementations on Foreign Types§

impl<'a, A, T, DB> ToSql<A, DB> for &'a Twhere DB: Backend, T: ToSql<A, DB> + ?Sized,

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, DB>) -> Result

impl ToSql<Datetime, Mysql> for NaiveDateTime

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Mysql>) -> Result

impl ToSql<Timestamp, Mysql> for NaiveDateTime

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Mysql>) -> Result

impl ToSql<Time, Mysql> for NaiveTime

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Mysql>) -> Result

impl ToSql<Date, Mysql> for NaiveDate

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Mysql>) -> Result

impl ToSql<Datetime, Mysql> for PrimitiveDateTime

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Mysql>) -> Result

impl ToSql<Timestamp, Mysql> for PrimitiveDateTime

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Mysql>) -> Result

impl ToSql<Datetime, Mysql> for OffsetDateTime

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Mysql>) -> Result

impl ToSql<Timestamp, Mysql> for OffsetDateTime

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Mysql>) -> Result

impl ToSql<Time, Mysql> for NaiveTime

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Mysql>) -> Result

impl ToSql<Date, Mysql> for NaiveDate

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Mysql>) -> Result

impl ToSql<Json, Mysql> for Value

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Mysql>) -> Result

impl ToSql<Numeric, Mysql> for BigDecimal

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Mysql>) -> Result

impl ToSql<TinyInt, Mysql> for i8

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Mysql>) -> Result

impl ToSql<Unsigned<TinyInt>, Mysql> for u8

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Mysql>) -> Result

impl ToSql<Unsigned<SmallInt>, Mysql> for u16

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Mysql>) -> Result

impl ToSql<Unsigned<Integer>, Mysql> for u32

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Mysql>) -> Result

impl ToSql<Unsigned<BigInt>, Mysql> for u64

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Mysql>) -> Result

impl ToSql<Bool, Mysql> for bool

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Mysql>) -> Result

impl ToSql<SmallInt, Mysql> for i16

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Mysql>) -> Result

impl ToSql<Integer, Mysql> for i32

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Mysql>) -> Result

impl ToSql<BigInt, Mysql> for i64

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Mysql>) -> Result

impl ToSql<Double, Mysql> for f64

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Mysql>) -> Result

impl ToSql<Float, Mysql> for f32

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Mysql>) -> Result

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

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Pg>) -> Result

impl<ST, T> ToSql<Nullable<Array<ST>>, Pg> for [T]where [T]: ToSql<Array<ST>, Pg>, ST: 'static,

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Pg>) -> Result

impl<ST, T> ToSql<Array<ST>, Pg> for Vec<T>where ST: 'static, [T]: ToSql<Array<ST>, Pg>, T: Debug,

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Pg>) -> Result

impl<ST, T> ToSql<Nullable<Array<ST>>, Pg> for Vec<T>where ST: 'static, Vec<T>: ToSql<Array<ST>, Pg>,

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Pg>) -> Result

impl ToSql<Timestamp, Pg> for NaiveDateTime

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Pg>) -> Result

impl ToSql<Timestamptz, Pg> for NaiveDateTime

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Pg>) -> Result

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

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Pg>) -> Result

impl ToSql<Time, Pg> for NaiveTime

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Pg>) -> Result

impl ToSql<Date, Pg> for NaiveDate

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Pg>) -> Result

impl ToSql<Timestamp, Pg> for SystemTime

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Pg>) -> Result

impl ToSql<Timestamp, Pg> for PrimitiveDateTime

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Pg>) -> Result

impl ToSql<Timestamptz, Pg> for PrimitiveDateTime

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Pg>) -> Result

impl ToSql<Timestamptz, Pg> for OffsetDateTime

fn to_sql<'b>(&'b self, out: &mut Output<'b, '_, Pg>) -> Result

impl<'a, A, T, DB> ToSql<A, DB> for &'a Twhere
DB: Backend,
T: ToSql<A, DB> + ?Sized,

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

impl<ST, T> ToSql<Nullable<Array<ST>>, Pg> for [T]where
[T]: ToSql<Array<ST>, Pg>,
ST: 'static,

impl<ST, T> ToSql<Array<ST>, Pg> for Vec<T>where
ST: 'static,
[T]: ToSql<Array<ST>, Pg>,
T: Debug,

impl<ST, T> ToSql<Nullable<Array<ST>>, Pg> for Vec<T>where
ST: 'static,
Vec<T>: ToSql<Array<ST>, Pg>,

impl<DB> ToSql<Nullable<MacAddr>, DB> for [u8; 6]where
DB: Backend,
Self: ToSql<MacAddr, DB>,

fn to_sql<'b>(&'b self, out: &mut Output<'__b, '_, __DB>) -> Result

impl<DB> ToSql<Nullable<Inet>, DB> for IpNetworkwhere
DB: Backend,
Self: ToSql<Inet, DB>,

fn to_sql<'b>(&'b self, out: &mut Output<'__b, '_, __DB>) -> Result

impl<DB> ToSql<Nullable<Cidr>, DB> for IpNetworkwhere
DB: Backend,
Self: ToSql<Cidr, DB>,

fn to_sql<'b>(&'b self, out: &mut Output<'__b, '_, __DB>) -> Result

impl<ST, T> ToSql<Range<ST>, Pg> for (Bound<T>, Bound<T>)where
T: ToSql<ST, Pg>,

impl<ST, T> ToSql<Nullable<Range<ST>>, Pg> for (Bound<T>, Bound<T>)where
ST: 'static,
(Bound<T>, Bound<T>): ToSql<Range<ST>, Pg>,

impl<DB> ToSql<Nullable<Uuid>, DB> for Uuidwhere
DB: Backend,
Self: ToSql<Uuid, DB>,

fn to_sql<'b>(&'b self, out: &mut Output<'__b, '_, __DB>) -> Result