Enum TypeAffinity 

pub enum TypeAffinity {
    Text,
    Numeric,
    Integer,
    Real,
    None,
}

SQLite Type Affinity

SQLite uses type affinity to determine how values are compared and stored. This enum represents the five affinity types defined by SQLite:

• TEXT: String comparison semantics
• NUMERIC: Numeric comparison, converts strings to numbers when possible
• INTEGER: Prefers integer storage
• REAL: Floating-point storage
• BLOB/NONE: No affinity, uses type ordering for cross-type comparisons

See: https://www.sqlite.org/datatype3.html

Variants

Text

TEXT affinity - string comparison semantics When comparing TEXT vs INTEGER, converts INTEGER to TEXT

Numeric

NUMERIC affinity - tries to convert to number first

Integer

INTEGER affinity - prefers integer storage

Real

REAL affinity - floating-point storage

None

BLOB/NONE affinity - no type preference, uses type ordering This is used for bare columns with no declared type

Trait Implementations

impl Clone for TypeAffinity

fn clone(&self) -> TypeAffinity

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for TypeAffinity

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

Formats the value using the given formatter.

impl PartialEq for TypeAffinity

fn eq(&self, other: &TypeAffinity) -> 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 Copy for TypeAffinity

impl Eq for TypeAffinity

impl StructuralPartialEq for TypeAffinity