Struct WithClause 

pub struct WithClause {
    pub ctes: Vec<Cte>,
    pub recursive: bool,
    pub main_query: Option<String>,
}

A WITH clause containing one or more CTEs.

Fields

ctes: Vec<Cte>

The CTEs in this WITH clause.

recursive: bool

Whether any CTE is recursive.

main_query: Option<String>

The main query that uses the CTEs.

Implementations

impl WithClause

pub fn new() -> Self

Create a new empty WITH clause.

pub fn cte(self, cte: Cte) -> Self

Add a CTE to this WITH clause.

pub fn ctes<I>(self, ctes: I) -> Self

where I: IntoIterator<Item = Cte>,

Add multiple CTEs.

pub fn main_query(self, query: impl Into<String>) -> Self

Set the main query.

pub fn select(self, columns: impl Into<String>) -> WithQueryBuilder

Convenience: SELECT from a CTE.

pub fn to_sql(&self, db_type: DatabaseType) -> QueryResult<String>

Generate the full SQL.

Trait Implementations

impl Clone for WithClause

fn clone(&self) -> WithClause

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for WithClause

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

Formats the value using the given formatter.

impl Default for WithClause

fn default() -> WithClause

Returns the “default value” for a type.

impl<'de> Deserialize<'de> for WithClause

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl Serialize for WithClause

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error>

where __S: Serializer,

Serialize this value into the given Serde serializer.