Struct Pagination

pub struct Pagination {
    pub page: u32,
    pub per_page: u32,
    pub total: Option<u64>,
    pub total_pages: Option<u32>,
}

Pagination parameters for queries

Provides offset-based pagination with helpful utility methods for calculating offsets, page numbers, and navigation state.

Examples

use libsql_orm::Pagination;

let mut pagination = Pagination::new(2, 10); // Page 2, 10 items per page
pagination.set_total(45); // 45 total items

assert_eq!(pagination.offset(), 10); // Skip first 10 items
assert_eq!(pagination.limit(), 10);  // Take 10 items
assert_eq!(pagination.total_pages, Some(5)); // 5 total pages
assert!(pagination.has_prev()); // Has previous page
assert!(pagination.has_next()); // Has next page

Fields

page: u32

Page number (1-based)

per_page: u32

Number of items per page

total: Option<u64>

Total number of items (set after query execution)

total_pages: Option<u32>

Total number of pages (calculated)

Implementations

impl Pagination

pub fn new(page: u32, per_page: u32) -> Self

Create a new pagination instance

pub fn offset(&self) -> u32

Get the offset for SQL LIMIT/OFFSET

pub fn limit(&self) -> u32

Get the limit for SQL LIMIT/OFFSET

pub fn set_total(&mut self, total: u64)

Set the total count and calculate total pages

pub fn has_next(&self) -> bool

Check if there’s a next page

pub fn has_prev(&self) -> bool

Check if there’s a previous page

pub fn start_item(&self) -> u32

Get the start item number for the current page

pub fn end_item(&self) -> u32

Get the end item number for the current page

pub fn next_page(&self) -> Option<u32>

Get the next page number

pub fn prev_page(&self) -> Option<u32>

Get the previous page number

Trait Implementations

impl Clone for Pagination

fn clone(&self) -> Pagination

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for Pagination

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Default for Pagination

fn default() -> Self

Returns the “default value” for a type.

impl<'de> Deserialize<'de> for Pagination

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl Serialize for Pagination

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error>

where __S: Serializer,

Serialize this value into the given Serde serializer.