Struct QueryBuilder 

pub struct QueryBuilder<E>
where
    E: EntityTrait,
{ /* private fields */ }

Fluent query builder wrapper

Wraps SeaORM’s Select with methods that use the global DB connection. This provides an Eloquent-like query API.

Example

let todos = Todo::query()
    .filter(Column::Active.eq(true))
    .order_by_asc(Column::Title)
    .all()
    .await?;

Implementations

impl<E> QueryBuilder<E>

where E: EntityTrait, E::Model: Send + Sync,

pub fn new() -> Self

Create a new query builder for the entity

pub fn filter<F>(self, filter: F) -> Self

where F: IntoCondition,

Add a filter condition

Example

let todos = Todo::query()
    .filter(Column::Title.eq("test"))
    .filter(Column::Active.eq(true))
    .all()
    .await?;

pub fn order_by_asc<C>(self, col: C) -> Self

where C: ColumnTrait,

Add an order by clause (ascending)

Example

let todos = Todo::query()
    .order_by_asc(Column::Title)
    .all()
    .await?;

pub fn order_by_desc<C>(self, col: C) -> Self

where C: ColumnTrait,

Add an order by clause (descending)

Example

let todos = Todo::query()
    .order_by_desc(Column::CreatedAt)
    .all()
    .await?;

pub fn order_by<C>(self, col: C, order: Order) -> Self

where C: ColumnTrait,

Add an order by clause with custom order

Example

use sea_orm::Order;
let todos = Todo::query()
    .order_by(Column::Title, Order::Asc)
    .all()
    .await?;

pub fn limit(self, limit: u64) -> Self

Limit the number of results

Example

let todos = Todo::query().limit(10).all().await?;

pub fn offset(self, offset: u64) -> Self

Skip a number of results (offset)

Example

// Skip first 10, get next 10
let todos = Todo::query().offset(10).limit(10).all().await?;

pub async fn all(self) -> Result<Vec<E::Model>, FrameworkError>

Execute query and return all results

Example

let todos = Todo::query().all().await?;

pub async fn first(self) -> Result<Option<E::Model>, FrameworkError>

Execute query and return first result

Returns None if no record matches.

Example

let todo = Todo::query()
    .filter(Column::Id.eq(1))
    .first()
    .await?;

pub async fn first_or_fail(self) -> Result<E::Model, FrameworkError>

Execute query and return first result or error

Returns an error if no record matches.

Example

let todo = Todo::query()
    .filter(Column::Id.eq(1))
    .first_or_fail()
    .await?;

pub async fn count(self) -> Result<u64, FrameworkError>

Count matching records

Example

let count = Todo::query()
    .filter(Column::Active.eq(true))
    .count()
    .await?;

pub async fn exists(self) -> Result<bool, FrameworkError>

Check if any records exist matching the query

Example

let has_active = Todo::query()
    .filter(Column::Active.eq(true))
    .exists()
    .await?;

pub fn into_select(self) -> Select<E>

Get access to the underlying SeaORM Select for advanced queries

Use this when you need SeaORM features not exposed by QueryBuilder.

Example

let select = Todo::query()
    .filter(Column::Active.eq(true))
    .into_select();

// Use with SeaORM directly
let todos = select.all(db.inner()).await?;

Trait Implementations

impl<E> Default for QueryBuilder<E>

where E: EntityTrait, E::Model: Send + Sync,

fn default() -> Self

Returns the “default value” for a type.