Struct CreateViewStatement 

pub struct CreateViewStatement { /* private fields */ }

CREATE VIEW statement builder

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

Examples

use reinhardt_query::prelude::*;

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

let query = Query::create_view()
    .name("active_users")
    .as_select(select)
    .if_not_exists();

Implementations

impl CreateViewStatement

pub fn new() -> Self

Create a new CREATE VIEW statement

pub fn take(&mut self) -> Self

Take the ownership of data in the current CreateViewStatement

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

where N: IntoIden,

Set the view name

Examples

use reinhardt_query::prelude::*;

let query = Query::create_view()
    .name("active_users");

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

Set the SELECT statement for the view

Examples

use reinhardt_query::prelude::*;

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

let query = Query::create_view()
    .name("user_names")
    .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_view()
    .name("active_users")
    .if_not_exists();

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

Add OR REPLACE clause

Note: Cannot be used with IF NOT EXISTS

Examples

use reinhardt_query::prelude::*;

let query = Query::create_view()
    .name("active_users")
    .or_replace();

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

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

Set column names for the view

Examples

use reinhardt_query::prelude::*;

let query = Query::create_view()
    .name("active_users")
    .columns(["user_name", "user_email"]);

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

Set MATERIALIZED flag (PostgreSQL only)

Examples

use reinhardt_query::prelude::*;

let query = Query::create_view()
    .name("active_users")
    .materialized(true);

Trait Implementations

impl Clone for CreateViewStatement

fn clone(&self) -> CreateViewStatement

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for CreateViewStatement

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

Formats the value using the given formatter.

impl Default for CreateViewStatement

fn default() -> Self

Returns the “default value” for a type.

impl QueryStatementBuilder for CreateViewStatement

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 CreateViewStatement