Enum SqliteValue 

pub enum SqliteValue {
    Null,
    Integer(i64),
    Float(f64),
    Text(String),
    Blob(Vec<u8>),
}

A dynamically-typed SQLite value.

Corresponds to C SQLite’s sqlite3_value / Mem type. SQLite has five fundamental storage classes: NULL, INTEGER, REAL, TEXT, and BLOB.

Variants

Null

SQL NULL.

Integer(i64)

A 64-bit signed integer.

Float(f64)

A 64-bit IEEE 754 floating-point number.

Text(String)

A UTF-8 text string.

Blob(Vec<u8>)

A binary large object.

Implementations

impl SqliteValue

pub const fn affinity(&self) -> TypeAffinity

Returns the type affinity that best describes this value.

pub const fn storage_class(&self) -> StorageClass

Returns the storage class of this value.

pub fn apply_affinity(self, affinity: TypeAffinity) -> Self

Apply column type affinity coercion (advisory mode).

In non-STRICT tables, affinity is advisory: values are coerced when possible but never rejected. Follows SQLite §3.4 rules from https://www.sqlite.org/datatype3.html#type_affinity_of_a_column.

• TEXT affinity: numeric values converted to text before storing.
• NUMERIC affinity: text parsed as integer/real if well-formed.
• INTEGER affinity: like NUMERIC, plus exact-integer reals become integer.
• REAL affinity: like NUMERIC, plus integers forced to float.
• BLOB affinity: no conversion.

pub fn validate_strict( self, col_type: StrictColumnType, ) -> Result<Self, StrictTypeError>

Validate a value against a STRICT table column type.

NULL is always accepted (nullability is enforced separately via NOT NULL). Returns Ok(value) with possible implicit coercion (REAL columns accept integers, converting them to float), or Err if the storage class is incompatible.

pub const fn is_null(&self) -> bool

Returns true if this is a NULL value.

pub const fn as_integer(&self) -> Option<i64>

Try to extract an integer value.

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

Try to extract a float value.

pub fn as_text(&self) -> Option<&str>

Try to extract a text reference.

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

Try to extract a blob reference.

pub fn to_integer(&self) -> i64

Convert to an integer following SQLite’s type coercion rules.

• NULL -> 0
• Integer -> itself
• Float -> truncated to i64
• Text -> attempt to parse, 0 on failure
• Blob -> 0

pub fn to_float(&self) -> f64

Convert to a float following SQLite’s type coercion rules.

• NULL -> 0.0
• Integer -> as f64
• Float -> itself
• Text -> attempt to parse, 0.0 on failure
• Blob -> 0.0

pub fn to_text(&self) -> String

Convert to text following SQLite’s type coercion rules.

pub const fn typeof_str(&self) -> &'static str

Returns the SQLite typeof() string for this value.

Matches C sqlite3: “null”, “integer”, “real”, “text”, or “blob”.

pub fn sql_length(&self) -> Option<i64>

Returns the SQLite length() result for this value.

• NULL → NULL (represented as None)
• TEXT → character count
• BLOB → byte count
• INTEGER/REAL → character count of text representation

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

Check equality for UNIQUE constraint purposes.

In SQLite, NULL != NULL for uniqueness: if either value is NULL, the result is false (they are never considered duplicates). Non-NULL values compare by storage class ordering (same as PartialEq).

pub fn sql_add(&self, other: &Self) -> Self

Add two values following SQLite’s overflow semantics.

• Integer + Integer: checked add; overflows promote to REAL.
• Any REAL operand: float addition.
• NULL propagates (NULL + x = NULL).
• Non-numeric types coerced to numeric first.

pub fn sql_sub(&self, other: &Self) -> Self

Subtract two values following SQLite’s overflow semantics.

Integer - Integer with overflow promotes to REAL.

pub fn sql_mul(&self, other: &Self) -> Self

Multiply two values following SQLite’s overflow semantics.

Integer * Integer with overflow promotes to REAL.

Trait Implementations

impl Clone for SqliteValue

fn clone(&self) -> SqliteValue

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for SqliteValue

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

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for SqliteValue

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl Display for SqliteValue

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

Formats the value using the given formatter.

impl From<&[u8]> for SqliteValue

fn from(b: &[u8]) -> Self

Converts to this type from the input type.

impl From<&str> for SqliteValue

fn from(s: &str) -> Self

Converts to this type from the input type.

impl<T: Into<Self>> From<Option<T>> for SqliteValue

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

Converts to this type from the input type.

impl From<String> for SqliteValue

fn from(s: String) -> Self

Converts to this type from the input type.

impl From<Vec<u8>> for SqliteValue

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

Converts to this type from the input type.

impl From<f64> for SqliteValue

fn from(f: f64) -> Self

Converts to this type from the input type.

impl From<i32> for SqliteValue

fn from(i: i32) -> Self

Converts to this type from the input type.

impl From<i64> for SqliteValue

fn from(i: i64) -> Self

Converts to this type from the input type.

impl PartialEq for SqliteValue

fn eq(&self, other: &Self) -> 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 PartialOrd for SqliteValue

fn partial_cmp(&self, other: &Self) -> Option<Ordering>

This method returns an ordering between self and other values if one exists.

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

Tests less than (for self and other) and is used by the < operator.

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

Tests less than or equal to (for self and other) and is used by the <= operator.

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

Tests greater than (for self and other) and is used by the > operator.

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

Tests greater than or equal to (for self and other) and is used by the >= operator.

impl Serialize for SqliteValue

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

where __S: Serializer,

Serialize this value into the given Serde serializer.