pub struct Cursor<S>where
S: SelectorTrait,{ /* private fields */ }
Expand description
Cursor pagination
Implementations§
source§impl<S> Cursor<S>where
S: SelectorTrait,
impl<S> Cursor<S>where S: SelectorTrait,
sourcepub fn new<C>(query: SelectStatement, table: DynIden, order_columns: C) -> Selfwhere
C: IntoIdentity,
pub fn new<C>(query: SelectStatement, table: DynIden, order_columns: C) -> Selfwhere C: IntoIdentity,
Initialize a cursor
sourcepub fn before<V>(&mut self, values: V) -> &mut Selfwhere
V: IntoValueTuple,
pub fn before<V>(&mut self, values: V) -> &mut Selfwhere V: IntoValueTuple,
Filter paginated result with corresponding column less than the input value
sourcepub fn after<V>(&mut self, values: V) -> &mut Selfwhere
V: IntoValueTuple,
pub fn after<V>(&mut self, values: V) -> &mut Selfwhere V: IntoValueTuple,
Filter paginated result with corresponding column greater than the input value
sourcepub fn first(&mut self, num_rows: u64) -> &mut Self
pub fn first(&mut self, num_rows: u64) -> &mut Self
Limit result set to only first N rows in ascending order of the order by column
sourcepub fn last(&mut self, num_rows: u64) -> &mut Self
pub fn last(&mut self, num_rows: u64) -> &mut Self
Limit result set to only last N rows in ascending order of the order by column
sourcepub async fn all<C>(&mut self, db: &C) -> Result<Vec<S::Item>, DbErr>where
C: ConnectionTrait,
pub async fn all<C>(&mut self, db: &C) -> Result<Vec<S::Item>, DbErr>where C: ConnectionTrait,
Fetch the paginated result
sourcepub fn into_model<M>(self) -> Cursor<SelectModel<M>>where
M: FromQueryResult,
pub fn into_model<M>(self) -> Cursor<SelectModel<M>>where M: FromQueryResult,
Construct a Cursor that fetch any custom struct
Trait Implementations§
source§impl<S> QueryOrder for Cursor<S>where
S: SelectorTrait,
impl<S> QueryOrder for Cursor<S>where S: SelectorTrait,
type QueryStatement = SelectStatement
source§fn query(&mut self) -> &mut SelectStatement
fn query(&mut self) -> &mut SelectStatement
Add the query to perform an ORDER BY operation
source§fn order_by<C>(self, col: C, ord: Order) -> Selfwhere
C: IntoSimpleExpr,
fn order_by<C>(self, col: C, ord: Order) -> Selfwhere C: IntoSimpleExpr,
Add an order_by expression Read more
source§fn order_by_asc<C>(self, col: C) -> Selfwhere
C: IntoSimpleExpr,
fn order_by_asc<C>(self, col: C) -> Selfwhere C: IntoSimpleExpr,
Add an order_by expression (ascending) Read more
source§fn order_by_desc<C>(self, col: C) -> Selfwhere
C: IntoSimpleExpr,
fn order_by_desc<C>(self, col: C) -> Selfwhere C: IntoSimpleExpr,
Add an order_by expression (descending) Read more