Struct Insert 

pub struct Insert<T: DynTable, S, B> { /* private fields */ }

Builder for an insert operation.

Implementations

impl<T: SchemaWithPK, S: Clone, B: Clone> Insert<T, S, B>

pub fn extract_pk(&self) -> Vec<Value<S, B>>

Extract the primary key values from this insert’s values.

impl<T: DynTable, S: AsRef<str>, B: AsRef<[u8]>> Insert<T, S, B>

pub fn set( self, col_idx: usize, value: impl Into<Value<S, B>>, ) -> Result<Self, Error>

Sets the value for a specific column by index.

Arguments

• col_idx - The index of the column to set.
• value - The value to set for the column.

Errors

• ColumnIndexOutOfBounds - If the provided column index is out of bounds for the table schema.

pub fn set_null(self, col_idx: usize) -> Result<Self, Error>

where S: Default, B: Default,

Sets a column to NULL.

This is a convenience method equivalent to .set(col_idx, Value::Null).

Errors

• ColumnIndexOutOfBounds - If the provided column index is out of bounds for the table schema.

Example

use sqlite_diff_rs::{Insert, TableSchema};

// CREATE TABLE items (id INTEGER PRIMARY KEY, description TEXT, price REAL)
let schema: TableSchema<String> = TableSchema::new("items".into(), 3, vec![1, 0, 0]);

// INSERT INTO items (id, description, price) VALUES (1, NULL, 9.99)
let insert = Insert::<_, String, Vec<u8>>::from(schema)
    .set(0, 1i64).unwrap()
    .set_null(1).unwrap()    // description = NULL
    .set(2, 9.99f64).unwrap();

Trait Implementations

impl<T: DynTable, S: AsRef<str>, B: AsRef<[u8]>> AsRef<T> for Insert<T, S, B>

fn as_ref(&self) -> &T

Converts this type into a shared reference of the (usually inferred) input type.

impl<T: DynTable, S: Clone, B: Clone> Clone for Insert<T, S, B>

fn clone(&self) -> Self

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl<T: Debug + DynTable, S: Debug, B: Debug> Debug for Insert<T, S, B>

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

Formats the value using the given formatter.

impl<T: DynTable + Eq, S: Eq + AsRef<str>, B: Eq + AsRef<[u8]>> Eq for Insert<T, S, B>

impl<T: DynTable, S: Clone, B: Clone> From<T> for Insert<T, S, B>

fn from(table: T) -> Self

Converts to this type from the input type.

impl<T: DynTable, S, B> Indirect for Insert<T, S, B>

fn indirect(self, indirect: bool) -> Self

Mark this operation as indirect (trigger-induced or cascading).

impl<T: DynTable + PartialEq, S: PartialEq + AsRef<str>, B: PartialEq + AsRef<[u8]>> PartialEq for Insert<T, S, B>

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

Equality operator ==.

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

Inequality operator !=.