Struct sea_query::query::OnConflict

pub struct OnConflict { /* private fields */ }

Implementations

impl OnConflict

pub fn new() -> Self

Create a ON CONFLICT expression without target column, a special method designed for MySQL

pub fn column<C>(column: C) -> Selfwhere C: IntoIden,

Set ON CONFLICT target column

pub fn columns<I, C>(columns: I) -> Selfwhere C: IntoIden, I: IntoIterator<Item = C>,

Set ON CONFLICT target columns

pub fn do_nothing(&mut self) -> &mut Self

pub fn update_column<C>(&mut self, column: C) -> &mut Selfwhere C: IntoIden,

Set ON CONFLICT update column

Examples

use sea_query::{tests_cfg::*, *};

let query = Query::insert()
    .into_table(Glyph::Table)
    .columns([Glyph::Aspect, Glyph::Image])
    .values_panic([
        "abcd".into(),
        3.1415.into(),
    ])
    .on_conflict(
        OnConflict::columns([Glyph::Id, Glyph::Aspect])
            .update_column(Glyph::Aspect)
            .value(Glyph::Image, Expr::val(1).add(2))
            .to_owned()
    )
    .to_owned();

assert_eq!(
    query.to_string(MysqlQueryBuilder),
    [
        r#"INSERT INTO `glyph` (`aspect`, `image`)"#,
        r#"VALUES ('abcd', 3.1415)"#,
        r#"ON DUPLICATE KEY UPDATE `aspect` = VALUES(`aspect`), `image` = 1 + 2"#,
    ]
    .join(" ")
);
assert_eq!(
    query.to_string(PostgresQueryBuilder),
    [
        r#"INSERT INTO "glyph" ("aspect", "image")"#,
        r#"VALUES ('abcd', 3.1415)"#,
        r#"ON CONFLICT ("id", "aspect") DO UPDATE SET "aspect" = "excluded"."aspect", "image" = 1 + 2"#,
    ]
    .join(" ")
);
assert_eq!(
    query.to_string(SqliteQueryBuilder),
    [
        r#"INSERT INTO "glyph" ("aspect", "image")"#,
        r#"VALUES ('abcd', 3.1415)"#,
        r#"ON CONFLICT ("id", "aspect") DO UPDATE SET "aspect" = "excluded"."aspect", "image" = 1 + 2"#,
    ]
    .join(" ")
);

pub fn update_columns<C, I>(&mut self, columns: I) -> &mut Selfwhere C: IntoIden, I: IntoIterator<Item = C>,

Set ON CONFLICT update columns

Examples

use sea_query::{tests_cfg::*, *};

let query = Query::insert()
    .into_table(Glyph::Table)
    .columns([Glyph::Aspect, Glyph::Image])
    .values_panic([
        2.into(),
        3.into(),
    ])
    .on_conflict(
        OnConflict::column(Glyph::Id)
            .update_columns([Glyph::Aspect, Glyph::Image])
            .to_owned(),
    )
    .to_owned();

assert_eq!(
    query.to_string(MysqlQueryBuilder),
    r#"INSERT INTO `glyph` (`aspect`, `image`) VALUES (2, 3) ON DUPLICATE KEY UPDATE `aspect` = VALUES(`aspect`), `image` = VALUES(`image`)"#
);
assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"INSERT INTO "glyph" ("aspect", "image") VALUES (2, 3) ON CONFLICT ("id") DO UPDATE SET "aspect" = "excluded"."aspect", "image" = "excluded"."image""#
);
assert_eq!(
    query.to_string(SqliteQueryBuilder),
    r#"INSERT INTO "glyph" ("aspect", "image") VALUES (2, 3) ON CONFLICT ("id") DO UPDATE SET "aspect" = "excluded"."aspect", "image" = "excluded"."image""#
);

pub fn values<C, I>(&mut self, values: I) -> &mut Selfwhere C: IntoIden, I: IntoIterator<Item = (C, SimpleExpr)>,

Set ON CONFLICT update exprs

Examples

use sea_query::{tests_cfg::*, *};

let query = Query::insert()
    .into_table(Glyph::Table)
    .columns([Glyph::Aspect, Glyph::Image])
    .values_panic([
        2.into(),
        3.into(),
    ])
    .on_conflict(
        OnConflict::column(Glyph::Id)
            .value(Glyph::Image, Expr::val(1).add(2))
            .to_owned()
    )
    .to_owned();

assert_eq!(
    query.to_string(MysqlQueryBuilder),
    r#"INSERT INTO `glyph` (`aspect`, `image`) VALUES (2, 3) ON DUPLICATE KEY UPDATE `image` = 1 + 2"#
);
assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"INSERT INTO "glyph" ("aspect", "image") VALUES (2, 3) ON CONFLICT ("id") DO UPDATE SET "image" = 1 + 2"#
);
assert_eq!(
    query.to_string(SqliteQueryBuilder),
    r#"INSERT INTO "glyph" ("aspect", "image") VALUES (2, 3) ON CONFLICT ("id") DO UPDATE SET "image" = 1 + 2"#
);

pub fn value<C, T>(&mut self, col: C, value: T) -> &mut Selfwhere C: IntoIden, T: Into<SimpleExpr>,

Set ON CONFLICT update value

pub fn target_and_where(&mut self, other: SimpleExpr) -> &mut Self

Set target WHERE

Examples

use sea_query::{tests_cfg::*, *};

let query = Query::insert()
    .into_table(Glyph::Table)
    .columns([Glyph::Aspect, Glyph::Image])
    .values_panic([
        2.into(),
        3.into(),
    ])
    .on_conflict(
        OnConflict::column(Glyph::Id)
            .value(Glyph::Image, Expr::val(1).add(2))
            .target_and_where(Expr::col((Glyph::Table, Glyph::Aspect)).is_null())
            .to_owned()
    )
    .to_owned();

assert_eq!(
    query.to_string(MysqlQueryBuilder),
    r#"INSERT INTO `glyph` (`aspect`, `image`) VALUES (2, 3) ON DUPLICATE KEY UPDATE `image` = 1 + 2"#
);
assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"INSERT INTO "glyph" ("aspect", "image") VALUES (2, 3) ON CONFLICT ("id") WHERE "glyph"."aspect" IS NULL DO UPDATE SET "image" = 1 + 2"#
);
assert_eq!(
    query.to_string(SqliteQueryBuilder),
    r#"INSERT INTO "glyph" ("aspect", "image") VALUES (2, 3) ON CONFLICT ("id") WHERE "glyph"."aspect" IS NULL DO UPDATE SET "image" = 1 + 2"#
);

pub fn target_and_where_option( &mut self, other: Option<SimpleExpr> ) -> &mut Self

Set target WHERE

pub fn target_cond_where<C>(&mut self, condition: C) -> &mut Selfwhere C: IntoCondition,

Set target WHERE

pub fn action_and_where(&mut self, other: SimpleExpr) -> &mut Self

Set action WHERE

Examples

use sea_query::{tests_cfg::*, *};

let query = Query::insert()
    .into_table(Glyph::Table)
    .columns([Glyph::Aspect, Glyph::Image])
    .values_panic([
        2.into(),
        3.into(),
    ])
    .on_conflict(
        OnConflict::column(Glyph::Id)
            .value(Glyph::Image, Expr::val(1).add(2))
            .action_and_where(Expr::col((Glyph::Table, Glyph::Aspect)).is_null())
            .to_owned()
    )
    .to_owned();

assert_eq!(
    query.to_string(MysqlQueryBuilder),
    r#"INSERT INTO `glyph` (`aspect`, `image`) VALUES (2, 3) ON DUPLICATE KEY UPDATE `image` = 1 + 2"#
);
assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"INSERT INTO "glyph" ("aspect", "image") VALUES (2, 3) ON CONFLICT ("id") DO UPDATE SET "image" = 1 + 2 WHERE "glyph"."aspect" IS NULL"#
);
assert_eq!(
    query.to_string(SqliteQueryBuilder),
    r#"INSERT INTO "glyph" ("aspect", "image") VALUES (2, 3) ON CONFLICT ("id") DO UPDATE SET "image" = 1 + 2 WHERE "glyph"."aspect" IS NULL"#
);

pub fn action_and_where_option( &mut self, other: Option<SimpleExpr> ) -> &mut Self

Set action WHERE

pub fn action_cond_where<C>(&mut self, condition: C) -> &mut Selfwhere C: IntoCondition,

Set action WHERE

Trait Implementations

impl Clone for OnConflict

fn clone(&self) -> OnConflict

Returns a copy of the value.

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

Performs copy-assignment from source.

impl Debug for OnConflict

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

Formats the value using the given formatter.

impl Default for OnConflict

fn default() -> OnConflict

Returns the “default value” for a type.

impl PartialEq<OnConflict> for OnConflict

fn eq(&self, other: &OnConflict) -> bool

This method tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

This method tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl StructuralPartialEq for OnConflict