Enum Value 

pub enum Value {
    Bool(Option<bool>),
    TinyInt(Option<i8>),
    SmallInt(Option<i16>),
    Int(Option<i32>),
    BigInt(Option<i64>),
    TinyUnsigned(Option<u8>),
    SmallUnsigned(Option<u16>),
    Unsigned(Option<u32>),
    BigUnsigned(Option<u64>),
    Float(Option<f32>),
    Double(Option<f64>),
    String(Option<Box<String>>),
    Char(Option<char>),
    Bytes(Option<Box<Vec<u8>>>),
    Json(Option<Box<Value>>),
    ChronoDate(Option<Box<NaiveDate>>),
    ChronoTime(Option<Box<NaiveTime>>),
    ChronoDateTime(Option<Box<NaiveDateTime>>),
    ChronoDateTimeUtc(Option<Box<DateTime<Utc>>>),
    ChronoDateTimeLocal(Option<Box<DateTime<Local>>>),
    ChronoDateTimeWithTimeZone(Option<Box<DateTime<FixedOffset>>>),
    TimeDate(Option<Box<Date>>),
    TimeTime(Option<Box<Time>>),
    TimeDateTime(Option<Box<PrimitiveDateTime>>),
    TimeDateTimeWithTimeZone(Option<Box<OffsetDateTime>>),
    Uuid(Option<Box<Uuid>>),
    Decimal(Option<Box<Decimal>>),
    BigDecimal(Option<Box<BigDecimal>>),
    Array(ArrayType, Option<Box<Vec<Value>>>),
}

Value variants

We want the inner Value to be exactly 1 pointer sized, so anything larger should be boxed.

If the hashable-value feature is enabled, NaN == NaN, which contradicts Rust’s built-in implementation of NaN != NaN.

Variants

Bool(Option<bool>)

TinyInt(Option<i8>)

SmallInt(Option<i16>)

Int(Option<i32>)

BigInt(Option<i64>)

TinyUnsigned(Option<u8>)

SmallUnsigned(Option<u16>)

Unsigned(Option<u32>)

BigUnsigned(Option<u64>)

Float(Option<f32>)

Double(Option<f64>)

String(Option<Box<String>>)

Char(Option<char>)

Bytes(Option<Box<Vec<u8>>>)

Json(Option<Box<Value>>)

Available on crate feature with-json only.

ChronoDate(Option<Box<NaiveDate>>)

Available on crate feature with-chrono only.

ChronoTime(Option<Box<NaiveTime>>)

Available on crate feature with-chrono only.

ChronoDateTime(Option<Box<NaiveDateTime>>)

Available on crate feature with-chrono only.

ChronoDateTimeUtc(Option<Box<DateTime<Utc>>>)

Available on crate feature with-chrono only.

ChronoDateTimeLocal(Option<Box<DateTime<Local>>>)

Available on crate feature with-chrono only.

ChronoDateTimeWithTimeZone(Option<Box<DateTime<FixedOffset>>>)

Available on crate feature with-chrono only.

TimeDate(Option<Box<Date>>)

Available on crate feature with-time only.

TimeTime(Option<Box<Time>>)

Available on crate feature with-time only.

TimeDateTime(Option<Box<PrimitiveDateTime>>)

Available on crate feature with-time only.

TimeDateTimeWithTimeZone(Option<Box<OffsetDateTime>>)

Available on crate feature with-time only.

Uuid(Option<Box<Uuid>>)

Available on crate feature with-uuid only.

Decimal(Option<Box<Decimal>>)

Available on crate feature with-rust_decimal only.

BigDecimal(Option<Box<BigDecimal>>)

Available on crate feature with-bigdecimal only.

Array(ArrayType, Option<Box<Vec<Value>>>)

Available on crate feature postgres-array only.

Implementations

impl Value

pub fn unwrap<T>(self) -> T

where T: ValueType,

pub fn expect<T>(self, msg: &str) -> T

where T: ValueType,

pub fn as_null(&self) -> Value

Get the null variant of self

use sea_query::Value;

let v = Value::Int(Some(2));
let n = v.as_null();

assert_eq!(n, Value::Int(None));

// one liner:
assert_eq!(Into::<Value>::into(2.2).as_null(), Value::Double(None));

pub fn dummy_value(&self) -> Value

Get a default value of self’s type

use sea_query::Value;

let v = Value::Int(None);
let n = v.dummy_value();
assert_eq!(n, Value::Int(Some(0)));

impl Value

pub fn is_json(&self) -> bool

Available on crate feature with-json only.

pub fn as_ref_json(&self) -> Option<&Value>

Available on crate feature with-json only.

impl Value

pub fn is_chrono_date(&self) -> bool

Available on crate feature with-chrono only.

pub fn as_ref_chrono_date(&self) -> Option<&NaiveDate>

Available on crate feature with-chrono only.

impl Value

pub fn is_time_date(&self) -> bool

Available on crate feature with-time only.

pub fn as_ref_time_date(&self) -> Option<&Date>

Available on crate feature with-time only.

impl Value

pub fn is_chrono_time(&self) -> bool

Available on crate feature with-chrono only.

pub fn as_ref_chrono_time(&self) -> Option<&NaiveTime>

Available on crate feature with-chrono only.

impl Value

pub fn is_time_time(&self) -> bool

Available on crate feature with-time only.

pub fn as_ref_time_time(&self) -> Option<&Time>

Available on crate feature with-time only.

impl Value

pub fn is_chrono_date_time(&self) -> bool

Available on crate feature with-chrono only.

pub fn as_ref_chrono_date_time(&self) -> Option<&NaiveDateTime>

Available on crate feature with-chrono only.

impl Value

pub fn is_time_date_time(&self) -> bool

Available on crate feature with-time only.

pub fn as_ref_time_date_time(&self) -> Option<&PrimitiveDateTime>

Available on crate feature with-time only.

impl Value

pub fn is_chrono_date_time_utc(&self) -> bool

Available on crate feature with-chrono only.

pub fn as_ref_chrono_date_time_utc(&self) -> Option<&DateTime<Utc>>

Available on crate feature with-chrono only.

impl Value

pub fn is_chrono_date_time_local(&self) -> bool

Available on crate feature with-chrono only.

pub fn as_ref_chrono_date_time_local(&self) -> Option<&DateTime<Local>>

Available on crate feature with-chrono only.

impl Value

pub fn is_chrono_date_time_with_time_zone(&self) -> bool

Available on crate feature with-chrono only.

pub fn as_ref_chrono_date_time_with_time_zone( &self, ) -> Option<&DateTime<FixedOffset>>

Available on crate feature with-chrono only.

impl Value

pub fn is_time_date_time_with_time_zone(&self) -> bool

Available on crate feature with-time only.

pub fn as_ref_time_date_time_with_time_zone(&self) -> Option<&OffsetDateTime>

Available on crate feature with-time only.

impl Value

pub fn chrono_as_naive_utc_in_string(&self) -> Option<String>

Available on crate feature with-chrono only.

impl Value

pub fn time_as_naive_utc_in_string(&self) -> Option<String>

Available on crate feature with-time only.

impl Value

pub fn is_decimal(&self) -> bool

Available on crate feature with-rust_decimal only.

pub fn as_ref_decimal(&self) -> Option<&Decimal>

Available on crate feature with-rust_decimal only.

pub fn decimal_to_f64(&self) -> Option<f64>

Available on crate feature with-rust_decimal only.

impl Value

pub fn is_big_decimal(&self) -> bool

Available on crate feature with-bigdecimal only.

pub fn as_ref_big_decimal(&self) -> Option<&BigDecimal>

Available on crate feature with-bigdecimal only.

pub fn big_decimal_to_f64(&self) -> Option<f64>

Available on crate feature with-bigdecimal only.

impl Value

pub fn is_uuid(&self) -> bool

Available on crate feature with-uuid only.

pub fn as_ref_uuid(&self) -> Option<&Uuid>

Available on crate feature with-uuid only.

impl Value

pub fn is_array(&self) -> bool

Available on crate feature postgres-array only.

pub fn as_ref_array(&self) -> Option<&Vec<Value>>

Available on crate feature postgres-array only.

Trait Implementations

impl Clone for Value

fn clone(&self) -> Value

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for Value

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

Formats the value using the given formatter.

impl Display for Value

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

Formats the value using the given formatter.

impl From<&[u8]> for Value

fn from(x: &[u8]) -> Value

Converts to this type from the input type.

impl From<&String> for Value

fn from(x: &String) -> Value

Converts to this type from the input type.

impl From<&str> for Value

fn from(x: &str) -> Value

Converts to this type from the input type.

impl From<BigDecimal> for Value

fn from(x: BigDecimal) -> Value

Converts to this type from the input type.

impl From<Braced> for Value

fn from(x: Braced) -> Value

Converts to this type from the input type.

impl From<Cow<'_, str>> for Value

fn from(x: Cow<'_, str>) -> Value

Converts to this type from the input type.

impl From<Date> for Value

fn from(x: Date) -> Value

Converts to this type from the input type.

impl From<DateTime<FixedOffset>> for Value

fn from(x: DateTime<FixedOffset>) -> Value

Converts to this type from the input type.

impl From<DateTime<Local>> for Value

fn from(v: DateTime<Local>) -> Value

Converts to this type from the input type.

impl From<DateTime<Utc>> for Value

fn from(v: DateTime<Utc>) -> Value

Converts to this type from the input type.

impl From<Decimal> for Value

fn from(x: Decimal) -> Value

Converts to this type from the input type.

impl From<Hyphenated> for Value

fn from(x: Hyphenated) -> Value

Converts to this type from the input type.

impl From<NaiveDate> for Value

fn from(x: NaiveDate) -> Value

Converts to this type from the input type.

impl From<NaiveDateTime> for Value

fn from(x: NaiveDateTime) -> Value

Converts to this type from the input type.

impl From<NaiveTime> for Value

fn from(x: NaiveTime) -> Value

Converts to this type from the input type.

impl From<OffsetDateTime> for Value

fn from(v: OffsetDateTime) -> Value

Converts to this type from the input type.

impl<T> From<Option<T>> for Value

where T: Into<Value> + Nullable,

fn from(x: Option<T>) -> Value

Converts to this type from the input type.

impl From<PrimitiveDateTime> for Value

fn from(x: PrimitiveDateTime) -> Value

Converts to this type from the input type.

impl From<Simple> for Value

fn from(x: Simple) -> Value

Converts to this type from the input type.

impl From<String> for Value

fn from(x: String) -> Value

Converts to this type from the input type.

impl From<Time> for Value

fn from(x: Time) -> Value

Converts to this type from the input type.

impl From<Urn> for Value

fn from(x: Urn) -> Value

Converts to this type from the input type.

impl From<Uuid> for Value

fn from(x: Uuid) -> Value

Converts to this type from the input type.

impl From<Value> for Value

fn from(x: Value) -> Value

Converts to this type from the input type.

impl<T> From<Vec<T>> for Value

where T: Into<Value> + NotU8 + ValueType,

fn from(x: Vec<T>) -> Value

Converts to this type from the input type.

impl From<Vec<u8>> for Value

fn from(x: Vec<u8>) -> Value

Converts to this type from the input type.

impl From<bool> for Value

fn from(x: bool) -> Value

Converts to this type from the input type.

impl From<char> for Value

fn from(x: char) -> Value

Converts to this type from the input type.

impl From<f32> for Value

fn from(x: f32) -> Value

Converts to this type from the input type.

impl From<f64> for Value

fn from(x: f64) -> Value

Converts to this type from the input type.

impl From<i16> for Value

fn from(x: i16) -> Value

Converts to this type from the input type.

impl From<i32> for Value

fn from(x: i32) -> Value

Converts to this type from the input type.

impl From<i64> for Value

fn from(x: i64) -> Value

Converts to this type from the input type.

impl From<i8> for Value

fn from(x: i8) -> Value

Converts to this type from the input type.

impl From<u16> for Value

fn from(x: u16) -> Value

Converts to this type from the input type.

impl From<u32> for Value

fn from(x: u32) -> Value

Converts to this type from the input type.

impl From<u64> for Value

fn from(x: u64) -> Value

Converts to this type from the input type.

impl From<u8> for Value

fn from(x: u8) -> Value

Converts to this type from the input type.

impl Hash for Value

fn hash<H>(&self, state: &mut H)

where H: Hasher,

Feeds this value into the given Hasher.

fn hash_slice<H>(data: &[Self], state: &mut H)

where H: Hasher, Self: Sized,

Feeds a slice of this type into the given Hasher.

impl PartialEq for Value

fn eq(&self, other: &Value) -> bool

Tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl PgExpr for Value

fn concatenate<T>(self, right: T) -> SimpleExpr

where T: Into<SimpleExpr>,

Express an postgres concatenate (||) expression.

fn concat<T>(self, right: T) -> SimpleExpr

where T: Into<SimpleExpr>,

Alias of PgExpr::concatenate

fn matches<T>(self, expr: T) -> SimpleExpr

where T: Into<SimpleExpr>,

Express an postgres fulltext search matches (@@) expression.

fn contains<T>(self, expr: T) -> SimpleExpr

where T: Into<SimpleExpr>,

Express an postgres fulltext search contains (@>) expression.

fn contained<T>(self, expr: T) -> SimpleExpr

where T: Into<SimpleExpr>,

Express an postgres fulltext search contained (<@) expression.

fn ilike<L>(self, like: L) -> SimpleExpr

where L: IntoLikeExpr,

Express a ILIKE expression.

fn not_ilike<L>(self, like: L) -> SimpleExpr

where L: IntoLikeExpr,

Express a NOT ILIKE expression

fn get_json_field<T>(self, right: T) -> SimpleExpr

where T: Into<SimpleExpr>,

Express a postgres retrieves JSON field as JSON value (->).

fn cast_json_field<T>(self, right: T) -> SimpleExpr

where T: Into<SimpleExpr>,

Express a postgres retrieves JSON field and casts it to an appropriate SQL type (->>).

impl SqliteExpr for Value

fn glob<T>(self, right: T) -> SimpleExpr

where T: Into<SimpleExpr>,

Express an sqlite GLOB operator.

fn matches<T>(self, right: T) -> SimpleExpr

where T: Into<SimpleExpr>,

Express an sqlite MATCH operator.

fn get_json_field<T>(self, right: T) -> SimpleExpr

where T: Into<SimpleExpr>,

Express an sqlite retrieves JSON field as JSON value (->).

fn cast_json_field<T>(self, right: T) -> SimpleExpr

where T: Into<SimpleExpr>,

Express an sqlite retrieves JSON field and casts it to an appropriate SQL type (->>).

impl Eq for Value