Trait derive_sql::Selectable

source · 
pub trait Selectable {
    // Required methods
    fn filter(&self) -> Option<String>;
    fn limit(&self) -> Option<usize>;
    fn offset(&self) -> Option<usize>;
    fn order_by(&self) -> Option<String>;

    // Provided method
    fn statement(&self) -> String { ... }
}
Expand description

Definition of trait Selectable. This trait outputs filter, limit and offset statement.

Required Methods§

source

fn filter(&self) -> Option<String>

Output filter statement - which will be appended to the WHERE clause - such as:

  • field='banana': item where the entry field is equal to 'banana';
  • 1=0: return no items;
  • 1=1: return all items;

Return None if no filtering is requested.

source

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

Output limit statement - which will be appended to the LIMIT clause - such as:

  • 10: returns only 10 entries

Return None if no limit is requested.

source

fn offset(&self) -> Option<usize>

Output offset statement - which will be appended to the OFFSET clause - such as:

  • 5: skip the first 5 entry

Return None if no offset is requested.

source

fn order_by(&self) -> Option<String>

Output order by statement - which will be appended to the ORDER BY clause - such as:

  • name DESC: order by descending name

Return None if no order is requested

Provided Methods§

source

fn statement(&self) -> String

Implementors§