Struct ViewFindManyOperation 

pub struct ViewFindManyOperation<E: QueryEngine, V: View> { /* private fields */ }

A query operation that finds multiple records from a view.

Views are read-only, so only SELECT operations are supported.

Example

let stats = client
    .user_stats()
    .find_many()
    .r#where(user_stats::post_count::gte(10))
    .order_by(user_stats::post_count::desc())
    .take(100)
    .exec()
    .await?;

Implementations

impl<E: QueryEngine, V: View> ViewFindManyOperation<E, V>

pub fn new(engine: E) -> Self

Create a new ViewFindMany operation.

pub fn where(self, filter: impl Into<Filter>) -> Self

Add a filter condition.

pub fn order_by(self, order: impl Into<OrderBy>) -> Self

Set the order by clause.

pub fn skip(self, n: u64) -> Self

Skip a number of records.

pub fn take(self, n: u64) -> Self

Take a limited number of records.

pub fn select(self, select: impl Into<Select>) -> Self

Select specific fields.

pub fn distinct( self, columns: impl IntoIterator<Item = impl Into<String>>, ) -> Self

Make the query distinct.

pub fn cursor(self, cursor: Cursor) -> Self

Set cursor for cursor-based pagination.

pub fn build_sql(&self) -> (String, Vec<FilterValue>)

Build the SQL query.

pub async fn exec(self) -> QueryResult<Vec<V>>

where V: Send + 'static + DeserializeOwned,

Execute the query.

Note: This requires the query engine to support view queries. For now, we use raw query execution.