rustyroad 1.8.0

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

use super::cleanup;
use super::error::MigrationValidationError;
use super::guard;
use super::identity::Identity;
use super::postgres_drop;
use sqlx::{AssertSqlSafe, PgPool};

pub(super) async fn resources(
    pool: &PgPool,
    id: &Identity,
) -> Result<(), MigrationValidationError> {
    guard::database(&id.database)?;
    guard::user(&id.user)?;
    guard::password(&id.password)?;
    let role = format!(
        "CREATE ROLE {} LOGIN PASSWORD '{}' NOSUPERUSER NOCREATEDB NOCREATEROLE NOINHERIT",
        id.user, id.password
    );
    sqlx::query(AssertSqlSafe(role))
        .execute(pool)
        .await
        .map_err(|error| {
            MigrationValidationError::new(format!(
                "Could not create scoped PostgreSQL role: {error}"
            ))
        })?;
    let database = format!("CREATE DATABASE {} OWNER {}", id.database, id.user);
    if let Err(error) = sqlx::query(AssertSqlSafe(database)).execute(pool).await {
        let failure = MigrationValidationError::new(format!(
            "Could not create isolated PostgreSQL database '{}': {error}",
            id.database
        ));
        let drop_role = postgres_drop::role(pool, id).await;
        return Err(cleanup::after_validation(Err(failure), drop_role).unwrap_err());
    }
    Ok(())
}