Struct CreateMaterializedViewStatement 

pub struct CreateMaterializedViewStatement { /* private fields */ }

CREATE MATERIALIZED VIEW statement builder

This struct provides a fluent API for constructing CREATE MATERIALIZED VIEW queries.

Examples

use reinhardt_query::prelude::*;

let select = Query::select()
    .column(Expr::col("id"))
    .column(Expr::col("name"))
    .from("users")
    .and_where(Expr::col("active").eq(true));

let query = Query::create_materialized_view()
    .name("active_users_mv")
    .as_select(select)
    .with_data(true);

Implementations

impl CreateMaterializedViewStatement

pub fn new() -> Self

Create a new CREATE MATERIALIZED VIEW statement

pub fn take(&mut self) -> Self

Take the ownership of data in the current statement

pub fn name<N>(&mut self, name: N) -> &mut Self

where N: IntoIden,

Set the materialized view name

Examples

use reinhardt_query::prelude::*;

let query = Query::create_materialized_view()
    .name("active_users_mv");

pub fn as_select(&mut self, select: SelectStatement) -> &mut Self

Set the SELECT statement for the materialized view

Examples

use reinhardt_query::prelude::*;

let select = Query::select()
    .column(Expr::col("id"))
    .from("users");

let query = Query::create_materialized_view()
    .name("users_mv")
    .as_select(select);

pub fn if_not_exists(&mut self) -> &mut Self

Add IF NOT EXISTS clause

Examples

use reinhardt_query::prelude::*;

let query = Query::create_materialized_view()
    .name("users_mv")
    .if_not_exists();

pub fn columns<I, C>(&mut self, cols: I) -> &mut Self

where I: IntoIterator<Item = C>, C: IntoIden,

Set column names for the materialized view

Examples

use reinhardt_query::prelude::*;

let query = Query::create_materialized_view()
    .name("users_mv")
    .columns(["user_id", "user_name"]);

pub fn tablespace<T>(&mut self, tablespace: T) -> &mut Self

where T: IntoIden,

Set TABLESPACE for the materialized view

Examples

use reinhardt_query::prelude::*;

let query = Query::create_materialized_view()
    .name("users_mv")
    .tablespace("pg_default");

pub fn with_data(&mut self, with_data: bool) -> &mut Self

Set WITH DATA or WITH NO DATA clause

Examples

use reinhardt_query::prelude::*;

// WITH DATA (populate immediately)
let query = Query::create_materialized_view()
    .name("users_mv")
    .with_data(true);

// WITH NO DATA (don't populate)
let query = Query::create_materialized_view()
    .name("users_mv")
    .with_data(false);

Trait Implementations

impl Clone for CreateMaterializedViewStatement

fn clone(&self) -> CreateMaterializedViewStatement

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for CreateMaterializedViewStatement

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

Formats the value using the given formatter.

impl Default for CreateMaterializedViewStatement

fn default() -> Self

Returns the “default value” for a type.

impl QueryStatementBuilder for CreateMaterializedViewStatement

fn build_any(&self, query_builder: &dyn QueryBuilderTrait) -> (String, Values)

Build SQL statement for a database backend and collect query parameters

fn to_string<T: QueryBuilderTrait>(&self, query_builder: T) -> String

Build SQL statement for a database backend and return SQL string with values inlined as SQL literals.

fn build<T: QueryBuilderTrait>(&self, query_builder: T) -> (String, Values)

Build SQL statement with parameter collection

impl QueryStatementWriter for CreateMaterializedViewStatement