Struct Insert

pub struct Insert {
    pub table: String,
    pub values: Vec<(String, String)>,
}

Represents the creation of a INSERT with specified table and values.

Fields

table: String

values: Vec<(String, String)>

Implementations

impl Insert

pub fn new(table: &str) -> Self

Creates a new Insert instance with the given table name.

Example

use lumus_sql_builder::sqlite::Insert;

let insert = Insert::new("metas_clientes_tb").values(vec![
    ("name", "João"),
    ("age", "30"),
    ("department", "TI"),
    ("salary", "5000.00"),
    ("hired_date", "2024-03-20"),
    ("manager_id", "1"),
]).build().unwrap();

assert_eq!(insert, “INSERT INTO metas_clientes_tb (name, age, department, salary, hired_date, manager_id) VALUES (‘João’, ‘30’, ‘TI’, ‘5000.00’, ‘2024-03-20’, ‘1’);”)

pub fn values(self, values: Vec<(&str, &str)>) -> Self

Sets the values to be inserted.

pub fn build(&self) -> Result<String, SqlBuilderError>

Builds and returns the SQL statement for the INSERT query.

Trait Implementations

impl Debug for Insert

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

Formats the value using the given formatter.