Struct CTEView 

pub struct CTEView<'a, V: SQLParam, Table, Query> {
    pub table: Table,
    /* private fields */
}

A named common table expression (CTE) that can be read like a table.

Created by a SELECT builder’s .into_cte::<Tag>(). Pass it to .with(...) to define it, then select from it. Its typed columns are reached through table (or directly, through Deref). As a source it renders as its quoted name.

Examples

use drizzle_core::{SQL, ToSQL};
use drizzle_core::cte::{CTEDefinition, CTEView};

let recent = CTEView::new((), "recent", SQL::<Value>::raw("SELECT 1"));
assert_eq!(recent.cte_definition().sql(), r#""recent" AS (SELECT 1)"#);
assert_eq!(recent.to_sql().sql(), r#""recent""#);

Fields

table: Table

The aliased table that gives typed access to the CTE’s columns.

Implementations

impl<'a, V, Table, Query> CTEView<'a, V, Table, Query>

where V: SQLParam, Query: ToSQL<'a, V>,

pub const fn new(table: Table, name: &'static str, query: Query) -> Self

Creates a CTE named name, defined by query, with columns typed by table.

pub const fn cte_name(&self) -> &'static str

Returns the CTE name.

pub const fn query(&self) -> &Query

Returns the defining query.

Trait Implementations

impl<'a, V, Table, Query> CTEDefinition<'a, V> for CTEView<'a, V, Table, Query>

where V: SQLParam, Query: ToSQL<'a, V>,

fn cte_definition(&self) -> SQL<'a, V>

Renders the definition: "name" AS (SELECT ...).

impl<'a, V, Table, Query> CTEDefinition<'a, V> for &CTEView<'a, V, Table, Query>

where V: SQLParam, Query: ToSQL<'a, V>,

fn cte_definition(&self) -> SQL<'a, V>

Renders the definition: "name" AS (SELECT ...).

impl<'a, V: Clone + SQLParam, Table: Clone, Query: Clone> Clone for CTEView<'a, V, Table, Query>

fn clone(&self) -> Self

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl<'a, V: Debug + SQLParam, Table: Debug, Query: Debug> Debug for CTEView<'a, V, Table, Query>

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

Formats the value using the given formatter.

impl<V: SQLParam, Table, Query> Deref for CTEView<'_, V, Table, Query>

type Target = Table

The resulting type after dereferencing.

fn deref(&self) -> &Self::Target

Dereferences the value.

impl<V: SQLParam, Table: ScopeEntry, Query> ScopeEntry for CTEView<'_, V, Table, Query>

type Key = <Table as ScopeEntry>::Key

How columns refer to this source: a TableKey or an AliasKey.

type Nullable = <Table as ScopeEntry>::Nullable

Null when an outer join can leave this source NULL.

type Sources = ()

Sources this source reads itself, such as the tables a derived table’s subquery reads from an outer query. They resolve against the enclosing query (or, for a LATERAL join, the sources joined before it). Tables and views read nothing (()).

impl<'a, V, Table, Query> ToSQL<'a, V> for CTEView<'a, V, Table, Query>

where V: SQLParam, Query: ToSQL<'a, V>,

fn to_sql(&self) -> SQL<'a, V>

Renders self as a SQL fragment.

fn into_sql(self) -> SQL<'a, V>

where Self: Sized,

Renders self as a SQL fragment, consuming it.