Struct sql_query_builder::UpdateBuilder

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

Builder to contruct a update command

Implementations

impl<'a> UpdateBuilder<'a>

pub fn and(self, condition: &'a str) -> Self

The same as where_clause method, useful to write more idiomatic SQL query

use sql_query_builder::UpdateBuilder;

let update = UpdateBuilder::new()
  .update("users")
  .set("name = $1")
  .where_clause("login = $2")
  .and("active = true");

pub fn as_string(&self) -> String

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

pub fn debug(self) -> Self

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

let update_query = UpdateBuilder::new()
  .update("users")
  .set("login = 'foo'")
  .debug()
  .set("name = 'Foo'")
  .as_string();

Output

UPDATE users
SET login = 'foo'

pub fn new() -> Self

Create UpdateBuilder’s instance

pub fn print(self) -> Self

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

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

Adds at the beginning a raw SQL query.

use sql_query_builder::UpdateBuilder;

let raw_query = "update users";
let update_query = UpdateBuilder::new()
  .raw(raw_query)
  .set("login = 'foo'")
  .as_string();

Output

update users
SET login = 'foo'

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

Adds a raw SQL query after a specified clause.

use sql_query_builder::{UpdateClause, UpdateBuilder};

let raw = "set name = 'Foo'";
let update_query = UpdateBuilder::new()
  .update("users")
  .raw_after(UpdateClause::Update, raw)
  .as_string();

Output

UPDATE users
set name = 'Foo'

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

Adds a raw SQL query before a specified clause.

use sql_query_builder::{UpdateClause, UpdateBuilder};

let raw = "update users";
let update_query = UpdateBuilder::new()
  .raw_before(UpdateClause::Set, raw)
  .set("name = 'Bar'")
  .as_string();

Output

update users
SET name = 'Bar'

pub fn returning(self, output_name: &'a str) -> Self

The returning clause, this method can be used enabling the feature flag postgresql

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

The set clause

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

The update clause. This method overrides the previous value

use sql_query_builder::UpdateBuilder;

let update = UpdateBuilder::new()
  .update("orders");

let update = UpdateBuilder::new()
  .update("address")
  .update("orders");

pub fn where_clause(self, condition: &'a str) -> Self

The where clause

use sql_query_builder::UpdateBuilder;

let update = UpdateBuilder::new()
  .update("users")
  .set("name = $1")
  .where_clause("login = $2");

pub fn with(self, name: &'a str, query: impl Query + 'static) -> Self

The with clause, this method can be used enabling the feature flag postgresql

Trait Implementations

impl<'a> Clone for UpdateBuilder<'a>

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

Returns a copy of the value.

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

Performs copy-assignment from source.

impl Debug for UpdateBuilder<'_>

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

Formats the value using the given formatter.

impl<'a> Default for UpdateBuilder<'a>

fn default() -> UpdateBuilder<'a>

Returns the “default value” for a type.

impl Display for UpdateBuilder<'_>

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

Formats the value using the given formatter.

impl Query for UpdateBuilder<'_>