Enum TypeAffinity 

#[repr(u8)]
pub enum TypeAffinity {
    Integer = 68,
    Text = 66,
    Blob = 65,
    Real = 69,
    Numeric = 67,
}

SQLite type affinity, used for column type resolution.

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

Variants

Integer = 68

Column prefers integer storage. Includes INTEGER, INT, TINYINT, etc.

Text = 66

Column prefers text storage. Includes TEXT, VARCHAR, CLOB.

Blob = 65

Column has no preference. Includes BLOB or no type specified.

Real = 69

Column prefers real (float) storage. Includes REAL, DOUBLE, FLOAT.

Numeric = 67

Column prefers numeric storage. Includes NUMERIC, DECIMAL, BOOLEAN, DATE, DATETIME.

Implementations

impl TypeAffinity

pub fn from_type_name(type_name: &str) -> Self

Determine the type affinity for a declared column type name.

Uses SQLite’s first-match rule (§3.1 of datatype3.html):

1. Contains “INT” → INTEGER
2. Contains “CHAR”, “CLOB”, or “TEXT” → TEXT
3. Contains “BLOB” or is empty → BLOB
4. Contains “REAL”, “FLOA”, or “DOUB” → REAL
5. Otherwise → NUMERIC

pub fn comparison_affinity(left: Self, right: Self) -> Option<Self>

Determine the affinity to apply for a comparison between two operands.

Returns Some(affinity) if one side needs coercion, None if no coercion is needed. The returned affinity should be applied to the operand that needs conversion.

Rules (§3.2 of datatype3.html):

• If one operand is INTEGER/REAL/NUMERIC and the other is TEXT/BLOB, apply numeric affinity to the TEXT/BLOB side.
• If one operand is TEXT and the other is BLOB (no numeric involved), apply TEXT affinity to the BLOB side.
• Same affinity or both BLOB → no coercion.

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 Hash for TypeAffinity

fn hash<__H: Hasher>(&self, state: &mut __H)

Feeds this value into the given Hasher.

fn hash_slice<H>(data: &[Self], state: &mut H)

where H: Hasher, Self: Sized,

Feeds a slice of this type into the given Hasher.

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