Type Alias SelectBuilder 

pub type SelectBuilder<'a, Schema, State, Table = ()> = QueryBuilder<'a, Schema, State, Table>;

Builds a SELECT query specifically for SQLite

Aliased Type

pub struct SelectBuilder<'a, Schema, State, Table = ()> {
    pub sql: SQL<'a, SQLiteValue<'a>>,
    /* private fields */
}

Fields

sql: SQL<'a, SQLiteValue<'a>>

Implementations

impl<'a, S> SelectBuilder<'a, S, SelectInitial>

pub fn from<T>(self, query: T) -> SelectBuilder<'a, S, SelectFromSet, T>

where T: ToSQL<'a, SQLiteValue<'a>>,

Specifies the table to select FROM and transitions state

impl<'a, S, T> SelectBuilder<'a, S, SelectFromSet, T>

where T: SQLTable<'a, SQLiteValue<'a>>,

pub fn join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

Adds a JOIN clause to the query

pub fn natural_join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

pub fn natural_left_join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

pub fn left_join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

pub fn left_outer_join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

pub fn natural_left_outer_join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

pub fn natural_right_join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

pub fn right_join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

pub fn right_outer_join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

pub fn natural_right_outer_join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

pub fn natural_full_join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

pub fn full_join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

pub fn full_outer_join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

pub fn natural_full_outer_join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

pub fn inner_join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

pub fn cross_join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

pub fn where( self, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectWhereSet, T>

pub fn group_by( self, expressions: Vec<SQL<'a, SQLiteValue<'a>>>, ) -> SelectBuilder<'a, S, SelectGroupSet, T>

Adds a GROUP BY clause to the query

pub fn limit(self, limit: usize) -> SelectBuilder<'a, S, SelectLimitSet, T>

Limits the number of rows returned

pub fn offset(self, offset: usize) -> SelectBuilder<'a, S, SelectOffsetSet, T>

Sets the offset for the query results

pub fn order_by<TOrderBy>( self, expressions: TOrderBy, ) -> SelectBuilder<'a, S, SelectOrderSet, T>

where TOrderBy: ToSQL<'a, SQLiteValue<'a>>,

Sorts the query results

impl<'a, S, T> SelectBuilder<'a, S, SelectJoinSet, T>

pub fn where( self, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectWhereSet, T>

Adds a WHERE condition after a JOIN

pub fn order_by<TOrderBy>( self, expressions: TOrderBy, ) -> SelectBuilder<'a, S, SelectOrderSet, T>

where TOrderBy: ToSQL<'a, SQLiteValue<'a>>,

Sorts the query results

pub fn join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

Adds a JOIN clause to the query

pub fn natural_join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

pub fn natural_left_join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

pub fn left_join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

pub fn left_outer_join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

pub fn natural_left_outer_join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

pub fn natural_right_join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

pub fn right_join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

pub fn right_outer_join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

pub fn natural_right_outer_join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

pub fn natural_full_join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

pub fn full_join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

pub fn full_outer_join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

pub fn natural_full_outer_join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

pub fn inner_join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

pub fn cross_join<U: IsInSchema<S> + SQLTable<'a, SQLiteValue<'a>>>( self, table: U, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectJoinSet, T>

impl<'a, S, T> SelectBuilder<'a, S, SelectWhereSet, T>

pub fn group_by( self, expressions: Vec<SQL<'a, SQLiteValue<'a>>>, ) -> SelectBuilder<'a, S, SelectGroupSet, T>

Adds a GROUP BY clause after a WHERE

pub fn order_by<TOrderBy>( self, expressions: TOrderBy, ) -> SelectBuilder<'a, S, SelectOrderSet, T>

where TOrderBy: ToSQL<'a, SQLiteValue<'a>>,

Adds an ORDER BY clause after a WHERE

pub fn limit(self, limit: usize) -> SelectBuilder<'a, S, SelectLimitSet, T>

Adds a LIMIT clause after a WHERE

impl<'a, S, T> SelectBuilder<'a, S, SelectGroupSet, T>

pub fn having( self, condition: SQL<'a, SQLiteValue<'a>>, ) -> SelectBuilder<'a, S, SelectGroupSet, T>

Adds a HAVING clause after GROUP BY

pub fn order_by<TOrderBy>( self, expressions: TOrderBy, ) -> SelectBuilder<'a, S, SelectOrderSet, T>

where TOrderBy: ToSQL<'a, SQLiteValue<'a>>,

Adds an ORDER BY clause after GROUP BY

impl<'a, S, T> SelectBuilder<'a, S, SelectOrderSet, T>

pub fn limit(self, limit: usize) -> SelectBuilder<'a, S, SelectLimitSet, T>

Adds a LIMIT clause after ORDER BY

impl<'a, S, T> SelectBuilder<'a, S, SelectLimitSet, T>

pub fn offset(self, offset: usize) -> SelectBuilder<'a, S, SelectOffsetSet, T>

Adds an OFFSET clause after LIMIT