Enum SqliteValue 

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

SQLite value wrapper for type mapping

Variants

Text(String)

TEXT type for strings

Integer(i64)

INTEGER type for small integers

Real(f64)

REAL type for floating point

Blob(Vec<u8>)

BLOB type for binary data

Jsonb(Value)

JSONB type for JSON (stored as BLOB, queried via -> operator) Note: SQLite JSONB is different from PostgreSQL JSONB but provides similar benefits: pre-parsed binary format for faster queries.

Null

NULL

Implementations

impl SqliteValue

pub fn sqlite_type(&self) -> &'static str

Get the SQLite type name for column creation

pub fn is_jsonb(&self) -> bool

Check if this value is a JSONB type that needs special SQL handling

pub fn as_json_string(&self) -> Option<String>

Get the JSON string representation (for use with jsonb() function)

pub fn to_sql(&self) -> Value

Convert to a rusqlite parameter value Note: For JSONB, this returns the JSON text - the caller must wrap with jsonb()

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 From<Option<Value>> for SqliteValue

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

Converts to this type from the input type.

impl From<Value> for SqliteValue

fn from(value: Value) -> Self

Converts to this type from the input type.

impl From<Value> for SqliteValue

Convert rusqlite Value to our SqliteValue

fn from(value: Value) -> Self

Converts to this type from the input type.