sql-bridge 0.1.0

SQL bridge for sqlx-repo
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

use sql_bridge::{MySqlDialect, PostgreSqlDialect, SQLiteDialect, parse};

#[test]
fn rename_table() {
    let query = "alter table test rename to foo";
    let mut ast = parse(query).unwrap();
    assert!(ast.len() == 1);
    let ast = ast.pop().unwrap();

    assert_eq!(
        ast.to_sql(&MySqlDialect {}).unwrap(),
        "ALTER TABLE `test` RENAME TO `foo`",
    );
    assert_eq!(
        ast.to_sql(&PostgreSqlDialect {}).unwrap(),
        "ALTER TABLE \"test\" RENAME TO \"foo\"",
    );
    assert_eq!(
        ast.to_sql(&SQLiteDialect {}).unwrap(),
        "ALTER TABLE `test` RENAME TO `foo`",
    );
}

#[test]
fn add_column() {
    let query = "alter table test add column foo int";
    let mut ast = parse(query).unwrap();
    assert!(ast.len() == 1);
    let ast = ast.pop().unwrap();

    assert_eq!(
        ast.to_sql(&MySqlDialect {}).unwrap(),
        "ALTER TABLE `test` ADD COLUMN `foo` INT"
    );
    assert_eq!(
        ast.to_sql(&PostgreSqlDialect {}).unwrap(),
        "ALTER TABLE \"test\" ADD COLUMN \"foo\" INT"
    );
    assert_eq!(
        ast.to_sql(&SQLiteDialect {}).unwrap(),
        "ALTER TABLE `test` ADD COLUMN `foo` INTEGER"
    );
}

#[test]
fn drop_column() {
    let query = "alter table test drop column foo";
    let mut ast = parse(query).unwrap();
    assert!(ast.len() == 1);
    let ast = ast.pop().unwrap();

    assert_eq!(
        ast.to_sql(&MySqlDialect {}).unwrap(),
        "ALTER TABLE `test` DROP COLUMN `foo`"
    );
    assert_eq!(
        ast.to_sql(&PostgreSqlDialect {}).unwrap(),
        "ALTER TABLE \"test\" DROP COLUMN \"foo\""
    );
    assert_eq!(
        ast.to_sql(&SQLiteDialect {}).unwrap(),
        "ALTER TABLE `test` DROP COLUMN `foo`"
    );
}

#[test]
fn rename_column() {
    let query = "alter table test rename column old_col to new_col";
    let mut ast = parse(query).unwrap();
    assert!(ast.len() == 1);
    let ast = ast.pop().unwrap();

    assert_eq!(
        ast.to_sql(&MySqlDialect {}).unwrap(),
        "ALTER TABLE `test` RENAME COLUMN `old_col` TO `new_col`"
    );
    assert_eq!(
        ast.to_sql(&PostgreSqlDialect {}).unwrap(),
        "ALTER TABLE \"test\" RENAME COLUMN \"old_col\" TO \"new_col\""
    );
    assert_eq!(
        ast.to_sql(&SQLiteDialect {}).unwrap(),
        "ALTER TABLE `test` RENAME COLUMN `old_col` TO `new_col`"
    );
}