Struct ReplaceQuery 

pub struct ReplaceQuery {
    pub hints: Hints,
    pub modifiers: Modifiers,
    pub table: TableRef,
    pub values: Values,
    pub set: Set,
}

A MySQL REPLACE.

From https://dev.mysql.com/doc/refman/8.4/en/replace.html:

REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name
    [PARTITION (partition_name [, partition_name] ...)]
    [(col_name [, col_name] ...)]
    { {VALUES | VALUE} (value_list) [, (value_list)] ...
    | SET assignment_list
    | [(col_name [, col_name] ...)] SELECT ... }

A statement type of its own rather than a flag on InsertQuery, because the differences are exactly the things a flag would leave reachable: REPLACE has no HIGH_PRIORITY, no IGNORE, no row alias and no ON DUPLICATE KEY UPDATE — the last two being meaningless when a duplicate key is what the statement is for. Not implementing the traits is how that is said, so replace::ignore() and replace::on_duplicate_key_update(..) simply do not exist.

Its query_type is QueryType::Insert: REPLACE is a DELETE-then-INSERT, and the layers above care only that it writes rows.

Fields

hints: Hints

/*+ … */.

modifiers: Modifiers

LOW_PRIORITY or DELAYED, and nothing else.

table: TableRef

The target: table, partitions, and the column list.

values: Values

The rows, or the query to insert the results of.

set: Set

SET a = 1, b = 2, the assignment-list row source.

Implementations

impl ReplaceQuery

pub fn new() -> ReplaceQuery

A REPLACE with nothing set yet.

pub fn apply(&mut self, mods: impl Mod<ReplaceQuery>)

Apply more mods to an existing query.

Trait Implementations

impl Clone for ReplaceQuery

fn clone(&self) -> ReplaceQuery

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for ReplaceQuery

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

Formats the value using the given formatter.

impl Default for ReplaceQuery

fn default() -> ReplaceQuery

Returns the “default value” for a type.

impl Expression for ReplaceQuery

fn write_sql(&self, w: &mut SqlWriter<'_>)

Append this fragment to w.

impl HasHints for ReplaceQuery

fn hints_mut(&mut self) -> &mut Hints

The hints to add to.

impl HasModifiers for ReplaceQuery

fn modifiers_mut(&mut self) -> &mut Modifiers

The modifiers to add to.

impl HasSet for ReplaceQuery

fn set_mut(&mut self) -> &mut Set

The assignment list to modify.

impl HasTableRef for ReplaceQuery

fn table_ref_mut(&mut self) -> &mut TableRef

The table reference to modify.

impl HasValues for ReplaceQuery

fn values_mut(&mut self) -> &mut Values

The row source to modify.

impl IntoExpr for ReplaceQuery

fn into_expr(self) -> Expr

Perform the conversion.

impl IntoExprList for ReplaceQuery

fn into_expr_list(self) -> Vec<Expr>

Perform the conversion.

impl Query for ReplaceQuery

fn query_type(&self) -> QueryType

Which statement this renders.

fn dialect(&self) -> &dyn Dialect

The dialect this query renders itself in.

fn build(&self) -> Result<(String, Vec<Value>), Error>

Render to SQL and arguments, numbering placeholders from 1.

fn build_from(&self, start: usize) -> Result<(String, Vec<Value>), Error>

build with a different first placeholder position, for splicing into a statement that already has arguments — bob’s BuildN.

impl<H, L, M> QueryExtensions<H, L, M> for ReplaceQuery

fn hooks(&self) -> &[Hook]

Hooks to run before this query executes.

fn loaders(&self) -> &[Loader]

Loaders to run after this query executes, for eagerly loaded relations.

fn mapper_mods(&self) -> &[MapperMod]

Adjustments to the row mapper, for relations loaded in the same query.