Struct SelectProps 

pub struct SelectProps {
    pub connect: SQLImplementation,
    pub columns: Vec<Column>,
    pub table: String,
    pub joins: Vec<Joins>,
    pub clause: Option<String>,
    pub order_by: (Option<String>, OrderBy),
    pub group_by: Option<Vec<String>>,
    pub limit: Limit,
    pub return_header: bool,
}

Fields

connect: SQLImplementation

columns: Vec<Column>

table: String

joins: Vec<Joins>

clause: Option<String>

order_by: (Option<String>, OrderBy)

group_by: Option<Vec<String>>

limit: Limit

return_header: bool

Trait Implementations

impl Debug for SelectProps

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

Formats the value using the given formatter.

impl QueryConjunctions for SelectProps

fn where_in(self, column: &ColumnProps, values: WhereArg) -> Self

Adds a WHERE clause to your query. The first argument is the column you want to filter on, and the second argument is the values you want to filter by. This can be chained with other conjunctions like and, or, and_not, and or_not.

fn where_not(self, column: &ColumnProps, values: WhereArg) -> Self

Adds a WHERE NOT clause to your query. The first argument is the column you want to filter on, and the second argument is the values you want to filter by. This can be chained with other conjunctions like and, or, and_not, and or_not.

fn and(self, column: &ColumnProps, values: WhereArg) -> Self

Adds an AND conjunction to a WHERE clause. The first argument is the column you want to filter on, and the second argument is the values you want to filter by. This can be chained with other conjunctions like or, and_not, and or_not.

fn or(self, column: &ColumnProps, values: WhereArg) -> Self

Adds an OR conjunction to a WHERE clause. The first argument is the column you want to filter on, and the second argument is the values you want to filter by. This can be chained with other conjunctions like and, and_not, and or_not.

fn and_not(self, column: &ColumnProps, values: WhereArg) -> Self

Adds an AND NOT conjunction to a WHERE clause. The first argument is the column you want to filter on, and the second argument is the values you want to filter by. This can be chained with other conjunctions like and, or, and or_not.

fn or_not(self, column: &ColumnProps, values: WhereArg) -> Self

Adds an OR NOT conjunction to a WHERE clause. The first argument is the column you want to filter on, and the second argument is the values you want to filter by. This can be chained with other conjunctions like and, and_not, and or.

impl SelectBuilder for SelectProps

fn inner_join( self, foreign_table: &str, primary_column: &str, foreign_column: &str, ) -> Self

Inner joins another table to your query.

fn outer_join( self, foreign_table: &str, primary_column: &str, foreign_column: &str, ) -> Self

Outer joins another table to your query.

fn right_join( self, foreign_table: &str, primary_column: &str, foreign_column: &str, ) -> Self

Right joins another table to your query.

fn left_join( self, foreign_table: &str, primary_column: &str, foreign_column: &str, ) -> Self

Left joins another table to your query.

fn order_asc(self, column: &str) -> Ordered

Order By a column ascending

fn order_desc(self, column: &str) -> Ordered

Order By a column descending

fn group_by(self, columns: Vec<&str>) -> Grouped

Group By column(s)

fn build(self) -> Result<Vec<Vec<Box<SQLDataTypes>>>, Error>

Builds the query. This is multi-threaded by default, dividing the number of rows by the number of CPU cores. If you’re using a single core machine, it’s recommended to use build_single_thread. SQLite runs better using build_single_thread (will either fix or remove it as an option in a future update).

fn build_single_thread(self) -> Result<Vec<Vec<Box<SQLDataTypes>>>, Error>

Builds the query only using one thread.

fn limit(self, limit: usize, offset: Option<usize>) -> Self

Sets limit and offset of query

fn return_header(self) -> Self

Returns column names