Struct sql_query_builder::InsertBuilder

pub struct InsertBuilder<'a> { /* private fields */ }

Builder to contruct a insert command

Implementations

impl<'a> InsertBuilder<'a>

pub fn as_string(&self) -> String

Gets the current state of the InsertBuilder and returns it as string

pub fn debug(self) -> Self

Prints the current state of the InsertBuilder into console output in a more ease to read version. This method is useful to debug complex queries or just to print the generated SQL while you type

use sql_query_builder::InsertBuilder;

let insert_query = InsertBuilder::new()
  .insert_into("users (login, name)")
  .values("('foo', 'Foo')")
  .debug()
  .values("('bar', 'Bar')")
  .as_string();

Output

INSERT INTO users (login, name)
VALUES ('foo', 'Foo')

pub fn insert_into(self, table_name: &'a str) -> Self

The insert into clause. This method overrides the previous value

use sql_query_builder::InsertBuilder;

let insert = InsertBuilder::new()
  .insert_into("users (login, name)");

let insert = InsertBuilder::new()
  .insert_into("address (state, country)")
  .insert_into("users (login, name)");

pub fn new() -> Self

Create InsertBuilder’s instance

pub fn overriding(self, option: &'a str) -> Self

The overriding clause

pub fn print(self) -> Self

Prints the current state of the InsertBuilder into console output similar to debug method, the difference is that this method prints in one line.

pub fn select(self, select: SelectBuilder<'a>) -> Self

The select clause. This method overrides the previous value

use sql_query_builder::{InsertClause, InsertBuilder, SelectBuilder};

let insert_query = InsertBuilder::new()
  .insert_into("users (login, name)")
  .select(
    SelectBuilder::new()
      .select("login, name")
      .from("users_bk")
      .where_clause("active = true"),
  )
  .as_string();

Output

INSERT INTO users (login, name)
SELECT login, name
FROM users_bk
WHERE active = true

pub fn raw(self, raw_sql: &'a str) -> Self

Adds at the beginning a raw SQL query.

use sql_query_builder::InsertBuilder;

let raw_query = "insert into users (login, name)";
let insert_query = InsertBuilder::new()
  .raw(raw_query)
  .values("('foo', 'Foo')")
  .as_string();

Output

insert into users (login, name)
VALUES ('bar', 'Bar')

pub fn raw_after(self, clause: InsertClause, raw_sql: &'a str) -> Self

Adds a raw SQL query after a specified clause.

use sql_query_builder::{InsertClause, InsertBuilder};

let raw = "values ('foo', 'Foo')";
let insert_query = InsertBuilder::new()
  .insert_into("users (login, name)")
  .raw_after(InsertClause::InsertInto, raw)
  .as_string();

Output

INSERT INTO users (login, name)
values ('foo', 'Foo')

pub fn raw_before(self, clause: InsertClause, raw_sql: &'a str) -> Self

Adds a raw SQL query before a specified clause.

use sql_query_builder::{InsertClause, InsertBuilder};

let raw = "insert into users (login, name)";
let insert_query = InsertBuilder::new()
  .raw_before(InsertClause::Values, raw)
  .values("('bar', 'Bar')")
  .as_string();

Output

insert into users (login, name)
VALUES ('bar', 'Bar')

pub fn values(self, value: &'a str) -> Self

The values clause

Trait Implementations

impl<'a> Clone for InsertBuilder<'a>

fn clone(&self) -> InsertBuilder<'a>

Returns a copy of the value.

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

Performs copy-assignment from source.

impl<'a> Debug for InsertBuilder<'a>

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

Formats the value using the given formatter.

impl<'a> Default for InsertBuilder<'a>

fn default() -> InsertBuilder<'a>

Returns the “default value” for a type.

impl<'a> Display for InsertBuilder<'a>

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

Formats the value using the given formatter.