Struct sea_query::query::Returning

source ·

pub struct Returning;

Expand description

Shorthand for constructing ReturningClause

Implementations§

source §

impl Returning

source

pub fn new() -> Self

Constructs a new Returning.

source

pub fn all(&self) -> ReturningClause

Constructs a new ReturningClause::All.

Examples

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

let query = Query::delete()
    .from_table(Glyph::Table)
    .and_where(Expr::col(Glyph::Id).eq(1))
    .returning(Query::returning().all())
    .to_owned();

assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"DELETE FROM "glyph" WHERE "id" = 1 RETURNING *"#
);
assert_eq!(
    query.to_string(SqliteQueryBuilder),
    r#"DELETE FROM "glyph" WHERE "id" = 1 RETURNING *"#
);

source

pub fn column<C>(&self, col: C) -> ReturningClause
where C: IntoColumnRef,

Constructs a new ReturningClause::Columns.

Examples

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

let query = Query::delete()
    .from_table(Glyph::Table)
    .and_where(Expr::col(Glyph::Id).eq(1))
    .returning(Query::returning().column(Glyph::Id))
    .to_owned();

assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"DELETE FROM "glyph" WHERE "id" = 1 RETURNING "id""#
);
assert_eq!(
    query.to_string(SqliteQueryBuilder),
    r#"DELETE FROM "glyph" WHERE "id" = 1 RETURNING "id""#
);

source

pub fn columns<T, I>(self, cols: I) -> ReturningClause
where T: IntoColumnRef, I: IntoIterator<Item = T>,

Constructs a new ReturningClause::Columns.

Examples

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

let query = Query::delete()
    .from_table(Glyph::Table)
    .and_where(Expr::col(Glyph::Id).eq(1))
    .returning(Query::returning().columns([Glyph::Id, Glyph::Image]))
    .to_owned();

assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"DELETE FROM "glyph" WHERE "id" = 1 RETURNING "id", "image""#
);
assert_eq!(
    query.to_string(SqliteQueryBuilder),
    r#"DELETE FROM "glyph" WHERE "id" = 1 RETURNING "id", "image""#
);

source

pub fn expr<T>(&self, expr: T) -> ReturningClause
where T: Into<SimpleExpr>,

Constructs a new ReturningClause::Exprs.

Examples

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

let query = Query::delete()
    .from_table(Glyph::Table)
    .and_where(Expr::col(Glyph::Id).eq(1))
    .returning(Query::returning().expr(Expr::col(Glyph::Id)))
    .to_owned();

assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"DELETE FROM "glyph" WHERE "id" = 1 RETURNING "id""#
);
assert_eq!(
    query.to_string(SqliteQueryBuilder),
    r#"DELETE FROM "glyph" WHERE "id" = 1 RETURNING "id""#
);

source

pub fn exprs<T, I>(self, exprs: I) -> ReturningClause
where T: Into<SimpleExpr>, I: IntoIterator<Item = T>,

Constructs a new ReturningClause::Exprs.

Examples

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

let query = Query::delete()
    .from_table(Glyph::Table)
    .and_where(Expr::col(Glyph::Id).eq(1))
    .returning(Query::returning().exprs([Expr::col(Glyph::Id), Expr::col(Glyph::Image)]))
    .to_owned();

assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"DELETE FROM "glyph" WHERE "id" = 1 RETURNING "id", "image""#
);
assert_eq!(
    query.to_string(SqliteQueryBuilder),
    r#"DELETE FROM "glyph" WHERE "id" = 1 RETURNING "id", "image""#
);