Struct sqlmo::Select

pub struct Select {
    pub ctes: Vec<Cte>,
    pub distinct: bool,
    pub columns: Vec<SelectColumn>,
    pub from: Option<From>,
    pub join: Vec<Join>,
    pub where_: Where,
    pub group: Vec<GroupBy>,
    pub having: Where,
    pub order: Vec<OrderBy>,
    pub limit: Option<usize>,
    pub offset: Option<usize>,
}

A SELECT query.

Fields

ctes: Vec<Cte>

distinct: bool

columns: Vec<SelectColumn>

from: Option<From>

join: Vec<Join>

where_: Where

group: Vec<GroupBy>

having: Where

order: Vec<OrderBy>

limit: Option<usize>

offset: Option<usize>

Implementations

impl Select

pub fn with_raw(self, name: &str, query: &str) -> Self

pub fn with(self, name: &str, query: Select) -> Self

pub fn distinct(self) -> Self

pub fn table_column(self, table: &str, column: &str) -> Self

pub fn select_raw(self, expression: impl Into<String>) -> Self

pub fn from(self, table: &str) -> Self

pub fn join(self, join: Join) -> Self

pub fn where_(self, where_: Where) -> Self

Assumes AND. Access the .where_ field directly for more advanced operations.

pub fn where_raw(self, where_: impl Into<String>) -> Self

pub fn group_by(self, group: &str) -> Self

pub fn having(self, having: Where) -> Self

pub fn order_by(self, order: &str, direction: Direction) -> Self

pub fn order_asc(self, order: &str) -> Self

pub fn order_desc(self, order: &str) -> Self

pub fn limit(self, limit: usize) -> Self

pub fn offset(self, offset: usize) -> Self

Trait Implementations

impl Clone for Select

fn clone(&self) -> Select

Returns a copy of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for Select

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

Formats the value using the given formatter.

impl Default for Select

fn default() -> Self

Returns the “default value” for a type.

impl ToSql for Select

fn write_sql(&self, buf: &mut String, dialect: Dialect)

fn to_sql(&self, dialect: Dialect) -> String