Struct pinto::query_builder::Select

pub struct Select<'a> { /* fields omitted */ }

SELECT

Methods

impl<'a> Select<'a>

fn new(table: &'a str) -> Self

Construct a new SELECT query builder

fn alias(&mut self, table: &'a str, alias: &'a str) -> &mut Self

Set a table alias (AS)

fn fields(&mut self, fields: &[&'a str]) -> &mut Self

Specify desired table fields in result set

fn filter(&mut self, expr: &'a str) -> &mut Self

Filter result set based on conditions (WHERE clause)

fn group_by(&mut self, val: &'a str) -> &mut Self

Group result set based on common value (GROUP BY clause)

fn having(&mut self, expr: &'a str) -> &mut Self

Filter result set based on an expression on an aggregate value (HAVING clause)

fn order_by(&mut self, expr: &'a str, direction: Order) -> &mut Self

Order result set based on the value of an expression (ORDER BY clause)

fn join(
    &mut self,
    table: &'a str,
    on_left: &'a str,
    on_right: &'a str,
    kind: Join
) -> &mut Self

fn limit(&mut self, limit: usize) -> &mut Self

Limit number of rows in result set (LIMIT)

fn offset(&mut self, offset: usize) -> &mut Self

Offset number of rows in result set (OFFSET)

fn build(&self) -> String

Generate SQL query (String) from subsequent method calls

Trait Implementations

impl<'a> Debug for Select<'a>

fn fmt(&self, __arg_0: &mut Formatter) -> Result

Formats the value using the given formatter.

impl<'a> Display for Select<'a>

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

Formats the value using the given formatter.