cake - v0.6.0

cake/query/update

A DSL to build UPDATE queries.

Functions

bool

</> 
pub fn bool(value vl: Bool) -> Param

Creates a Param from a Bool.

comment

</> 
pub fn comment(
  query qry: Update(a),
  comment cmmnt: String,
) -> Update(a)

Sets a Comment or appends into an existing Comment.

epilog

</> 
pub fn epilog(
  query qry: Update(a),
  epilog eplg: String,
) -> Update(a)

Sets an Epilog or appends into an existing Epilog.

float

</> 
pub fn float(value vl: Float) -> Param

Creates a Param from a Float.

from_sub_query

</> 
pub fn from_sub_query(
  query qry: Update(a),
  sub_query sb_qry: Query,
  alias als: String,
) -> Update(a)

Sets the FROM clause of the Update query to an aliased sub-query.

from_table

</> 
pub fn from_table(
  query qry: Update(a),
  name tbl_nm: String,
) -> Update(a)

Sets the FROM clause of the Update query to a table name.

get_comment

</> 
pub fn get_comment(query qry: Update(a)) -> Comment

Gets the Comment of the Update query.

get_epilog

</> 
pub fn get_epilog(query qry: Update(a)) -> Epilog

Gets the Epilog of the Update query.

get_from

</> 
pub fn get_from(query qry: Update(a)) -> From

Gets the FROM clause of the Update query.

get_joins

</> 
pub fn get_joins(query qry: Update(a)) -> Joins

Gets the Joins of the Update query.

get_where

</> 
pub fn get_where(query qry: Update(a)) -> Where

Gets the Where of the Update query.

int

</> 
pub fn int(value vl: Int) -> Param

Creates a Param from an Int.

join

</> 
pub fn join(query qry: Update(a), join jn: Join) -> Update(a)

Adds a Join to the Update query.

NOTICE: On Postgres/SQLite Joins are only allowed if the FROM clause is set as well.

joins

</> 
pub fn joins(
  query qry: Update(a),
  joins jns: List(Join),
) -> Update(a)

Adds Joins to the Update query.

NOTICE: On Postgres/SQLite Joins are only allowed if the FROM clause is set as well.

new

</> 
pub fn new(
  table tbl: String,
  sets sts: List(UpdateSet),
) -> Update(a)

Creates a minimal Update query specifying the table and the sets.

no_comment

</> 
pub fn no_comment(query qry: Update(a)) -> Update(a)

Removes the Comment from the Update query.

no_epilog

</> 
pub fn no_epilog(query qry: Update(a)) -> Update(a)

Removes the Epilog from the Update query.

no_from

</> 
pub fn no_from(query qry: Update(a)) -> Update(a)

Removes the FROM clause of the Update query.

no_join

</> 
pub fn no_join(query qry: Update(a)) -> Update(a)

Removes any Joins from the Update query.

no_returning

</> 
pub fn no_returning(query qry: Update(a)) -> Update(a)

NOTICE: MariaDB/MySQL do not support RETURNING in UPDATE queries; they do support it in INSERT (and REPLACE) queries, however.

no_where

</> 
pub fn no_where(query qry: Update(a)) -> Update(a)

Removes the Where from the Update query.

or_where

</> 
pub fn or_where(
  query qry: Update(a),
  where whr: Where,
) -> Update(a)

Sets an OrWhere or appends into an existing OrWhere.

  • If the outermost Where is an OrWhere, the new Where is appended to the list within OrWhere.
  • If the query does not have a Where clause, the given Where is set instead.
  • If the outermost Where is any other kind of Where, this and the current outermost Where are wrapped in an OrWhere.

replace_join

</> 
pub fn replace_join(
  query qry: Update(a),
  join jn: Join,
) -> Update(a)

Replaces any Joins of the Update query with a signle Join.

NOTICE: On Postgres/SQLite Joins are only allowed if the FROM clause is set as well.

replace_joins

</> 
pub fn replace_joins(
  query qry: Update(a),
  joins jns: List(Join),
) -> Update(a)

Replaces any Joins of the Update query with the given Joins.

NOTICE: On Postgres/SQLite Joins are only allowed if the FROM clause is set as well.

replace_where

</> 
pub fn replace_where(
  query qry: Update(a),
  where whr: Where,
) -> Update(a)

Replaces the Where in the Update query.

returning

</> 
pub fn returning(
  query qry: Update(a),
  returning rtrn: List(String),
) -> Update(a)

NOTICE: MariaDB/MySQL do not support RETURNING in UPDATE queries; they do support it in INSERT (and REPLACE) queries, however.

set_many_to_expression

</> 
pub fn set_many_to_expression(
  columns cols: List(String),
  expression exp: String,
) -> UpdateSet

Sets many columns to an expression value.

NOTICE: the expression must return the same number of columns.

set_many_to_sub_query

</> 
pub fn set_many_to_sub_query(
  columns cols: List(String),
  sub_query qry: Query,
) -> UpdateSet

Sets many columns to a sub-query value.

NOTICE: the sub-query must return the same number of columns.

set_to_expression

</> 
pub fn set_to_expression(
  column col: String,
  expression exp: String,
) -> UpdateSet

Sets a column to an expression value.

set_to_param

</> 
pub fn set_to_param(
  column col: String,
  param prm: Param,
) -> UpdateSet

Sets a column to a param value.

set_to_sub_query

</> 
pub fn set_to_sub_query(
  column col: String,
  sub_query qry: Query,
) -> UpdateSet

Sets a column to a sub-query value.

string

</> 
pub fn string(value vl: String) -> Param

Creates a Param from a String.

to_query

</> 
pub fn to_query(update updt: Update(a)) -> WriteQuery(a)

Creates a WriteQuery from an Update query.

where

</> 
pub fn where(query qry: Update(a), where whr: Where) -> Update(a)

Sets an AndWhere or appends into an existing AndWhere.

  • If the outermost Where is an AndWhere, the new Where is appended to the list within AndWhere.
  • If the query does not have a Where clause, the given Where is set instead.
  • If the outermost Where is any other kind of Where, this and the current outermost Where are wrapped in an AndWhere.

xor_where

</> 
pub fn xor_where(
  query qry: Update(a),
  where whr: Where,
) -> Update(a)

Sets an XorWhere or appends into an existing XorWhere.

  • If the outermost Where is an XorWhere, the new Where is appended to the list within XorWhere.
  • If the query does not have a Where clause, the given Where is set instead.
  • If the outermost Where is any other kind of Where, this and the current outermost Where are wrapped in an XorWhere.

NOTICE: This operator does not exist in Postgres or SQLite, and Cake generates equivalent SQL using OR and AND and NOT. This operator exists in MariaDB/MySQL.

✨ Search Document