Enum MySQLValue 

pub enum MySQLValue<'a> {
    Null,
    Bytes(Cow<'a, [u8]>),
    Int(i64),
    UInt(u64),
    Float(f32),
    Double(f64),
    Date {
        year: u16,
        month: u8,
        day: u8,
        hour: u8,
        minute: u8,
        second: u8,
        microseconds: u32,
    },
    Time {
        negative: bool,
        days: u32,
        hours: u8,
        minutes: u8,
        seconds: u8,
        microseconds: u32,
    },
}

A value in one of MySQL’s wire categories, possibly borrowing its bytes.

Used for bound parameters and for cells read from a row. The variants mirror the values of the mysql and mysql_async clients, so this crate does not depend on either. See OwnedMySQLValue for an owned form.

Variants

Null

SQL NULL.

Bytes(Cow<'a, [u8]>)

Text, binary, decimal, JSON, enum, and set payloads.

Int(i64)

Signed integer payload.

UInt(u64)

Unsigned integer payload.

Float(f32)

Single-precision floating-point payload.

Double(f64)

Double-precision floating-point payload.

Date

Date, datetime, or timestamp payload.

Fields

year: u16

Four-digit year.

month: u8

Month in the range 1 through 12.

day: u8

Day of the month.

hour: u8

Hour in the range 0 through 23.

minute: u8

Minute in the range 0 through 59.

second: u8

Second in the range 0 through 59.

microseconds: u32

Fractional seconds in microseconds.

Time

Time or duration payload.

Fields

negative: bool

Whether the duration is negative.

days: u32

Whole days in the duration.

hours: u8

Remaining hours after whole days.

minutes: u8

Remaining minutes after whole hours.

seconds: u8

Remaining seconds after whole minutes.

microseconds: u32

Fractional seconds in microseconds.

Implementations

impl MySQLValue<'_>

pub const fn is_null(&self) -> bool

Returns true if this value is SQL NULL.

pub fn as_bytes(&self) -> Option<&[u8]>

Returns the bytes of a Bytes value (text, binary, decimal, JSON, enum or set), or None for other variants.

pub fn as_ref(&self) -> MySQLValue<'_>

Returns a borrowed view of this value.

pub fn into_owned(self) -> OwnedMySQLValue

Converts this value into an owned representation.

Trait Implementations

impl<'a> Clone for MySQLValue<'a>

fn clone(&self) -> Self

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl<'a> Debug for MySQLValue<'a>

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

Formats the value using the given formatter.

impl<'a> Default for MySQLValue<'a>

fn default() -> Self

Returns the “default value” for a type.

impl<'a, S, State, T, M, R, G> Expr<'a, MySQLValue<'a>> for SelectBuilder<'a, S, State, T, M, R, G>

where State: ClauseAllowed<Compound> + ExecutableState, M: SubqueryType<'a, MySQLValue<'a>> + SelectSources,

type SQLType = <M as SubqueryType<'a, MySQLValue<'a>>>::SQLType

The SQL data type this expression evaluates to.

type Nullable = Null

Whether this expression can be NULL.

type Aggregate = Scalar

Whether this is an aggregate (COUNT, SUM) or scalar expression.

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

Renders this value as a scalar expression, borrowing it.

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

where Self: Sized,

Renders this value as a scalar expression, consuming it.

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

Renders this value as one element of a ConditionList.

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

where Self: Sized,

Consuming counterpart of Expr::to_condition_sql.

impl<'a> From<&'a Arc<String>> for MySQLValue<'a>

fn from(value: &'a Arc<String>) -> Self

Converts to this type from the input type.

impl<'a> From<&'a Arc<Vec<u8>>> for MySQLValue<'a>

fn from(value: &'a Arc<Vec<u8>>) -> Self

Converts to this type from the input type.

impl<'a> From<&'a Arc<str>> for MySQLValue<'a>

fn from(value: &'a Arc<str>) -> Self

Converts to this type from the input type.

impl<'a> From<&'a Box<String>> for MySQLValue<'a>

fn from(value: &'a Box<String>) -> Self

Converts to this type from the input type.

impl<'a> From<&'a Box<Vec<u8>>> for MySQLValue<'a>

fn from(value: &'a Box<Vec<u8>>) -> Self

Converts to this type from the input type.

impl<'a> From<&'a Box<str>> for MySQLValue<'a>

fn from(value: &'a Box<str>) -> Self

Converts to this type from the input type.

impl<'a> From<&'a MySQLValue<'a>> for Cow<'a, MySQLValue<'a>>

fn from(value: &'a MySQLValue<'a>) -> Self

Converts to this type from the input type.

impl<'a> From<&'a OwnedMySQLValue> for MySQLValue<'a>

fn from(value: &'a OwnedMySQLValue) -> Self

Converts to this type from the input type.

impl<'a> From<&'a Rc<String>> for MySQLValue<'a>

fn from(value: &'a Rc<String>) -> Self

Converts to this type from the input type.

impl<'a> From<&'a Rc<Vec<u8>>> for MySQLValue<'a>

fn from(value: &'a Rc<Vec<u8>>) -> Self

Converts to this type from the input type.

impl<'a> From<&'a Rc<str>> for MySQLValue<'a>

fn from(value: &'a Rc<str>) -> Self

Converts to this type from the input type.

impl<'a> From<&'a String> for MySQLValue<'a>

fn from(value: &'a String) -> Self

Converts to this type from the input type.

impl<'a, const N: usize> From<&'a [u8; N]> for MySQLValue<'a>

fn from(value: &'a [u8; N]) -> Self

Converts to this type from the input type.

impl<'a> From<&'a [u8]> for MySQLValue<'a>

fn from(value: &'a [u8]) -> Self

Converts to this type from the input type.

impl<'a> From<&'a str> for MySQLValue<'a>

fn from(value: &'a str) -> Self

Converts to this type from the input type.

impl<const N: usize> From<&[char; N]> for MySQLValue<'_>

fn from(value: &[char; N]) -> Self

Converts to this type from the input type.

impl From<&bool> for MySQLValue<'_>

fn from(value: &bool) -> Self

Converts to this type from the input type.

impl From<&f32> for MySQLValue<'_>

fn from(value: &f32) -> Self

Converts to this type from the input type.

impl From<&f64> for MySQLValue<'_>

fn from(value: &f64) -> Self

Converts to this type from the input type.

impl From<&i8> for MySQLValue<'_>

fn from(value: &i8) -> Self

Converts to this type from the input type.

impl From<&i16> for MySQLValue<'_>

fn from(value: &i16) -> Self

Converts to this type from the input type.

impl From<&i32> for MySQLValue<'_>

fn from(value: &i32) -> Self

Converts to this type from the input type.

impl From<&i64> for MySQLValue<'_>

fn from(value: &i64) -> Self

Converts to this type from the input type.

impl From<&isize> for MySQLValue<'_>

fn from(value: &isize) -> Self

Converts to this type from the input type.

impl From<&u8> for MySQLValue<'_>

fn from(value: &u8) -> Self

Converts to this type from the input type.

impl From<&u16> for MySQLValue<'_>

fn from(value: &u16) -> Self

Converts to this type from the input type.

impl From<&u32> for MySQLValue<'_>

fn from(value: &u32) -> Self

Converts to this type from the input type.

impl From<&u64> for MySQLValue<'_>

fn from(value: &u64) -> Self

Converts to this type from the input type.

impl From<&usize> for MySQLValue<'_>

fn from(value: &usize) -> Self

Converts to this type from the input type.

impl From<Arc<String>> for MySQLValue<'_>

fn from(value: Arc<String>) -> Self

Converts to this type from the input type.

impl From<Arc<Vec<u8>>> for MySQLValue<'_>

fn from(value: Arc<Vec<u8>>) -> Self

Converts to this type from the input type.

impl From<Arc<str>> for MySQLValue<'_>

fn from(value: Arc<str>) -> Self

Converts to this type from the input type.

impl From<Box<String>> for MySQLValue<'_>

fn from(value: Box<String>) -> Self

Converts to this type from the input type.

impl From<Box<Vec<u8>>> for MySQLValue<'_>

fn from(value: Box<Vec<u8>>) -> Self

Converts to this type from the input type.

impl From<Box<str>> for MySQLValue<'_>

fn from(value: Box<str>) -> Self

Converts to this type from the input type.

impl<'a> From<Cow<'a, [u8]>> for MySQLValue<'a>

fn from(value: Cow<'a, [u8]>) -> Self

Converts to this type from the input type.

impl<'a> From<Cow<'a, str>> for MySQLValue<'a>

fn from(value: Cow<'a, str>) -> Self

Converts to this type from the input type.

impl<'a> From<MySQLValue<'a>> for Cow<'a, MySQLValue<'a>>

fn from(value: MySQLValue<'a>) -> Self

Converts to this type from the input type.

impl<'a> From<MySQLValue<'a>> for OwnedMySQLValue

fn from(value: MySQLValue<'a>) -> Self

Converts to this type from the input type.

impl<'a> From<MySQLValue<'a>> for SQL<'a, MySQLValue<'a>>

fn from(value: MySQLValue<'a>) -> Self

Converts to this type from the input type.

impl<'a, T> From<Option<T>> for MySQLValue<'a>

where MySQLValue<'a>: From<T>,

fn from(value: Option<T>) -> Self

Converts to this type from the input type.

impl From<OwnedMySQLValue> for MySQLValue<'_>

fn from(value: OwnedMySQLValue) -> Self

Converts to this type from the input type.

impl From<Rc<String>> for MySQLValue<'_>

fn from(value: Rc<String>) -> Self

Converts to this type from the input type.

impl From<Rc<Vec<u8>>> for MySQLValue<'_>

fn from(value: Rc<Vec<u8>>) -> Self

Converts to this type from the input type.

impl From<Rc<str>> for MySQLValue<'_>

fn from(value: Rc<str>) -> Self

Converts to this type from the input type.

impl From<String> for MySQLValue<'_>

fn from(value: String) -> Self

Converts to this type from the input type.

impl<'a, T> From<T> for MySQLValue<'a>

where T: DrizzleMySQLColumn,

fn from(value: T) -> Self

Converts to this type from the input type.

impl From<Vec<u8>> for MySQLValue<'_>

fn from(value: Vec<u8>) -> Self

Converts to this type from the input type.

impl<const N: usize> From<[char; N]> for MySQLValue<'_>

fn from(value: [char; N]) -> Self

Converts to this type from the input type.

impl<const N: usize> From<[u8; N]> for MySQLValue<'_>

fn from(value: [u8; N]) -> Self

Converts to this type from the input type.

impl From<bool> for MySQLValue<'_>

fn from(value: bool) -> Self

Converts to this type from the input type.

impl From<char> for MySQLValue<'_>

fn from(value: char) -> Self

Converts to this type from the input type.

impl From<f32> for MySQLValue<'_>

fn from(value: f32) -> Self

Converts to this type from the input type.

impl From<f64> for MySQLValue<'_>

fn from(value: f64) -> Self

Converts to this type from the input type.

impl From<i8> for MySQLValue<'_>

fn from(value: i8) -> Self

Converts to this type from the input type.

impl From<i16> for MySQLValue<'_>

fn from(value: i16) -> Self

Converts to this type from the input type.

impl From<i32> for MySQLValue<'_>

fn from(value: i32) -> Self

Converts to this type from the input type.

impl From<i64> for MySQLValue<'_>

fn from(value: i64) -> Self

Converts to this type from the input type.

impl From<isize> for MySQLValue<'_>

fn from(value: isize) -> Self

Converts to this type from the input type.

impl From<u8> for MySQLValue<'_>

fn from(value: u8) -> Self

Converts to this type from the input type.

impl From<u16> for MySQLValue<'_>

fn from(value: u16) -> Self

Converts to this type from the input type.

impl From<u32> for MySQLValue<'_>

fn from(value: u32) -> Self

Converts to this type from the input type.

impl From<u64> for MySQLValue<'_>

fn from(value: u64) -> Self

Converts to this type from the input type.

impl From<usize> for MySQLValue<'_>

fn from(value: usize) -> Self

Converts to this type from the input type.

impl<'a> PartialEq for MySQLValue<'a>

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

Equality operator ==.

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

Inequality operator !=.

impl SQLParam for MySQLValue<'_>

const DIALECT: Dialect = Dialect::MySQL

The dialect, at runtime.

type DialectMarker = MySQLDialect

The dialect, as a type (SQLiteDialect, PostgresDialect or MySQLDialect).

fn pagination_param(value: usize) -> Option<Self>

Converts a LIMIT/OFFSET value into a parameter, or returns None to write it as a literal (the default).

fn write_literal(&self, buf: &mut String) -> bool

Appends this value to buf as a SQL literal of this dialect.

impl<'a> StructuralPartialEq for MySQLValue<'a>

impl<'a, Schema, State, Table, Marker, Row, Grouped> ToSQL<'a, MySQLValue<'a>> for QueryBuilder<'a, Schema, State, Table, Marker, Row, Grouped>

where State: ExecutableState,

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

Renders self as a SQL fragment.

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

Renders self as a SQL fragment, consuming it.

impl<'a, T> ToSQL<'a, MySQLValue<'a>> for OrderExpr<T>

where T: ToSQL<'a, MySQLValue<'a>>,

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

Renders self as a SQL fragment.

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

where Self: Sized,

Renders self as a SQL fragment, consuming it.

impl<'a> ToSQL<'a, MySQLValue<'a>> for OutputAlias

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

Renders self as a SQL fragment.

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

where Self: Sized,

Renders self as a SQL fragment, consuming it.

impl<'a> ToSQL<'a, MySQLValue<'a>> for MySQLValue<'a>

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

Renders self as a SQL fragment.

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

where Self: Sized,

Renders self as a SQL fragment, consuming it.