Skip to main content

merge_into

Function merge_into 

Source
pub fn merge_into(target: &str) -> MergeBuilder
Expand description

Start building a MERGE INTO statement targeting the given table.

Returns a MergeBuilder which supports .using(), .when_matched_update(), .when_matched_delete(), and .when_not_matched_insert().

ยงExamples

use polyglot_sql::builder::*;

let sql = merge_into("target")
    .using("source", col("target.id").eq(col("source.id")))
    .when_matched_update(vec![("name", col("source.name"))])
    .when_not_matched_insert(&["id", "name"], vec![col("source.id"), col("source.name")])
    .to_sql();
assert!(sql.contains("MERGE INTO"));