Struct sql_query_builder::ValuesBuilder

pub struct ValuesBuilder { /* private fields */ }

Builder to contruct a values command

Implementations

impl ValuesBuilder

pub fn as_string(&self) -> String

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

pub fn debug(self) -> Self

Prints the current state of the ValuesBuilder 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::ValuesBuilder;

let values = ValuesBuilder::new()
  .values("(1, 'one'), (2, 'two')")
  .values("(3, 'three')")
  .debug();

Output

VALUES (1, 'one'), (2, 'two'), (3, 'three')

pub fn new() -> Self

Create ValuesBuilder’s instance

pub fn print(self) -> Self

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

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

Adds at the beginning a raw SQL query.

use sql_query_builder::ValuesBuilder;

let raw_query = "insert into my_table(nun, txt)";
let values = ValuesBuilder::new()
  .raw(raw_query)
  .values("(1, 'one'), (2, 'two')")
  .debug();

Output

insert into my_table(num, txt)
VALUES (1, 'one'), (2, 'two')

pub fn raw_after(self, clause: ValuesClause, raw_sql: &str) -> Self

Adds a raw SQL query after a specified clause.

use sql_query_builder::{ValuesBuilder, ValuesClause};

let raw_query = ", (3, 'three')";
let values = ValuesBuilder::new()
  .values("(1, 'one'), (2, 'two')")
  .raw_after(ValuesClause::Values, raw_query)
  .debug();

Output

VALUES (1, 'one'), (2, 'two') , (3, 'three')

pub fn raw_before(self, clause: ValuesClause, raw_sql: &str) -> Self

Adds a raw SQL query before a specified clause.

use sql_query_builder::{ValuesBuilder, ValuesClause};

let raw_query = "/* the values command */";
let values = ValuesBuilder::new()
  .raw_before(ValuesClause::Values, raw_query)
  .values("(1, 'one'), (2, 'two')")
  .debug();

Output

/* the values command */
VALUES (1, 'one'), (2, 'two')

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

The values clause

use sql_query_builder::ValuesBuilder;

let values = ValuesBuilder::new()
  .values("(1, 'one'), (2, 'two')")
  .values("(3, 'three')");

Trait Implementations

impl Clone for ValuesBuilder

fn clone(&self) -> ValuesBuilder

Returns a copy of the value.

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

Performs copy-assignment from source.

impl Debug for ValuesBuilder

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

Formats the value using the given formatter.

impl Default for ValuesBuilder

fn default() -> ValuesBuilder

Returns the “default value” for a type.

impl Display for ValuesBuilder

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

Formats the value using the given formatter.