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

#![allow(unused_imports)]

use crate::backend::{MsSql, SqlGenerator};
use crate::{types, Migration, Table};

#[test]
fn in_schema() {
    let sql = MsSql::add_column(
        false,
        Some("schema"),
        "author",
        &types::foreign("users", "id"),
    );

    assert_eq!(
        sql,
        "[author] INT REFERENCES [schema].[users]([id]) NOT NULL"
    );
}

#[test]
fn ext_schema() {
    let sql = MsSql::add_column(
        false,
        Some("schema"),
        "author",
        &types::foreign_schema("other_schema", "users", "id"),
    );

    assert_eq!(
        sql,
        "[author] INT REFERENCES [other_schema].[users]([id]) NOT NULL"
    );
}