Struct pinto::query_builder::Select
[−]
[src]
pub struct Select<'a> { /* fields omitted */ }
SELECT
Methods
impl<'a> Select<'a>
[src]
fn new(table: &'a str) -> Self
[src]
Construct a new SELECT
query builder
fn alias(&mut self, table: &'a str, alias: &'a str) -> &mut Self
[src]
Set a table alias (AS
)
fn fields(&mut self, fields: &[&'a str]) -> &mut Self
[src]
Specify desired table fields in result set
fn filter(&mut self, expr: &'a str) -> &mut Self
[src]
Filter result set based on conditions (WHERE
clause)
fn group_by(&mut self, val: &'a str) -> &mut Self
[src]
Group result set based on common value (GROUP BY
clause)
fn having(&mut self, expr: &'a str) -> &mut Self
[src]
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
[src]
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
[src]
&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
[src]
Limit number of rows in result set (LIMIT
)
fn offset(&mut self, offset: usize) -> &mut Self
[src]
Offset number of rows in result set (OFFSET
)
fn build(&self) -> String
[src]
Generate SQL query (String
) from subsequent method calls