Struct sql_query_builder::Update

source · [−]

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

Expand description

Builder to contruct a Update command

Implementations

source

impl<'a> Update<'a>

source

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

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

Examples

use sql_query_builder as sql;

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

source

pub fn as_string(&self) -> String

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

Examples

use sql_query_builder as sql;

let query = sql::Update::new()
  .update("users")
  .set("login = 'foo'")
  .as_string();

Output

 UPDATE users SET login = 'foo'

source

pub fn debug(self) -> Self

Prints the current state of the Update 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

Examples

use sql_query_builder as sql;

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

Output

UPDATE users
SET login = 'foo'

source

pub fn from(self, tables: &'a str) -> Self

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

source

pub fn new() -> Self

Create Update’s instance

source

pub fn print(self) -> Self

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

source

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

Adds at the beginning a raw SQL query.

Examples

use sql_query_builder as sql;

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

Output

update users
SET login = 'foo'

source

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

Adds a raw SQL query after a specified clause.

Examples

use sql_query_builder as sql;

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

Output

UPDATE users
set name = 'Foo'

source

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

Adds a raw SQL query before a specified clause.

Examples

use sql_query_builder as sql;

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

Output

update users
SET name = 'Bar'

source

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

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

source

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

The set clause

source

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

The update clause. This method overrides the previous value

Examples

use sql_query_builder as sql;

let update = sql::Update::new()
  .update("orders");

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

source

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

The where clause

Examples

use sql_query_builder as sql;

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

source

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

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

Examples

use sql_query_builder as sql;

let user = sql::Insert::new()
  .insert_into("users(login, name)")
  .values("('foo', 'Foo')")
  .returning("group_id");
let update = sql::Update::new()
  .with("user", user)
  .update("user_group")
  .set("count = count + 1")
  .where_clause("id = (select group_id from user)")
  .debug();

Output

WITH user AS (
  INSERT INTO users(login, name)
  VALUES ('foo', 'Foo')
  RETURNING group_id
)
UPDATE user_group
SET count = count + 1
WHERE id = (select group_id from user)