Struct PaginationOptions 

pub struct PaginationOptions<T: OrderByOptions = ()> {
    pub page: usize,
    pub items_per_page: usize,
    pub order_by: T,
}

Struct representing pagination options.

Examples

let options = PaginationOptions::new().page(1).items_per_page(20);

Fields

page: usize

Page number.

• If the value is 0, it will default to 1.
• If the value exceeds the maximum page number, it will be considered as the maximum page number.

Default: 1.

items_per_page: usize

Number of items per page.

• If the value is 0, it means query all items in a single page.

Default: 0.

order_by: T

Ordering options which has to implement the OrderByOptions trait.

Default: ().

Implementations

impl PaginationOptions

pub const fn new() -> Self

Create a new PaginationOptions.

let options = PaginationOptions::new();
// equals to
let options = PaginationOptions {
    page:           1,
    items_per_page: 0,
    order_by:       (),
};

impl<T: OrderByOptions> PaginationOptions<T>

pub const fn page(self, page: usize) -> Self

Set the page number.

• If the value is 0, it will be considered as 1.
• If the value exceeds the maximum page number, it will be considered as the maximum page number.

pub const fn items_per_page(self, items_per_page: usize) -> Self

Set the number of items per page.

• If the value is 0, it means query all items in a single page.

pub fn order_by(self, order_by: T) -> Self

Set the ordering options which has to implement the OrderByOptions trait.

pub const fn offset(&self) -> u64

Compute the offset for pagination.

pub const fn limit(&self) -> Option<usize>

Compute the limit for pagination. None means unlimited.

impl<T: OrderByOptions> PaginationOptions<T>

pub fn to_mysql_limit_offset<'a>(&self, s: &'a mut String) -> &'a str

Generate a LIMIT with OFFSET clause for MySQL.

If limit() is Some(n),

LIMIT <limit()> [OFFSET <offset()>]

If offset() is not zero,

[LIMIT <limit()>] OFFSET <offset()>

impl<T: OrderByOptions> PaginationOptions<T>

pub fn to_sqlite_limit_offset<'a>(&self, s: &'a mut String) -> &'a str

Generate a LIMIT with OFFSET clause for SQLite.

If limit() is Some(n),

LIMIT <limit()> [OFFSET <offset()>]

If offset() is not zero,

[LIMIT <limit()>] OFFSET <offset()>

impl<T: OrderByOptions> PaginationOptions<T>

pub fn to_mssql_limit_offset<'a>(&self, s: &'a mut String) -> &'a str

Generate a OFFSET with FETCH clause for Microsoft SQL Server.

If limit() is Some(n) or offset() is not zero,

OFFSET <offset()> ROWS [FETCH NEXT <limit()> ROWS ONLY]

impl<T: OrderByOptions> PaginationOptions<T>

pub fn to_mssql2008_limit_offset<'a>( &self, row_number_column_name: impl AsRef<str>, s: &'a mut String, ) -> &'a str

Generate a WHERE clause for Microsoft SQL Server 2008 and earlier (used for check the row number).

If limit() is Some(n),

WHERE [<row_number_column_name>] <= <limit()>

If offset() is not zero,

WHERE [<row_number_column_name>] > <offset()>

If both above are true,

WHERE [<row_number_column_name>] BETWEEN (<offset() + 1>) AND <offset() + limit()>

Trait Implementations

impl<T: Clone + OrderByOptions> Clone for PaginationOptions<T>

fn clone(&self) -> PaginationOptions<T>

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl<T: Debug + OrderByOptions> Debug for PaginationOptions<T>

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

Formats the value using the given formatter.

impl<T: OrderByOptions> Default for PaginationOptions<T>

fn default() -> Self

Create a new PaginationOptions<T>.

let options = <PaginationOptions<()>>::default();
// equals to
let options = PaginationOptions {
    page:           1,
    items_per_page: 0,
    order_by:       (),
};

impl<'de, T: OrderByOptions + Deserialize<'de>> Deserialize<'de> for PaginationOptions<T>

fn deserialize<D>(deserializer: D) -> Result<Self, D::Error>

where D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl<T: OrderByOptions + Serialize> Serialize for PaginationOptions<T>

fn serialize<S>(&self, serializer: S) -> Result<S::Ok, S::Error>

where S: Serializer,

Serialize this value into the given Serde serializer.