Collections

Sea-ORM provides pagination and ordering support through PaginatorTrait and QueryOrder.

use sea_orm::{QueryOrder, PaginatorTrait};

// Ordered query
let users = entity::sys_user::Entity::find()
    .order_by_asc(entity::sys_user::Column::Username)
    .all(&db).await?;

// Paginated query
let paginator = entity::sys_user::Entity::find()
    .order_by_desc(entity::sys_user::Column::CreatedAt)
    .paginate(&db, 20);  // 20 items per page

let total_pages = paginator.num_pages().await?;
let total_items = paginator.num_items().await?;
let page = paginator.fetch_page(0).await?;  // Page 0 (first page)