Struct Pagination

pub struct Pagination<T>
where
    T: TableBuilder + QueryBuilderTrait + Serialize + for<'de> Deserialize<'de> + Sized,
{ /* private fields */ }

A struct for paginating results

Example

#[derive(Table, Debug, Default, Clone, serde::Serialize, serde::Deserialize)]
pub struct Users {
    pub id: PrimaryKeyInteger,
    pub username: String,
    pub age: i32,
    pub postcode: Option<String>,
}

pub type UserPage = Pagination<Users>;

#[tokio::main]
async fn main() -> anyhow::Result<()> {
    let database = libsql::Builder::new_local(":memory:").build().await?;
    let connection = database.connect().unwrap();
     
    // Create a new Page instance
    let mut page = UserPage::new();

    // Update the page to the next page
    let results = page.next(&connection).await?;

}

Implementations

impl<T> Pagination<T>

where T: TableBuilder + QueryBuilderTrait + Serialize + for<'de> Deserialize<'de> + Sized,

pub fn new() -> Self

Create a new Pagination instance

pub fn page(&self) -> u32

Get the current page

pub fn limit(&self) -> u32

Get the limit

pub fn total(&self) -> u32

Get the total number of items

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

Set the total number of items

pub async fn get<'a, C>(&mut self, connection: &'a C) -> Result<Vec<T>, Error>

where C: GeekConnection<Connection = C> + 'a,

Get the current page results

pub async fn next<'a, C>(&mut self, connection: &'a C) -> Result<Vec<T>, Error>

where C: GeekConnection<Connection = C> + 'a,

Get the next page of results

pub async fn prev<'a, C>(&mut self, connection: &'a C) -> Result<Vec<T>, Error>

where C: GeekConnection<Connection = C> + 'a,

Get the previous page of results

Trait Implementations

impl<T> Default for Pagination<T>

where T: TableBuilder + QueryBuilderTrait + Serialize + for<'de> Deserialize<'de> + Sized,

fn default() -> Self

Returns the “default value” for a type.