rustyroad 1.7.3

Rusty Road is a framework written in Rust that is based on Ruby on Rails. It is designed to provide the familiar conventions and ease of use of Ruby on Rails, while also taking advantage of the performance and efficiency of Rust.
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65

//! View DDL projecting a physical table into a schema version.

use super::super::model::Table;
use super::super::naming::versioned_schema;
use super::super::quote::{quote_ident, quote_qualified};

/// Postgres version from which `security_invoker` views are available.
pub const SECURITY_INVOKER_MIN_MAJOR: u32 = 15;

/// Returns the statements that define `table` as a view in `version`.
///
/// Column defaults are restated because a view does not inherit the defaults of
/// its underlying table.
pub fn create_view(schema: &str, version: &str, table: &Table, major_version: u32) -> Vec<String> {
    let view = quote_qualified(&versioned_schema(schema, version), &table.name);

    let mut statements = vec![
        format!("DROP VIEW IF EXISTS {view}"),
        format!(
            "CREATE VIEW {view}{} AS SELECT {} FROM {}",
            options(major_version),
            projection(table),
            quote_qualified(schema, &table.physical_name)
        ),
    ];

    for column in table.visible_columns() {
        if let Some(default) = &column.default {
            statements.push(format!(
                "ALTER VIEW {view} ALTER {} SET DEFAULT {default}",
                quote_ident(&column.name)
            ));
        }
    }

    statements
}

/// Returns the `physical AS logical` projection list.
fn projection(table: &Table) -> String {
    table
        .visible_columns()
        .iter()
        .map(|column| {
            format!(
                "{} AS {}",
                quote_ident(&column.physical_name),
                quote_ident(&column.name)
            )
        })
        .collect::<Vec<_>>()
        .join(", ")
}

/// Returns view options for the server version.
///
/// `security_invoker` makes the view respect row-level security on the underlying
/// table. It is unavailable before Postgres 15.
fn options(major_version: u32) -> &'static str {
    if major_version >= SECURITY_INVOKER_MIN_MAJOR {
        " WITH (security_invoker = true)"
    } else {
        ""
    }
}