Trait ToSQL 

pub trait ToSQL<'a, V: SQLParam> {
    // Required method
    fn to_sql(&self) -> SQL<'a, V>;

    // Provided method
    fn into_sql(self) -> SQL<'a, V>
       where Self: Sized { ... }
}

Something that renders as a SQL fragment for the value type V.

Columns, tables, expressions, query builders and plain Rust values all implement it. Rust values (i64, &str, Option<T>, …) render as bound parameters, None renders as NULL, and lists (Vec<T>, arrays, slices) render as comma-separated items. 'a lets the fragment borrow its inputs instead of copying them.

Examples

Rendering a custom type:

use drizzle_core::{SQL, ToSQL};

struct Now;

impl<'a> ToSQL<'a, Value> for Now {
    fn to_sql(&self) -> SQL<'a, Value> {
        SQL::raw("CURRENT_TIMESTAMP")
    }
}

assert_eq!(Now.to_sql().sql(), "CURRENT_TIMESTAMP");

Required Methods

fn to_sql(&self) -> SQL<'a, V>

Renders self as a SQL fragment.

Provided Methods

fn into_sql(self) -> SQL<'a, V>

where Self: Sized,

Renders self as a SQL fragment, consuming it.

The default calls to_sql. Types that already hold a fragment (such as SQL and SQLExpr) override it to avoid a clone.

Dyn Compatibility

This trait is dyn compatible.

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

Implementations on Foreign Types

impl<'a, V, T, const N: usize> ToSQL<'a, V> for [T; N]

where V: SQLParam + 'a, T: ToSQL<'a, V>,

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V, T> ToSQL<'a, V> for &'a [T]

where V: SQLParam + 'a, T: ToSQL<'a, V>,

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V, T> ToSQL<'a, V> for Arc<T>

where V: SQLParam + 'a, T: ToSQL<'a, V>,

Available on crate features alloc or std only.

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V, T> ToSQL<'a, V> for Box<T>

where V: SQLParam + 'a, T: ToSQL<'a, V>,

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V, T> ToSQL<'a, V> for Option<T>

where V: SQLParam + 'a, T: ToSQL<'a, V>,

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V, T> ToSQL<'a, V> for Rc<T>

where V: SQLParam + 'a, T: ToSQL<'a, V>,

Available on crate features alloc or std only.

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V, T> ToSQL<'a, V> for Vec<T>

where V: SQLParam + 'a, T: ToSQL<'a, V>,

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V: SQLParam + 'a> ToSQL<'a, V> for ()

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V: SQLParam, T0: ToSQL<'a, V>, T1: ToSQL<'a, V>, T2: ToSQL<'a, V>, T3: ToSQL<'a, V>, T4: ToSQL<'a, V>, T5: ToSQL<'a, V>, T6: ToSQL<'a, V>, T7: ToSQL<'a, V>, T8: ToSQL<'a, V>, T9: ToSQL<'a, V>, T10: ToSQL<'a, V>, T11: ToSQL<'a, V>, T12: ToSQL<'a, V>, T13: ToSQL<'a, V>, T14: ToSQL<'a, V>, T15: ToSQL<'a, V>> ToSQL<'a, V> for (T0, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15)

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V: SQLParam, T0: ToSQL<'a, V>, T1: ToSQL<'a, V>, T2: ToSQL<'a, V>, T3: ToSQL<'a, V>, T4: ToSQL<'a, V>, T5: ToSQL<'a, V>, T6: ToSQL<'a, V>, T7: ToSQL<'a, V>, T8: ToSQL<'a, V>, T9: ToSQL<'a, V>, T10: ToSQL<'a, V>, T11: ToSQL<'a, V>, T12: ToSQL<'a, V>, T13: ToSQL<'a, V>, T14: ToSQL<'a, V>> ToSQL<'a, V> for (T0, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14)

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V: SQLParam, T0: ToSQL<'a, V>, T1: ToSQL<'a, V>, T2: ToSQL<'a, V>, T3: ToSQL<'a, V>, T4: ToSQL<'a, V>, T5: ToSQL<'a, V>, T6: ToSQL<'a, V>, T7: ToSQL<'a, V>, T8: ToSQL<'a, V>, T9: ToSQL<'a, V>, T10: ToSQL<'a, V>, T11: ToSQL<'a, V>, T12: ToSQL<'a, V>, T13: ToSQL<'a, V>> ToSQL<'a, V> for (T0, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13)

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V: SQLParam, T0: ToSQL<'a, V>, T1: ToSQL<'a, V>, T2: ToSQL<'a, V>, T3: ToSQL<'a, V>, T4: ToSQL<'a, V>, T5: ToSQL<'a, V>, T6: ToSQL<'a, V>, T7: ToSQL<'a, V>, T8: ToSQL<'a, V>, T9: ToSQL<'a, V>, T10: ToSQL<'a, V>, T11: ToSQL<'a, V>, T12: ToSQL<'a, V>> ToSQL<'a, V> for (T0, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12)

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V: SQLParam, T0: ToSQL<'a, V>, T1: ToSQL<'a, V>, T2: ToSQL<'a, V>, T3: ToSQL<'a, V>, T4: ToSQL<'a, V>, T5: ToSQL<'a, V>, T6: ToSQL<'a, V>, T7: ToSQL<'a, V>, T8: ToSQL<'a, V>, T9: ToSQL<'a, V>, T10: ToSQL<'a, V>, T11: ToSQL<'a, V>> ToSQL<'a, V> for (T0, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11)

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V: SQLParam, T0: ToSQL<'a, V>, T1: ToSQL<'a, V>, T2: ToSQL<'a, V>, T3: ToSQL<'a, V>, T4: ToSQL<'a, V>, T5: ToSQL<'a, V>, T6: ToSQL<'a, V>, T7: ToSQL<'a, V>, T8: ToSQL<'a, V>, T9: ToSQL<'a, V>, T10: ToSQL<'a, V>> ToSQL<'a, V> for (T0, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10)

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V: SQLParam, T0: ToSQL<'a, V>, T1: ToSQL<'a, V>, T2: ToSQL<'a, V>, T3: ToSQL<'a, V>, T4: ToSQL<'a, V>, T5: ToSQL<'a, V>, T6: ToSQL<'a, V>, T7: ToSQL<'a, V>, T8: ToSQL<'a, V>, T9: ToSQL<'a, V>> ToSQL<'a, V> for (T0, T1, T2, T3, T4, T5, T6, T7, T8, T9)

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V: SQLParam, T0: ToSQL<'a, V>, T1: ToSQL<'a, V>, T2: ToSQL<'a, V>, T3: ToSQL<'a, V>, T4: ToSQL<'a, V>, T5: ToSQL<'a, V>, T6: ToSQL<'a, V>, T7: ToSQL<'a, V>, T8: ToSQL<'a, V>> ToSQL<'a, V> for (T0, T1, T2, T3, T4, T5, T6, T7, T8)

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V: SQLParam, T0: ToSQL<'a, V>, T1: ToSQL<'a, V>, T2: ToSQL<'a, V>, T3: ToSQL<'a, V>, T4: ToSQL<'a, V>, T5: ToSQL<'a, V>, T6: ToSQL<'a, V>, T7: ToSQL<'a, V>> ToSQL<'a, V> for (T0, T1, T2, T3, T4, T5, T6, T7)

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V: SQLParam, T0: ToSQL<'a, V>, T1: ToSQL<'a, V>, T2: ToSQL<'a, V>, T3: ToSQL<'a, V>, T4: ToSQL<'a, V>, T5: ToSQL<'a, V>, T6: ToSQL<'a, V>> ToSQL<'a, V> for (T0, T1, T2, T3, T4, T5, T6)

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V: SQLParam, T0: ToSQL<'a, V>, T1: ToSQL<'a, V>, T2: ToSQL<'a, V>, T3: ToSQL<'a, V>, T4: ToSQL<'a, V>, T5: ToSQL<'a, V>> ToSQL<'a, V> for (T0, T1, T2, T3, T4, T5)

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V: SQLParam, T0: ToSQL<'a, V>, T1: ToSQL<'a, V>, T2: ToSQL<'a, V>, T3: ToSQL<'a, V>, T4: ToSQL<'a, V>> ToSQL<'a, V> for (T0, T1, T2, T3, T4)

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V: SQLParam, T0: ToSQL<'a, V>, T1: ToSQL<'a, V>, T2: ToSQL<'a, V>, T3: ToSQL<'a, V>> ToSQL<'a, V> for (T0, T1, T2, T3)

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V: SQLParam, T0: ToSQL<'a, V>, T1: ToSQL<'a, V>, T2: ToSQL<'a, V>> ToSQL<'a, V> for (T0, T1, T2)

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V: SQLParam, T0: ToSQL<'a, V>, T1: ToSQL<'a, V>> ToSQL<'a, V> for (T0, T1)

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V: SQLParam, T0: ToSQL<'a, V>> ToSQL<'a, V> for (T0,)

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V: SQLParam, T> ToSQL<'a, V> for &T

where T: ToSQL<'a, V>,

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V> ToSQL<'a, V> for &'a str

where V: SQLParam + 'a + From<&'a str> + Into<Cow<'a, V>>,

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V> ToSQL<'a, V> for Arc<str>

where V: SQLParam + 'a + From<String> + Into<Cow<'a, V>>,

Available on crate features alloc or std only.

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V> ToSQL<'a, V> for Box<str>

where V: SQLParam + 'a + From<String> + Into<Cow<'a, V>>,

fn to_sql(&self) -> SQL<'a, V>

fn into_sql(self) -> SQL<'a, V>

impl<'a, V> ToSQL<'a, V> for Cow<'a, [u8]>

where V: SQLParam + 'a + From<&'a [u8]> + From<Vec<u8>> + Into<Cow<'a, V>>,

fn to_sql(&self) -> SQL<'a, V>

fn into_sql(self) -> SQL<'a, V>

impl<'a, V> ToSQL<'a, V> for Cow<'a, str>

where V: SQLParam + 'a + From<&'a str> + From<String> + Into<Cow<'a, V>>,

fn to_sql(&self) -> SQL<'a, V>

fn into_sql(self) -> SQL<'a, V>

impl<'a, V> ToSQL<'a, V> for Rc<str>

where V: SQLParam + 'a + From<String> + Into<Cow<'a, V>>,

Available on crate features alloc or std only.

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V> ToSQL<'a, V> for String

where V: SQLParam + 'a + From<Self> + Into<Cow<'a, V>>,

fn to_sql(&self) -> SQL<'a, V>

fn into_sql(self) -> SQL<'a, V>

impl<'a, V> ToSQL<'a, V> for bool

where V: SQLParam + 'a + From<bool> + Into<Cow<'a, V>>,

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V> ToSQL<'a, V> for char

where V: SQLParam + 'a + From<char> + Into<Cow<'a, V>>,

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V> ToSQL<'a, V> for f32

where V: SQLParam + 'a + From<f32> + Into<Cow<'a, V>>,

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V> ToSQL<'a, V> for f64

where V: SQLParam + 'a + From<f64> + Into<Cow<'a, V>>,

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V> ToSQL<'a, V> for i8

where V: SQLParam + 'a + From<i8> + Into<Cow<'a, V>>,

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V> ToSQL<'a, V> for i16

where V: SQLParam + 'a + From<i16> + Into<Cow<'a, V>>,

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V> ToSQL<'a, V> for i32

where V: SQLParam + 'a + From<i32> + Into<Cow<'a, V>>,

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V> ToSQL<'a, V> for i64

where V: SQLParam + 'a + From<i64> + Into<Cow<'a, V>>,

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V> ToSQL<'a, V> for isize

where V: SQLParam + 'a + From<isize> + Into<Cow<'a, V>>,

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V> ToSQL<'a, V> for u8

where V: SQLParam + 'a + From<u8> + Into<Cow<'a, V>>,

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V> ToSQL<'a, V> for u16

where V: SQLParam + 'a + From<u16> + Into<Cow<'a, V>>,

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V> ToSQL<'a, V> for u32

where V: SQLParam + 'a + From<u32> + Into<Cow<'a, V>>,

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V> ToSQL<'a, V> for u64

where V: SQLParam + 'a + From<u64> + Into<Cow<'a, V>>,

fn to_sql(&self) -> SQL<'a, V>

impl<'a, V> ToSQL<'a, V> for usize

where V: SQLParam + 'a + From<usize> + Into<Cow<'a, V>>,

fn to_sql(&self) -> SQL<'a, V>

Implementors

impl<'a, V, C> ToSQL<'a, V> for Excluded<C>

where V: SQLParam + 'a, V::DialectMarker: DialectSupports<Excluded>, C: SQLColumnInfo,

impl<'a, V, E, Name> ToSQL<'a, V> for NamedExpr<E, Name>

where V: SQLParam + 'a, E: ToSQL<'a, V>, Name: Tag,

impl<'a, V, E> ToSQL<'a, V> for AliasedExpr<E>

where V: SQLParam + 'a, E: ToSQL<'a, V>,

impl<'a, V, Name, Output> ToSQL<'a, V> for DerivedField<Name, Output>

where V: SQLParam, Name: Tag, Output: ProjectionOutput,

impl<'a, V, Name, Projection, Query> ToSQL<'a, V> for Derived<'a, V, Name, Projection, Query>

where V: SQLParam, Name: Tag, Query: ToSQL<'a, V>,

impl<'a, V, Table, Query> ToSQL<'a, V> for CTEView<'a, V, Table, Query>

where V: SQLParam, Query: ToSQL<'a, V>,

impl<'a, V: SQLParam + 'a, T: DataType, N: Nullability> ToSQL<'a, V> for TypedPlaceholder<T, N>

impl<'a, V: SQLParam + 'a> ToSQL<'a, V> for ColumnRef

impl<'a, V: SQLParam + 'a> ToSQL<'a, V> for Join

impl<'a, V: SQLParam + 'a> ToSQL<'a, V> for OrderBy

Renders ASC or DESC.

impl<'a, V: SQLParam + 'a> ToSQL<'a, V> for Placeholder

impl<'a, V: SQLParam + 'a> ToSQL<'a, V> for SQL<'a, V>

impl<'a, V: SQLParam + 'a> ToSQL<'a, V> for SQLNull

impl<'a, V: SQLParam + 'a> ToSQL<'a, V> for TableRef

impl<'a, V: SQLParam, S> ToSQL<'a, V> for Ordered<'a, V, S>

impl<'a, V: SQLParam, T: DataType, N: Nullability, A: AggregateKind, S> ToSQL<'a, V> for SQLExpr<'a, V, T, N, A, S>

impl<'a, V: SQLParam> ToSQL<'a, V> for OwnedPreparedStatement<V>

impl<'a, V: SQLParam> ToSQL<'a, V> for PreparedStatement<'a, V>

impl<'a, V> ToSQL<'a, V> for SQLBytes<'a>

where V: SQLParam + 'a + From<&'a [u8]> + From<Vec<u8>> + Into<Cow<'a, V>>,

impl<V: SQLParam> ToSQL<'static, V> for OwnedSQL<V>