Struct CteBuilder 

pub struct CteBuilder { /* private fields */ }

Builder for CTEs.

Implementations

impl CteBuilder

pub fn new(name: impl Into<String>) -> Self

Create a new CTE builder.

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

where I: IntoIterator<Item = S>, S: Into<String>,

Set the column aliases.

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

Set the query that defines this CTE.

pub fn recursive(self) -> Self

Mark this as a recursive CTE.

pub fn materialized(self) -> Self

Set materialization hint (PostgreSQL only).

pub fn not_materialized(self) -> Self

Prevent materialization (PostgreSQL only).

pub fn search_breadth_first<I, S>( self, columns: I, set_column: impl Into<String>, ) -> Self

where I: IntoIterator<Item = S>, S: Into<String>,

Add breadth-first search (PostgreSQL only).

pub fn search_depth_first<I, S>( self, columns: I, set_column: impl Into<String>, ) -> Self

where I: IntoIterator<Item = S>, S: Into<String>,

Add depth-first search (PostgreSQL only).

pub fn cycle<I, S>( self, columns: I, set_column: impl Into<String>, using_column: impl Into<String>, ) -> Self

where I: IntoIterator<Item = S>, S: Into<String>,

Add cycle detection (PostgreSQL only).

pub fn build(self) -> QueryResult<Cte>

Build the CTE.

Trait Implementations

impl Clone for CteBuilder

fn clone(&self) -> CteBuilder

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for CteBuilder

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

Formats the value using the given formatter.