Struct sea_orm::SelectorRaw

source ·

pub struct SelectorRaw<S>where
    S: SelectorTrait,
{ /* private fields */ }

Expand description

Performs a raw SELECT operation on a model

Implementations§

source §

impl<S> SelectorRaw<S>
where S: SelectorTrait,

source

pub fn from_statement<M>(stmt: Statement) -> SelectorRaw<SelectModel<M>>
where M: FromQueryResult,

Select a custom Model from a raw SQL Statement.

source

pub fn with_columns<T, C>( stmt: Statement ) -> SelectorRaw<SelectGetableValue<T, C>>
where T: TryGetableMany, C: IntoEnumIterator + Iden,

Create SelectorRaw from Statement and columns. Executing this SelectorRaw will return a type T which implement TryGetableMany.

source

pub fn into_model<M>(self) -> SelectorRaw<SelectModel<M>>
where M: FromQueryResult,

use sea_orm::{entity::*, query::*, tests_cfg::cake, FromQueryResult};

#[derive(Debug, PartialEq, FromQueryResult)]
struct SelectResult {
    name: String,
    num_of_cakes: i32,
}

let res: Vec<SelectResult> = cake::Entity::find()
    .from_raw_sql(Statement::from_sql_and_values(
        DbBackend::Postgres,
        r#"SELECT "cake"."name", count("cake"."id") AS "num_of_cakes" FROM "cake""#,
        [],
    ))
    .into_model::<SelectResult>()
    .all(&db)
    .await?;

assert_eq!(
    res,
    [
        SelectResult {
            name: "Chocolate Forest".to_owned(),
            num_of_cakes: 1,
        },
        SelectResult {
            name: "New York Cheese".to_owned(),
            num_of_cakes: 1,
        },
    ]
);

assert_eq!(
    db.into_transaction_log(),
    [Transaction::from_sql_and_values(
        DbBackend::Postgres,
        r#"SELECT "cake"."name", count("cake"."id") AS "num_of_cakes" FROM "cake""#,
        []
    ),]
);

source

pub fn into_json(self) -> SelectorRaw<SelectModel<JsonValue>>

use sea_orm::{entity::*, query::*, tests_cfg::cake};

let res: Vec<serde_json::Value> = cake::Entity::find().from_raw_sql(
    Statement::from_sql_and_values(
        DbBackend::Postgres, r#"SELECT "cake"."id", "cake"."name" FROM "cake""#, []
    )
)
.into_json()
.all(&db)
.await?;

assert_eq!(
    res,
    [
        serde_json::json!({
            "name": "Chocolate Forest",
            "num_of_cakes": 1,
        }),
        serde_json::json!({
            "name": "New York Cheese",
            "num_of_cakes": 1,
        }),
    ]
);

assert_eq!(
    db.into_transaction_log(),
    [
    Transaction::from_sql_and_values(
            DbBackend::Postgres, r#"SELECT "cake"."id", "cake"."name" FROM "cake""#, []
    ),
]);

source

pub fn into_statement(self) -> Statement

Get the SQL statement

source

pub async fn one<'a, C>(self, db: &C) -> Result<Option<S::Item>, DbErr>
where C: ConnectionTrait,

Get an item from the Select query

use sea_orm::{entity::*, query::*, tests_cfg::cake};

let _: Option<cake::Model> = cake::Entity::find()
    .from_raw_sql(Statement::from_sql_and_values(
        DbBackend::Postgres,
        r#"SELECT "cake"."id", "cake"."name" FROM "cake" WHERE "id" = $1"#,
        [1.into()],
    ))
    .one(&db)
    .await?;

assert_eq!(
    db.into_transaction_log(),
    [Transaction::from_sql_and_values(
        DbBackend::Postgres,
        r#"SELECT "cake"."id", "cake"."name" FROM "cake" WHERE "id" = $1"#,
        [1.into()]
    ),]
);

source

pub async fn all<'a, C>(self, db: &C) -> Result<Vec<S::Item>, DbErr>
where C: ConnectionTrait,

Get all items from the Select query

use sea_orm::{entity::*, query::*, tests_cfg::cake};

let _: Vec<cake::Model> = cake::Entity::find()
    .from_raw_sql(Statement::from_sql_and_values(
        DbBackend::Postgres,
        r#"SELECT "cake"."id", "cake"."name" FROM "cake""#,
        [],
    ))
    .all(&db)
    .await?;

assert_eq!(
    db.into_transaction_log(),
    [Transaction::from_sql_and_values(
        DbBackend::Postgres,
        r#"SELECT "cake"."id", "cake"."name" FROM "cake""#,
        []
    ),]
);