Struct sql_query_builder::Values

pub struct Values { /* private fields */ }

Builder to contruct a Values command

Implementations

impl Values

pub fn as_string(&self) -> String

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

Example

let values_query = sql::Values::new()
  .values("('foo', 'Foo')")
  .as_string();

Output

VALUES ('foo', 'Foo')

pub fn debug(self) -> Self

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

Example

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

Prints to the standard output

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

pub fn new() -> Self

Creates instance of the Values command

pub fn print(self) -> Self

Prints the current state of the Values to the standard 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.

Example

let raw_query = "insert into my_table(num, txt)";

let values_query = sql::Values::new()
  .raw(raw_query)
  .values("(1, 'one'), (2, 'two')")
  .as_string();

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.

Example

let raw_query = ", (3, 'three')";

let values_query = sql::Values::new()
  .values("(1, 'one'), (2, 'two')")
  .raw_after(sql::ValuesClause::Values, raw_query)
  .as_string();

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.

Example

let raw_query = "/* the values command */";

let values_query = sql::Values::new()
  .raw_before(sql::ValuesClause::Values, raw_query)
  .values("(1, 'one'), (2, 'two')")
  .as_string();

Output

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

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

The values clause

Example

let values_query = sql::Values::new()
  .values("(1, 'one'), (2, 'two')")
  .values("(3, 'three')")
  .as_string();

Output

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

Trait Implementations

impl Clone for Values

fn clone(&self) -> Values

Returns a copy of the value.

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

Performs copy-assignment from source.

impl Debug for Values

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

Formats the value using the given formatter.

impl Default for Values

fn default() -> Values

Returns the “default value” for a type.

impl Display for Values

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

Formats the value using the given formatter.