Struct msi::Select

pub struct Select { /* private fields */ }

A database query to select rows.

Implementations

impl Select

pub fn table<S: Into<String>>(table_name: S) -> Select

Starts building a query that will select rows from the specified table.

pub fn inner_join(self, rhs: Select, on: Expr) -> Select

Performs an inner join between this and another query, producing a row for each pair of rows from the two tables that matches the expression.

pub fn left_join(self, rhs: Select, on: Expr) -> Select

Performs a left join between this and another query.

pub fn columns<S>(self, column_names: &[S]) -> Selectwhere S: Clone + Into<String>,

Transforms the selected rows to only include the specified columns, in the order given.

pub fn with(self, condition: Expr) -> Select

Adds a restriction on which rows should be selected by the query; only rows that match the given boolean expression will be returned. (This method would have been called where(), to better match SQL, but where is a reserved word in Rust.)

Trait Implementations

impl Display for Select

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

Formats the value using the given formatter.