barrel 0.7.0

A powerful schema migration building API for 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
66
67
68
69
70

//! Other simple table/ column migrations
#![allow(unused_imports)]

use crate::backend::{Pg, SqlGenerator};

#[test]
fn create_table() {
    let sql = Pg::create_table("table_to_create", None);
    assert_eq!(String::from("CREATE TABLE \"table_to_create\""), sql);
}

#[test]
fn create_table_with_schema() {
    let sql = Pg::create_table("table_to_create", Some("my_schema"));
    assert_eq!(
        String::from("CREATE TABLE \"my_schema\".\"table_to_create\""),
        sql
    );
}

#[test]
fn create_table_if_not_exists() {
    let sql = Pg::create_table_if_not_exists("table_to_create", None);
    assert_eq!(
        String::from("CREATE TABLE IF NOT EXISTS \"table_to_create\""),
        sql
    );
}

#[test]
fn drop_table() {
    let sql = Pg::drop_table("table_to_drop", None);
    assert_eq!(String::from("DROP TABLE \"table_to_drop\""), sql);
}

#[test]
fn drop_table_if_exists() {
    let sql = Pg::drop_table_if_exists("table_to_drop", None);
    assert_eq!(String::from("DROP TABLE IF EXISTS \"table_to_drop\""), sql);
}

#[test]
fn rename_table() {
    let sql = Pg::rename_table("old_table", "new_table", None);
    assert_eq!(
        String::from("ALTER TABLE \"old_table\" RENAME TO \"new_table\""),
        sql
    );
}

#[test]
fn alter_table() {
    let sql = Pg::alter_table("table_to_alter", None);
    assert_eq!(String::from("ALTER TABLE \"table_to_alter\""), sql);
}

#[test]
fn drop_column() {
    let sql = Pg::drop_column("column_to_drop");
    assert_eq!(String::from("DROP COLUMN \"column_to_drop\""), sql);
}

#[test]
fn rename_column() {
    let sql = Pg::rename_column("old_column", "new_column");
    assert_eq!(
        String::from("RENAME COLUMN \"old_column\" TO \"new_column\""),
        sql
    );
}