Struct sea_query::query::OnConflict

source ·

pub struct OnConflict { /* private fields */ }

Implementations

source

impl OnConflict

source

pub fn new() -> Self

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

source

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

Set ON CONFLICT target column

source

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

Set ON CONFLICT target columns

source

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

source

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

Set ON CONFLICT update column

source

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""#
);

source

pub fn update_value<C>(&mut self, column_value: (C, Value)) -> &mut Selfwhere
C: IntoIden,

👎Deprecated since 0.27.0: Please use the [OnConflict::value]

source

pub fn update_values<C, I>(&mut self, column_values: I) -> &mut Selfwhere
C: IntoIden,
I: IntoIterator<Item = (C, Value)>,

👎Deprecated since 0.27.0: Please use the [OnConflict::values]

source

pub fn update_expr<C, E>(&mut self, col_expr: (C, E)) -> &mut Selfwhere
C: IntoIden,
E: Into<SimpleExpr>,

👎Deprecated since 0.27.0: Please use the [OnConflict::value]

source

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

👎Deprecated since 0.27.0: Please use the [OnConflict::values]

source

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"#
);

source

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

Set ON CONFLICT update value

source

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::tbl(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"#
);

source

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

Set target WHERE

source

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

Set target WHERE

source

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::tbl(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"#
);

source

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

Set action WHERE

source

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

Set action WHERE

Trait Implementations

source

impl Clone for OnConflict

source

fn clone(&self) -> OnConflict

Returns a copy of the value. Read more

1.0.0 · source

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

Performs copy-assignment from source. Read more

source

impl Debug for OnConflict

source

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

Formats the value using the given formatter. Read more

source

impl Default for OnConflict

source

fn default() -> OnConflict

Returns the “default value” for a type. Read more

Auto Trait Implementations

impl !RefUnwindSafe for OnConflict

impl Send for OnConflict

impl Sync for OnConflict

impl Unpin for OnConflict

impl !UnwindSafe for OnConflict

Blanket Implementations

source

impl<T> Any for Twhere
T: 'static + ?Sized,

source

fn type_id(&self) -> TypeId

Gets the TypeId of self. Read more

source

impl<T> Borrow<T> for Twhere
T: ?Sized,

const: unstable · source

fn borrow(&self) -> &T

Immutably borrows from an owned value. Read more

source

impl<T> BorrowMut<T> for Twhere
T: ?Sized,

const: unstable · source

fn borrow_mut(&mut self) -> &mut T

Mutably borrows from an owned value. Read more

source

impl<T> From<T> for T

const: unstable · source

fn from(t: T) -> T

Returns the argument unchanged.

source

impl<T, U> Into for Twhere
U: From<T>,

const: unstable · source

fn into(self) -> U

Calls U::from(self).

That is, this conversion is whatever the implementation of From<T> for U chooses to do.

source

impl<T> Same<T> for T

type Output = T

Should always be Self

source

impl<T> ToOwned for Twhere
T: Clone,

type Owned = T

The resulting type after obtaining ownership.

source

fn to_owned(&self) -> T

Creates owned data from borrowed data, usually by cloning. Read more

source

fn clone_into(&self, target: &mut T)

Uses borrowed data to replace owned data, usually by cloning. Read more

source

impl<T, U> TryFrom for Twhere
U: Into<T>,

type Error = Infallible

The type returned in the event of a conversion error.

const: unstable · source

fn try_from(value: U) -> Result<T, <T as TryFrom>::Error>

Performs the conversion.

source

impl<T, U> TryInto for Twhere
U: TryFrom<T>,

type Error = >::Error

The type returned in the event of a conversion error.

const: unstable · source

fn try_into(self) -> Result<U, >::Error>

Performs the conversion.

Struct sea_query::query::OnConflict

Implementations

impl OnConflict

pub fn new() -> Self

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

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

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

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

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

pub fn update_value<C>(&mut self, column_value: (C, Value)) -> &mut Selfwhere C: IntoIden,

pub fn update_values<C, I>(&mut self, column_values: I) -> &mut Selfwhere C: IntoIden, I: IntoIterator<Item = (C, Value)>,

pub fn update_expr<C, E>(&mut self, col_expr: (C, E)) -> &mut Selfwhere C: IntoIden, E: Into<SimpleExpr>,

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

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

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

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

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

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

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

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

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

Trait Implementations

impl Clone for OnConflict

fn clone(&self) -> OnConflict

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

impl Debug for OnConflict

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

impl Default for OnConflict

fn default() -> OnConflict

Auto Trait Implementations

impl !RefUnwindSafe for OnConflict

impl Send for OnConflict

impl Sync for OnConflict

impl Unpin for OnConflict

impl !UnwindSafe for OnConflict

Blanket Implementations

impl<T> Any for Twhere T: 'static + ?Sized,

fn type_id(&self) -> TypeId

impl<T> Borrow<T> for Twhere T: ?Sized,

fn borrow(&self) -> &T

impl<T> BorrowMut<T> for Twhere T: ?Sized,

fn borrow_mut(&mut self) -> &mut T

impl<T> From<T> for T

fn from(t: T) -> T

impl<T, U> Into<U> for Twhere U: From<T>,

fn into(self) -> U

impl<T> Same<T> for T

type Output = T

impl<T> ToOwned for Twhere T: Clone,

type Owned = T

fn to_owned(&self) -> T

fn clone_into(&self, target: &mut T)

impl<T, U> TryFrom<U> for Twhere U: Into<T>,

type Error = Infallible

fn try_from(value: U) -> Result<T, <T as TryFrom<U>>::Error>

impl<T, U> TryInto<U> for Twhere U: TryFrom<T>,

type Error = <U as TryFrom<T>>::Error

fn try_into(self) -> Result<U, <U as TryFrom<T>>::Error>

impl<V, T> VZip<V> for Twhere V: MultiLane<T>,

fn vzip(self) -> V

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

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

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

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

pub fn update_value<C>(&mut self, column_value: (C, Value)) -> &mut Selfwhere
C: IntoIden,

pub fn update_values<C, I>(&mut self, column_values: I) -> &mut Selfwhere
C: IntoIden,
I: IntoIterator<Item = (C, Value)>,

pub fn update_expr<C, E>(&mut self, col_expr: (C, E)) -> &mut Selfwhere
C: IntoIden,
E: Into<SimpleExpr>,

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

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

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

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

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

impl<T> Any for Twhere
T: 'static + ?Sized,

impl<T> Borrow<T> for Twhere
T: ?Sized,

impl<T> BorrowMut<T> for Twhere
T: ?Sized,

impl<T, U> Into<U> for Twhere
U: From<T>,

impl<T> ToOwned for Twhere
T: Clone,

impl<T, U> TryFrom<U> for Twhere
U: Into<T>,

impl<T, U> TryInto<U> for Twhere
U: TryFrom<T>,

impl<V, T> VZip<V> for Twhere
V: MultiLane<T>,