pub struct Select<E> where
E: EntityTrait, { /* private fields */ }
Expand description
Defines a structure to perform select operations
Implementations
sourceimpl<E> Select<E> where
E: EntityTrait,
impl<E> Select<E> where
E: EntityTrait,
sourcepub fn from_raw_sql(self, stmt: Statement) -> SelectorRaw<SelectModel<E::Model>>
pub fn from_raw_sql(self, stmt: Statement) -> SelectorRaw<SelectModel<E::Model>>
Perform a Select operation on a Model using a Statement
sourcepub fn into_model<M>(self) -> Selector<SelectModel<M>> where
M: FromQueryResult,
pub fn into_model<M>(self) -> Selector<SelectModel<M>> where
M: FromQueryResult,
Return a Selector from Self
that wraps a SelectModel
sourcepub fn into_json(self) -> Selector<SelectModel<JsonValue>>
pub fn into_json(self) -> Selector<SelectModel<JsonValue>>
Get a selectable Model as a JsonValue for SQL JSON operations
sourcepub fn into_values<T, C>(self) -> Selector<SelectGetableValue<T, C>> where
T: TryGetableMany,
C: IntoEnumIterator + Iden,
pub fn into_values<T, C>(self) -> Selector<SelectGetableValue<T, C>> where
T: TryGetableMany,
C: IntoEnumIterator + Iden,
use sea_orm::{entity::*, query::*, tests_cfg::cake, DeriveColumn, EnumIter};
#[derive(Copy, Clone, Debug, EnumIter, DeriveColumn)]
enum QueryAs {
CakeName,
}
let res: Vec<String> = cake::Entity::find()
.select_only()
.column_as(cake::Column::Name, QueryAs::CakeName)
.into_values::<_, QueryAs>()
.all(&db)
.await?;
assert_eq!(
res,
vec!["Chocolate Forest".to_owned(), "New York Cheese".to_owned()]
);
assert_eq!(
db.into_transaction_log(),
vec![Transaction::from_sql_and_values(
DbBackend::Postgres,
r#"SELECT "cake"."name" AS "cake_name" FROM "cake""#,
vec![]
)]
);
use sea_orm::{entity::*, query::*, tests_cfg::cake, DeriveColumn, EnumIter};
#[derive(Copy, Clone, Debug, EnumIter, DeriveColumn)]
enum QueryAs {
CakeName,
NumOfCakes,
}
let res: Vec<(String, i64)> = cake::Entity::find()
.select_only()
.column_as(cake::Column::Name, QueryAs::CakeName)
.column_as(cake::Column::Id.count(), QueryAs::NumOfCakes)
.group_by(cake::Column::Name)
.into_values::<_, QueryAs>()
.all(&db)
.await?;
assert_eq!(res, vec![("Chocolate Forest".to_owned(), 2i64)]);
assert_eq!(
db.into_transaction_log(),
vec![Transaction::from_sql_and_values(
DbBackend::Postgres,
vec![
r#"SELECT "cake"."name" AS "cake_name", COUNT("cake"."id") AS "num_of_cakes""#,
r#"FROM "cake" GROUP BY "cake"."name""#,
]
.join(" ")
.as_str(),
vec![]
)]
);
sourcepub async fn one<'a, C>(self, db: &C) -> Result<Option<E::Model>, DbErr> where
C: ConnectionTrait,
pub async fn one<'a, C>(self, db: &C) -> Result<Option<E::Model>, DbErr> where
C: ConnectionTrait,
Get one Model from the SELECT query
sourceimpl<E> Select<E> where
E: EntityTrait,
impl<E> Select<E> where
E: EntityTrait,
sourcepub fn select_also<F>(self, _: F) -> SelectTwo<E, F> where
F: EntityTrait,
pub fn select_also<F>(self, _: F) -> SelectTwo<E, F> where
F: EntityTrait,
Selects and Entity and returns it together with the Entity from Self
sourcepub fn select_with<F>(self, _: F) -> SelectTwoMany<E, F> where
F: EntityTrait,
pub fn select_with<F>(self, _: F) -> SelectTwoMany<E, F> where
F: EntityTrait,
Makes a SELECT operation in conjunction to another relation
sourceimpl<E> Select<E> where
E: EntityTrait,
impl<E> Select<E> where
E: EntityTrait,
sourcepub fn left_join<R>(self, _: R) -> Self where
R: EntityTrait,
E: Related<R>,
pub fn left_join<R>(self, _: R) -> Self where
R: EntityTrait,
E: Related<R>,
Left Join with a Related Entity.
sourcepub fn right_join<R>(self, _: R) -> Self where
R: EntityTrait,
E: Related<R>,
pub fn right_join<R>(self, _: R) -> Self where
R: EntityTrait,
E: Related<R>,
Right Join with a Related Entity.
sourcepub fn inner_join<R>(self, _: R) -> Self where
R: EntityTrait,
E: Related<R>,
pub fn inner_join<R>(self, _: R) -> Self where
R: EntityTrait,
E: Related<R>,
Inner Join with a Related Entity.
sourcepub fn reverse_join<R>(self, _: R) -> Self where
R: EntityTrait + Related<E>,
pub fn reverse_join<R>(self, _: R) -> Self where
R: EntityTrait + Related<E>,
Join with an Entity Related to me.
Left Join with a Related Entity and select both Entity.
Left Join with a Related Entity and select the related Entity as a Vec
sourcepub fn find_also_linked<L, T>(self, l: L) -> SelectTwo<E, T> where
L: Linked<FromEntity = E, ToEntity = T>,
T: EntityTrait,
pub fn find_also_linked<L, T>(self, l: L) -> SelectTwo<E, T> where
L: Linked<FromEntity = E, ToEntity = T>,
T: EntityTrait,
Left Join with a Linked Entity and select both Entity.
Trait Implementations
sourceimpl<E: Clone> Clone for Select<E> where
E: EntityTrait,
impl<E: Clone> Clone for Select<E> where
E: EntityTrait,
sourceimpl<E: Debug> Debug for Select<E> where
E: EntityTrait,
impl<E: Debug> Debug for Select<E> where
E: EntityTrait,
sourceimpl<'db, C, M, E> PaginatorTrait<'db, C> for Select<E> where
C: ConnectionTrait,
E: EntityTrait<Model = M>,
M: FromQueryResult + Sized + Send + Sync + 'db,
impl<'db, C, M, E> PaginatorTrait<'db, C> for Select<E> where
C: ConnectionTrait,
E: EntityTrait<Model = M>,
M: FromQueryResult + Sized + Send + Sync + 'db,
sourceimpl<E> QueryFilter for Select<E> where
E: EntityTrait,
impl<E> QueryFilter for Select<E> where
E: EntityTrait,
type QueryStatement = SelectStatement
sourcefn query(&mut self) -> &mut SelectStatement
fn query(&mut self) -> &mut SelectStatement
Add the query to perform a FILTER on
sourcefn filter<F>(self, filter: F) -> Self where
F: IntoCondition,
fn filter<F>(self, filter: F) -> Self where
F: IntoCondition,
Add an AND WHERE expression Read more
sourcefn belongs_to<M>(self, model: &M) -> Self where
M: ModelTrait,
fn belongs_to<M>(self, model: &M) -> Self where
M: ModelTrait,
Apply a where condition using the model’s primary key
sourcefn belongs_to_tbl_alias<M>(self, model: &M, tbl_alias: &str) -> Self where
M: ModelTrait,
fn belongs_to_tbl_alias<M>(self, model: &M, tbl_alias: &str) -> Self where
M: ModelTrait,
Perform a check to determine table belongs to a Model through it’s name alias
sourceimpl<E> QueryOrder for Select<E> where
E: EntityTrait,
impl<E> QueryOrder for Select<E> where
E: EntityTrait,
type QueryStatement = SelectStatement
sourcefn query(&mut self) -> &mut SelectStatement
fn query(&mut self) -> &mut SelectStatement
Add the query to perform an ORDER BY operation
sourcefn order_by<C>(self, col: C, ord: Order) -> Self where
C: IntoSimpleExpr,
fn order_by<C>(self, col: C, ord: Order) -> Self where
C: IntoSimpleExpr,
Add an order_by expression Read more
sourcefn order_by_asc<C>(self, col: C) -> Self where
C: IntoSimpleExpr,
fn order_by_asc<C>(self, col: C) -> Self where
C: IntoSimpleExpr,
Add an order_by expression (ascending) Read more
sourcefn order_by_desc<C>(self, col: C) -> Self where
C: IntoSimpleExpr,
fn order_by_desc<C>(self, col: C) -> Self where
C: IntoSimpleExpr,
Add an order_by expression (descending) Read more
sourceimpl<E> QuerySelect for Select<E> where
E: EntityTrait,
impl<E> QuerySelect for Select<E> where
E: EntityTrait,
type QueryStatement = SelectStatement
sourcefn query(&mut self) -> &mut SelectStatement
fn query(&mut self) -> &mut SelectStatement
Add the select SQL statement
sourcefn select_only(self) -> Self
fn select_only(self) -> Self
Clear the selection list
sourcefn column<C>(self, col: C) -> Self where
C: ColumnTrait,
fn column<C>(self, col: C) -> Self where
C: ColumnTrait,
Add a select column Read more
sourcefn column_as<C, I>(self, col: C, alias: I) -> Self where
C: IntoSimpleExpr,
I: IntoIdentity,
fn column_as<C, I>(self, col: C, alias: I) -> Self where
C: IntoSimpleExpr,
I: IntoIdentity,
Add a select column with alias Read more
sourcefn group_by<C>(self, col: C) -> Self where
C: IntoSimpleExpr,
fn group_by<C>(self, col: C) -> Self where
C: IntoSimpleExpr,
Add a group by column Read more
sourcefn having<F>(self, filter: F) -> Self where
F: IntoCondition,
fn having<F>(self, filter: F) -> Self where
F: IntoCondition,
Add an AND HAVING expression Read more
sourcefn join(self, join: JoinType, rel: RelationDef) -> Self
fn join(self, join: JoinType, rel: RelationDef) -> Self
Join via RelationDef
.
sourcefn join_rev(self, join: JoinType, rel: RelationDef) -> Self
fn join_rev(self, join: JoinType, rel: RelationDef) -> Self
Join via RelationDef
but in reverse direction.
Assume when there exist a relation A to B.
You can reverse join B from A. Read more
Select lock shared
sourcefn lock_exclusive(self) -> Self
fn lock_exclusive(self) -> Self
Select lock exclusive
sourceimpl<E> QueryTrait for Select<E> where
E: EntityTrait,
impl<E> QueryTrait for Select<E> where
E: EntityTrait,
type QueryStatement = SelectStatement
type QueryStatement = SelectStatement
Constrain the QueryStatement to QueryStatementBuilder trait
sourcefn query(&mut self) -> &mut SelectStatement
fn query(&mut self) -> &mut SelectStatement
Get a mutable ref to the query builder
sourcefn as_query(&self) -> &SelectStatement
fn as_query(&self) -> &SelectStatement
Get an immutable ref to the query builder
sourcefn into_query(self) -> SelectStatement
fn into_query(self) -> SelectStatement
Take ownership of the query builder
Auto Trait Implementations
impl<E> !RefUnwindSafe for Select<E>
impl<E> Send for Select<E>
impl<E> Sync for Select<E>
impl<E> Unpin for Select<E> where
E: Unpin,
impl<E> !UnwindSafe for Select<E>
Blanket Implementations
sourceimpl<T> BorrowMut<T> for T where
T: ?Sized,
impl<T> BorrowMut<T> for T where
T: ?Sized,
const: unstable · sourcefn borrow_mut(&mut self) -> &mut T
fn borrow_mut(&mut self) -> &mut T
Mutably borrows from an owned value. Read more
sourceimpl<T> Instrument for T
impl<T> Instrument for T
sourcefn instrument(self, span: Span) -> Instrumented<Self>
fn instrument(self, span: Span) -> Instrumented<Self>
sourcefn in_current_span(self) -> Instrumented<Self>
fn in_current_span(self) -> Instrumented<Self>
sourceimpl<T> ToOwned for T where
T: Clone,
impl<T> ToOwned for T where
T: Clone,
type Owned = T
type Owned = T
The resulting type after obtaining ownership.
sourcefn clone_into(&self, target: &mut T)
fn clone_into(&self, target: &mut T)
toowned_clone_into
)Uses borrowed data to replace owned data, usually by cloning. Read more
impl<V, T> VZip<V> for T where
V: MultiLane<T>,
impl<V, T> VZip<V> for T where
V: MultiLane<T>,
fn vzip(self) -> V
sourceimpl<T> WithSubscriber for T
impl<T> WithSubscriber for T
sourcefn with_subscriber<S>(self, subscriber: S) -> WithDispatch<Self> where
S: Into<Dispatch>,
fn with_subscriber<S>(self, subscriber: S) -> WithDispatch<Self> where
S: Into<Dispatch>,
Attaches the provided Subscriber
to this type, returning a
WithDispatch
wrapper. Read more
sourcefn with_current_subscriber(self) -> WithDispatch<Self>
fn with_current_subscriber(self) -> WithDispatch<Self>
Attaches the current default Subscriber
to this type, returning a
WithDispatch
wrapper. Read more