Struct diesel::sql_types::Nullable

source · [−]

pub struct Nullable<ST: NotNull>(_);

Expand description

The nullable SQL type.

This wraps another SQL type to indicate that it can be null. By default all values are assumed to be NOT NULL.

`ToSql` impls

Any T which implements ToSql<ST>
Option<T> for any T which implements ToSql<ST>

`FromSql` impls

Option<T> for any T which implements FromSql<ST>

Trait Implementations

source

impl<T> Add for Nullable<T> where
 T: Add + NotNull,
 T::Rhs: NotNull,
 T::Output: NotNull,

type Rhs = Nullable<T::Rhs>

The SQL type which can be added to this one

type Output = Nullable<T::Output>

The SQL type of the result of adding Rhs to Self

source

impl<'expr> AsExpression<Nullable<BigInt>> for &'expr i64

type Expression = Bound<Nullable<BigInt>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl<'expr2, 'expr> AsExpression<Nullable<BigInt>> for &'expr2 &'expr i64

type Expression = Bound<Nullable<BigInt>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl AsExpression<Nullable<BigInt>> for i64

type Expression = Bound<Nullable<BigInt>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl<'expr> AsExpression<Nullable<Binary>> for &'expr Vec<u8>

type Expression = Bound<Nullable<Binary>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl<'expr2, 'expr> AsExpression<Nullable<Binary>> for &'expr2 &'expr Vec<u8>

type Expression = Bound<Nullable<Binary>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl AsExpression<Nullable<Binary>> for Vec<u8>

type Expression = Bound<Nullable<Binary>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl<'expr> AsExpression<Nullable<Binary>> for &'expr [u8 ]

type Expression = Bound<Nullable<Binary>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl<'expr2, 'expr> AsExpression<Nullable<Binary>> for &'expr2 &'expr [u8 ]

type Expression = Bound<Nullable<Binary>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl<'expr> AsExpression<Nullable<Bool>> for &'expr bool

type Expression = Bound<Nullable<Bool>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl<'expr2, 'expr> AsExpression<Nullable<Bool>> for &'expr2 &'expr bool

type Expression = Bound<Nullable<Bool>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl AsExpression<Nullable<Bool>> for bool

type Expression = Bound<Nullable<Bool>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl<'expr> AsExpression<Nullable<Double>> for &'expr f64

type Expression = Bound<Nullable<Double>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl<'expr2, 'expr> AsExpression<Nullable<Double>> for &'expr2 &'expr f64

type Expression = Bound<Nullable<Double>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl AsExpression<Nullable<Double>> for f64

type Expression = Bound<Nullable<Double>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl<'expr> AsExpression<Nullable<Float>> for &'expr f32

type Expression = Bound<Nullable<Float>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl<'expr2, 'expr> AsExpression<Nullable<Float>> for &'expr2 &'expr f32

type Expression = Bound<Nullable<Float>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl AsExpression<Nullable<Float>> for f32

type Expression = Bound<Nullable<Float>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl<'expr> AsExpression<Nullable<Integer>> for &'expr i32

type Expression = Bound<Nullable<Integer>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl<'expr2, 'expr> AsExpression<Nullable<Integer>> for &'expr2 &'expr i32

type Expression = Bound<Nullable<Integer>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl AsExpression<Nullable<Integer>> for i32

type Expression = Bound<Nullable<Integer>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl<T, ST> AsExpression<Nullable<ST>> for Option<T> where
ST: NotNull,

type Expression = Bound<Nullable<ST>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl<'a, T, ST> AsExpression<Nullable<ST>> for &'a Option<T> where
ST: NotNull,

type Expression = Bound<Nullable<ST>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl<'expr> AsExpression<Nullable<SmallInt>> for &'expr i16

type Expression = Bound<Nullable<SmallInt>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl<'expr2, 'expr> AsExpression<Nullable<SmallInt>> for &'expr2 &'expr i16

type Expression = Bound<Nullable<SmallInt>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl AsExpression<Nullable<SmallInt>> for i16

type Expression = Bound<Nullable<SmallInt>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl<'expr> AsExpression<Nullable<Text>> for &'expr String

type Expression = Bound<Nullable<Text>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl<'expr2, 'expr> AsExpression<Nullable<Text>> for &'expr2 &'expr String

type Expression = Bound<Nullable<Text>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl AsExpression<Nullable<Text>> for String

type Expression = Bound<Nullable<Text>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl<'expr> AsExpression<Nullable<Text>> for &'expr str

type Expression = Bound<Nullable<Text>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl<'expr2, 'expr> AsExpression<Nullable<Text>> for &'expr2 &'expr str

type Expression = Bound<Nullable<Text>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl AsExpression<Nullable<Timestamp>> for now

type Expression = Coerce<now, Nullable<Timestamp>>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl<'expr> AsExpression<Nullable<Timestamp>> for &'expr SystemTime

type Expression = Bound<Nullable<Timestamp>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl<'expr2, 'expr> AsExpression<Nullable<Timestamp>> for &'expr2 &'expr SystemTime

type Expression = Bound<Nullable<Timestamp>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl AsExpression<Nullable<Timestamp>> for SystemTime

type Expression = Bound<Nullable<Timestamp>, Self>

The expression being returned

source

fn as_expression(self) -> Self::Expression

Perform the conversion

source

impl<ST: Clone + NotNull> Clone for Nullable<ST>

source

fn clone(&self) -> Nullable<ST>

Returns a copy of the value. Read more

1.0.0 · source

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source. Read more

source

impl<ST: Debug + NotNull> Debug for Nullable<ST>

source

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter. Read more

source

impl<ST: Default + NotNull> Default for Nullable<ST>

source

fn default() -> Nullable<ST>

Returns the “default value” for a type. Read more

source

impl<T> Div for Nullable<T> where
 T: Div + NotNull,
 T::Rhs: NotNull,
 T::Output: NotNull,

type Rhs = Nullable<T::Rhs>

The SQL type which this one can be divided by

type Output = Nullable<T::Output>

The SQL type of the result of dividing Self by Rhs

source

impl<T> Foldable for Nullable<T> where
T: Foldable + NotNull,

type Sum = T::Sum

The SQL type of sum(this_type)

type Avg = T::Avg

The SQL type of avg(this_type)

source

impl<T, ST, DB> FromSql<Nullable<ST>, DB> for Option<T> where
 T: FromSql<ST, DB>,
 DB: Backend,
 ST: NotNull,

source

fn from_sql(bytes: Option<&DB::RawValue>) -> Result<Self>

See the trait documentation.

source

impl<T, ST, DB> FromSqlRow<Nullable<ST>, DB> for Option<T> where
 T: FromSqlRow<ST, DB>,
 DB: Backend,
 ST: NotNull,

source

const FIELDS_NEEDED: usize

The number of fields that this type will consume. Must be equal to the number of times you would call row.take() in build_from_row Read more

source

fn build_from_row<R: Row<DB>>(row: &mut R) -> Result<Self>

See the trait documentation.

source

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

source

fn metadata(lookup: &DB::MetadataLookup) -> DB::TypeMetadata

Fetch the metadata for the given type Read more

source

impl<T: NotNull> IntoNullable for Nullable<T>

type Nullable = Nullable<T>

The nullable representation of this type. Read more

source

impl<T> Mul for Nullable<T> where
 T: Mul + NotNull,
 T::Rhs: NotNull,
 T::Output: NotNull,

type Rhs = Nullable<T::Rhs>

The SQL type which this can be multiplied by

type Output = Nullable<T::Output>

The SQL type of the result of multiplying Self by Rhs

source

impl<T> QueryId for Nullable<T> where
T: QueryId + NotNull,

type QueryId = T::QueryId

A type which uniquely represents Self in a SQL query. Read more

source

const HAS_STATIC_QUERY_ID: bool

Can the SQL generated by Self be uniquely identified by its type? Read more

source

fn query_id() -> Option<TypeId>

Returns the type id of Self::QueryId if Self::HAS_STATIC_QUERY_ID. Returns None otherwise. Read more

source

impl<T, ST, DB> Queryable<Nullable<ST>, DB> for Option<T> where
 T: Queryable<ST, DB>,
 DB: Backend,
 Option<T::Row>: FromSqlRow<Nullable<ST>, DB>,
 ST: NotNull,

type Row = Option<T::Row>

The Rust type you’d like to map from. Read more

source

fn build(row: Self::Row) -> Self

Construct an instance of this type

source

impl<T> Sub for Nullable<T> where
 T: Sub + NotNull,
 T::Rhs: NotNull,
 T::Output: NotNull,

type Rhs = Nullable<T::Rhs>

The SQL type which can be subtracted from this one

type Output = Nullable<T::Output>

The SQL type of the result of subtracting Rhs from Self

source

impl<DB> ToSql<Nullable<BigInt>, DB> for i64 where
DB: Backend,
Self: ToSql<BigInt, DB>,

source

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

See the trait documentation.

source

impl<DB> ToSql<Nullable<Binary>, DB> for Vec<u8> where
DB: Backend,
Self: ToSql<Binary, DB>,

source

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

See the trait documentation.

source

impl<DB> ToSql<Nullable<Binary>, DB> for [u8 ] where
DB: Backend,
Self: ToSql<Binary, DB>,

source

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

See the trait documentation.

source

impl<DB> ToSql<Nullable<Bool>, DB> for bool where
DB: Backend,
Self: ToSql<Bool, DB>,

source

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

See the trait documentation.

source

impl<DB> ToSql<Nullable<Double>, DB> for f64 where
DB: Backend,
Self: ToSql<Double, DB>,

source

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

See the trait documentation.

source

impl<DB> ToSql<Nullable<Float>, DB> for f32 where
DB: Backend,
Self: ToSql<Float, DB>,

source

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

See the trait documentation.

source

impl<DB> ToSql<Nullable<Integer>, DB> for i32 where
DB: Backend,
Self: ToSql<Integer, DB>,

source

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

See the trait documentation.

source

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

source

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

See the trait documentation.

source

impl<DB> ToSql<Nullable<SmallInt>, DB> for i16 where
DB: Backend,
Self: ToSql<SmallInt, DB>,

source

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

See the trait documentation.

source

impl<DB> ToSql<Nullable<Text>, DB> for String where
DB: Backend,
Self: ToSql<Text, DB>,

source

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

See the trait documentation.

source

impl<DB> ToSql<Nullable<Text>, DB> for str where
DB: Backend,
Self: ToSql<Text, DB>,

source

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

See the trait documentation.

source

impl<DB> ToSql<Nullable<Timestamp>, DB> for SystemTime where
DB: Backend,
Self: ToSql<Timestamp, DB>,

source

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

See the trait documentation.

source

impl<ST: Copy + NotNull> Copy for Nullable<ST>

source

impl<T: NotNull + SingleValue> SingleValue for Nullable<T>

source

impl<T: SqlOrd + NotNull> SqlOrd for Nullable<T>

Auto Trait Implementations

impl<ST> RefUnwindSafe for Nullable<ST> where
ST: RefUnwindSafe,

impl<ST> Send for Nullable<ST> where
ST: Send,

impl<ST> Sync for Nullable<ST> where
ST: Sync,

impl<ST> Unpin for Nullable<ST> where
ST: Unpin,

impl<ST> UnwindSafe for Nullable<ST> where
ST: UnwindSafe,

Blanket Implementations

source

impl<T> Any for T where
T: 'static + ?Sized,

source

fn type_id(&self) -> TypeId

Gets the TypeId of self. Read more

source

impl<T> Borrow<T> for T where
T: ?Sized,

const: unstable · source

fn borrow(&self) -> &T

Immutably borrows from an owned value. Read more

source

impl<T> BorrowMut<T> for T where
T: ?Sized,

const: unstable · source

fn borrow_mut(&mut self) -> &mut T

Mutably borrows from an owned value. Read more

source

impl<T> From<T> for T

const: unstable · source

fn from(t: T) -> T

Returns the argument unchanged.

source

impl<T, U> Into for T where
U: From<T>,

const: unstable · source

fn into(self) -> U

Calls U::from(self).

That is, this conversion is whatever the implementation of From<T> for U chooses to do.

source

impl<T> IntoSql for T

source

fn into_sql<T>(self) -> AsExprOf<Self, T> where
Self: AsExpression<T> + Sized,

Convert self to an expression for Diesel’s query builder. Read more

source

fn as_sql<'a, T>(&'a self) -> AsExprOf<&'a Self, T> where
&'a Self: AsExpression<T>,

Convert &self to an expression for Diesel’s query builder. Read more

source

impl<T> ToOwned for T where
T: Clone,

type Owned = T

The resulting type after obtaining ownership.

source

fn to_owned(&self) -> T

Creates owned data from borrowed data, usually by cloning. Read more

source

fn clone_into(&self, target: &mut T)

🔬 This is a nightly-only experimental API. (toowned_clone_into)

Uses borrowed data to replace owned data, usually by cloning. Read more

source

impl<T, U> TryFrom for T where
U: Into<T>,

type Error = Infallible

The type returned in the event of a conversion error.

const: unstable · source

fn try_from(value: U) -> Result<T, <T as TryFrom>::Error>

Performs the conversion.

source

impl<T, U> TryInto for T where
U: TryFrom<T>,

type Error = >::Error

The type returned in the event of a conversion error.

const: unstable · source

fn try_into(self) -> Result<U, >::Error>

Performs the conversion.

Struct diesel::sql_types::Nullable

ToSql impls

FromSql impls

Trait Implementations

impl<T> Add for Nullable<T> where T: Add + NotNull, T::Rhs: NotNull, T::Output: NotNull,

type Rhs = Nullable<T::Rhs>

type Output = Nullable<T::Output>

impl<'expr> AsExpression<Nullable<BigInt>> for &'expr i64

type Expression = Bound<Nullable<BigInt>, Self>

fn as_expression(self) -> Self::Expression

impl<'expr2, 'expr> AsExpression<Nullable<BigInt>> for &'expr2 &'expr i64

type Expression = Bound<Nullable<BigInt>, Self>

fn as_expression(self) -> Self::Expression

impl AsExpression<Nullable<BigInt>> for i64

type Expression = Bound<Nullable<BigInt>, Self>

fn as_expression(self) -> Self::Expression

impl<'expr> AsExpression<Nullable<Binary>> for &'expr Vec<u8>

type Expression = Bound<Nullable<Binary>, Self>

fn as_expression(self) -> Self::Expression

impl<'expr2, 'expr> AsExpression<Nullable<Binary>> for &'expr2 &'expr Vec<u8>

type Expression = Bound<Nullable<Binary>, Self>

fn as_expression(self) -> Self::Expression

impl AsExpression<Nullable<Binary>> for Vec<u8>

type Expression = Bound<Nullable<Binary>, Self>

fn as_expression(self) -> Self::Expression

impl<'expr> AsExpression<Nullable<Binary>> for &'expr [u8]

type Expression = Bound<Nullable<Binary>, Self>

fn as_expression(self) -> Self::Expression

impl<'expr2, 'expr> AsExpression<Nullable<Binary>> for &'expr2 &'expr [u8]

type Expression = Bound<Nullable<Binary>, Self>

fn as_expression(self) -> Self::Expression

impl<'expr> AsExpression<Nullable<Bool>> for &'expr bool

type Expression = Bound<Nullable<Bool>, Self>

fn as_expression(self) -> Self::Expression

impl<'expr2, 'expr> AsExpression<Nullable<Bool>> for &'expr2 &'expr bool

type Expression = Bound<Nullable<Bool>, Self>

fn as_expression(self) -> Self::Expression

impl AsExpression<Nullable<Bool>> for bool

type Expression = Bound<Nullable<Bool>, Self>

fn as_expression(self) -> Self::Expression

impl<'expr> AsExpression<Nullable<Double>> for &'expr f64

type Expression = Bound<Nullable<Double>, Self>

fn as_expression(self) -> Self::Expression

impl<'expr2, 'expr> AsExpression<Nullable<Double>> for &'expr2 &'expr f64

type Expression = Bound<Nullable<Double>, Self>

fn as_expression(self) -> Self::Expression

impl AsExpression<Nullable<Double>> for f64

type Expression = Bound<Nullable<Double>, Self>

fn as_expression(self) -> Self::Expression

impl<'expr> AsExpression<Nullable<Float>> for &'expr f32

type Expression = Bound<Nullable<Float>, Self>

fn as_expression(self) -> Self::Expression

impl<'expr2, 'expr> AsExpression<Nullable<Float>> for &'expr2 &'expr f32

type Expression = Bound<Nullable<Float>, Self>

fn as_expression(self) -> Self::Expression

impl AsExpression<Nullable<Float>> for f32

type Expression = Bound<Nullable<Float>, Self>

fn as_expression(self) -> Self::Expression

impl<'expr> AsExpression<Nullable<Integer>> for &'expr i32

type Expression = Bound<Nullable<Integer>, Self>

fn as_expression(self) -> Self::Expression

impl<'expr2, 'expr> AsExpression<Nullable<Integer>> for &'expr2 &'expr i32

type Expression = Bound<Nullable<Integer>, Self>

fn as_expression(self) -> Self::Expression

impl AsExpression<Nullable<Integer>> for i32

type Expression = Bound<Nullable<Integer>, Self>

fn as_expression(self) -> Self::Expression

impl<T, ST> AsExpression<Nullable<ST>> for Option<T> where ST: NotNull,

type Expression = Bound<Nullable<ST>, Self>

fn as_expression(self) -> Self::Expression

impl<'a, T, ST> AsExpression<Nullable<ST>> for &'a Option<T> where ST: NotNull,

type Expression = Bound<Nullable<ST>, Self>

fn as_expression(self) -> Self::Expression

impl<'expr> AsExpression<Nullable<SmallInt>> for &'expr i16

type Expression = Bound<Nullable<SmallInt>, Self>

fn as_expression(self) -> Self::Expression

impl<'expr2, 'expr> AsExpression<Nullable<SmallInt>> for &'expr2 &'expr i16

type Expression = Bound<Nullable<SmallInt>, Self>

fn as_expression(self) -> Self::Expression

impl AsExpression<Nullable<SmallInt>> for i16

`ToSql` impls

`FromSql` impls

impl<T> Add for Nullable<T> where
T: Add + NotNull,
T::Rhs: NotNull,
T::Output: NotNull,

impl<'expr> AsExpression<Nullable<Binary>> for &'expr [u8 ]

impl<'expr2, 'expr> AsExpression<Nullable<Binary>> for &'expr2 &'expr [u8 ]

impl<T, ST> AsExpression<Nullable<ST>> for Option<T> where
ST: NotNull,

impl<'a, T, ST> AsExpression<Nullable<ST>> for &'a Option<T> where
ST: NotNull,

impl<T> Div for Nullable<T> where
T: Div + NotNull,
T::Rhs: NotNull,
T::Output: NotNull,

impl<T> Foldable for Nullable<T> where
T: Foldable + NotNull,

impl<T, ST, DB> FromSql<Nullable<ST>, DB> for Option<T> where
T: FromSql<ST, DB>,
DB: Backend,
ST: NotNull,

impl<T, ST, DB> FromSqlRow<Nullable<ST>, DB> for Option<T> where
T: FromSqlRow<ST, DB>,
DB: Backend,
ST: NotNull,

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

impl<T> Mul for Nullable<T> where
T: Mul + NotNull,
T::Rhs: NotNull,
T::Output: NotNull,

impl<T> QueryId for Nullable<T> where
T: QueryId + NotNull,

impl<T, ST, DB> Queryable<Nullable<ST>, DB> for Option<T> where
T: Queryable<ST, DB>,
DB: Backend,
Option<T::Row>: FromSqlRow<Nullable<ST>, DB>,
ST: NotNull,

impl<T> Sub for Nullable<T> where
T: Sub + NotNull,
T::Rhs: NotNull,
T::Output: NotNull,