Enum mysql_async_support_model::Value

pub enum Value {
    None,
    Bool(bool),
    String(String),
    Bytes(Vec<u8>),
    Int(i64),
    UInt(u64),
    Float(f32),
    Double(f64),
    Date(NaiveDateTime),
    Time(Duration),
}

Programmer-friendly model of MySQL [Value][mysql_async::Value] type.

Note

• You must use prepared statements if you want types to be returned, otherwise it is always returned as Value::Bytes
• There must be only one statement in the query – i.e. no multiple selects.
• Not sure if nested select statements work.

However, I haven’t managed to get MySQL to return Values with proper return types.

See:

• https://github.com/go-sql-driver/mysql/issues/407#issuecomment-172583652
• https://dev.mysql.com/doc/refman/8.0/en/sql-prepared-statements.html

Variants

None

Value was NULL in the database.

Bool(bool)

String(String)

Bytes(Vec<u8>)

Int(i64)

UInt(u64)

Float(f32)

Double(f64)

Date(NaiveDateTime)

DateTime without a time zone.

In mysql_async stores this as Date(u16, u8, u8, u8, u8, u8, u32), correspnding to:

year, month, day, hour, minutes, seconds, micro seconds

If you wish to attach timezone information, such as UTC, you may do something like the following:

use chrono::{NaiveDate, TimeZone, Utc};

let naive_date_time = NaiveDate::from_ymd(2021, 05, 30).and_hms_micro(12, 06, 53, 445);
let _utc_date_time = Utc.from_utc_datetime(&naive_date_time);

See:

• https://docs.rs/mysql_async/latest/mysql_async/enum.Value.html#variant.Date
• https://dev.mysql.com/doc/refman/8.0/en/datetime.html

Time(Duration)

Time offset or duration.

In mysql_async stores this as Time(bool, u32, u8, u8, u8, u32), correspnding to:

is negative, days, hours, minutes, seconds, micro seconds

See:

• https://docs.rs/mysql_async/latest/mysql_async/enum.Value.html#variant.Time
• https://dev.mysql.com/doc/refman/8.0/en/time.html

Trait Implementations

impl Clone for Value

fn clone(&self) -> Value

Returns a copy 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

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for Value

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error> where
    __D: Deserializer<'de>, 

Deserialize this value from the given Serde deserializer.

impl From<Value> for Value

fn from(value: MySqlValue) -> Self

Performs the conversion.

impl FromValue for Value

type Intermediate = ValueIr

fn from_value(v: Value) -> Self

Will panic if could not convert v to Self.

fn from_value_opt(v: Value) -> Result<Self, FromValueError>

Will return Err(Error::FromValueError(v)) if could not convert v to Self.

fn get_intermediate(v: Value) -> Result<Self::Intermediate, FromValueError>

Will return Err(Error::FromValueError(v)) if v is not convertible to Self.

impl PartialEq<Value> for Value

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

This method tests for self and other values to be equal, and is used by ==.

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

This method tests for !=.

impl Serialize for Value

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error> where
    __S: Serializer, 

Serialize this value into the given Serde serializer.

impl StructuralPartialEq for Value