roadster 0.9.0-alpha.6

A "Batteries Included" web framework for rust designed to get you moving fast.
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
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88

use crate::error::RoadsterResult;
use diesel::backend::Backend;
use diesel::query_builder::{AstPass, QueryFragment, QueryId};
use diesel::{Connection, QueryResult, RunQueryDsl};
use url::Url;

pub fn create_database(uri: &Url, db_name: &str) -> RoadsterResult<()> {
    let mut conn: AnyConnection = Connection::establish(uri.as_ref())?;
    let statement = CreateDatabaseStatement::new(db_name);
    RunQueryDsl::execute(statement, &mut conn)?;
    Ok(())
}

pub async fn drop_database(uri: &Url, db_name: &str) -> RoadsterResult<()> {
    let mut conn: AnyConnection = Connection::establish(uri.as_ref())?;
    let statement = DropDatabaseStatement::new(db_name);
    RunQueryDsl::execute(statement, &mut conn)?;
    Ok(())
}

#[derive(diesel::MultiConnection)]
enum AnyConnection {
    #[cfg(feature = "db-diesel-postgres")]
    Postgres(diesel::pg::PgConnection),
    #[cfg(feature = "db-diesel-mysql")]
    Mysql(diesel::mysql::MysqlConnection),
}

// Originally from https://github.com/diesel-rs/diesel/blob/7d8844547498407b6d5b8d1a37e695d35aa8c08b/diesel_cli/src/database.rs#L181
#[derive(Debug, Clone)]
struct DropDatabaseStatement {
    db_name: String,
}

impl DropDatabaseStatement {
    fn new(db_name: &str) -> Self {
        DropDatabaseStatement {
            db_name: db_name.to_owned(),
        }
    }
}

impl<DB: Backend> QueryFragment<DB> for DropDatabaseStatement {
    fn walk_ast<'b>(&'b self, mut out: AstPass<'_, 'b, DB>) -> QueryResult<()> {
        out.push_sql("DROP DATABASE IF EXISTS ");
        out.push_identifier(&self.db_name)?;
        out.push_sql(" WITH (FORCE)");
        Ok(())
    }
}

impl<Conn> RunQueryDsl<Conn> for DropDatabaseStatement {}

impl QueryId for DropDatabaseStatement {
    type QueryId = ();

    const HAS_STATIC_QUERY_ID: bool = false;
}

// Originally from https://github.com/diesel-rs/diesel/blob/7d8844547498407b6d5b8d1a37e695d35aa8c08b/diesel_cli/src/database.rs#L181
#[derive(Debug, Clone)]
struct CreateDatabaseStatement {
    db_name: String,
}

impl CreateDatabaseStatement {
    fn new(db_name: &str) -> Self {
        CreateDatabaseStatement {
            db_name: db_name.to_owned(),
        }
    }
}

impl<DB: Backend> QueryFragment<DB> for CreateDatabaseStatement {
    fn walk_ast<'b>(&'b self, mut out: AstPass<'_, 'b, DB>) -> QueryResult<()> {
        out.push_sql("CREATE DATABASE ");
        out.push_identifier(&self.db_name)?;
        Ok(())
    }
}

impl<Conn> RunQueryDsl<Conn> for CreateDatabaseStatement {}

impl QueryId for CreateDatabaseStatement {
    type QueryId = ();

    const HAS_STATIC_QUERY_ID: bool = false;
}