pub enum Value {
Show 37 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<String>),
Char(Option<char>),
Bytes(Option<Vec<u8>>),
Json(Option<Value>),
ChronoDate(Option<NaiveDate>),
ChronoTime(Option<NaiveTime>),
ChronoDateTime(Option<NaiveDateTime>),
ChronoDateTimeUtc(Option<DateTime<Utc>>),
ChronoDateTimeLocal(Option<DateTime<Local>>),
ChronoDateTimeWithTimeZone(Option<DateTime<FixedOffset>>),
TimeDate(Option<Date>),
TimeTime(Option<Time>),
TimeDateTime(Option<PrimitiveDateTime>),
TimeDateTimeWithTimeZone(Option<OffsetDateTime>),
JiffDate(Option<Date>),
JiffTime(Option<Time>),
JiffDateTime(Option<Box<DateTime>>),
JiffTimestamp(Option<Box<Timestamp>>),
JiffZoned(Option<Box<Zoned>>),
Uuid(Option<Uuid>),
Decimal(Option<Decimal>),
BigDecimal(Option<Box<BigDecimal>>),
Array(ArrayType, Option<Box<Vec<Value>>>),
Vector(Option<Vector>),
IpNetwork(Option<IpNetwork>),
MacAddress(Option<MacAddress>),
}Expand description
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<String>)
Char(Option<char>)
Bytes(Option<Vec<u8>>)
Json(Option<Value>)
Available on crate feature
with-json only.ChronoDate(Option<NaiveDate>)
Available on crate feature
with-chrono only.ChronoTime(Option<NaiveTime>)
Available on crate feature
with-chrono only.ChronoDateTime(Option<NaiveDateTime>)
Available on crate feature
with-chrono only.ChronoDateTimeUtc(Option<DateTime<Utc>>)
Available on crate feature
with-chrono only.ChronoDateTimeLocal(Option<DateTime<Local>>)
Available on crate feature
with-chrono only.ChronoDateTimeWithTimeZone(Option<DateTime<FixedOffset>>)
Available on crate feature
with-chrono only.TimeDate(Option<Date>)
Available on crate feature
with-time only.TimeTime(Option<Time>)
Available on crate feature
with-time only.TimeDateTime(Option<PrimitiveDateTime>)
Available on crate feature
with-time only.TimeDateTimeWithTimeZone(Option<OffsetDateTime>)
Available on crate feature
with-time only.JiffDate(Option<Date>)
Available on crate feature
with-jiff only.JiffTime(Option<Time>)
Available on crate feature
with-jiff only.JiffDateTime(Option<Box<DateTime>>)
Available on crate feature
with-jiff only.JiffTimestamp(Option<Box<Timestamp>>)
Available on crate feature
with-jiff only.JiffZoned(Option<Box<Zoned>>)
Available on crate feature
with-jiff only.Uuid(Option<Uuid>)
Available on crate feature
with-uuid only.Decimal(Option<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.Vector(Option<Vector>)
Available on crate feature
postgres-vector only.IpNetwork(Option<IpNetwork>)
Available on crate feature
with-ipnetwork only.MacAddress(Option<MacAddress>)
Available on crate feature
with-mac_address only.Implementationsยง
Sourceยงimpl Value
impl Value
pub fn is_chrono_date(&self) -> bool
Available on crate feature
with-chrono only.pub fn is_chrono_time(&self) -> bool
Available on crate feature
with-chrono only.pub fn is_chrono_date_time(&self) -> bool
Available on crate feature
with-chrono only.pub fn is_chrono_date_time_utc(&self) -> bool
Available on crate feature
with-chrono only.pub fn is_chrono_date_time_with_time_zone(&self) -> bool
Available on crate feature
with-chrono only.pub fn is_chrono_date_time_local(&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.pub fn as_ref_chrono_time(&self) -> Option<&NaiveTime>
Available on crate feature
with-chrono only.pub fn as_ref_chrono_date_time(&self) -> Option<&NaiveDateTime>
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.pub fn as_ref_chrono_date_time_with_time_zone( &self, ) -> Option<&DateTime<FixedOffset>>
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.pub fn chrono_as_naive_utc_in_string(&self) -> Option<String>
Available on crate feature
with-chrono only.Sourceยงimpl Value
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.Sourceยงimpl Value
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.Sourceยงimpl Value
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.Sourceยงimpl Value
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.Sourceยงimpl Value
impl Value
pub fn time_as_naive_utc_in_string(&self) -> Option<String>
Available on crate feature
with-time only.Sourceยงimpl Value
impl Value
pub fn jiff_date<T: Into<Option<Date>>>(v: T) -> Value
Available on crate feature
with-jiff only.pub fn jiff_time<T: Into<Option<Time>>>(v: T) -> Value
Available on crate feature
with-jiff only.pub fn jiff_date_time<T: Into<Option<DateTime>>>(v: T) -> Value
Available on crate feature
with-jiff only.pub fn jiff_timestamp<T: Into<Option<Timestamp>>>(v: T) -> Value
Available on crate feature
with-jiff only.pub fn jiff_zoned<T: Into<Option<Zoned>>>(v: T) -> Value
Available on crate feature
with-jiff only.Sourceยงimpl Value
impl Value
pub fn is_jiff_date(&self) -> bool
Available on crate feature
with-jiff only.pub fn is_jiff_time(&self) -> bool
Available on crate feature
with-jiff only.pub fn is_jiff_date_time(&self) -> bool
Available on crate feature
with-jiff only.pub fn is_jiff_timestamp(&self) -> bool
Available on crate feature
with-jiff only.pub fn is_jiff_zoned(&self) -> bool
Available on crate feature
with-jiff only.pub fn as_ref_jiff_date(&self) -> Option<&Date>
Available on crate feature
with-jiff only.pub fn as_ref_jiff_time(&self) -> Option<&Time>
Available on crate feature
with-jiff only.pub fn as_ref_jiff_date_time(&self) -> Option<&DateTime>
Available on crate feature
with-jiff only.pub fn as_ref_jiff_timestamp(&self) -> Option<&Timestamp>
Available on crate feature
with-jiff only.pub fn as_ref_jiff_zoned(&self) -> Option<&Zoned>
Available on crate feature
with-jiff only.Sourceยงimpl Value
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.Sourceยงimpl Value
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.Sourceยงimpl Value
impl Value
pub fn is_mac_address(&self) -> bool
Available on crate feature
with-mac_address only.pub fn as_ref_mac_address(&self) -> Option<&MacAddress>
Available on crate feature
with-mac_address only.Sourceยงimpl Value
impl Value
pub fn unwrap<T>(self) -> Twhere
T: ValueType,
pub fn expect<T>(self, msg: &str) -> Twhere
T: ValueType,
Sourcepub fn as_null(&self) -> Self
pub fn as_null(&self) -> Self
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));Sourcepub fn dummy_value(&self) -> Self
pub fn dummy_value(&self) -> Self
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)));Trait Implementationsยง
Sourceยงimpl<'de> Deserialize<'de> for Value
impl<'de> Deserialize<'de> for Value
Sourceยงfn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>where
__D: Deserializer<'de>,
fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>where
__D: Deserializer<'de>,
Deserialize this value from the given Serde deserializer. Read more
Sourceยงimpl From<BigDecimal> for Value
Available on crate feature with-bigdecimal only.
impl From<BigDecimal> for Value
Available on crate feature
with-bigdecimal only.Sourceยงfn from(x: BigDecimal) -> Value
fn from(x: BigDecimal) -> Value
Converts to this type from the input type.
Sourceยงimpl From<Hyphenated> for Value
Available on crate feature with-uuid only.
impl From<Hyphenated> for Value
Available on crate feature
with-uuid only.Sourceยงfn from(x: Hyphenated) -> Value
fn from(x: Hyphenated) -> Value
Converts to this type from the input type.
Sourceยงimpl From<MacAddress> for Value
Available on crate feature with-mac_address only.
impl From<MacAddress> for Value
Available on crate feature
with-mac_address only.Sourceยงfn from(x: MacAddress) -> Value
fn from(x: MacAddress) -> Value
Converts to this type from the input type.
Sourceยงimpl From<NaiveDateTime> for Value
Available on crate feature with-chrono only.
impl From<NaiveDateTime> for Value
Available on crate feature
with-chrono only.Sourceยงfn from(x: NaiveDateTime) -> Value
fn from(x: NaiveDateTime) -> Value
Converts to this type from the input type.
Sourceยงimpl From<OffsetDateTime> for Value
Available on crate feature with-time only.
impl From<OffsetDateTime> for Value
Available on crate feature
with-time only.Sourceยงfn from(v: OffsetDateTime) -> Value
fn from(v: OffsetDateTime) -> Value
Converts to this type from the input type.
Sourceยงimpl From<PrimitiveDateTime> for Value
Available on crate feature with-time only.
impl From<PrimitiveDateTime> for Value
Available on crate feature
with-time only.Sourceยงfn from(x: PrimitiveDateTime) -> Value
fn from(x: PrimitiveDateTime) -> Value
Converts to this type from the input type.
impl Eq for Value
Available on crate feature
hashable-value only.Auto Trait Implementationsยง
impl Freeze for Value
impl RefUnwindSafe for Value
impl Send for Value
impl Sync for Value
impl Unpin for Value
impl UnwindSafe for Value
Blanket Implementationsยง
Sourceยงimpl<T> BorrowMut<T> for Twhere
T: ?Sized,
impl<T> BorrowMut<T> for Twhere
T: ?Sized,
Sourceยงfn borrow_mut(&mut self) -> &mut T
fn borrow_mut(&mut self) -> &mut T
Mutably borrows from an owned value. Read more
Sourceยงimpl<T> CloneToUninit for Twhere
T: Clone,
impl<T> CloneToUninit for Twhere
T: Clone,
Sourceยงimpl<T> ExprTrait for T
impl<T> ExprTrait for T
Sourceยงfn as_enum<N>(self, type_name: N) -> Exprwhere
N: IntoIden,
fn as_enum<N>(self, type_name: N) -> Exprwhere
N: IntoIden,
Express a
AS enum expression. Read moreSourceยงfn cast_as<N>(self, type_name: N) -> Exprwhere
N: IntoIden,
fn cast_as<N>(self, type_name: N) -> Exprwhere
N: IntoIden,
Express a
CAST AS expression. Read moreSourceยงfn equals<C>(self, col: C) -> Exprwhere
C: IntoColumnRef,
fn equals<C>(self, col: C) -> Exprwhere
C: IntoColumnRef,
Express a equal expression between two table columns,
you will mainly use this to relate identical value between two table columns. Read more
Sourceยงfn in_subquery(self, sel: SelectStatement) -> Expr
fn in_subquery(self, sel: SelectStatement) -> Expr
Express a
IN sub-query expression. Read moreSourceยงfn in_tuples<V, I>(self, v: I) -> Exprwhere
V: IntoValueTuple,
I: IntoIterator<Item = V>,
fn in_tuples<V, I>(self, v: I) -> Exprwhere
V: IntoValueTuple,
I: IntoIterator<Item = V>,
Express a
IN sub expression. Read moreSourceยงfn is_not_null(self) -> Expr
fn is_not_null(self) -> Expr
Express a
IS NOT NULL expression. Read moreSourceยงfn left_shift<R>(self, right: R) -> Expr
fn left_shift<R>(self, right: R) -> Expr
Express a bitwise left shift. Read more
Sourceยงfn not_between<A, B>(self, a: A, b: B) -> Expr
fn not_between<A, B>(self, a: A, b: B) -> Expr
Express a
NOT BETWEEN expression. Read moreSourceยงfn not_equals<C>(self, col: C) -> Exprwhere
C: IntoColumnRef,
fn not_equals<C>(self, col: C) -> Exprwhere
C: IntoColumnRef,
Express a not equal expression between two table columns,
you will mainly use this to relate identical value between two table columns. Read more
Sourceยงfn not_in_subquery(self, sel: SelectStatement) -> Expr
fn not_in_subquery(self, sel: SelectStatement) -> Expr
Express a
NOT IN sub-query expression. Read moreSourceยงfn not_like<L>(self, like: L) -> Exprwhere
L: IntoLikeExpr,
fn not_like<L>(self, like: L) -> Exprwhere
L: IntoLikeExpr,
Express a
NOT LIKE expression. Read moreSourceยงfn right_shift<R>(self, right: R) -> Expr
fn right_shift<R>(self, right: R) -> Expr
Express a bitwise right shift. Read more
Sourceยงimpl<T> IntoValueTuple for Twhere
T: Into<ValueTuple>,
impl<T> IntoValueTuple for Twhere
T: Into<ValueTuple>,
fn into_value_tuple(self) -> ValueTuple
Sourceยงimpl<T> PgExpr for Twhere
T: ExprTrait,
impl<T> PgExpr for Twhere
T: ExprTrait,
Sourceยงfn concatenate<T>(self, right: T) -> Expr
fn concatenate<T>(self, right: T) -> Expr
Available on crate feature
backend-postgres only.Express an postgres concatenate (
||) expression. Read moreSourceยงfn concat<T>(self, right: T) -> Expr
fn concat<T>(self, right: T) -> Expr
Available on crate feature
backend-postgres only.Alias of
PgExpr::concatenateSourceยงfn matches<T>(self, expr: T) -> Expr
fn matches<T>(self, expr: T) -> Expr
Available on crate feature
backend-postgres only.Express an postgres fulltext search matches (
@@) expression. Read moreSourceยงfn contains<T>(self, expr: T) -> Expr
fn contains<T>(self, expr: T) -> Expr
Available on crate feature
backend-postgres only.Express an postgres fulltext search contains (
@>) expression. Read moreSourceยงfn contained<T>(self, expr: T) -> Expr
fn contained<T>(self, expr: T) -> Expr
Available on crate feature
backend-postgres only.Express an postgres fulltext search contained (
<@) expression. Read moreSourceยงfn ilike<L>(self, like: L) -> Exprwhere
L: IntoLikeExpr,
fn ilike<L>(self, like: L) -> Exprwhere
L: IntoLikeExpr,
Available on crate feature
backend-postgres only.Express a
ILIKE expression. Read moreSourceยงfn not_ilike<L>(self, like: L) -> Exprwhere
L: IntoLikeExpr,
fn not_ilike<L>(self, like: L) -> Exprwhere
L: IntoLikeExpr,
Available on crate feature
backend-postgres only.Express a
NOT ILIKE expressionSourceยงfn get_json_field<T>(self, right: T) -> Expr
fn get_json_field<T>(self, right: T) -> Expr
Available on crate feature
backend-postgres only.Express a postgres retrieves JSON field as JSON value (
->). Read moreSourceยงimpl<T> SqliteExpr for Twhere
T: ExprTrait,
impl<T> SqliteExpr for Twhere
T: ExprTrait,
Sourceยงfn glob<T>(self, right: T) -> Expr
fn glob<T>(self, right: T) -> Expr
Available on crate feature
backend-sqlite only.Express an sqlite
GLOB operator. Read moreSourceยงfn matches<T>(self, right: T) -> Expr
fn matches<T>(self, right: T) -> Expr
Available on crate feature
backend-sqlite only.Express an sqlite
MATCH operator. Read moreSourceยงfn get_json_field<T>(self, right: T) -> Expr
fn get_json_field<T>(self, right: T) -> Expr
Available on crate feature
backend-sqlite only.Express an sqlite retrieves JSON field as JSON value (
->). Read more